Setting account quotas, Modifying the default quotas, Account quotas – Oracle Audio Technologies ORACLE9I B10508-01 User Manual
Page 53
Installation Procedure Requirements
CD-ROM Pre-installation Requirements
3-9
At the UAF prompt, use the MODIFY command to add the required default and
authorized privileges as follows:
UAF> MODIFY ORACLE9 -
/PRIVILEGE=(CMKRNL,NETMBX,OPER,PFNMAP,PRMGBL,PRMMBX,SHARE,SYSGBL, -
SYSNAM,TMPMBX,GROUP,GRPNAM,IMPERSONATE,LOG_IO,WORLD,SYSLCK, SYSPRV) -
/DEFPRIVILEGE=(CMKRNL,NETMBX,OPER,PFNMAP,PRMGBL,PRMMBX,SHARE, SYSGBL, -
SYSNAM,TMPMBX,GROUP,GRPNAM,IMPERSONATE,LOG_IO,WORLD,SYSLCK, SYSPRV)
Setting Account Quotas
Use the AUTHORIZE utility to change account quotas to accommodate the
requirements of your Oracle9i installation.
Modifying the Default Quotas
After adding a record with the default quotas, use the MODIFY command to alter
the default values
.
The following example changes the Enqueue quota (ENQLM)
from the default value to a value of 150:
UAF> MODIFY ORACLE9i/ENQLM=150
Account Quotas
The following table lists the Oracle9i account quotas, their minimum recommended
values, and their equivalent HP OpenVMS Alpha quota names as displayed by the
DCL commands SHOW PROCESS/QUOTA and SHOW WORKING_SET.
Note:
These quotas depend on the number of log files, the number
of databases, the number of network connections, and other
logicals on your system
.
You might need to customize them.
Table 3–1
Oracle9i Account Quotas
Account Quota
Minimum Value
Quota Name
ASTLM
250 (the default)
Asynchronous System Trap limit
BYTLM
150,000
Buffered I/O limit
CHANNELCNT
31
Channel Count
ENQLM
2000 (the default)
Enqueue quota