-
Hi All,
I am having an error with my database and I can't seem to be able to resolve it. The error is as follows:
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 2 with name "RB1" too small.
This erro occurs when I try to log onto sqlplus..
Thanks in advance,
Dee.
God Bless
-
i don't see a match between entrance in sql and rollback segment
(if you are in audit mode , your db will save same information on system tables, but use system rollback segment) however try to use largeer rollback segs.
-
Increase the size of your rollback segments:
As a guide
'When a mix of transactions is not prevalent, each rollback segment should be 10% of the size of the databases largest table because most SQL affects 10% or less of a table'
Their words not mine!
Hope this helps
Moff
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|