-
Hi,
Yesterday I observed abnormally high no of Archlogs Generation.
In normal cases I get around 4 GB of ArchLogs. Yesterday it crossed 30GB.
Can I check weather there was some problem due to which this had happened or some other issue.
Yesterday Logs were switching twice per minute also sometimes.
My RedoLog file size is 20MB and the user are 300.
I am running SAP on Oracle 816 / NT.
-
Same problem happened to me.
I used logminer to see what was in the logs and narrowed it down to an object which kept cropping up in the logs.
I sent this info to Oracle and I was told that the object had a permanent lock on it or something like that. gave this information to our application developers who were able to resolve the issue (they were the cause of the issue in the first place).
The best thing to do is mine your log or dump it and investigate what is in them. Take it from there.
Info on how to do this can be found on Oracle Metalink.
-
Hi Suresh,
Thanks for the reply.
Can I make use of my other server as I don't want to do anything on my production server.
I mean can I check these use logs on other machine.
regds
vijay
-
sure you can.
You have to make sure that the dictionary file is created from the database the log file came from.
It is all documented
http://home.clara.net/dwotton/dba/logminer.htm