Email us [email protected]
Choose currency

editor01

About editor01

This author has not yet filled in any details.
So far editor01 has created 32 entries.

How to use TAR command in Unix

“tar” is called as tape archive a command in UNIX or Linux is one of the important command which provides archiving functionality in UNIX.

The tar command used to merge a collection of files and directories into highly compressed archive file commonly called tarball or tar, gzip and bzip in Linux. Its very widely used […]

Flash Recovery Area in Oracle 11g

Flash Recovery Area is the most powerful tool available from Oracle 10g, that plays a vital role in performing database backup & recovery operations. From Oracle 11g release2, flash recovery area is called as fast recovery area.
Flash Recovery Area can be defined as a single, centralized, unified storage area that keep all the database […]

Overview of Partitioning in Oracle 11g

Partitioning in Oracle

Oracle introduced partitioning with Oracle8.

Partitioning allows tables or materialized views or indexes(based on table or materialized view) or index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularity. Each partition of a table or index must have the […]

Data Science and Data Mining

What are the differences between data science, data mining, machine learning, statistics, operations research, and so on?

Here I compare several analytic disciplines that overlap, to explain the differences and common denominators. Sometimes differences exist for nothing else other than historical reasons. Sometimes the differences are real and subtle. I also provide typical job titles, […]

How to monitor temp space usage in Oracle 11g

As more often we’ve noticed that temp usage hits max in certain situations and in order for DBA to proactively monitor and get notified, DBA can schedule script to monitor temp space usage and here is the sample script that can scheduled to run more often ( probably every 15 or 10 mins frequency […]

How to use Explain Plan Oracle 11g

EXPLAIN PLAN Usage

When an SQL statement is passed to the server the Cost Based Optimizer (CBO) uses database statistics to create an execution plan which it uses to navigate through the data. Once you’ve highlighted a problem query the first thing you should do is EXPLAIN the statement to check the execution plan that […]

Procedure to Perform DR test using Snapshot STANDBY of Data Guard

The Snapshot standby is an Oracle 11g feature following which a physical standby database can be used in Read-Write mode for testing purposes mainly for short period of time.

Characteristics : (Ref Metalink Note: 443720.1)

1. Snapshot standby database receives and archives, but does not apply the redo data.

2. Redo data received from the primary database […]

What is OLAP and OLTP

On Line Transaction Processing  is processing of short and simple transaction data at operational sites i.e. day to day operations in the Source systems. The Database is designed as Application-oriented (E-R based) i.e Highly Normalized so as to efficiently support INSERT and UPDATE operations. Data stored in these systems are raw Current and Isolated […]

Space Growth Monitoring of DB2 LUW Tables

Growth Monitoring of size of DB2 tables – SYSIBMADM.ADMINTABINFO

Application database tables in DB2 LUW environment grows or shrinks over the period of time , and for DBA to monitor space growth can be viewed in DB2 administrative view called SYSIBMADM.ADMINTABINFO so nothing too complicated to do here; full details about SYSIBMADM.ADMINTABINFO can be found […]

DBA Unix commands

Unix for the DBA

How to kill all similar processes with single command

ps -ef | grep eagle |grep -v grep | awk ‘{print $2}’ |xargs -i kill -9 {}
Locating Files under a particular directory
find . -print |grep -i test.sql
 Using AWK in UNIX
To remove a specific column of output from a UNIX command – for example […]