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

Thread: Oracle wait event

  1. 08-27-2008, 06:43 AM #1
    dba127
    dba127 is offline Junior Member
    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..
    Reply With Quote Reply With Quote
  2. 08-27-2008, 07:22 AM #2
    malay_biswal
    malay_biswal is offline Senior Member
    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
    Reply With Quote Reply With Quote
  3. 08-27-2008, 07:48 AM #3
    dba127
    dba127 is offline Junior Member
    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..
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width