Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
Property | Description |
---|---|
Parameter type | Integer |
Default value | 0 |
Modifiable | ALTER SYSTEM |
Range of values | 0 to 232 - 1 (max value represented by 32 bits) |
PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT
specifies the number of subdirectories created by the database administrator in the directory specified by PLSQL_NATIVE_LIBRARY_DIR
.
When using the PL/SQL native compiler, Performance of file create/open operations is unacceptably slow if the number of files in a directory is very large. It is usually advisable to create subdirectories and use this parameter if the total number of different PL/SQL packages that may need to be compiled natively by all users of the database instance exceeds 10000.
The subdirectories should have names corresponding to zero-based decimal numbers, prefixed by d
. For example, the database administrator can create 1000 subdirectories named d0
, d1
, ... d999
, and set PLSQL_NATIVE_LIBRARY_SUBDIR_COUNT
to 1000
.