| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index Usage Monitoring
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 ORACLE-L_at_fatcity.com
Vadim Gorbounov <vgorbounov_at_simplyengineering.com> on 02/05/2001 09:30:47 AM
Message - From: Vadim Gorbounov <vgorbounov_at_simplyengineering.com> on
02/05/2001 03:30 PM GMT
To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
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: pprince_at_oppd.com Omaha Public Power District voice: (402) 636-3762444 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: pprince_at_oppd.com 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Feb 05 2001 - 16:35:37 CST
(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: vgorbounov_at_simplyengineering.com 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: ListGuru_at_fatcity.com (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: exu_at_nnng.com 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: ListGuru_at_fatcity.com (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: vgorbounov_at_simplyengineering.com 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: ListGuru_at_fatcity.com (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).
 |
 |