QueryDB

Sys.V_$SQL v$sql_bind_capture v$session V$SQLAREA v$sql_bind_capture for further details:- http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2111.htm

select scn_to_timestamp(max(ora_rowscn)) from OWNER.TABLE_NAME while running above query you can have error:- ERROR at line 1: ORA-08181: specified number is not a valid system change number ORA-06512: at "SYS.SCN_TO_TIMESTAMP", line 1 Cause: supplied scn was beyond the bounds of a valid scn. Action: use a valid scn. reason behind this can be:- This only works as long as the snapshot is still around. After that, it appears to go into a frozen state. All off my records older than a certain point have the same SCN. you can also use:- SELECT * FROM all_tab_modifications

Your Browser Do not Support Iframe

error java.sql.SQLException: ORA-28000: the account is locked alter user user_name identified by user_name account unlock;

Select * from all_users;