Look at x$bh (or v$bh) for rows where
the TCH (touch count) column is high,
then interpret the obj column by reference
to the data_object_id of dba_objects.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
yewpc wrote in message <3c425a95$1_at_usenetgateway.com>...
>Hi,
>
> Does anyone know how to write a PL/SQL or just SQL stmt that able to
> determine which object ie table or index is having a hot spot ?
>
>
>Thank you
>
>
>
>--
>Posted via dBforums
>http://dbforums.com
>
Received on Wed Jan 16 2002 - 07:21:44 CST
