Re: [Fwd: Re: 10046 trace - unaccounted for time]
- From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
- To: tanel.poder.003@xxxxxxx
- Date: Fri, 8 Aug 2008 14:23:12 +0300
2008/8/8, Tanel Poder <tanel.poder.003@xxxxxxx>:
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
