Re: A doubt in 9.0.1.0.0 database..

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: teci_at_the-testas.net

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: ListGuru_at_fatcity.com (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).