Database

This section contains various Oracle database related articles, tutorials and white papers covering a wide range of areas starting from Oracle architecture to performance tuning

How to find out Which User is Running what SQL Query in Oracle database?

Details: Category: Database Oracle; Published on Monday, 16 August 2010 21:35; Written by Akash Mitra; Hits: 626

Do you wonder how to get information on all the active query in the Oracle database? Do you want to know what query is executed by which user and how long is it running? Here is how to do it!

How to find out Expected Time of Completion for an Oracle Query

Details: Category: Database Oracle; Published on Tuesday, 08 June 2010 15:43; Written by Akash Mitra; Hits: 670

Too often we become impatient when Oracle Query executed by us does not seem to return any result. But Oracle (10g onwards) gives us an option to check how long a query will run, that is, to find out expected time of completion for a query.

Oracle AUTOTRACE Explained - A 10 Minute Guide

Details: Category: Database Oracle; Published on Wednesday, 28 April 2010 17:23; Written by Akash Mitra; Hits: 930

AUTOTRACE is a beautiful utility in Oracle that can help you gather vital performance statistics for a SQL Query. You need to understand and use it for SQL Query Tuning. Here is how!

Understanding Oracle QUERY PLAN - Part2 (Exploring SQL Joins)

Details: Category: Database Oracle; Published on Saturday, 08 May 2010 22:30; Written by Akash Mitra; Hits: 442

This is the second part of the article Understanding Oracle Query Plan. In this part we will deal with SQL Joins.

UTL_FILE

Details: Category: Database Oracle; Published on Wednesday, 28 April 2010 17:18; Written by Saurav Mitra; Hits: 508

The Oracle supplied PL/SQL package UTL_FILE used to read and write operating system files that are located on the database server.

Understanding Oracle QUERY PLAN - A 10 minutes guide

Details: Category: Database Oracle; Published on Friday, 30 April 2010 20:43; Written by Akash Mitra; Hits: 705

Confused about how to understand Oracle Query Execution Plan? Here is a 10 minutes step by step primer that will teach you all the right things that you must know about it.

Different Methods to move data from Oracle to External File

Details: Category: Database Oracle; Published on Wednesday, 28 April 2010 17:17; Written by Saurav Mitra; Hits: 608

How to push data from Oracle Table to external files? Well, external tables in Oracle provides a way to move data in as well as out of the database with the help of SQL*Loader and Data Pump functionality.

Oracle Analytic Functions

Details: Category: Database Oracle; Published on Wednesday, 28 April 2010 18:35; Written by Saurav Mitra; Hits: 484

Oracle Analytic Functions compute an aggregate value based on a group of rows. It opens up a whole new way of looking at the data. This article explains how we can unleash the full potential of this.

Database Performance Tuning

Details: Category: Database Oracle; Published on Wednesday, 28 April 2010 17:14; Written by Akash Mitra; Hits: 499

This article tries to comprehensively list down many things one needs to know for Oracle Database Performance Tuning. The ultimate goal of this document is to provide a generic and comprehensive guideline to Tune Oracle Databases from both programmer and administrator's standpoint.