Scripts:ash_gcwait_to_obj.sql
来源:互联网 发布:游戏服务端 python 编辑:程序博客网 时间:2024/05/20 01:37
set lines 100 pages 100
undef event
col object_name format A32
col object_type format A20
col owner format A20
col cnt format 999999999
with ash_gc as
(select * from (
select /*+ materialize */ inst_id, event, current_obj#, count(*) cnt
from gv$active_session_history where event=lower('&event')
group by inst_id,event, current_obj#
))
select * from (
select inst_id,owner, object_name,object_type, cnt
from ash_gc a, dba_objects o
where (a.current_obj#=o.data_object_id or a.current_obj#=o.object_id)
and a.current_obj#>=1
union
select inst_id, '','','Undo Header/Undo block' , cnt
from ash_gc a
where a.current_obj#=0
union
select inst_id, '','','Undo Block' , cnt
from ash_gc a
where a.current_obj#=-1
) order by 5
undef event
col object_name format A32
col object_type format A20
col owner format A20
col cnt format 999999999
with ash_gc as
(select * from (
select /*+ materialize */ inst_id, event, current_obj#, count(*) cnt
from gv$active_session_history where event=lower('&event')
group by inst_id,event, current_obj#
))
select * from (
select inst_id,owner, object_name,object_type, cnt
from ash_gc a, dba_objects o
where (a.current_obj#=o.data_object_id or a.current_obj#=o.object_id)
and a.current_obj#>=1
union
select inst_id, '','','Undo Header/Undo block' , cnt
from ash_gc a
where a.current_obj#=0
union
select inst_id, '','','Undo Block' , cnt
from ash_gc a
where a.current_obj#=-1
) order by 5
/
只为分享,风险自负
0 0
- Scripts:ash_gcwait_to_obj.sql
- Common SQL Scripts
- Workflow SQL scripts安装
- EBS查询sql scripts
- Scripts in $AD_TOP/sql
- Scripts:perf_redo_log_contention.sql
- Scripts:perf_performance_snapshot.sql
- Scripts:segment_size.sql
- Scripts:sess_users_by_cursors.sql
- Scripts:sess_users_by_cpu.sql
- Scripts:sess_users_active_sql.sql
- Scripts:sess_users_active.sql
- Scripts:sess_users_by_transactions.sql
- Scripts:sess_users_by_memory.sql
- Scripts:sess_users_by_io.sql
- Scripts:session_wait.sql
- Scripts:sess_waiting.sql
- Scripts:top.sql
- java中JFrame 窗口关闭时,弹出一个对话框提示是否确定关闭
- 基于百度定位SDK的定位服务的实现
- 【整理】MySQL引擎
- vtkPolyData中GetPoint函数冲掉上一个数据的问题
- 单例设计模式
- Scripts:ash_gcwait_to_obj.sql
- iOS block
- ps -aux|grep 详细信息
- 十六进制转化为十进制的方法
- 合理规划SAT阅读备考节奏
- 算法 线性排序-计数排序
- 【似曾相识燕归来】
- java使用tomcat数据源连接mysql
- tomcat 设置 HTML5 的离线缓存