open cursors [message #271296] |
Mon, 01 October 2007 03:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi Friends,
when i execute the below statement,
SELECT sid, user_name, COUNT(*) "Cursors per session"
FROM v$open_cursor
GROUP BY sid, user_name
I have about 379 as result.
In my init.ora, the parameter "open_cursors=400".
What factors should be taken into consideration to increase this value?
|
|
|
|
Re: open cursors [message #271302 is a reply to message #271297] |
Mon, 01 October 2007 03:44 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi Michel,
thanks,
this means that if we take the below output (in red), the user mnswcp is connected to the database and is using 34 cursors over the total of 400 that I have.
SID USER_NAME Cursors per session
15 MNSWCP 34
From which I read, if there is a cursor problem, I should get "ORA-01000 Open Cursor error".
Fortunately, till now I haven,t get this error. But to be on the safe side, I want to increase the open cursors value.
Can you please tell me which factors should be taken into consideration to increase this value.
Thx
|
|
|
|
|
Re: open cursors [message #271517 is a reply to message #271302] |
Mon, 01 October 2007 16:48 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
OracleDisected
Messages: 25 Registered: September 2007 Location: Mexico
|
Junior Member |
|
|
Apparently you don't need to increase that parameter.
Given 400 as open cursor limit per session , and 34 as the current open cursors for that user, the session has margin for 366 additional cursors to open.
In other words , every session has 400 cursors to open.
Best Regards
Ignacio
[Edit MC: url to poster blog removed. We don't care about your blog in this post. If you have an answer on your site, post a link to this answer. If you don't, post your blog url in Marketplace]
[Updated on: Thu, 11 October 2007 12:40] by Moderator Report message to a moderator
|
|
|
|
Re: open cursors [message #271544 is a reply to message #271537] |
Tue, 02 October 2007 00:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi Friends,
I made a statistics yesterday and I noticed that over the total (open_cursors) of 400 that I have in the parameter file, an average of 350-375 are being used.
Fortunately, till now I haven't come across the error 'ORA-01000 Open Cursor error'.
Can I increase it, to be on the safe side?
Thx
|
|
|
|
|
|
|
|
Re: open cursors [message #271589 is a reply to message #271569] |
Tue, 02 October 2007 02:13 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi All,
it's said that 'The maximum value of this parameter is operating system dependent'.
I have Solaris 8 and oracle 9db. 600M SGA, 3GB Physical memory. Can you please tell me the maximum value I can set for this parameter.
Thx
Dirish
|
|
|
|
Re: open cursors [message #271606 is a reply to message #271590] |
Tue, 02 October 2007 03:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | Can you please tell me the maximum value I can set for this parameter.
|
No, I can't. Ask Oracle or try all values you can.
Quote: | you asked me to read "this topic". But you haven't sent me any topic/mail/URL.
|
I answered:
That is "this very one you are currently writing in".
Regards
Michel
|
|
|