Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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!