Thanks for the prompt reply in the forum.
btw, When we use AUTO value for UNDO Management, it is supposed to be handled by oracle AUTOmatically.
I have read the docs. there is not much info reg. this......
My question is :
If Oracle is handling it, then why contention for UNDO HEADER in V$waitstat...inspite of being allocated enough space for the underlying tablespace ( UNDOTBS )....??
I will appreciate , if u can really help me.....
TIA
regards,
Arul.
Joe Testa wrote:
its not a doubt and you're not using rollback, your using automatic undo
management.read up on it in the admin guide,.
joe
Arul kumar wrote:
> Hi DBAs,
>
> I got a problem in Rollback Segments..
>
> This is the setting for UNDO ( Rollback ) in my init file...
>
> undo_management=AUTO
> undo_retention=900
> undo_suppress_errors=FALSE
> undo_tablespace=UNDOTBS
>
> While querying V$waitstat, got the foll. :
>
> CLASS COUNT TIME
> system undo header 0 0
> system undo block 0 0
> *undo header 312 64*
> undo block 1 32
>
> The entry for "undo header" indicates Undo Header contention for
> rollback.. Right ?
>
> Since it is "AUTO" managed, how do i tune ??
>
> I have chk the space usage of the tablespace, it is fairly enough free
> space...
>
> Any suggestions / tips ?
>
> Thank You.
>
> regards,
> Arul.
> *********************************************************
> Disclaimer
>
> This message (including any attachments) contains
> confidential information intended for a specific
> individual and purpose, and is protected by law.
> If you are not the intended recipient, you should
> delete this message and are hereby notified that
> any disclosure, copying, or distribution of this
> message, or the taking of any action based on it,
> is strictly prohibited.
>
> *********************************************************
> Visit us at http://www.mahindrabt.com
>--
Joe Testa, Oracle DBA
Nothing new to put here, hmmmmmm--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Testa
INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
*********************************************************
Disclaimer
This message (including any attachments) contains
confidential information intended for a specific
individual and purpose, and is protected by law.
If you are not the intended recipient, you should
delete this message and are hereby notified that
any disclosure, copying, or distribution of this
message, or the taking of any action based on it,
is strictly prohibited.
*********************************************************
Visit us at http://www.mahindrabt.com
