Topic : Performance Tuning

How do you enable traceing while you are in the database?


Answer :

SQL>alter session set sql_trace=true;

Show Answer Discuss

If you want to enable tracing in remote system? what will u do?


Answer :

SQL>exec dbms_system.SET_SQL_TRACE_IN_SESSION(9;3;TRUE);

Show Answer Discuss

What is the parameter to set the user trace enabiling?


Answer :

Sql_trace = true

Show Answer Discuss

Types of trace files?


Answer :

1. trace files generated by database (bdump)
2. trace files generated by user(udump)

Show Answer Discuss

How do you enable monitoring of a table?


Answer :

Alter table tablename monitoring

Show Answer Discuss