Re: Do some V$/X$ tables give same details as a 10046 trace ?

• Post for FREE via your newsreader at post.usenet.com ****

"Spendius" <spendius_at_muchomail.com> wrote in message news:aba30b75.0409060707.603d7313_at_posting.google.com...
> Do you think all the information that's recorded in a 10046 level 12
> trace file (in the lines like:
> >PARSE #3:c=20000,e=12342,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=160093
> >EXEC #1:c=0,e=506,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=16009175
> >[etc etc.])
> can be found in certain (fixed) tables or views ?
>
> I doubt it, but one never knows...
> Thanks.
> Sp

Hi Spendius

All information no, but as of 9.2 you can get interesting data through V$SQL_PLAN_STATISTICS_ALL. In fact the view gives the execution plan, information about the CBO estimates (like PLAN_TABLE) and runtime information like the following at operation level:

- LAST_CR_BUFFER_GETS
- LAST_CU_BUFFER_GETS
- LAST_DISK_READS
- LAST_DISK_WRITES
- LAST_ELAPSED_TIME

Chris

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=