Re: ORA 1575 - timeout waiting for space mgmt

From: Michael S. Abbey <masint_at_istar.ca>
Date: Mon, 13 Apr 1998 02:40:42 GMT
Message-ID: <35317ae9.31650000@news.istar.ca>

On 08 Apr 1998 14:12:17 EDT, Badri_at_cris.com (BADRI) wrote:

>Hi:
>
> We have frequent occurrences of the error "ORA-1575, timeout
> waiting for space management resource". There is no pattern to
>what occurs before this error - it usually occurs when we have a lot
>of jobs running. What is the resource the processes needs? What do I need
>to tune?

This is a non-fatal error usually out of 7.1.6 of the database, having to do with coalescing of free space for tablespaces with a non-zero default PCTINCREASE. It is more of a nuisance than anything else, and does contribute to wait situations.

Michael

+------------------------------------
+  Michael S. Abbey    Ottawa Canada
+  Co-author of Oracle8: A Beginner's Guide

+ and 5 other works in the Oracle Press Series

+------------------------------------

Received on Sun Apr 12 1998 - 21:40:42 CDT