熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

查看SGA區剩余可用內存的方法

2013-11-13 22:22:12  來源: Oracle 

  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
  
  已選擇

From:http://tw.wingwit.com/Article/program/Oracle/201311/18896.html
  • 上一篇文章:

  • 下一篇文章:
  • 推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.