How to Unlock the Locked Table in ORACLE

Oracle puts locks while performing any DDL or DML operation on oracle tables.When table locks is present on any tables in Oracle we cannot run DDL on those tables.

Some of the locks automatically set by oracle are RS and RX Locks.

SELECT … FOR UPDATE execution results in RS (row share) table lock. When you execute an INSERT, UPDATE or DELETE Oracle puts RX (row exclusive) table lock.

We have to kill the session which holds the lock in order to execute further operations. Follow the below steps to kill the session and forcibly unlock the table.

Let’s assume that 'EMP' table is locked,

How to Delete All Files In a Directory Except Few Files in LINUX /UNIX

First let’s go through the RM command in UNIX:

The rm command is used in Unix / Linux to remove a file or a directory. The syntax is as follows:

Syntax:

rm [OPTION] [FILE] 

OPTION’s include

> rm –f {file-name} – To remove files forcefully without prompting to the user.

> rm –i {file-name} – To remove files by prompting to the user for confirming.

> rm –r {file-name} – To remove files in directories recursively.

Now we will see how to delete All Files in Directory except Few files>

1) USING RM COMMAND:

To remove all files from directory /home/opt/class/ except .log and .zip

> rm /home/opt/class/ !(*.zip|*.log)

To remove all files except a specific file (file123)

> rm  !(file123)

Splunk Overview-For Operational Intelligence & Log Management

What is Splunk:

It’s a popular Advanced IT Search Tool  used by many companies which derives information from machine data. To make it more lucid, Splunk has the ability to search, monitor and analyze through all machine generated data such as log data generated by applications, servers, and network devices across an organization. This product further indexes structured as well as unstructured data and helps in diagnosing the problems, making it easy for administrators, business analysts and managers to detect requisite information.

Splunk’s web interface makes its easy to examine data as an alternative of going through each log files individually. Splunk helps in easier monitoring and log aggregation thus allowing non experts and beginners to extract important data from the log entries.

Main Features of Teradata Database

Teradata has a Massive Parallel Processing  system, Shared Nothing Architecture thereby eliminating resource contention. Teradata is mainly designed to accommodate large data warehouse implementation and has many data warehousing features embedded into the core of the database. With linear scalability (Software can scale linearly with hardware), unconditional parallelism, multi-faceted parallelism, intelligent data distribution, parallel-aware optimizer makes Teradata is capable of handling large data and complex queries.