Database Administrator (DBA) Question:

How can you enable a trace for a session?

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

Answer:

Use the DBMS_SESSION.SET_SQL_TRACE or
Use ALTER SESSION SET SQL_TRACE = TRUE;


Previous QuestionNext Question
How can you gather statistics on a table?What is the difference between the SQL*Loader and IMPORT utilities?