| vikhardba |
Posted: Dec 28, 2007 12:19:56 AM |
Total Post: 86
Joined: Apr, 2007
|
Hi to All,
Can i know how to find out whether the database is in rollback or undo?
I am using Oracle 9i and 10g on two different platforms respectively.
|
|
|
 Murtuja |
| Posted: Dec 28, 2007 01:39:26 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
|
|
|
|
| Murtuja |
| Posted: Dec 28, 2007 01:46:01 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
The following initialization parameter setting causes the STARTUP command to start an instance in automatic undo management mode:
UNDO_MANAGEMENT = AUTO
If you use the rollback segment method of managing undo space, you are said to be operating in the manual undo management mode. If you use the undo tablespace method, you are operating in the automatic undo management mode. You determine the mode at instance startup using the UNDO_MANAGEMENT initialization parameter.
|
|
|
|
|
| vikhardba |
| Posted: Dec 28, 2007 11:07:59 PM | |
|
Total Post: 86
Joined: Apr, 2007
|
Thanks for your response. I am using Oracle 9i, how can i know how many rollbacks are there if undo_management is set to manual. Is there any view?
Thanks once again.
|
|
|
|
|
| Mohammed Taj |
| Posted: Dec 29, 2007 12:20:35 AM | |
|
Total Post: 704
Joined: Jul, 2007
|
Yes, you can check "select status from v$rollstat;"
http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/undo.htm#8243
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
