Re: ORA - 01555 rollback segment too old

On 9 Jul 2003 18:36:59 -0700, evoradba_at_yahoo.ca (Maria) wrote:

>Oops
>
>Oracle veriosn is 8174 on solaris, the largest table is 20GB but the
>issue only started to happen when we introduce partition tables...
>does this mean that partition will take more of the RBS's then
>other's? also this job which fails drops and then re creates a
>partition, which means creating the DDL.. also includes a procedure,
>we tried to hard code a RBS but there are 5 jobs which depende on
>it... too complicated. Oracle support told me to keep trying the
>sizes of the rollback's, I did this select query, but I don't know
>how to get the " If Shrinks "Low" and Avesize "High" then, Optsize is
>OK" from the select query. I don't know what I'm missing on this
>query
>
>
>"Select a.name, b.extents, b.rssize, b.optsize, b.shrinks,
>b.aveshrink, b.aveactive, b.wraps, b.extends, b.status from v$rollname
>a, v$rollstat b
>where a.usn = b.usn;"
>
>If Shrinks "High" and Avesize "High" then, Optsize = too low, increase
>optimal
>If Shrinks "High" and Avesize "Low" then, Optsize = too low, increase
>optimal
>If Shrinks "Low" and Avesize "Low" then, Optsize = Too high, reduce
>optimal (unless nearly equal to AVEACTIVE)
>If Shrinks "Low" and Avesize "High" then, Optsize is OK
>
>Thanks
>Maria
>
>
>
>
>

Just forget about setting optimal. It is a pain which increases the chance of getting ora-1555. Disk is cheap. If you still want to resize rollback segs, wait until they go baloney and shrink them manually

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jul 10 2003 - 12:38:26 CDT