Pages

▼
Showing posts with label DBA. Show all posts
Showing posts with label DBA. Show all posts

EBS R12 Find all Tablespace Free Script

›
--Find all Free Tablespace SELECT /* + RULE */ df.tablespace_name "Tablespace", df.bytes / (1024 * 1024) "Size (MB)", SU...

Oracle EBS query to find profile option Printer has a value at site level

›
---Oracle R12 Printer profile setup  SELECT t.user_profile_option_name "Profile Option", decode(a.level_id, 10001, 'Site',...

How to Get Application User Login Session Details

›
---Get Application User Login Session Details  Oracle R12 SELECT SUBSTR( d . user_name , 1 , 50 ) User_Name ,   a. pid Process_ID ,...

Find Tablespace Free

›
/*Query Find Tablespace Free */   SELECT TABLESPACE_NAME, ROUND (SUM (BYTES) / POWER (2, 20)) FREE_MB     FROM (SELECT BYTES, TABLESPACE_NAM...

Hold and Unhold concurrent program schedule

›
-----Check how many program are hold------------------- SELECT *   FROM fnd_concurrent_requests  WHERE hold_flag = 'Y' AND request_i...

How to enable oracle EBS Diagnostics or Examine menu

›
Steps 1: Navigate to System Administrator responsibility -> Profile -> System -> Enter profile name:  Utilities:Diagnostics Enter A...

Oracle Apps R12: Check if the patch applied or not

›
--Check if the patch applied or not This table includes the defined bugs on the system: SELECT    bug_number        || '.'        ||...

Oracle EBS Windows Name Changes

›
System Admin Responsibility:  Go to  Profile -> System  Find the Profile Name: Site Name

Calculate Average Completed Time on Concurrent Program

›
/*Calculate Average Oracle Concurrent Program Completed Time*/ select avg(fr1.actual_completion_date - fr1.actual_start_date) avgCPtime   fr...

How to Kill the session in Oracle

›
select  *   from  v$lock   where id1 = (                select  object_id                  from  dba_objects                  where ow...

Getting Error in R12 FNDLOAD: command not found

›
uploading or downloading FNDLOADS we may get following error FNDLOAD: command not found Solution:  Apply .  Env  file   as shown...

File transfer from Windows to Linux

›
---CSV file move The PuTTY Secure Copy client(PSCP), is a tool for transferring files securely between computers using an SSH connection: ...

How to find the Output file path in oracle EBS

›
cd $APPLCSF/log cd $APPLCSF/out – PDF/excel/out For eg : In stage :- Location :-  /u03/app/STAGE/inst/apps/ STAGE_XXXXtes...

How to find the Lock table in oracle apps

›
SELECT   a.session_id,          a.oracle_username,          a.os_user_name,          b.owner "OBJECT OWNER",          b.object_na...

How to find Application Instance Login URL same database

›
---Application Instance Login URL SELECT profile_option_value URL   FROM fnd_profile_option_values  WHERE     profile_option_id =           ...

How to Check the File Version in Oracle Application

›
Below command for 12.1.X and  Run the same command for 12.2.X then set the environment file e.g. $ . EBSapps.env Check the File  version ...

How to Find the Node, Platform and IP address in Instance

›
 Oracle apps Node, Platform and IP address in Instance Navigation: System Administrator -> Install -> Nodes

How to Find Application Top by particular application name

›
  SELECT    B.APPLICATION_ID,                     B.APPLICATION_SHORT_NAME,                     B.BASEPATH APPLICATION_TOP,                ...

How to increase oracle froms session times

›
Session Timeout Log in : System Administrator Select the Profile option (Profile - > System -> ICX:Session Timeout) in user le...

How to Hide Diagnostics Menu in Apps Forms

›
Hide Diagnostics Menu