|
|
|
|
|
|
| Author |
Message |
Sybrand Bakker
*nix forums Guru
Joined: 03 Apr 2005
Posts: 1766
|
 Posted: Sun Feb 06, 2005 11:20 am Post subject:
Re: Why sometime redo log switch very fast?
|
|
|
On Sun, 6 Feb 2005 16:47:40 +0800, "music4" <music4@163.net> wrote:
| Quote: | A redolog switch every minute is really undesirable, let alone every
20 seconds.
If you have a redolog switch every 20 seconds it simply measn your
application is generating three times as much redolog volume.
You can easily find out what is going on using logminer.
Oracle doesn't have any mechanism to increase the number of redolog
switches.
--
Sybrand Bakker, Senior Oracle DBA
Sybrand,
Thanks for your answer. But the problem is from our applicaton's log, we am
sure our application did generate too much redolog. So I want to check what
generated too much redo?
And what's "logminer"? I cannot find it under $ORACLE_HOME/bin.
Evan
|
Logminer is a pl/sql utility, you can apply to online and archived
redologs
The utility reads the logs and populates v$logmnr_contents
You populate this by using
dbms_logmnr.add_file
and you start working with them using
dbms_logmnr.start_logmnr
after that you can select from v$logmnr_contents
In it's bare form it won't however list table names and colum names,
you'll need
dbms_logmnr_d
to create a copy of the datadictionary in flat file format.
More details in Appendix A of Thomas Kyte's Expert One on One book
and of course in the Oracle Supplied Packages reference.
Hth
--
Sybrand Bakker, Senior Oracle DBA |
|
| Back to top |
|
 |
music4
*nix forums beginner
Joined: 22 Feb 2005
Posts: 18
|
| Posted: Sun Feb 06, 2005 7:47 am Post subject:
Re: Why sometime redo log switch very fast?
|
|
|
| Quote: | A redolog switch every minute is really undesirable, let alone every
20 seconds.
If you have a redolog switch every 20 seconds it simply measn your
application is generating three times as much redolog volume.
You can easily find out what is going on using logminer.
Oracle doesn't have any mechanism to increase the number of redolog
switches.
--
Sybrand Bakker, Senior Oracle DBA
|
Sybrand,
Thanks for your answer. But the problem is from our applicaton's log, we am
sure our application did generate too much redolog. So I want to check what
generated too much redo?
And what's "logminer"? I cannot find it under $ORACLE_HOME/bin.
Evan |
|
| Back to top |
|
|
Sybrand Bakker
*nix forums Guru
Joined: 03 Apr 2005
Posts: 1766
|
| Posted: Sun Feb 06, 2005 7:34 am Post subject:
Re: Why sometime redo log switch very fast?
|
|
|
On Sun, 6 Feb 2005 16:25:24 +0800, "music4" <music4@163.net> wrote:
| Quote: | Greetings,
Recently, we found a strange on our system. Our system uses Oracle 8.1.7.
Each day, we can find a period that lasts about 10 minutes, during that
period, from alartSID.log file, we can see redo log switches very fast.
Normally, redo log switch each minute, but during that period, redo log
switches each 20 seconds.
From our program's log file, we are sure our program doesn't perform special
operations at time. So we guessed there might be somebody did manually
operations, like update, detele, etc. at that time. But nobody admit they
did manually operations.
So I just want to know is it possible that Oracle itself do something that
cause redo log switch very fast?
Regards,
Evan
|
A redolog switch every minute is really undesirable, let alone every
20 seconds.
If you have a redolog switch every 20 seconds it simply measn your
application is generating three times as much redolog volume.
You can easily find out what is going on using logminer.
Oracle doesn't have any mechanism to increase the number of redolog
switches.
--
Sybrand Bakker, Senior Oracle DBA |
|
| Back to top |
|
|
music4
*nix forums beginner
Joined: 22 Feb 2005
Posts: 18
|
| Posted: Sun Feb 06, 2005 7:25 am Post subject:
Why sometime redo log switch very fast?
|
|
|
Greetings,
Recently, we found a strange on our system. Our system uses Oracle 8.1.7.
Each day, we can find a period that lasts about 10 minutes, during that
period, from alartSID.log file, we can see redo log switches very fast.
Normally, redo log switch each minute, but during that period, redo log
switches each 20 seconds.
From our program's log file, we are sure our program doesn't perform special
operations at time. So we guessed there might be somebody did manually
operations, like update, detele, etc. at that time. But nobody admit they
did manually operations.
So I just want to know is it possible that Oracle itself do something that
cause redo log switch very fast?
Regards,
Evan |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Jan 08, 2009 3:04 am | All times are GMT
|
|
Remortgaging | Free Animated Greetings | Credit Cards | MPAA | Advertising
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
