| Archive logswitch every minute (Oracle 8.1.7) [message #55980] |
Thu, 27 February 2003 14:59  |
Mathias Schulze
Messages: 1
Registered: February 2003
|
Junior Member |
|
|
Hello
does anybody have a hint for me ?
Our archivelog files switch about every minute and we cannot find the root cause.
We disconnected every user, restarted the database, and controled dba_jobs but nothing seems to stop the redolog files from switching. This happens once in a while, but during normal work days the logfiles switch correctly as planed after about 1 hour.
Do you have a idea where we can look at ?
msz
|
|
|
|
| Re: Archive logswitch every minute (Oracle 8.1.7) [message #56008 is a reply to message #55980] |
Fri, 28 February 2003 16:02  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Next time when happened again, query v$process and v$sqltext (join on ADDRESS), to see which processes are running and what SQL they are excuting. That should give you an idea what is going on.
Also check for any DBMS_JOB jobs or batch scripts running. Redo logs are generated because of DML so someone has to be doing it.
Another way is to load some of the redo logs in Logminer and see what kind of transactions you have.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
