
|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
W2K3/Oracle 10.2.0.3
|
|
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
|
|
Description
|
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 |
Show » |
| There are no comments yet on this issue.
|
|