Re: [Fwd: Re: 10046 trace - unaccounted for time]
Date: Fri, 8 Aug 2008 14:23:12 +0300
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 :)