Re: ORA-1595 / ORA-1575 Errors

Hi Ron,
I have never seen this error, but I am almost sure what is going on. You are using an optimal value on your rollback segment # 18 (which you can find using v$rollname).
The segment is being trimmed back (that is where the 'freeing extent' is referring to) and either another transaction is at the same time trying to reuse that extent or you are unable to obtain a latch (which is the dictionary locking mechanism).
I have always avoided using optimal, as I know space management is time consuming in Oracle 7. The 'optimal' optimal value seems to equal four times the initial extent.

Hth,

Sybrand Bakker, Oracle DBA

rspeaker_at_my-dejanews.com wrote in message <7h6t02$563$1_at_nnrp1.deja.com>...
>Hi,
>
>can anybody shed any light onto what might cause these 2 errors:
>
>Thu May 6 09:38:27 1999
>SMON: following errors trapped and ignored:
>ORA-01595: error freeing extent (536871660) of rollback segment (18))
>ORA-01575: timeout waiting for space management resource
>
>
>There have been no hardware errors reported by the OS. We are running
>Oracle 7.3.4 on AIX 4.2.1. I see these errors repeated over and over
>and over again.
>
>Thanks, any help is appreciated.
>
>Roy
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Mon May 10 1999 - 12:02:22 CDT