What is a trace file and how is it created?

- The files that are created when an oracle background process encounters an exception are Trace files.

- Processes like dbwr, lgwr, pmon, smon create them.

- Trace files are also created by ORA-00600 error or due to some diagnostic dump events

- The SQL Trace facility provides performance information on individual SQL statements.

It generates the following statistics for each statement:

a. Parse, execute, and fetch counts.
b. CPU and elapsed times.
c. Physical reads and logical reads.
d. Number of rows processed.
e. Misses on the library cache.
f. Username under which each parse occurred.
g. Each commit and rollback.

- The SQL Trace facility can be enabled for a session or for an instance.

- When the SQL Trace facility is enabled, performance statistics for all SQL statements executed in a user session or in the instance are placed into trace files.

- The additional overhead of running the SQL Trace facility against an application with performance problems is normally insignificant compared with the inherent overhead caused by the application's inefficiency.
What are Tablespace Quota and default tablespace?
A tablespace is a logical storage unit within an Oracle database because it is not visible in the file system of the machine, the database resides on.....
What is Auditing? What are the different Levels of Auditing?
Auditing includes reading, writing and deleting the access on the objects at the table level. The privileges granted to a user can be audited....
Explain Statement Auditing, Privilege Auditing, And Object Auditing
There are three levels of auditing: Statement level: Statements found in stmt_audit_option_map are audited.....
Post your comment