Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Hot indexes

Re: Hot indexes

From: Tanel P§der <tanel.poder.003_at_mail.ee>
Date: Mon, 12 Jul 2004 11:05:45 +0300
Message-ID: <101701c467e7$09293ba0$bff923d5@porgand>


> You probably meant tracking PIO calls here, since v$session_wait and 10046
> trace arent able to report LIOs in detailed level. If one wanted to track
> LIOs, event 10200 could be used. But as you said, it would generate huge

One more comment, event 10200 traces only consistent gets, not all possible types of LIOs.

Tanel.



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Jul 12 2004 - 03:02:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US