Forgot your password?    
+ Reply to Thread
Results 1 to 4 of 4

Thread: Apps Tables which you do reorg regularly

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120

    Apps Tables which you do reorg regularly

    I had been asked in interview to name Apps tables which you reorg regularly.

    Any answer.

    Regards
    Md Masood

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Reorg would be carried out for those tables which are big in size and have more DML Transactions.
    The tables which are reorg-ed would differ from customer to customer , based on the modules they are using.

    Here are a few examples of the tables which may require reorg based on the modules :

    a) GL - GL_JE_LINES , GL_IMPORT_REFERENCES , tables related to GL Ledger Balance
    b) INV - MTL_MATERIAL_TRANSACTIONS, MTL_TRANSACTION_ACCOUNTS
    c) CZ - CZ_CONFIG_ITEMS
    d) AP - AP_EXPENSE_REPORTS_LINES_ALL
    e) WIP - WIP_REQUIREMENT_OPERATIONS
    f) FND - FND_CONCURRENT_REQUESTS, FND_LOG_MESSAGES

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Posts
    120
    Thanks a very helpful reply

  4. #4
    Oracle Administrator
    Join Date
    Oct 2011
    Location
    Venice
    Posts
    40
    I think the Wokflow related tables too we need to re-org on regular basis as these grows by very fast and consumes a lot of space. am I right ?
    Cheers !
    pk.ora

+ Reply to Thread

Similar Threads

  1. Global Temporary Tables
    By mdmasood in forum Oracle Apps Patching and Cloning, Installation , Migration,Upgrades
    Replies: 0
    Last Post: 09-11-2012, 10:42 PM
  2. OIM : List of Tables and Description
    By Hemant in forum Oracle Fusion Middleware 11G - OIM , OAM , ODS , Weblogic , Webgate ..
    Replies: 0
    Last Post: 05-08-2012, 01:23 PM
  3. Find Unsupported Tables to Create a LOGICAL STANDBY
    By Hemant in forum Database Scripts
    Replies: 0
    Last Post: 02-03-2012, 06:34 PM
  4. Oracle 11g Feature Read Only Tables.
    By ajaychandi in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 01-10-2012, 09:29 PM
  5. Script to Assess Fragmented objects for Reorg
    By Amit in forum Database Scripts
    Replies: 0
    Last Post: 11-02-2011, 03:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics