Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • Last Modified:

v$session_longops doesnot populate for long running SQL's

Hi Experts,

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
0
vkchaitu82
Asked:
vkchaitu82
  • 2
1 Solution
 
sdstuberCommented:
longops isn't for your sql statements it's for operations that the database runs.

you can populate it yourself with dbms_application_info package but not at the sql level.
0
 
vkchaitu82Author Commented:
But i see from different articles that from Oracle 8i it has been enhanced to caputre the information about long running SQL's
0
 
sdstuberCommented:
Yes, it "can" do that, but it's not the sql itself it's operations behind it.

For instance, if your sql has a big table or index scan in it,  the scan might be considered a longop, the sql itself is not.  If your sql has lots and lots of small operations you very likely won't see it in the longops view because no one operation is considered "long"

0

Featured Post

How to Use the Help Bell

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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now