ORA-01575: timeout waiting for space management resource

From: Jeff Shervey <jeff.shervey_at_us.landisstaefa.com>
Date: 1997/02/18
Message-ID: <01bc1deb$3f670f10$b6ee1bac@usbgrjeff>#1/1

I seem to get a couple minutes a day of SMON errors in my alert_sid??.log file. I called it into Oracle and they said that it probably is from heavy TEMP space extent expansion. But I also saw a posting that someone thought it has something to do with Redo Log usage and/or copy latch contention? Anybody ever figured this one out?
We are running Oracle Manufacturing and soon the rest of the Financial apps.

Thank You - Jeff Shervey

Tue Feb 18 08:30:38 1997
Errors in file /usr1/oracle/product/7.1.6/rdbms/log/smon_15014.trc: ORA-01575: timeout waiting for space management resource Tue Feb 18 08:30:44 1997
Errors in file /usr1/oracle/product/7.1.6/rdbms/log/smon_15014.trc: ORA-01575: timeout waiting for space management resource Tue Feb 18 08:30:50 1997
Errors in file /usr1/oracle/product/7.1.6/rdbms/log/smon_15014.trc: ORA-01575: timeout waiting for space management resource Tue Feb 18 08:30:56 1997
Errors in file /usr1/oracle/product/7.1.6/rdbms/log/smon_15014.trc: ORA-01575: timeout waiting for space management resource Tue Feb 18 08:31:02 1997
Errors in file /usr1/oracle/product/7.1.6/rdbms/log/smon_15014.trc: ORA-01575: timeout waiting for space management resource Tue Feb 18 08:31:17 1997
Errors in file /usr1/oracle/product/7.1.6/rdbms/log/smon_15014.trc: ORA-01575: timeout waiting for space management resource Tue Feb 18 08:31:43 1997

The trace file it generates:

pfmux2> cat /usr1/oracle/product/7.1.6/rdbms/log/smon_15014.trc Dump file /usr1/oracle/product/7.1.6/rdbms/log/smon_15014.trc Oracle7 Server Release 7.1.6.2.0 - Production Release PL/SQL Release 2.1.6.2.0 - Production
ORACLE_HOME = /usr1/oracle/product/7.1.6 ORACLE_SID = orbitpro
Oracle process number: 5 Unix process id: 15014 System name: OSF1

Node name:      pfmux2
Release:        V3.2
Version:        148
Machine:        alpha

Tue Feb 18 08:30:38 1997
Tue Feb 18 08:30:38 1997
*** SESSION ID:(4.1)
SMON: following errors trapped and ignored: ORA-01575: timeout waiting for space management resource Tue Feb 18 08:30:44 1997
SMON: following errors trapped and ignored: ORA-01575: timeout waiting for space management resource Tue Feb 18 08:30:50 1997
SMON: following errors trapped and ignored: ORA-01575: timeout waiting for space management resource Tue Feb 18 08:30:56 1997
SMON: following errors trapped and ignored: ORA-01575: timeout waiting for space management resource Tue Feb 18 08:31:02 1997
SMON: following errors trapped and ignored: ORA-01575: timeout waiting for space management resource

PROCESS STATE

Process global information:

process: 20a91f0, call: 20ccc88, xact: 0, curses: 20b3968, usrses: 20b3968

SO: 20a91f0, type: 1, owner: 0, flag: INIT/-/-/0x00 (process) Oracle pid=5, calls cur/top: 20ccc88/20ccc88, flag: (a) SYSTEM

int error: 0, call error: 0, sess error: 0
(latch info) wait_event=0 bits=0

O/S info: user: oracle, term: ?, ospid: 15014 OSD pid info: pid: 3aa6, image:

SO: 20b3968, type: 3, owner: 20a91f0, flag: INIT/-/-/0x00
(session) trans: 0, flag: (51) USR/- BSY/-/-/-/-/-

oct: 0, prv: 0, user: 0/SYS last wait for 'enqueue' seq=1071 wait_time=200

                name|mode=53540006, id1=0, id2=0
    ----------------------------------------

SO: 20ccc88, type: 2, owner: 20a91f0, flag: INIT/-/-/0x00
(call) sess: cur 20b3968, rec 0, usr 20b3968; depth: 0

CURRENT SESSION'S INSTANTIATION STATE

current session=20b3968
Tue Feb 18 08:31:17 1997
SMON: following errors trapped and ignored: ORA-01575: timeout waiting for space management resource pfmux2>

-- 
These comments do not necessarily reflect the views of Landis & Staefa, Inc.

Received on Tue Feb 18 1997 - 00:00:00 CST