What Is Oracle Server Autotrace in Oracle

Q

What Is Oracle Server Autotrace in Oracle?

✍: 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.

 

Introduction to Command-Line SQL*Plus Client Tool

⇒⇒Oracle Database Tutorials

2016-10-16, 189👍, 0💬