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

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Mon, 06 Sep 2004 15:31:34 GMT
Message-ID: <Xns955C56BC27A11SunnySD@68.6.19.6>

spendius_at_muchomail.com (Spendius) wrote in 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
>

NO, it is in the trace file, which could be opened as an external table should you want to actually treat it is a table. Received on Mon Sep 06 2004 - 10:31:34 CDT