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

From: Anurag Verma <anuragdba_at_gmail.com>
Date: Wed, 15 Feb 2012 21:37:09 -0800
Message-ID: <CAFJhYoAX6_CwqQuShoiX95kWTQOrcps8_sK9Nm=KYPfkkWy9CQ_at_mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Feb 15 2012 - 23:37:09 CST

This message: [ Message body ]
Next message: Rajaram Subramanian: "Re: Identical table definitions, identical queries, identical xpalns: significant elapsed times in 2 different databases"
Previous message: Paresh Yadav: "Re: An unusual case of recovery asking for an archived log from long time a go."
Next in thread: Jeremiah Wilton: "Re: To find out the Top process or Top User sessions generating highest number of archive logs"
Reply: Jeremiah Wilton: "Re: To find out the Top process or Top User sessions generating highest number of archive logs"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message