ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oralce ASH report

Oralce ASH report

原创 Linux操作系统 作者:yuanqc 时间:2013-08-21 14:49:56 0 删除 编辑
@$ORACLE_HOME/rdbms/admin/ashrpt.sql
 
v$session
v$active_session_history
dba_hist_active_sess_history

select

* from dba_hist_active_sess_history a where a.session_id=266 and a.session_serial#=35119 order by snap_id;

select

* from dba_hist_active_sess_history a where a.session_id=266 order by snap_id;

select

* from v$active_session_history a where a.session_id=266;

select

* from v$sqlarea s where s.SQL_ID='d81f0p9hta8ag';

select

* from dba_objects o where o.OBJECT_NAME='GFDR_FUND_HOLDINGS';

select

count(*) from FAIMSVIEW.GFDR_FUND_HOLDINGS;

select

* from dba_hist_active_sess_history d where d.sql_id='d81f0p9hta8ag' order by snap_id;

select

distinct d.sql_id from dba_hist_active_sess_history d where d.session_id=266 and d.session_serial#=35119;

select

* from v$sqlarea s where s.SQL_ID='c07vt7yjt4nks';

select

* from v$sqlarea s where s.SQL_ID='a6xbjss5fuuy7';

select

* from v$session s where s.sid=266 and s.SERIAL#=35119;

select

* from dba_users u where u.user_id=119;

select

text from dba_views v where v.VIEW_NAME='ACCURED_QTY_VIEW';

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10973950/viewspace-768966/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-11-23

  • 博文量
    47
  • 访问量
    102338