SYS@newtest>select name,value from v$pgastat where name like '%OS';

NAME

VALUE

---

PGA memory freed back to OS

4943904768 SYS@newtest>SELECT DESCRIPTION,DEST FROM X$MESSAGES WHERE DESCRIPTION LIKE 'SQLM emory%';

未选定行

12C

SYS@newtest>set linesize 120 SYS@newtest>col time format 99999999999999999 SYS@newtest>col data format A80 SYS@newtest>select time, data from 2 x$trace where data like '%SQL Memory%' 3 ; 未选定行 12c SYS@newtest>SELECT * FROM V$SGASTAT WHERE NAME LIKE 'work area%';

POOL NAME

BYTES CON_ID

---

---

shared pool work area table entry

273360 1 SYS@newtest>show sga

Total System Global Area 2768240640 bytes

Fixed Size 8922760 bytes Variable Size 620759416 bytes Database Buffers 2130706432 bytes Redo Buffers 7852032 bytes 12c SYS@newtest>show parameter cache_size

NAME TYPE VALUE

---

---

client_result_cache_size big integer 0

data_transfer_cache_size big integer 0 db_16k_cache_size big integer 0 db_2k_cache_size big integer 0 db_32k_cache_size big integer 0 db_4k_cache_size big integer 0 db_8k_cache_size big integer 0 db_cache_size big integer 0 db_flash_cache_size big integer 0 db_keep_cache_size big integer 0 db_recycle_cache_size big integer 0 SYS@newtest>select id,name,block_size,current_size,target_size from 2 v$buffer_pool;

ID NAME                                     BLOCK_SIZE CURRENT_SIZE TARG

ET_SIZE

---

---

3 DEFAULT                                        8192         1888

1888

SYS@newtest>select * from v$sga;

NAME VALUE CON_ID

---

Fixed Size 8922760 0

Variable Size 620759416 0 Database Buffers 2130706432 0 Redo Buffers 7852032 0 12C SQL> select * from v$sgainfo;

NAME BYTES RESIZEABLE CON_ID

---

Fixed SGA Size 8922760 No 0

Redo Buffers 7852032 No 0 Buffer Cache Size 2130706432 Yes 0 In-Memory Area Size 0 No 0 Shared Pool Size 570425344 Yes 0 Large Pool Size 33554432 Yes 0 Java Pool Size 16777216 Yes 0 Streams Pool Size 0 Yes 0 Shared IO Pool Size 150994944 Yes 0 Data Transfer Cache Size 0 Yes 0 Granule Size 16777216 No 0 Maximum SGA Size 2768240640 No 0 Startup overhead in Shared Pool 191216928 No 0 Free SGA Memory Available 0 0 14 rows selected

     本文转自whshurk 51CTO博客，原文链接：http://blog.51cto.com/shurk/2059346，如需转载请自行联系原作者