高分求助：根据sql语句查询scn

[zhanghai921]

我找到当时执行的sql语句，想看下提交时的scn，各位老大们，有知道咋查的吗？

[wffffc]

SQL> select count(*) from t;

COUNT(*)
----------
53753

SQL> select sql_text,LAST_ACTIVE_TIME from v$sql where sql_text like '%select count(*) from t%';

SQL_TEXT
-------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
LAST_ACTIVE_TI
--------------
select sql_text,LAST_ACTIVE_TIME from v$sql where sql_text like '%select count(*) from t%'
01-9月 -11

select count(*) from t
01-9月 -11


SQL> select sql_text,to_char(LAST_ACTIVE_TIME,'yyyy-mm-dd hh24:mi:ss') from v$sql where sql_text like '%select count(*) from t%';

SQL_TEXT
-------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
TO_CHAR(LAST_ACTIVE
-------------------
select sql_text,LAST_ACTIVE_TIME from v$sql where sql_text like '%select count(*) from t%'
2011-09-01 16:10:46

select count(*) from t
2011-09-01 16:09:58

select sql_text,to_char(LAST_ACTIVE_TIME,'yyyy-mm-dd hh24:mi:ss') from v$sql where sql_text like '%select count(*) from t%'
2011-09-01 16:11:31


SQL> select TIMESTAMP_TO_SCN(to_date('2011-09-01 16:11:31','yyyy-mm-dd hh24:mi:ss')) from dual;

TIMESTAMP_TO_SCN(TO_DATE('2011-09-0116:11:31','YYYY-MM-DDHH24:MI:SS'))
----------------------------------------------------------------------
1379145

[gnahshining]

select * from t1 as of scn :scn;

[yjytiantang]

select * from test ;

select sql_text,LAST_ACTIVE_TIME from v$sql
where sql_text like '%select * from test%';

select timestamp_to_scn(to_date('2011/9/2 9:37:08','yyyy/mm/dd hh24:mi:ss')) scn from dual;