今天主要介紹Oracle一個數據字典:V$SQL_WORKAREA_ACTIVE,下面一起來看看吧~
oracle查詢、V$SQL_WORKAREA_ACTIVE contains an instantaneous view of the work areas currently allocated by the system. You can join this view against V$SQL_WORKAREA on WORKAREA_ADDRESS to access the definition of that work area. If a work area spills to disk, then this view contains information for the temporary segment created on behalf of this work area.
V$SQL_WORKAREA_HISTOGRAM 視圖確是對真實發生的情況統計出來的數據,所以根據這個數據,可以對PGA做適當地調整。
SQL> desc V$SQL_WORKAREA_ACTIVE
sql查看數據庫中的表?列說明如下:
通過這張視圖,可以看到當前SQL_WORKAREA_ACTIVE的相關操作如sort,hash join等及內存信息。
SQL> SELECT to_number(decode(SID, 65535, NULL, SID)) sid, operation_type OPERATION, trunc(EXPECTED_SIZE / 1024) ESIZE, trunc(ACTUAL_MEM_USED / 1024) MEM, trunc(MAX_MEM_USED / 1024) "MAX MEM
版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。
工作时间:8:00-18:00
客服电话
电子邮件
admin@qq.com
扫码二维码
获取最新动态