Re: UNDOTBS01.DBF file size

From: Jim <mail_at_lost.com>
Date: Fri, 26 Aug 2005 12:23:18 -0400
Message-ID: <bufug1docu8rcrrp0p662n3hl6tfr7n77t@4ax.com>

>An area no one has yet considered is the value for the undo_retention
>parameter; this directly affects the size of the UNDO tablespace.
>Possibly this is set larger than necessary; a quick chat with the DBA
>should put this issue to rest as he/she can explain the rationale
>behind the undo tablespace size.
>

the is no (gulp) dba here. where can i find the undo-retention parameter in Oracle10? which file? i can't find init.ora file anywhere on the system.

i also ran dbmsuadv.sql file hoping it would give me some insights. thanks. Received on Fri Aug 26 2005 - 11:23:18 CDT