Oracle Audio Technologies B10508-01 ユーザーズマニュアル

ページ / 186
Installation Procedure Requirements
3-10
Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS
 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