长事务统计中发现如下会话SQL,一直持续...在MOS未找到相关indrebuild$说明,又是BUG?
SID SERIAL# MACHINE OWNER OBJECT_NAME EVENT PROGRAM SQL_TEXT
------ ---------- ---------------- ---------- -------------------- ------------------------ -------------------- -----------------------------------
761 1 CXCSSJK FSHSC HSC_SUBS_SUBSCRIBER_LOG read by other session oracle@CXCSSJK (SMON) SELECT dataobj#, ts#, file#, block#, pctfree$, initrans, maxtrans, compcols, flags FROM indrebuild$ WHERE obj#=:1
------ ---------- ---------------- ---------- -------------------- ------------------------ -------------------- -----------------------------------
761 1 CXCSSJK FSHSC HSC_SUBS_SUBSCRIBER_LOG read by other session oracle@CXCSSJK (SMON) SELECT dataobj#, ts#, file#, block#, pctfree$, initrans, maxtrans, compcols, flags FROM indrebuild$ WHERE obj#=:1
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22308399/viewspace-752171/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22308399/viewspace-752171/