ITPub博客

By my understanding the main difference between Sync and Async for VVR is how VVR writes VVR log and ship it to DR side. [@more@]Async mode, 1> Oracle messages OS to request IO operations to write oracle redo buffer into a certain group of log files when a client process commits a transaction.2> Oracle writes redo buffer into a certain group of log files. 3> Oracle completes the transaction and won’t wait for VVR. 4> VVR get the message from OS immediately and writes

Lock mode in which the process requests the lock:¦ 0 - none¦ 1 - null (NULL)¦ 2 - row-S (SS)¦ 3 - row-X (SX)¦ 4 - Table share (S)¦ 5 - Table Share and Row-X (SSX)¦ 6 - Table exclusive (X)Conclusion in 10gR2.1> create index az_obj_id. (4-TM)2>alter index az_obj_id rebuild online; (2-TM and 4-TM)3> alter index az_obj_id rebuild; (4-TM and 3-TM)4>alter table az move tablespace test; (6-TM)5>alter table az shrink space; (3-TM and 6-TM

http://space.itpub.net/756652/viewspace-442206[@more@]FIY.