Oracle 视图 USER_SR_OBJ 官方解释,作用,如何使用详细说明
本站中文解释
ECTS
Oracle视图User_SR_Objects用来查看数据库中存在的全部维护对象,可以把它看做是一张存储索引,它内部储存有每个维护对象的状态,拥有者,大小等许多信息。
使用方法:
(1)查看指定Object的状态:
SELECT STATUS
FROM USER_SR_OBJECTS
WHERE OBJECT_NAME=’
(2)查看指定Object的拥有者:
SELECT OWNER
FROM USER_SR_OBJECTS
WHERE OBJECT_NAME=’
(3)查看指定Object的大小:
SELECT OBJECT_SIZE
FROM USER_SR_OBJECTS
WHERE OBJECT_NAME=’
官方英文解释
USER_SR_OBJ
provides information on the objects currently registered for synchronous refresh for current groups for the current user. Its columns are the same as those in DBA_SR_OBJ
.
See Also:
“DBA_SR_OBJ”