What is Oracle Server Autotrace?

Oracle - What is Oracle Server Autotrace? - Feb 07, 2010 at 14:20 PM by Shuchi Gauri

What is Oracle Server Autotrace?

It is a utility that provides instant feedback on successful execution of any statement (select, update, insert, delete). It is the most basic utility to test the performance issues.

Oracle - What is Oracle Server Autotrace? - June 27, 2009 at 11:00 AM

What is Oracle Server Autotrace?  

The Autotrace feature of Oracle server generates two statement execution reports which are useful for performance tuning. They are:

1. Statement execution path
    Displays execution loop logic of a DML statement.

2. Statement execution statistics
     Displays various execution statistics of a DML statement.

Steps to turn the autotrace feature ON:
Create table PLAN_TABLE.
Create a special security role called PLUSTRACE.
Grant PLUSTRACE role your user account.

Also read

Explain the concepts of Exception in Oracle. Explain its type.

Exceptions in oracle occur when unwanted situations happen during the execution of a program. They can occur due to system error, user error or application error.............

What are SQL*Plus Environment variables?

The behaviour of SQL PLUS depends on some environmental variables predefined in the OS: ORACLE_HOME: This variable stores the home directory where the Oracle client.............

Explain the difference between a data block, an extent and a segment.

A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks.............

Advantages of PL/SQL

Support SQL data manipulation, provide facilities like conditional checking, branching and looping..............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience