Jonathan Lewis,
Hi, lewis,have you ever see any big system with large shared pool
size? This week I saw a mobile telecom system running ops 8163, have 8GB sga, with 3GB
of shared_pool_size and About 5GB of data buffer.(Physical memory is 16GB)
I never configured a system with shared_pool_size larger than 200MB(my
current system is 200MB).But that oracle is installed by oracle china, so i wonder if
this kind of configuration is reasonable? I do not have enough time to analyze that
system, but I do not think Oracle china is giving the customer the right parameter
about shared_pool, can you give your opinion?
Thanks.
Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(ChinaOracle User Group)
======= 2003-01-02 02:28:00 ,you wrote��=======
>I think it's safe to say that if the free memory is always very large
>then you can reinterpret it as 'wasted memory'.
>
>If the free memory is alway very small, I don't think it is possible
>to make any decision without know the application. It is possible
>that you need to increase the shared pool slightly (good app), it is
>also possible that your shared pool is just about the right size
>(great
>app) , but it is possible that your application design has a flaw in
>it.
>
>
>Regards
>
>Jonathan Lewis
>http://www.jlcomp.demon.co.uk
>
>Coming soon a new one-day tutorial:
>Cost Based Optimisation
>(see http://www.jlcomp.demon.co.uk/tutorial.html )
>
>Next Seminar dates:
>(see http://www.jlcomp.demon.co.uk/seminar.html )
>
>____England______January 21/23
>
>
>The Co-operative Oracle Users' FAQ
>http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
>
>
>-----Original Message-----
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Date: 02 January 2003 05:39
>
>
>>
>>Is it Correct to Look at FREE Memory in the Shared Pool ?
>>Memory when used once thereafter when NO Longer in use does the FREE
>Memory again Come up ?
>>Are there any ideal Values for percentage of Free memory for the
>Shared Pool
>>
>>The Respective Hybrid Application mostly uses Bind Variables
>>
>>Thanks
>>
>>
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>--
>>Author: VIVEK_SHARMA
>> 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: Jonathan Lewis
> 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).
