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

Thread: Oracle wait event

  1. #1
    Join Date
    May 2006
    Posts
    41

    Oracle wait event

    Hi,

    What is "wait for master scn" wait event? Can anyone explain this event with a scenario?

    Thanks..

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    If you ahve RAC with 2 Nodes, synchronization will be done by using highest SCN. THis wait time is number of times foreground processes
    waited for SCNs to be acknowledged from other instances in the cluster.
    http://www.perf-engg.com
    A performance engineering forum

  3. #3
    Join Date
    May 2006
    Posts
    41
    Hi Malay Biswal,

    Thanks for your information.

    Can you please explain what is "wait for scn from all nodes" with an example and which events in oracle database trigger SCN propagation?

    Thanks..

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