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

  • From: Jared.Still@xxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 4 Jun 2004 15:35:32 -0700

>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@xxxxxxxxxxx

oracle-l-bounce@xxxxxxxxxxxxx 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?
> 

Other related posts: