URGENT - Can you coalesce a RBS tablespace? 2005-09-06 - By Jared Still
On 9/6/05, Henslee, Jeff <jhenslee@(protected)> wrote:
> Apologies - Here's are the error messages I was receiving -
>
> ORA-01562 (See ORA-01562.ora-code.com) Failed to extend rollback segment number 11
> ORA-01650 (See ORA-01650.ora-code.com) unable to extend rollback segment RBS10 by 128 in tablespace RBS.
>
A common cause of this is that a very large transaction that extended one
of your rollback segments to the point that it consumed most of
the space in the rollback tablespace.
Check the hwmsize in v$rollstat to see if that is the case.
You may want to assign as rollback segment in a separate tablespace
to transactions that cause this.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
11+ years of trying to appear to know what I'm doing.
--
http://www.freelists.org/webpage/oracle-l
|
|
