RE: What can cause a rapid frequency of log switches?

From: <Jared.Still_at_radisys.com>
Date: Fri, 4 Jun 2004 15:35:32 -0700
Message-ID: <OF535E9164.B59A69F3-ON88256EA9.007BF831-88256EA9.007C17FD@radisys.com>

>Not my database though and I'm not at the site. I'm telling my friend "it
has to be database activity, there is no other reason."

Your "friend" could run a query against v$session and v$sess_io to find out which session(s)
are doing a lot of io. ;)

Jared

Jared.Still_at_radisys.com

oracle-l-bounce_at_freelists.org wrote on 06/04/2004 01:38:23 PM:

> Oracle 9.2.0.4 / AIX 5.1
>
> I'm looking at an issue with redo log switches.
> As far as I know, a log switch will only happen
> A) if the log is full
> B) if someone enters an "alter system switch logfile"
> C) if archive_log_target is set
>
> I've been asked why there would be a log switch in less than a minute
> (the redo logs are all 400 MB in size). The only answer I could think of
> is that there is a lot of activity in the database. Is there some
> possibility I'm overlooking?
>

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 Fri Jun 04 2004 - 17:32:32 CDT