1 Reply Latest reply on Jan 23, 2013 5:03 PM by Iordan Iotzov

    RAC Clsuter waits

    DBA112
      Deae experts,

      RDBMS - 11.2.0.3,
      Any idea how we can find cluster waits for a particular service in a database for last 24 hours?

      AWR report has database wide - not a specific service..
        • 1. Re: RAC Clsuter waits
          Iordan Iotzov
          You can find quite a bit of useful information about services in dba_hist_service_stat data dictionary view. Make sure you have the appropriate licenses to use that view.

          The query to get what you want would probably look something like this:
          select 
              * 
          from 
             dba_hist_service_stat
          where 
             stat_name = 'cluster wait time'
          and 
             service_name = ‘SERVICE..’
          and 
             snap_id between .. and ... 
          Iordan Iotzov
          http://iiotzov.wordpress.com/