I have 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, I checked the database; the archive log files are
generating very quickly, nearly 2 archive log files in a minute,
100 mb each. Normally it takes one hour for one archive file to
generate.
I restarted the database then it runs very
smoothly. I switch to the log miner to see the activities from the
archive log file but while generating the output of the archive file
v$logmnr_contents through SYS user the session ends abruptly and a
ORA-03113 error message appears saying, "end-of-communication
channel".
Please solve my problem!!
This question posed on 29 November 2005
Answer:
This is probably due to running out of
space. The table used to hold the data from log miner 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'."
