SQL> col OBJECT_NAME format a
SQL> col 自由空間百分比(%) format
SQL> select name
sgasize/
bytes/
round(bytes/sgasize*
from (select sum(bytes) sgasize from sys
where f
NAME Allocated(M) 自由空間(K) 自由空間百分比(%)
free memory
free memory
free memory
以下為查看sys
SQL> desc sys
名稱 空? 類型
POOL VARCHAR
NAME VARCHAR
BYTES NUMBER
SQL> select sum(bytes) sgasize from sys
SGASIZE
SQL> select * from sys
POOL NAME BYTES
fixed_sga
db_block_buffers
log_buffer
shared pool free memory
shared pool miscellaneous
shared pool PLS non
shared pool State objects
shared pool KGFF heap
shared pool character set object
shared pool KGK heap
shared pool db_files
POOL NAME BYTES
shared pool joxlod: in phe
shared pool KQLS heap
shared pool table columns
shared pool fixed allocation callback
shared pool PL/SQL DIANA
shared pool enqueue_resources
shared pool PL/SQL MPCODE
shared pool trigger inform
shared pool transactions
shared pool trigger defini
shared pool distributed_transactions
POOL NAME BYTES
shared pool VIRTUAL CIRCUITS
shared pool view columns d
shared pool SYSTEM PARAMETERS
shared pool dictionary cache
shared pool message pool freequeue
shared pool joxlod: in ehe
shared pool character set memory
shared pool db_block_buffers
shared pool library cache
shared pool Checkpoint queue
shared pool sql area
POOL NAME BYTES
shared pool processes
shared pool sessions
shared pool joxs heap init
shared pool transaction_branches
shared pool event statistics per sess
shared pool db_block_hash_buckets
shared pool file # translation table
large pool free memory
java pool free memory
java pool memory in use
已選擇
From:http://tw.wingwit.com/Article/program/Oracle/201311/18896.html