1748216 Members
3764 Online
108759 Solutions
New Discussion юеВ

ORA-01575

 
System Dude_1
Frequent Advisor

ORA-01575

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?
Performance Issue on HP-UX 10.20
4 REPLIES 4
Alexander M. Ermes
Honored Contributor

Re: ORA-01575

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
System Dude_1
Frequent Advisor

Re: ORA-01575

How to determine which resource is blocking the job?
Performance Issue on HP-UX 10.20
Volker Borowski
Honored Contributor

Re: ORA-01575

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
Honored Contributor

Re: ORA-01575

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


Only by ignoring what everyone think is important, can you be aware of what everyone ignores!