+Nikita Dachawar thanks for the feedback... Shall take care in future videos... I suppose the bg music is Lloyd on this video... More on RAC will come up soon
Hi Sir, Your videos are ultimate. When checkpoint occurs, I know dbwr will write the dirty buffer to datafile.. so will archive process also writes from redo to archivelog at the same time? Please clarify
please explain in details .how the survive instance will get information about instance is crashed .how did survive instance get which block need to recover.what would be 1st step to in recovery to redo or undo.
Two things: 1) In which video are you talking about Redo log Threads? 2) Does instances communicate with each other? How instance 1 knows that instance 2 have lock on row/object XXX (because XXX is modified in instance 2 and at the same time another user wants to do changes on the same object on instance 1) ?
Row level locks are maintained in the row header... instances can share blocks with each other using cache fusion.. I shall explain in more detail in another video soon
Hello Santo, I am a bit late with the response but for people asking this question in the future as well, threads are typically used in Oracle Real Application Clusters (RAC) environments, where each instance has its own set of redo logs. A thread can have multiple redo log groups associated with it. So, a thread is the collection of redo logs used by one instance in a multi-instance (RAC) environment.