Re: ORA-01575: timeout waiting for space management resource

In article <19980206005101.TAA29513_at_ladder02.news.aol.com>, Catcox <catcox_at_aol.com> wrote:
>For some periods during the day I get a lot of the following message.
>
>ORA-01575: timeout waiting for space management resource

How big are the parts of your SGA and how much memory do you have?

>
>During this time performance is very bad.
>
>The error manual says, "System timed out before it could acquire the necessary
>resouces to do space management." and simply suggests waiting and trying the
>same operation later.
>
>Can somebody tell me what sort of space managment this refers too? I am not
>sure where to start looking for problems first.
>
>The temporary tablespace is supposedly very fragmented and I have posted a
>separate question on this.
>
>We are using Oracle7 Server Release 7.2.3.0.0 on HP UNIX.
>
>Thank you very much,
>
>Catherine Cox
>catcox_at_aol.com

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!