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 <Grant_at_towersoft.com.au> 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 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 down what object this is (i.e. table, index
> or whatever)?
>
> thanks
> Fuzzy
> :-)
>
>
>
> "Woo Hoo!" - H. Simpson
>
> The contents of this post are my opinions only
> If swallowed seek medical advice
>
> (Apologies for the excess signature)
> This email message (and attachments) may contain
> information
> confidential to TOWER Software. If you are not the
> intended recipient
> you cannot use, distribute or copy the message or
> message attachments.
> If you are not the intended recipient, please notify
> the sender by
> return email immediately and delete all copies of
> the message and
> attachments. Opinions, conclusions and other
> information in this
> message and attachments that do not relate to the
> official business of
> TOWER Software, are not given or endorsed by it.
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Grant Allen
> INET: Grant_at_towersoft.com.au
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Remember amateurs built the ark - Professionals built the Titanic"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Oct 16 2002 - 04:29:04 CDT