Q
Problem solve Get help with specific problems with your technologies, process and projects.

Archive log files generating quickly

Yesterday users complained that performance was going down; after than I checked in the database and I found that archive log files are generating very quickly, nearly two archive log files in a minute with a size of 100 MB each. But normally it takes one hour for one archive file to generate.

I have a problem in my database. I am using Oracle9i release 2 with patch 5 as my production database in archive log mode. Yesterday users complained that performance was going down; after than I checked in the database and I found that archive log files are generating very quickly, nearly two archive log files in a minute with a size of 100 MB each. But normally it takes one hour for one archive file to generate. After I restart the database then it runs very smoothly. Then I swtich to the Logminer to see the activities but while generating the output of that archive file from v$logmnr_contents through SYS user, it comes out from the session and throws an error, ORA-03113 saying end-of-communication channel.
This is probably due to running out of space. The table that used to hold the data from Logminer sessions is actually a virtual table that exists in memory. Another issue is caused by some unresolved bugs in 9i. Jared Still suggests: "Running logmnr_create_replace_metadata is one option, but that is not exactly 'supported'."

Dig Deeper on Oracle error messages

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close