select * from v$sql
select * from v$sqltext
select * from v$sqlarea
select * from v$sql
where parsing_schema_name = 'USER'
and last_active_time > TO_DATE('2007/07/31 08:50','RRRR/MM/DD HH:MI' )
and last_active_time < TO_DATE('2007/07/31 08:11','RRRR/MM/DD HH:MI' )
order by last_active_time desc ;
select * from v$sqltext
select * from v$sqlarea
select * from v$sql
where parsing_schema_name = 'USER'
and last_active_time > TO_DATE('2007/07/31 08:50','RRRR/MM/DD HH:MI' )
and last_active_time < TO_DATE('2007/07/31 08:11','RRRR/MM/DD HH:MI' )
order by last_active_time desc ;
Trackback URL : http://apollo89.com/blog/trackback/237
rss