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

Home -> Community -> Usenet -> c.d.o.server -> Re: Usage of Multiple Buffer Pools

Re: Usage of Multiple Buffer Pools

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 20 May 2003 07:20:53 -0700
Message-ID: <1b061893.0305200620.4822909c@posting.google.com> 




> 1. How can I sample I/O per segment other than pinging




>    V$SESSION_WAIT?


>    In V$SESSION_WAIT I can capture only current waits and if I/O is

>    taking place at the moment, and save FILE# and BLOCK#. But this

>    means I should ping V$SESSION_WAIT very frequently.




In 9i, you could use the dynamic view V$SEGSTAT, which gives among
other stats the I/O per segment.



Daniel
Received on Tue May 20 2003 - 09:20:53 CDT












Original text of this message













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