Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    23

    Unanswered: tuning parameter

    Dear Viewers,

    Good morning and wish you all a good day....

    My query is , what are the tuning parameter you can get to know that their is a problem with REDO ALLOCATING LATCH or REDO COPY LATCH after quering the v$LATCH table.

    To solve this problem what are the paramete you will add in the INIT.ora parameter file


    Please mail me at MANIPS15@hotmail.com

    with regards
    mani PS

  2. #2
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: tuning parameter

    Hi,

    In Oracle7 and Oracle8.0 , LOG_SIMULTANEOUS_COPIES (This parameter controls the number of redo copy latches when the system has more than one CPU) and LOG_SMALL_ENTRY_MAX_SIZE

    In Oracle 8i and oracle 9.0, these parameters are obsolete.

    In Oracle9.2, multiple redo allocation latches become possible with init.ora LOG_PARALLELISM. The log buffer is split in multiple LOG_PARALLELISM areas that each have a size of init.ora LOG_BUFFER. The number of redo copy latches is determined by the number of cpus.

    hope this will help you

Posting Permissions

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