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

Thread: how check which object genrating how much archive

  1. #1

    how check which object genrating how much archive

    Hi,
    I have an materilize view in my data base when we run it our data base goes in hang and ression is our archive location full

    so how we can now which object genration so much of archive

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    Dev- plz mention the OS and DB version of your database.

    OS ?
    DB version?
    Apps version?
    Regards,
    -Amit

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128
    You need to check that during the MV refresh, which session is generating how much of the redo logs and which segment is genration how much redo log.

    Check the given link http://www.dbalounge.com/forum/showt...&p=526#post526
    Last edited by Amit; 11-20-2011 at 09:24 AM.
    Regards,
    -Amit

+ Reply to Thread

Similar Threads

  1. Oracle 11gR2 RAC Enable Archive log Mode.
    By ajaychandi in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 10-06-2012, 09:31 AM
  2. IT Resource , Object Form and Process Form in OIM 11g
    By Hemant in forum Oracle Fusion Middleware 11G - OIM , OAM , ODS , Weblogic , Webgate ..
    Replies: 0
    Last Post: 08-25-2012, 02:42 AM
  3. Log Miner This Utility used to convert redo file or archive file into readable format
    By devesh_ocp in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 04-25-2012, 11:05 AM
  4. Script to find lock object
    By Amit in forum Database Scripts
    Replies: 0
    Last Post: 11-04-2011, 12:46 PM

Tags for this Thread

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