Achieve acceptable performance when using the embedded PL/SQL gateway by setting the SHARED_SERVERS
database initialization parameter to a reasonable value.
The embedded PL/SQL gateway uses the shared server architecture of the Oracle Database. To achieve acceptable performance when using the embedded PL/SQL gateway, ensure the SHARED_SERVERS
database initialization parameter is set to a reasonable value (that is, not 0
or 1
). For a small group of concurrent users, Oracle recommends a value of 5
for SHARED_SERVERS
.
Consider the following example:
Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS
specifying the SYSDBA
role. For example:
On Windows:
SYSTEM_DRIVE:\ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password
On UNIX and Linux:
$ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
Run the following statement:
ALTER SYSTEM SET SHARED_SERVERS = 5 SCOPE=BOTH;