How to check Java heap size and How to change Java heap size

At first you need to know your Java heap size,

If it is required to change or update Java heap size, Then please flow this post and you'll be able to change Java heap size as an Oracle AppsDBA.

 

SO, by this post you will know....

How to check Java heap size

How to change Java heap size

To check use below query....

SELECT service_id, service_handle, developer_parameters
  FROM fnd_cp_services
 WHERE service_id = (SELECT manager_type
                       FROM fnd_concurrent_queues
                      WHERE concurrent_queue_name = 'FNDCPOPP');

Output will show like below screen...

 

 

Above output showing Java heap size 2048mb (2GB)

 

 

Now we will change or update it by another query

 UPDATE fnd_cp_services
   SET developer_parameters =
          'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx3072m'
 WHERE service_id = (SELECT manager_type
                       FROM fnd_concurrent_queues
                      WHERE concurrent_queue_name = 'FNDCPOPP');

COMMIT;

Output will show like below screen...

 

 

 Above output showing Java heap size 3072mb (3GB)

 

Please don't forget to commit. 

 

I hope this post will help you to change or check Java heap size.

As an Oracle AppsDBA you will need this.

 

You can find me on Fiverr & LinkedIn