What Is Oracle Server Autotrace in Oracle


What Is Oracle Server Autotrace in Oracle?

✍: FYIcenter.com


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.


Introduction to Command-Line SQL*Plus Client Tool

⇒⇒Oracle Database Tutorials

2020-06-08, 740👍, 0💬