What Is Oracle Server Autotrace

Q

What Is Oracle Server Autotrace? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool

✍: FYIcenter.com

A

Autotrace is Oracle server feature that generates two statement execution reports very useful for performance tuning:

  • Statement execution path - Shows you the execution loop logic of a DML statement.
  • Statement execution statistics - Shows you various execution statistics of a DML statement.

To turn on the autotrace feature, the Oracle server DBA need to:

  • Create a special table called PLAN_TABLE.
  • Create a special security role called PLUSTRACE.
  • Grant PLUSTRACE role your user account.

2007-04-29, 4748👍, 0💬