SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
TEST
SQL> select DEVELOPER_PARAMETERS from apps.FND_CP_SERVICES where SERVICE_ID = (select MANAGER_TYPE from apps.FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
DEVELOPER_PARAMETERS
-----------------------------------------------------
J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m
SQL> update FND_CP_SERVICES
set DEVELOPER_PARAMETERS =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
1 row updated.
SQL> commit;
Commit complete.
SQL> select DEVELOPER_PARAMETERS from apps.FND_CP_SERVICES where SERVICE_ID = (select MANAGER_TYPE from apps.FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
DEVELOPER_PARAMETERS
------------------------------------------------------
J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m
INSTANCE_NAME
----------------
TEST
SQL> select DEVELOPER_PARAMETERS from apps.FND_CP_SERVICES where SERVICE_ID = (select MANAGER_TYPE from apps.FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
DEVELOPER_PARAMETERS
-----------------------------------------------------
J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx512m
SQL> update FND_CP_SERVICES
set DEVELOPER_PARAMETERS =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
1 row updated.
SQL> commit;
Commit complete.
SQL> select DEVELOPER_PARAMETERS from apps.FND_CP_SERVICES where SERVICE_ID = (select MANAGER_TYPE from apps.FND_CONCURRENT_QUEUES where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');
DEVELOPER_PARAMETERS
------------------------------------------------------
J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx1024m
No comments:
Post a Comment