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’);



Advertisements

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

  1. chaitanya said

    Chaitanya

    Very useful info….!

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: