slow EPG PL/SQL Gateway problem

slow EPG PL/SQL Gateway problem

———- Forwarded message ———-
From: Davide Moraschi
Date: Wed, 15 Sep 2010 08:01:07 +0200
Subject: EPG PL/SQL Gateway slow problem
To: dmoraschi

3.3.11 Configuring the SHARED_SERVERS Parameter
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:

1.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
2.Run the following statement:

ALTER SYSTEM SET SHARED_SERVERS = 5 SCOPE=BOTH;

Leave a Reply

Leave a Reply