- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: open_cursors's impact?
Operating System - HP-UX
1753502
Members
4943
Online
108794
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-26-2004 08:56 PM
тАО10-26-2004 08:56 PM
open_cursors's impact?
Originally , DB's open_cursors is 6000. However, programs still hitted ORA-01000: maximum open cursors exceeded. We decide to set open_cursors = 7000. But we don't know what impact this parameter do. Pls kindly explain it.
Thanks
Eric
Thanks
Eric
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-26-2004 10:54 PM
тАО10-26-2004 10:54 PM
Re: open_cursors's impact?
hi,
It will affect performance in that your applications will work where right now they fail ;)
Seriously, open_cursors will set a maximum number of cursors a process can open. If you set it to 1000 (the recommended setting) Oracle will actually allocate cursors 64 at a time, thus setting this artificially high does NOT have a negative impact on resource usage.
Note that, open_cursors is what controls how many cursors java/jdbc is going to open. A program that leaks cursors will ultimately hit this upper bound. To be able to identify those programs that must be fixed versus those programs which need more cursors than others, you may query the V$SESSTAT to identify sessions with more then 5,900 open cursors -- then, if you have that sid, you can goto v$open_cursor and see the cursors.
hope this helps!
regards
Yogeeraj
It will affect performance in that your applications will work where right now they fail ;)
Seriously, open_cursors will set a maximum number of cursors a process can open. If you set it to 1000 (the recommended setting) Oracle will actually allocate cursors 64 at a time, thus setting this artificially high does NOT have a negative impact on resource usage.
Note that, open_cursors is what controls how many cursors java/jdbc is going to open. A program that leaks cursors will ultimately hit this upper bound. To be able to identify those programs that must be fixed versus those programs which need more cursors than others, you may query the V$SESSTAT to identify sessions with more then 5,900 open cursors -- then, if you have that sid, you can goto v$open_cursor and see the cursors.
hope this helps!
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-26-2004 10:55 PM
тАО10-26-2004 10:55 PM
Re: open_cursors's impact?
hi again,
see also Metalink Note:1012266.6 with subject: Overview of ORA-1000 Maximum Number of Cursors Exceeded.
regards
Yogeeraj
see also Metalink Note:1012266.6 with subject: Overview of ORA-1000 Maximum Number of Cursors Exceeded.
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2004 04:26 AM
тАО10-29-2004 04:26 AM
Re: open_cursors's impact?
Hi Eric,
I also think 6000 is too high for open_cursors parameter: I have it set with 255 and have no problem at all... Remenber that this value is for EACH SINGLE USER PROCESS. See Metalink Note 30781.1 for better understanding this parameter.
Best Regards,
Eric
I also think 6000 is too high for open_cursors parameter: I have it set with 255 and have no problem at all... Remenber that this value is for EACH SINGLE USER PROCESS. See Metalink Note 30781.1 for better understanding this parameter.
Best Regards,
Eric
Each and every day is a good day to learn.
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP