To find out the Top process or Top User sessions generating highest number of archive logs

  • From: Anurag Verma <anuragdba@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 15 Feb 2012 21:37:09 -0800

Hi all,

How to find out which process or user session(s) are generating highest
number of archive logs in a RAC database?

My database is in 10.2.0.3 RAC

In 10.2.0.3 Grid control, I noticed there is a link "Top Segments", but it
does not have any info on segments having highest physical writes.

Thanks in advance...

-- 

Anurag Verma,
Database Administrator
ERCOT(Electric Reliability Council of Texas),
Texas 76574


--
//www.freelists.org/webpage/oracle-l


Other related posts: