DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Supllemental Logging

  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Supllemental Logging

    Hi

    We have developed an application for a telecom service provider with subscriber base of 15 million. The application uses logminer utility to capture data from the archive logs. It requires enabling supplemental logging to capture information on updates.

    As the data that is required from archive logs is very selective (for around 5% of the tables and only few columns per table) we are creating supplemental log groups (with ALWAYS option) on these tables only.

    In all only 5% of transactions effect the tables on which we create the supplemental log groups.

    Can anyone give an indiacation of the performance impact this is going to have on the database under these conditions.

    Sanjeev

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what did you see when you tested it?

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Are you using Data Mirror or Golden Gate ?

Posting Permissions

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


Click Here to Expand Forum to Full Width