| PRANABH |
Posted: Oct 16, 2006 01:31:16 AM |
Total Post: 4
Joined: Sep, 2006
|
I am finding reasons why in the database i am handling UNDO tablespace gets corrupted time and again so that i can rectify the
problem.
For this
1.I have shanged undo_retention parameter to 40 so
that there is not much undo retention required which
may have caused to break down of undo segments.Earlier
it was 10800.
2.I have added a datafile to undo tablespace with
autoextend on and checked parameter undo_management.It
is AUTo so that the error may not be becuse of less
undo space or expansion of undo previous datafile.
3.I have decreased fast_start_mttr_target from 300 to
50 so that checkpoint is fired after approx. so much
time and recovery time is reduced,causing less undo
utalization.
4.I am looking for any network errors which may have
caused distributed processing haults during updation
causing undo segment failures.I saw some warning
messages in windows server regarding network error.
Though if a transaction is breaked in between updation
without commit or rollback the Oracle background
processes should bring the same in consistent state
but I think that due to large updations there is some
problem with undo segments.This is under observation
and now i will be updating it under my supervision
and not by batch processing so that i can
know wether it is the root cause of problem.
Pls give your suggesions on above points.
Thanks and Regards
Pranabh
|
|
|
 nirav |
| Posted: Oct 22, 2006 07:00:38 AM |  |
|
Total Post: 20
Joined: Jun, 2005
|
did u open a tar with oracle?
|
|
|
|
|
| PRANABH |
| Posted: Oct 22, 2006 07:12:53 PM | |
|
Total Post: 4
Joined: Sep, 2006
|
No I do not know about tar and i never opened it.
Regards
Pranabh
|
|
|
|
|
| nirav |
| Posted: Oct 23, 2006 02:47:29 AM | |
|
Total Post: 20
Joined: Jun, 2005
|
a tar is a Technical Assistance Request...it is opened with Oracle Support..for that you should have an oracle metalink id..do you have oracle support and a metalink account?
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
