Re: Index vs. table scans in statspack reports

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>This may give you a clue about the object that is
>the hot object. A high touch count (tch) means heavy
>use. The OBJ column maps to the data_object_id in
>dba_objects (or dataobj# in sys.obj$ if you want a
>less expensive check).

What could I do then with the hot object? Difficult to split into different disks...

Bye
Rick Denoire Received on Sun Nov 30 2003 - 08:45:54 CST