And if we're only talking a limited number of indexes, you can isolate them
in separate tablespaces/datafiles and look at v$datafile.
Mogens
Sutton, Reed wrote:
Prem,
I found this on Google. Some guy named Thomas Kyte? He sounds like
maybe he might know what he is talking about ;
Prem,
I found this on Google. Some guy named Thomas Kyte? He sounds like
maybe he might know what he is talking about ;-) Unfortunately I don't
have his book here with me now so I am not sure exactly what code he is
talking about, but this should be a good start for you.
>Question:
>
>H
Prem
That is a 9i feature. One way in 8i is to regularly sample the SQL in the
buffers, run explain plan on it, and scan the results for that specific
index name. Another way is to drop the index and see if anyone complains ;-)
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
--
