内存管理
[email protected]>select name,value from v$pgastat where name like '%OS';
NAME
VALUE
PGA memory freed back to OS
4943904768
[email protected]>SELECT DESCRIPTION,DEST FROM X$MESSAGES WHERE DESCRIPTION LIKE 'SQLM
emory%';
未选定行
12C
[email protected]>set linesize 120
[email protected]>col time format 99999999999999999
[email protected]>col data format A80
[email protected]>select time, data from
2 x$trace where data like '%SQL Memory%'
3 ;
未选定行
12c
[email protected]>SELECT * FROM V$SGASTAT WHERE NAME LIKE 'work area%';
POOL NAME
BYTES CON_ID
shared pool work area table entry
273360 1
[email protected]>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
[email protected]>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
[email protected]>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
[email protected]>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,如需转载请自行联系原作者