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).
