performance tuning
SQL> select last_call_et, event,username,sql_id,program,module from v$session where status='ACTIVE' and username<>'SYS';
LAST_CALL_ET EVENT USERNAME SQL_ID PROGRAM MODULE
------------ ---------------------------------------------------------------- ------------------------------ ------------- ------------------------------------------------ ----------------------------------------------------------------
4742 direct path read temp PSPAYRL 8m7bzgwzb2ms3 sqr@l4repa19 (TNS V1-V3) sqr@l4repa19 (TNS V1-V3)
This is a select statement .
Pls suggest.
Regards,
Vishal