v$session_longops doesnot populate for long running SQL's
When we are running long running SQl's which are about 30sec this particular table does not populate entrees to monitor.But i see entrees from username 'SYS'.
Some parameters at the system level needs to be set??
We are using Oracle9i
Thanks in advance
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.