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
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what functionality does oracle provide to secure sensitive information?
What is a system database and what is a user database? : sql server DBA
what is the use of ocr?
How would you extract DDL of a table without using a GUI tool?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is the use of recording information about current session?
Where would you look for errors from the database engine?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Explain materialized views and how they are used.
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how can you initialize log miner?
what are the benefits of flashback feature?
. 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?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
