Re: Rollback segments

Hi:

Go to the Oracle supplied documentation about space management and performance tuning for Rollback segments and read it. Then, read it again. Then, read it once more. You'll find the answers you are looking for!

Good luck,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

Cristóbal García wrote in message <7l7n06$22b$1_at_diana.bcn.ttd.net>...
>Hello!!
>
> I'm testing Oracle in order to see if it suits our requirements (Oracle
>8.0.5 for Linux) and I've created a package with some pl/sql methods which
>populate tables on a db.
> The story is that I've inserted 10.000 rows and that's ok, when I've
>inserted 100.000 rows Oracle has issued me a 1600 error (Cannot extend
>rollback segments), that's a correct behavior I think, but since then the
>dbms has decreased dramatically its capacity to insert rows without giving
>me the same error. For example I've cleared the tables (left it in 0 rows)
>and tried to re-insert the 10.000 rows. The 1600 condition strikes back
>again!!!!
> I'd like to know if this is a normal behavior, if so I want to know why
>and how to correct it (It seems like Oracle cannot clear the rollback
>segments when the transaction is aborted).
> I'd like to know your oppinion about Oracle 8 on Linux (Oracle 8i also)
>because my boss and I are trying to decide between a dbms (I'm working at a
>University in Spain) and I prefer Oracle but my boss doesn't, so I've we
try
>oracle and it's not stable or needs lot of management (our normal work
isn't
>very hard so I think the DBA tasks can be done by a non dedicated employee)
>I will probably be fired :(
>
> Thanx a lot
>
>
>
Received on Mon Jun 28 1999 - 22:10:28 CDT