Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
Enable trace at session level
( A )to start trace:
ALTER SESSION SET sql_trace = TRUE;
- or -
EXECUTE dbms_session.set_sql_trace (TRUE);
- or -
EXECUTE dbms_support.start_trace;
(B) to stop trace:
ALTER SESSION SET sql_trace = FALSE;
- or -
EXECUTE dbms_session.set_sql_trace (FALSE);
- or -
EXECUTE dbms_support.stop_trace;
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Which autogrowth database setting is good? : sql server DBA
What are the recovery models for a database? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is transparent data encryption? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
What is the difference between clustered and non-clustered index? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What the different components in replication and what is their use? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What authentication modes does sql server support? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
