Computer Accessories User Manual

Installation Procedure Requirements
3-10 Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS
Appendix B, "Oracle9i 64-bit Feature" has additional information explaining the
meanings of the quotas and how to determine their values.
Process Rights for Database Administrators
The Oracle server Database Administrator (DBA) account must be granted one or
more process rights identifiers
. These identifiers provide the ability to issue the
CONNECT / AS SYSDBA command that is required to perform database
administration functions
. The following table displays the combinations of adding
and granting rights identifiers to this account:
For example, to grant the ORA_<sid>_DBA rights identifier to the Oracle9i account
for an instance called TEST, issue the following command:
UAF> ADD/IDENTIFIER ORA_TEST_DBA
FILLM 100 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
Table 3–2 Adding and Granting Process Rights Identifiers
Adding... and Granting... Allows Control of...
ORA_DBA ORA_DBA any database instance, provided it does
not also have an ORA_<sid>_DBA
identifier defined for it.
ORA_<sid>_DBA ORA_<sid>_DBA database instance <sid> only
ORA_<sid>_DBA ORA_DBA all database instances except <sid>
Table 3–1 Oracle9i Account Quotas (Cont.)
Account Quota Minimum Value Quota Name