Oracle Apps DBA

Oracle apps dba workshop for all of you who are related Linux and Oracle. If you are looking for getting knowledge about oracle apps dba, oracle ebs and linux etc then you are in right place. Oracle apps dba workshop will provide info that is tested. whatever you are in beginner or advance level, you can follow this blog for increasing you knowledge in Linux and Oracle Apps DBA. You will find everything in step by step. So you can accept this blog as Oracle Apps DBA Workshop.

Showing posts with label TOP Path. Show all posts

Tuesday, January 10, 2023

Oracle Application TOP

How to find Application TOP

To find oracle application top you can use below Query...

Query:

SELECT variable_name,
VALUE
FROM fnd_env_context
WHERE variable_name LIKE 'AP\_TOP' ESCAPE '\'
AND concurrent_process_id =
(SELECT MAX(concurrent_process_id) FROM fnd_env_context
)
ORDER BY 1;

Please not that you can find more important info from this "fnd_env_context" table that i have used above.

So, I request you to check this table in details.

If you are oracle apps dba then it will be helpful for you.

You can find me on Fiverr & LinkedIn