ORA-01575

[System Dude_1]

I am experienceing a database performance degradation since last two days on N4000_1.
It gives the following error in my alert.log file:-
ORA-01575: timeout waiting for space management resource

*** SESSION ID:(5.1) 2001-06-19 12:43:31.440
*** 2001-06-19 12:43:31.440
SMON: following errors trapped and ignored:
ORA-01575: timeout waiting for space management resource
*** 2001-06-19 12:49:45.050
SMON: following errors trapped and ignored:
ORA-01575: timeout waiting for space management resource
*** 2001-06-19 12:55:23.060

Could anybody share some thought?

[Alexander M. Ermes]

Hi there.
Some resource is blocked by a job, when it is trying to do some space management like extending tables, indexes or something like this. You have to try again later.
Rgds
Alexander M. Ermes

[System Dude_1]

How to determine which resource is blocking the job?

[Volker Borowski]

Hi,

if this occurs since two days, I think you have a run-away session. Check your active sessions, find out, which one may be dead or worthless because of an unintended everlasting FULL TABLESCAN or so.

Try to kill the session it if possible.

Volker

[Andreas D. Skjervold]

Hi

I've attached 2 notes from Oracle Metalink.

The one is when the INIT.ORA parameter REDUCE_ALARM is set to TRUE. This error might occure. This is likely note the case since i guess you haven't changed you parameter recently.

The other note is more likely the cause where big sort / join operations take possesion of the 'ST' enqueue end thus giving some sort of contention of this resource.

Andreas