Re: ora 1575?

Are you doing a lot of sorting with a small sort_area_size set? That's what Note:33567.1 in Metalink seems to point to. Since this involves the ST enqueue it is probably also a good idea to see if you can switch to locally managed tablespaces. Switch temp over first. You might want to run a query like this to see what proportion of your sorts are in memory:

SELECT

	   a.value "Disk Sorts", 
	   b.value "Memory Sorts",
	   round((100*b.value) / decode((a.value + b.value),0,1, 
			 (a.value + b.value)),2) "Pct Memory Sorts"  	
FROM 
	 v$sysstat a, 
	 v$sysstat b  	
WHERE 
	  a.name = 'sorts (disk)'  	
	  and b.name = 'sorts (memory)';

Regards,
Chris Gait

>
> on 8/12/03 12:44 PM, Gurelei at gurelei_at_yahoo.com wrote:
>
> > Hi all:
> >
> > I'm seeing the ora-01575 error in the alert logfile.
> > The article on the metalink refers to the parameter
> > which I think is obsolete in the ORacle version we are
> > running (8.1.7). What does this error refer to? Any
> > thoughts? references?
> >
> > thanks
> >
> > gene
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site design software
> > http://sitebuilder.yahoo.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Tim Gorman
> INET: tim_at_sagelogix.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: cjgait_at_earthlink.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).