Hi all,
For some reason my 9.0.1 windows install has no tkprof binary, so I'm
trying to decipher some 10046 output. I've got a bunch of
WAIT #1: nam='db file sequential read' ela= 6467 p1=7 p2=219340
p3=1
For this event, p1 is the file, and p2 is the block. Any ideas on how
to track
select * from dba_extents
where file_id = P1
and P2 between block_id and (block_id + (blocks - 1));
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, October 15, 2002 9:03 PM
table or index
Hi all,
For some reason my 9.0.1 windows instal
This is a known oversight...I haven't verified this,
but I've read that you can use the 8.1.6+ one, or the
9.2 one if you've got it handy. In the 8.1 case, the
timings may be a little off due to the change in
precision
hth
connor
--- Grant Allen <[EMAIL PROTECTED]> wrote: > Hi
all,
>
> For so
it's a bug in the install package, they "forgot" to include tkprof
... you can get a copy of it off Metalink I believe
--- Grant Allen <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> For some reason my 9.0.1 windows install has no tkprof binary, so I'm
> trying to decipher some 10046 output. I've go
Go to the "$OH/rdbms/lib" directory as the "oracle" user and run "make -f
ins_rdbms.mk itkprof"...
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 16, 2002 7:39 AM
to table or index
> it's a bug in the install package, they "f