New to this topic? Not sure where to start? For your convenience, we have created the below learning path where articles are organised in the order of their relevance and complexity. Start from the beginning and read one by one to master the subject.
|1||Learn Oracle Server Architecture in 10 minutes||Basic|
|2||Oracle External Tables||Basic|
|5||Different Methods to move data from Oracle to External File||Basic|
|6||Oracle Analytic Functions||Intermediate|
|7||How to find out Expected Time of Completion for an Oracle Query||Intermediate|
|8||How to find out Which User is Running what SQL Query in Oracle database?||Intermediate|
|9||Understanding Oracle QUERY PLAN - A 10 minutes guide||Intermediate|
|10||Understanding Oracle QUERY PLAN - Part2 (Exploring SQL Joins)||Intermediate|
|11||Oracle AUTOTRACE Explained - A 10 Minute Guide||Advanced|
|12||Database Performance Tuning||Basic|
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.
This is the second part of the article Understanding Oracle Query Plan. In this part we will deal with SQL Joins.
Confused about how to understand Oracle Query Execution Plan? This 10 minutes step by step primer is the first of a two part article that will teach you exactly the things you must know about Query Plan.
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!
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.
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.