一起学习网 一起学习网

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”