Hi, Eveleen,
you a right, x$bh is the veiw, which contain important information
about database buffer. This means, you will find here references to only
those database blocks, which are currently in buffer, i.e., most recently
used. You even can identify "hot" (often updated) blocks, because Oracle
reconstructs block image in memory for different queries, and this will be
different records in x$bh. I use the following query
select FILE#, DBABLK, count(*) from x$bh
group by FILE#, DBABLK
having count(*) > 10
order by 3 desc;
Top line blocks are subjects to revise segment parameters. But this doesn't
not completely the same task, as in question.
Vadim Gorbounov
Oracle DBA
-----Original Message-----
Sent: Monday, February 05, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L
I do know there is a way to tell which indexes are accessed most recently by
query x$bh view. Is this what you want or something different? Sorry I
forgot
the initial posting of this issue.
Eveleen
Please respond to [EMAIL PROTECTED]
Vadim Gorbounov <[EMAIL PROTECTED]> on 02/05/2001 09:30:47 AM
Message - From: Vadim Gorbounov <[EMAIL PROTECTED]> on
02/05/2001 03:30 PM GMT
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc: (bcc: Eveleen Xu/NNIB/NNNG)
Subject: RE: Index Usage Monitoring
Hi,
Why not to use otrace? Of cource, you may need some space to save
trace results, but you'll definitely get complete statistics.
Vadim Gorbounov
Oracle DBA
-----Original Message-----
Sent: Tuesday, January 30, 2001 3:57 PM
To: Multiple recipients of list ORACLE-L
We have a purchased application with over 1,300 indexes.
Can someone suggest a method to monitor the system to
determine which indexes are actively being used over time? I'm assuming
that some are old/not necessary and would like to save the overhead
of maintaining them.
Oracle 8.0.6
Patrick Prince email: [EMAIL PROTECTED]
Omaha Public Power District voice: (402) 636-3762
444 S 16th St. Mall, Omaha, NE 68102 fax: (402) 636-3931
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: PRINCE, PATRICK W.
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vadim Gorbounov
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vadim Gorbounov
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
