-
编辑 删除
Oracle X$ View:X$KJBL
Oracle X$ View:X$KJBL The status of buffer locks can be checked through the table X$KJBL; it is not necessary to dump the locks with the ORADEBUG command, in order to get to this information. The table contains the client and shadow locks. Column name &n...
-
编辑 删除
RAC object remastering ( Dynamic remastering )
RAC object remastering ( Dynamic remastering )Posted by Riyaj Shamsudeen on March 25, 2010In RAC, every data block is mastered by an instance. Mastering a block simply means that master instance keeps track of the state of the block until the next reconfiguration event (d...
-
编辑 删除
oracle 表在线重定义
在生产环境下，有时侯我们需要对表进行表空间的迁移，或碎片整理等，我们可以通过在线重定义来完成。---在定重定义包Summary of DBMS_REDEFINITION Subprograms:=========================================CAN_REDEF_TABLE Procedure:--------------------------This procedure determines if a given table can b...
