Oracle Database Discussions

Hi

I am not able to get wait events section in my tkprof output, probably because they were not captured in trace file.
Please help me in understanding what I missed in getting the wait events.

The wait events will help in understanding where the (elapsed - cpu) time was spent by Oracle.

I generated trace files using following steps:

1) Enquired paramters:
timed_statistics TRUE
timed_os_statistics 0
max_dump_file_size unlimited
statistics_level TYPICAL


2) Enabled trace using ---> exec sys.dbms_system.set_sql_trace_in_session (141,23652,TRUE);

3) then turned it off. ---> exec sys.dbms_system.set_sql_trace_in_session (141,23652,FALSE);

4) tkprof myfile_ora_35389658_Q2.trc Q2.txt sys=no explain=\" / as sysdba\"

--------My Query here--------------

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 45.00 62.00 0 79 0 157
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 45.00 62.00 0 79 0 157

Misses in library cache during parse: 1
Optimizer mode: ALL_ROWS
Parsing user id: 761
Number of plan statistics captured: 1

Rows (1st) Rows (avg) Rows (max) Row Source Operation
---------- ---------- ---------- ---------------------------------------------------
157 157 157 NESTED LOOPS (cr=79 pr=0 pw=0 time=2025 us cost=15 size=67 card=1)
157 157 157 NESTED LOOPS (cr=70 pr=0 pw=0 time=1234 us cost=15 size=52 card=1)
157 157 157 TABLE ACCESS FULL RPTNODE (cr=61 pr=0 pw=0 time=354 us cost=15 size=18907 card=511)
157 157 157 INDEX UNIQUE SCAN CENTER_ROLLUP_PK (cr=9 pr=0 pw=0 time=285 us cost=0 size=15 card=1)(object id 29247)
157 157 157 INDEX UNIQUE SCAN CENTER_ROLLUP_PK (cr=9 pr=0 pw=0 time=230 us cost=0 size=15 card=1)(object id 29247)

********************************************************************************


Following wait event section was MISSING from tkprof o/p:

Elapsed times include waiting on following events:
Event waited on Times Waited Max. Wait Total Waited
---------------------------------------- ---------- ----------------------------------------

Please help.

Thanks.