Re: ORA-04031 error

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:chao_ping_at_163.com
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: brain_damage_at_eth.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).

• = = = = = = = = = = = = = = = = = = =

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  INET: chao_ping_at_vip.163.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).