or select a.first_load_time, executions, elapsed_time, a.sql_text stmt, hash_value, address from v$sqlarea a where users_executing > 0 elapsed_time is the accumulated microseconds elapsed time used by the SQL The two views should be granted for select (using sys as sysdba) for the account for running this checking query grant SELECT on V_$SQLAREA to bdsuser with grant option; grant SELECT on V_$Session to bdsuser with grant option;