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
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to...
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists.
I want to find the length of a numeric datatype field in my table. How can I find it?
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.