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,如需转载请自行联系原作者