History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: SQL-35
Type: Support Request Support Request
Status: Open Open
Priority: Major Major
Assignee: Bob Swift
Reporter: Cameron Pyziak
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Confluence SQL Plugin

Open cursors

Created: 16/May/08 10:47 AM   Updated: 16/May/08 10:47 AM
Component/s: sql-query macro
Affects Version/s: 3.4.0
Fix Version/s: None

Time Tracking:
Not Specified

Environment: W2K3/Oracle 10.2.0.3

Labels: sql_queries open_cursors


 Description  « Hide
We are connecting our wiki dashboard to one of our DB's to run queries and display charts and graphs. On that DB (where we are querying on) the connecting session has several open cursors...like 100+. I don't not recognize the queries either, I think they are internal Wiki queries. See some examples below, thanks:

update sys.col_usage$ set equality_preds = equality_pre
select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$
select pos#,intcol#,col#,spare1,bo#,spare2 from icol$
select pos#,intcol#,col#,spare1,bo#,spare2 from icol$

Can you please tell me how to close these queries? We are set to a max of 600 open_cursors and DB will start rejecting connections if we hit that. I could simply increase it but I'd like to understand how to control the connections from wiki. Plus we could potentially have many users on this...which would require 1000's of open cursors.
Thank you in advance,
Cam Pyziak
905-214-3080



 All   Comments   Work Log   Change History   FishEye   Crucible   Related Builds      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.