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.

 

Setup Autotrace for a User Account in Oracle

Use SQL*Plus Built-in Timer in Oracle

Introduction to Command-Line SQL*Plus Client Tool

⇑⇑ Oracle Database Tutorials

2020-06-08, 1593🔥, 0💬