select * from v$transaction; select SQL_TEXT from v$sql,v$transaction where LAST_ACTIVE_TIME=START_DATE;