| Re: Unnecessary Indices [message #52762] |
Mon, 12 August 2002 06:12  |
Andrew Ballance
Messages: 3
Registered: August 2002
|
Junior Member |
|
|
Thanks that did the trick! One thing I noticed as I
was automating this beast was that it is necessary to
export the x$bh memory map to a table and then join it
to dba_extents and then to dba_segments in order to
get an appreciation of the percentage of the object's
total size which is cached.
So the question is, are there known ways of performing
joins with x$ tables so that you don't grind the
server to a halt? Or is it just a case of trial and
error (and to be on the safe side always creating
copies of the x$ data at any given point in time)?
Cheers
Andy
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
