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).