See the following:
Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 2120 05-Dec-12 09:00:43 160 5.3
End Snap: 2122 05-Dec-12 11:00:04 153 5.5
Elapsed: 119.34 (mins)
DB Time: 504.70 (mins)
Parses: 44.1
Hard parses: 3.5
Cache Sizes
Begin End
Buffer Cache: 3,840M 3,840M Std Block Size: 8K
Shared Pool Size: 7,168M 7,168M Log Buffer: 161,732K
Shared Pool Statistics
Begin End
Memory Usage %: 54.31 55.01
% SQL with executions>1: 73.18 82.35
% Memory for SQL w/exec>1: 76.41 83.42
相关参数设置:
db_cache_advice OFF
memory_target 22548578304
建议:
Shared pool size will be enlarged and may remain large when:
1. Back to a time, there is a need to increase the shared pool size, eg lots hard/soft parsing occurred, then shared pool size would be 7GB
2. Then if there is no need to enlarge buffer cache or other dynamic pool, the shared pool size will remain 7GB
So to reduce the shared pool size, you could:
+++ Enlarge or set a minimal size of buffer cache and restart the database
What Type of SGA Re-Size Operations Occur When DB_CACHE_ADVICE=OFF? (Doc ID 1434975.1)
--immediate type of resizing will still be occurring even DB_CACHE_ADVICE=OFF
Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 2120 05-Dec-12 09:00:43 160 5.3
End Snap: 2122 05-Dec-12 11:00:04 153 5.5
Elapsed: 119.34 (mins)
DB Time: 504.70 (mins)
Parses: 44.1
Hard parses: 3.5
Cache Sizes
Begin End
Buffer Cache: 3,840M 3,840M Std Block Size: 8K
Shared Pool Size: 7,168M 7,168M Log Buffer: 161,732K
Shared Pool Statistics
Begin End
Memory Usage %: 54.31 55.01
% SQL with executions>1: 73.18 82.35
% Memory for SQL w/exec>1: 76.41 83.42
相关参数设置:
db_cache_advice OFF
memory_target 22548578304
建议:
Shared pool size will be enlarged and may remain large when:
1. Back to a time, there is a need to increase the shared pool size, eg lots hard/soft parsing occurred, then shared pool size would be 7GB
2. Then if there is no need to enlarge buffer cache or other dynamic pool, the shared pool size will remain 7GB
So to reduce the shared pool size, you could:
+++ Enlarge or set a minimal size of buffer cache and restart the database
What Type of SGA Re-Size Operations Occur When DB_CACHE_ADVICE=OFF? (Doc ID 1434975.1)
--immediate type of resizing will still be occurring even DB_CACHE_ADVICE=OFF