Hi, I am using Oracle 7.3, I remember getting ORA-01575 once only, but
I am getting ORA-01594 together with ORA-01595 quite often. This is a
known bug, the solution seems to be to use a larger optimal size for
rollback segment. ( as recommended by Oracle Support ) But even after
I have increased the optimal size by quite a bit, I am still getting
this error from time to time. The error happened when Oracle tried to
shrink the rollback segments or when rollback extents are released
( because of commit ). Usually ORA-01594 and ORA-01595 are harmless.
I have to check whether this known bug has been fixed in Oracle8 or not.
Regards
Joseph
In article <6giovd$3ik_at_examiner.concentric.net>, Badri_at_cris.com (BADRI) says:
>
>Hi:
>
> I had previously posted a message regarding Ora 1575 -
>timeout waiting for space management resource and gotten a reply that
>I need to increase the initial extent size of the temp tablespaces,
>since this error has a high correlation with sorting. I do observe
>that almost every time I get the 1575, I get the 1595 - error freeing
>extent (nnn) of rollback segment (m))
>
> What is the real problem?
>
>please help, I noticed that the optimal setting of 2 segments out of
>the 10 we have had improper settings, I have corrected those, however,
>the 1595 occurs on all rollback segs, not just one.
>
>any leads are greatly appreciated,
>
>-Badri
Received on Sat Apr 11 1998 - 08:30:58 CDT
