Showing posts with label erp. Show all posts
Showing posts with label erp. Show all posts

Thursday, April 29, 2021

How to change session time out in oracle application

 In this post we will learn how to change session time out.

you can do it for any specific user by using user ID or you can ignore user ID if you want to change it for all user in oracle application

It is a system administrator job, So you must have system administrator responsibility. 


Now, just follow below 3 images, 































I have mentioned every single point in image by red circle, you just follow images.


You can find me on Fiverr & LinkedIn

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