Queries to know Information about your Oracle Instance

There are some queries given below by which you can get the information regarding your oracle application instance:

Query to find Oracle Apps Database Version
SELECT VERSION FROM V$INSTANCE ;

Query to find host name of Oracle Apps Instance
SELECT HOST_NAME FROM V$INSTANCE;

Query to find Oracle Apps Instance Version
SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS;

Query to find Oracle Apps Instance Name
SELECT INSTANCE_NAME FROM V$INSTANCE;

Query to find Oracle Apps Instance is set up for MultiOrg
SELECT MULTI_ORG_FLAG FROM FND_PRODUCT_GROUPS;

Query to find list of Products and their version installed on your Oracle Apps Instance
SELECT * FROM PRODUCT_COMPONENT_VERSION;

Query to find workflow version
SELECT TEXT FROM WF_RESOURCES WHERE NAME= 'WF_VERSION';

Query to find Database Version and PL/SQL version
SELECT * FROM V$VERSION;

Query to find Database Status
SELECT STATUS FROM V$INSTANCE;

Query to find Application Patch Level
SELECT PATCH_LEVEL FROM FND_PRODUCT_INSTALLATIONS WHERE PATCH_LEVEL LIKE '%&Your_Application_Short_Name%';

Post a Comment