- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - OpenVMS
- >
- Re: Setting Account Quotas for Oracle
Categories
Company
Local Language
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
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
Community
Resources
Forums
Blogs
- 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-2006 05:39 AM
тАО10-26-2006 05:39 AM
Can someone let me know if the following quotas can be specified for oracle user on HP OpenVMS 8.1-2. This will be a build system which will not involve much of database activity. The only activity that goes on this system is compilation and validation. May I know what will be the respective quota value on those systems where heavy load of database transactions happen.
Account Quota Minimum Value Quota Name
ASTLM
250 (the default)
Asynchronous system trap limit
BYTLM
750000
Buffered I/O limit
ENQLM
2000 (the default)
Enqueue quota
FILLM
2048
Open file quota
JTQUOTA
8192
Job table quota
MAXDETACH
0 (the default)
Max detached processes
MAXJOBS
0 (the default)
Max active jobs
PGFLQUOTA
1,500,000 (recommended)
Paging file quota
WSDEFAULT
2048
Working set default
WSEXTENT
8192
Working set extent
WSQUOTA
4096
Working set quota
Thanks,
Srikanth
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-26-2006 07:24 AM
тАО10-26-2006 07:24 AM
Solutionwith no recent experience on VMS+Oracle, I only can give general indications.
ASTLM, ENQLM, FILLM, MAXDETACH, MAXJOB are looking good to generous. Some special cases may want one of m higher, but it would be SPECIAL.
BYTLM looks rather low. The cost of it is trivial, so I would advise 2 4, or (especially on IA64) maybe 10 M
JTQUOTA depends on your app. Should be enough, or ORACLE would have advised more.
PGFLQUOTA might turn out scrappy if you run big databases. I usually use about double a recommended value.
WSQUOTA I would prefer 8 or 16 K on modern systems, maybe evn 32 or 64 K on IA64
The one that really sticks out as plainly WRONG is WSEXTENT. Make this BIG. AFAIK the limit of 64K very much enlarged with VMS V8.x
Modern systems tend to have much memory. Therefor, allow processes to USE it if/when no one else needs it.
hth
Proost.
Have one on me.
jpe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-26-2006 08:29 AM
тАО10-26-2006 08:29 AM
Re: Setting Account Quotas for Oracle
regards Kalle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-26-2006 09:38 AM
тАО10-26-2006 09:38 AM
Re: Setting Account Quotas for Oracle
If Bytlm is suppose to hold 2M of value, should I insert value of 2147483648.
thanks,
Srikanth A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-26-2006 01:20 PM
тАО10-26-2006 01:20 PM
Re: Setting Account Quotas for Oracle
Allan in Atlanta
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-26-2006 11:02 PM
тАО10-26-2006 11:02 PM
Re: Setting Account Quotas for Oracle
If, for example, a user's PGFLQUOTA in SYSUAF is 200000 but PQL_MPGFLQUOTA is 2000000, you'd have to increase the SYSUAF a long way (by at least 1800000) before the user's processes would actually see any difference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2006 02:48 AM
тАО10-27-2006 02:48 AM
Re: Setting Account Quotas for Oracle
Maxjobs: 0
Fillm: 2048
Bytlm: 500000
Maxacctjobs: 0
Shrfillm: 0
Pbytlm: 0
Maxdetach: 0
BIOlm: 400
JTquota: 4096
Prclm: 100
DIOlm: 200
WSdef: 8192
Prio: 4
ASTlm: 200
WSquo: 32768
Queprio: 0
TQElm: 200
WSextent: 262144
CPU: (none)
Enqlm: 2000
Pgflquo: 2000000
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2006 04:05 AM
тАО10-27-2006 04:05 AM
Re: Setting Account Quotas for Oracle
If you are not using Reserved Memory, make sure your Global Pages are very generous, or you won't be able to restart Oracle without a reboot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2006 04:15 AM
тАО10-27-2006 04:15 AM
Re: Setting Account Quotas for Oracle
re Galen:
"If, for example, a user's PGFLQUOTA in SYSUAF is 200000 but PQL_MPGFLQUOTA is 2000000, you'd have to increase the SYSUAF a long way (by at least 1800000) before the user's processes would actually see any difference."
In this case (PQL_MPGFLQUOTA=2000000) ALL processes would at least get a minimum of 2000000 for their PGFLQUOTA.
/Guenther
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-27-2006 04:30 AM
тАО10-27-2006 04:30 AM
Re: Setting Account Quotas for Oracle
thanks for your response. I had good info from all of you. I will close the fir with this note.
Thanks,
Srikanth