Sep 5, 2010

Which Command is more efficient: Move vs Shrink?

Common Advantages:

1) Reset the high water mark of a table.
2) Resolves the row-chaining.
3) “Alter table move” moves the rows to un-used space and reset the High-Water Mark.
4) Better index access takes place because of a smaller b-tree.
5) Chained-rows are repaired.
6) Can be done online.


a) Doesn't lock the objects in exclusive mode.
b) Executes in LOCKED_MODE=3 (Row Lock Mode), which enables recovering without stopping operations.

a) Locks the objects in Exclusive mode.
b) Executes in LOCKED_MODE=6 (exclusive mode).

Restrictions/Disadvantages on Shrink:

1) You cannot shrink following:
    a) UNDO segments
    b) Temporary segments
    c) Clustered tables
    d) Tables with a column of datatype LONG
    e) LOB indexes
    f) IOT mapping tables and IOT overflow segments
    g) Tables with MVIEWS with ON COMMIT
    h) Tables with MVIEWS which are based on ROWIDs
2) Possible in tablespace with ASSM (Automatic segment Space management)
3) Need full (exclusive) table lock.
4) Indexes will be left with the status unusable (because they contain the old rowids) and must be rebuilt.

Different ways of reclaiming the space:

1) Create table as select:
2) Export and Import (exp & imp or expdp & impdp)
3) Online re-org
4) Alter table shrink

More Details to come....

Jun 6, 2007

What is adident utility? Or To know the file Version in Oracle Apps?

adident utility in oracle apps is used to find version of any file .

AD Identification:
Example: adident Header < filename >

Patch Log file in Oracle Apps

Q: Where are the log files for the patch process stored?

The log files that are generated during the patch process are stored in the
following locations:

- $APPL_TOP/install/log
- $APPL_TOP/admin/log

Q: What other log files are generated when applying a patch?
When a patch is applied, it may generate other log files besides the log name
that is entered at the start of adpatch. Following are some log files that may
also be updated by the patch.

- adfrmgen.log (Form generation)
- adlibin.log (libin commands)
- adlibout.log (libout commands)
- admvcode.log (copying files to destination)

What is the oraInventory?

The oraInventory is the location for the OUI (Oracle Universal Installer)'s
bookkeeping. The inventory stores information about:

* All Oracle software products installed in all ORACLE_HOMES on a machine
* Other non-Oracle products, such as the Java Runtime Environment (JRE)

In a 11i Application system the RDBMS and iAS ORACLE_HOMEs are registered in
the oraInventory. The 806 ORACLE_HOME, which is not managed through OUI, is not.

On Unix/Linux, the location of the oraInventory is defined by the content of
oraInst.loc, at:

- /var/opt/oracle/oraInst.loc on Solaris, HP-UX and Tru64
- /etc/oraInst.loc on Linux and AIX
On Windows, the location of the oraInventory is defined by the value of the
registry key HKEY_LOCAL_MACHINE|Software\Oracle\INST_LOC or if this value
is not defined, at C:\Program Files\Oracle\Inventory

With Courtesy by ML

Can't View Reports in Concurrent_Request



1) Can't "View Output"/"View Log file" in the Concurrent Request.
2) Can't Copy files (Navigation: Special --> Copy Files).





1.  Check Profile Option: PROFILE > SYSTEM
    APPLICATIONS: Web Agent  =

2.  Check that the FNDWRR.exe exists in the $FND_TOP/bin & $OA_HTML/bin
3.  Relink to create a New FNDWRR.exe in The $FND_TOP/bin:
  A. as APPLMGR Shutdown the Concurrent Manager
     Example: $common_top/admin/scripts/ apps/apps stop
  B. $cd $FND_TOP/bin
  C. $mv FNDWRR.exe FNDWRR.bak
  D. $ force=y "fnd FNDWRR.exe"
4. Copy the New FNDWRR.exe to the $OA_HTML/bin directory

5. Start the Concurrent Manager

 Example: $common_top/admin/scripts/ apps/apps start