|
SQL> col OBJECT_NAME format a SQL> col 自由空间百分比(%) format 格式化把小数点对齐为两位 SQL> select name sgasize//Allocated(M) bytes/ 自由空间(K) round(bytes/sgasize* )自由空间百分比(%) from (select sum(bytes) sgasize from sysv_$sgastat) s sysv_$sgastat f where fname = free memory; NAME Allocated(M) 自由空间(K) 自由空间百分比(%) free memory free memory free memory 以下为查看sysv_$sgastat相关 SQL> desc sysv_$sgastat 名称 空? 类型 POOL VARCHAR() NAME VARCHAR() BYTES NUMBER SQL> select sum(bytes) sgasize from sysv_$sgastat; SGA区总和 SGASIZE SQL> select * from sysv_$sgastat; POOL NAME BYTES fixed_sga db_block_buffers log_buffer shared pool free memory shared pool miscellaneous shared pool PLS nonlib hp 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 已选择行 |
