Your Doorstep to the Temple of Oracle

Oracle EBS

Useful DBA/APPSDBA sql/Scripts

Posted by appsdba11i on May 4, 2011

To Find The Application URL from Database

select home_url from apps.icx_parameters;

to find invalid objects in Database

select owner,object_type,count(object_name) INVALIDS from dba_objects where status =’INVALID’

To  Find Blocking Sessions in Database

select * from dba_blockers

TO Find The Product Code Level Or patchset level

select Status  ,PATCH_LEVEL from fnd_product_installations where PATCH_LEVEL like ‘%AD%’;

Ex : replace AD with desire Product

To find the Languages Installed ??

select nls_language, language_code, installed_flag from apps.fnd_languages where installed_flag in (‘I’,’B’);


One Response to “Useful DBA/APPSDBA sql/Scripts”

  1. chaitanya said


    Very useful info….!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: