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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
