Database Administrator (DBA) Question:
Download Job Interview Questions and Answers PDF
How can you enable a trace for a session?
Answer:
Use the DBMS_SESSION.SET_SQL_TRACE or
Use ALTER SESSION SET SQL_TRACE = TRUE;
Use ALTER SESSION SET SQL_TRACE = TRUE;
Download Database Administrator (DBA) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How can you gather statistics on a table? | What is the difference between the SQL*Loader and IMPORT utilities? |