Saturday, 15 November 2014

Queries to know Information about your Oracle Instance

There are some quries 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%';

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete