Re: [Fwd: Re: 10046 trace - unaccounted for time]

2008/8/8, Tanel Poder <tanel.poder.003_at_mail.ee>:
> The reason why you didn't see any cursor using that CPU time could be due
> how some Oracle calls are handled.
>
> For example when you run "describe xyz" in sqlplus, that describe command
> does not go through normal cursor parse/execute/fetch cycle. In fact there
> is no library cache cursor associated with this call at all (describe calls
> opidsc directly in kernel).

Aside from original topic this is cool insight for me. A while ago I tried to trace sql*plus session for desc <tablename> and was wondering why nothing is in trace file although SQL*Plus have to __somehow__ get info out of data dictionary. Now I know :)

Gints Plivna
http://www.gplivna.eu

--
http://www.freelists.org/webpage/oracle-l