brain_damage,
It seems you are just running a small database, why using shared
server? MTS in linux/816 has severe bug, I suggest you move to dedicated server?
And in shared server mode,sort_area_size is allocated from sga, not
the pga, but does it come from the large pool?
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)
======= 2003-02-07 17:28:00 ,you wrote��=======
>Hi List,
>whats the meaning of the following error
>ERROR at line 1:
>ORA-04031: unable to allocate 4096 bytes of shared memory ("large
>pool","unknown object","sort subheap","sort key")
>
>heres the sql query --->select * from hox12 order by op desc;
>Oracle Release -->8.1.6.1.0
>OS --> RH 7.1
>sort_area_size--> 2MB
>Temporary Tablespace--> 25MB
>Large pool--> 10MB
>Server Type--> Shared
>
>TIA
>
>Tc
>--
>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).
= = = = = = = = = = = = = = = = = = = =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: chao_ping
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).
