Re: Rollback segment problem

Your problem is that the rollback segments are reaching the maximum number of extents (121).

There are 2 ways you can fix this:

1. Increase MAXEXTENTS storage parameter. This will allow more extents to used for a transaction
2. Increase INITIAL and NEXT storage parameters. This will use larger extents, so you won't need as many for a transaction.

Use the command:

	Alter rollback R03
	  storage( .............. );

You will have to do this for all your rollback segments R01 - R03 because, you don't always use the same rollback segment for a transaction.

Hope this helps.

Mr. Chow Wing Siu <wschow_at_Comp.HKBU.Edu.HK> wrote in article <5nv8v9$732$1_at_power42t.hkbu.edu.hk>...
> -----BEGIN PGP SIGNED MESSAGE-----
>
> =======================Error Message============================
> ORA-01562: failed to extend rollback segment number 4
> ORA-01628: max # extents (121) reached for rollback segment R03
> ORA-06512: at line 1
> =======================End of Message===========================
>
> There are 3-4 rollback segment R0? It happens to each RBS.
> How to fix this problem? Please reply to wschow_at_comp.hkbu.edu.hk
> Thanks in advance.
>
> - --
> PGP PUBLIC KEY: https://www.comp.hkbu.edu.hk/~wschow/pgp.html
> Key fingerprint = 15 C4 36 D6 EC CF 1D A4 7F D8 F9 EF 2E D7 32 A6
>
> -----BEGIN PGP SIGNATURE-----
> Version: 2.6.3i
> Charset: noconv
>
> iQCVAwUBM6MoVb3ixeOqBhAdAQG5VAQAlKM8PZ5a2V+zGynbIr/uaBvaDX32lvxI
> X2jHf8cUf5mQqk0VGTJ65oj2lDZUzONHoEepUg7Co0cZcQCu+IM1cHuuYt9HxV7j
> WwMMKHn4Ld9a8C1gXsJYGLU2g/0QU7hCRCVqO1KLthg30tSzXAWdDIy/ynHt/WJl
> 0cgWqK/Ozwo=
> =xDXn
> -----END PGP SIGNATURE-----
>
Received on Wed Jun 18 1997 - 00:00:00 CDT