Oracle Database Discussions

Hi Team,

I am getting below error

ORA-01554: transaction concurrency limit reached reason:no undo segment found with available slot params:0, 0

Google hit says : Action: Shutdown the system, modify the INIT.ORA parameters transactions, rollback_segments or rollback_segments_required, then startup again._


I am on 11gR2 with oracle enterprise linux. My init.ora parameters are like below

SQL> show parameter undo;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS4
SQL> show parameter rollback;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_parallel_rollback string LOW
rollback_segments string
transactions_per_rollback_segment integer 5
SQL> show parameter transaction;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
transactions integer 8289
transactions_per_rollback_segment integer 5


Any suggestion to avoid that error , without bouncing the database?
Please Advice

Thanks

Edited by: user12096071 on Jul 26, 2011 3:14 PM