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博客 ” ，链接：https://blog.itpub.net/10973950/viewspace-768966/ ，如需转载，请注明出处，否则将追究法律责任。
