SQL

Hi,

I am writing a query to identified the number of times the object access by the user in that i have seen the SQL_OPNAME and SQL_exec_start is having null value. I suspect it could be due to the idle time of the user but looking for the detailed explanation of the null value on these columns.

Would appreciate you faster response.

Below is the query used to get the number of times object accessed by user.

set linesize 300

set pagesize 1000

col user_id format 999999

col username format a30

col object_owner format a30

col object_id format 999999999