Script taken from Oracle NoteID: 295626.1. Example was from my own lab on Oracle 12C. Refreshed for Oracle 12C
SGA_TARGET non-zero. ASMM enabled.
show parameter sga
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean TRUE
sga_max_size big integer 4816M
sga_target big integer 4816M
unified_audit_sga_queue_size integer 1048576
Looking at the patterns of automatic management.
SQL> set lines 150
SQL> col component format a25
SQL> select component, current_size/1024/1024 "CURRENT_SIZE", min_size/1024/1024 "MIN_SIZE", user_specified_size/1024/1024 "USER_SPECIFIED_SIZE", last_oper_type "TYPE" from v$sga_dynamic_components;
COMPONENT CURRENT_SIZE MIN_SIZE USER_SPECIFIED_SIZE TYPE
------------------------- ------------ ---------- ------------------- -------------
shared pool 832 800 0 GROW
large pool 256 256 0 SHRINK
java pool 64 64 0 STATIC
streams pool 0 0 0 STATIC
DEFAULT buffer cache 3392 3392 0 SHRINK
KEEP buffer cache 0 0 0 STATIC
RECYCLE buffer cache 0 0 0 STATIC
DEFAULT 2K buffer cache 0 0 0 STATIC
DEFAULT 4K buffer cache 0 0 0 STATIC
DEFAULT 8K buffer cache 0 0 0 STATIC
DEFAULT 16K buffer cache 0 0 0 STATIC
COMPONENT CURRENT_SIZE MIN_SIZE USER_SPECIFIED_SIZE TYPE
------------------------- ------------ ---------- ------------------- -------------
DEFAULT 32K buffer cache 0 0 0 STATIC
Shared IO Pool 240 0 0 GROW
Data Transfer Cache 0 0 0 STATIC
ASM Buffer Cache 0 0 0 STATIC
15 rows selected.
Looking at the historical data of ASMM movements.
SQL> col component format a25;
SQL> set pages 100;
SQL> set lines 150;
SQL> col init format 9999;
SQL> col target format 9990;
SQL> select component, oper_type, initial_size/1024/1024 "INITIAL", TARGET_SIZE/1024/1024 "TARGET", FINAL_SIZE/1024/1024 "FINAL", TO_CHAR(end_time, 'DD/MM/YYYY HH:MI:SS') "DATE" from V$SGA_RESIZE_OPS order by end_time;
COMPONENT OPER_TYPE INIT TARGET FINAL DATE
------------------------- ------------- ----- ------ ---------- -------------------
DEFAULT 8K buffer cache STATIC 0 0 0 30/12/2014 12:51:36
KEEP buffer cache STATIC 0 0 0 30/12/2014 12:51:36
large pool STATIC 0 336 336 30/12/2014 12:51:36
shared pool STATIC 0 800 800 30/12/2014 12:51:36
java pool STATIC 0 64 64 30/12/2014 12:51:36
streams pool STATIC 0 0 0 30/12/2014 12:51:36
DEFAULT 4K buffer cache STATIC 0 0 0 30/12/2014 12:51:36
ASM Buffer Cache STATIC 0 0 0 30/12/2014 12:51:36
DEFAULT buffer cache STATIC 0 3584 3584 30/12/2014 12:51:36
RECYCLE buffer cache STATIC 0 0 0 30/12/2014 12:51:36
DEFAULT 32K buffer cache STATIC 0 0 0 30/12/2014 12:51:36
DEFAULT 16K buffer cache STATIC 0 0 0 30/12/2014 12:51:36
DEFAULT 2K buffer cache STATIC 0 0 0 30/12/2014 12:51:36
DEFAULT buffer cache INITIALIZING 3584 3584 3584 30/12/2014 12:51:37
large pool SHRINK 336 256 256 30/12/2014 12:52:18
DEFAULT buffer cache GROW 3584 3664 3664 30/12/2014 12:52:18
DEFAULT buffer cache SHRINK 3664 3424 3424 30/12/2014 12:52:29
shared pool GROW 800 832 832 02/01/2015 01:05:16
DEFAULT buffer cache SHRINK 3424 3392 3392 02/01/2015 01:05:16
19 rows selected.
perde modelleri
ReplyDeletesms onay
MOBİL ÖDEME BOZDURMA
Nftnasilalinir
Ankara Evden Eve Nakliyat
trafik sigortası
DEDEKTÖR
WEB SİTE KURMAK
aşk kitapları
smm panel
ReplyDeleteSmm panel
İs ilanlari
instagram takipçi satın al
Https://www.hirdavatciburada.com
BEYAZESYATEKNİKSERVİSİ.COM.TR
servis
tiktok jeton hilesi
yurtdışı kargo
ReplyDeletenft nasıl alınır
en son çıkan perde modelleri
özel ambulans
uc satın al
en son çıkan perde modelleri
lisans satın al
minecraft premium
başakşehir
ReplyDeletebayrampaşa
beşiktaş
beykoz
beylikdüzü
EXJ7Q8
mecidiyeköy
ReplyDeletesakarya
istanbul
kayseri
ordu
3BDAOV