| excess redo log generation [message #166095] |
Tue, 04 April 2006 08:51  |
SHYJU KT
Messages: 8
Registered: February 2004
|
Junior Member |
|
|
HI,
WE HAVE 10g DATABASE VERSION 10.2.0.1.0 RUNNING.
Our problem is that it generates excess redo logs at times.
The excess log generation(in one second, more than 10 logs) happens only sometimes and otherwise, database generates logs normally. ie; one in every 1 hour or so.
We have checked the transactions through log miner ,
we get millions of unsupported OPERATION with unsupported values in sql_undo and sql_redo columns ON ONE PARTICULAR TABLE.
Every time when excess logs are generated, the same table is creating the transaction entries with unsupported operation.
Can any one suggest what we can do to track these unsupported operation and find out what exactly is triggering this millions database activities.....
The table in question has only 400000 rows but the updations occurs more than 1600000 times at a time.
Regards,
Shyju
|
|
|
|
|
|
| Re: excess redo log generation [message #166312 is a reply to message #166147] |
Wed, 05 April 2006 12:04  |
SHYJU KT
Messages: 8
Registered: February 2004
|
Junior Member |
|
|
hi,
Thanks for the response.
I have closely monitored the table. It is being inserted/updated from only one d2k form and nothing much in that form apart from plain execute_query and commit_form.
Why is it showing unsupported operations in the v$logmnr_contents???? That too in millions and eventually creating many logs !!!!!!!!
Only some times say three/four times in a day , this happens.
Otherwise, the database is smooth running with 1 or two log switches per hour.
Regards,
Shyju
|
|
|
|
|
|
| Re: excess redo log generation [message #166410 is a reply to message #166344] |
Thu, 06 April 2006 03:44 |
SHYJU KT
Messages: 8
Registered: February 2004
|
Junior Member |
|
|
Could U Please elaborate that....
What could be the solution ????
Table Recreation ?????
I think I will redefine the table using dbms_redefine and see the effect!!!!!!!
Regards,
Shyju
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
