shared_pool_advice view

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 01 Nov 2005 08:10:59 -0500
Message-Id: <s36723a2.019@gcrta.org>

I ran the following query. As I interpret this, if I increase the shared_pool from 304 to 336, I will save 300 sec. What timeframe is this being measured over - would this be 300 seconds since database was started?

SQL> l
1 SELECT shared_pool_size_for_estimate "Size of Shared Pool in MB", 2 shared_pool_size_factor "Size Factor", 3 estd_lc_time_saved "Time Saved in sec" 4* FROM v$shared_pool_advice

SQL> @shared_pool_advice
DOC>select *
DOC>from v$shared_pool_advice;
DOC>*/

Size of Shared Pool in MB Size Factor Time Saved in sec
------------------------- ----------- -----------------

                      176       .5789           1204307
                      208       .6842           1205981
                      240       .7895           1207003
                      272       .8947           1207818
                      304           1           1208317
                      336      1.1053           1208618
                      368      1.2105           1208799
                      400      1.3158           1210166
                      432      1.4211           1210306
                      464      1.5263           1210434
                      496      1.6316           1210534
                      528      1.7368           1210650
                      560      1.8421           1210755
                      592      1.9474           1210848
                      624      2.0526           1210926

15 rows selected.

SQL> Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 01 2005 - 07:15:26 CST