How can you enable a trace for a session?
Answer / 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 |
How would you best determine why your MVIEW couldn't FAST REFRESH?
any body know about orawaves do they really provide placements in their unique placement program
how do see how much space is used and free in a tablespace
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????
by issuing "alter tablespace begin backup;" what happens to tablespace?
WHEN DOWN TIME WHAT CAN U DO?
when does an alert gets signaled?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is ora 600?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)