shared_pool_advice view
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>, <oracledba@xxxxxxxxxxx>, <oracle-rdbms@xxxxxxxxxxxxxxx>
- Date: Tue, 01 Nov 2005 08:10:59 -0500
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
Other related posts:
- » shared_pool_advice view
