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

From: Gints Plivna <>
Date: Fri, 8 Aug 2008 14:23:12 +0300
Message-ID: <>

2008/8/8, Tanel Poder <>:
> 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

Received on Fri Aug 08 2008 - 06:23:12 CDT

Original text of this message