A Brief Introduction to ADPatch AutoPatch (adpatch) “AutoPatch (adpatch) is the utility you use to apply patches to the Oracle E-Business Suite file system or database.”   Modes Of adpatch There …

How to Check Version of Apache in Oracle Apps?   Step 1. Goto Oracle Application Home  $ cd $IAS_ORACLE_HOME/Apache/Apache/bin/ $ pwd /apps/ebs/apps/tech_st/10.1.3/Apache/Apache/bin Step 2. Write httpd -v to fetch the …

How To Find Oracle Database 32 bit or 64 bit Finding Oracle Database Version on your system through Operating System $ cd $ORACLE_HOME $ cd bin $ file oracle oracle:         …

Change Date and Time Formats In Oracle Database? Option 1. If We want to change this format to DD/MONTH/YYYY format. SQL> alter session set nls_date_format=’DD/MONTH/YYYY’; Session altered. SQL> select sysdate …

Application Names in Oracle E-Business Suite R12     Application ID Application Name Application Short Name Basepath 1 0 Application Object Library FND FND_TOP 2 1 System Administration SYSADMIN FND_TOP …

How to find the Oracle E-Business Suite R12 application URL? $ sqlplus apps/appsdrdg SQL*Plus: Release 10.2.0.4.0 – Production on Fri Oct 20 16:55:32 2017 Copyright (c) 1982, 2007, Oracle. All …

Difference between P-File and SP-File? P-FILE SP-FILE It is called as parameter file. It is called as server parameter file. P-File is ASCII file and it can be edited Manually spfile is binary file and it …

How to rename a Datafile with Extension .dbf? For example we have  added a datafile but we forgot to give the extension .dbf Step 1. Shut down the Database SQL> …

How to Find Database Object and it’s Corresponding Datafiles SELECT DISTINCT t.ts#, t.name                AS Tablespace_name, d.name                AS DATAFILE, s.owner, s.segment_name, s.segment_type, s.bytes / 1024 / 1024 AS “MB” FROM   v$tablespace t, v$datafile d, dba_segments s WHERE  t.ts# = d.ts# AND t.name = s.tablespace_name AND s.owner = ‘APPS’;  

How to Find CPU Usage for a Session SET linesize 145 SET pagesize 9999 COLUMN sid format 9999 heading ‘SID’ COLUMN serial_id format 999999 heading ‘Serial#’ COLUMN session_status format a9 heading ‘Status’ justify right