Oracle EBS Application Objects and Tablespaces .

     In Oracle Application databases there is a schema/User per very product top .Apart from each individual schema, there is a master schema called APPS which has access to all objects in every product schema, similar to SYSTEM schema in normal database.

The following code objects are installed in the APPS schema.
   i.     Packages 
   ii.    Procedures 
   iii.   Functions 
   iiii.  Triggers 
   iiiii.  Views 
   iiiiii. Materialized Views

The following objects are installed in the base product schemas.
   i.   Tables 
   ii.  Sequences
   iii. Indexes 
   iiii. Constrains 
 
In addition ,there are grants from the tables and sequences to the APPS schema, as well as synonyms from the APPS schema to those objects .

Oracle Applications Releases R12 required an Oracle Database block size of 8K,no other block size is supported by Oracle Product Support.

Till Oracle Applications 11.5.9 tablespace model employed separate tablespaces for a product's tables and indexes .The resulting tablespaces were named by appending 'D' for data or 'X' for an index to the product's short name or Oracle Schema name.

For example ,APD was the tablespace for Oracle Payables data, and APX was the tablespace for Oracle Payables indexes .

Only exceptions are APPS schema, As Apps schema doesn't have any tables or indexed of its own,
it used APPLSYSD as it is default tablespace.

Oracle Applications Release 11.5.10 introduces a new infrastructures for tablespace management ,the Oracle Applications Tablespace Model (OATM) . OATM comprised nine default tablespaces for applications objects in addition to Undo,Temp, and System database tablespaces .Indexes on transaction tables are held in a separate tablespace dedicated for transaction table indexes, whereas all other indexes are held in the same tablespace as the parent/base table .

Following are the Tablespaces types available out of the box with OATM.

OATM becomes mandatory for Application instances with RAC and RAW devices ,where there is currently limitation on number of raw devices .They can't go beyond 255 raw devices .In additional old tablespace modal ,each applications products has two tablespaces .As each tablespace needs at least one raw devices ,We will easily cross 255 devices limit if we use old model.