在 GaussDB 1.0.1 中,对于 DV_DC_RANKINGS 的查询,大量对象的数据成对出现。
不仅对象名称相同,而且 PAGES 数量也完全相同,需要确认是否是BUG,或者能解释原因。
以下是一个测试输出:
SQL> select * from DV_DC_RANKINGS order by 1,2;
USER_NAME OBJ_NAME PAGES
---------- -------------------------------------------------- ------------
ENMO ENMOTECH 1
ENMO ENMOTECH 1
SYS ADM_HIST_SNAPSHOT 1
SYS ADM_TABLESPACES 1
SYS ADM_TAB_PARTITIONS 1
SYS DV_BUFFER_PAGE_STATS 1
SYS DV_BUFFER_POOLS 1
SYS DV_BUFFER_POOL_STATS 1
SYS DV_CONNPOOL_STATS 1
SYS DV_DATABASE 1
SYS DV_DC_POOLS 1
SYS DV_DC_RANKINGS 1
SYS DV_DYNAMIC_VIEWS 1
SYS DV_GMA 1
SYS DV_GMA_STATS 1
SYS DV_INSTANCE 1
SYS DV_LATCHS 1
SYS DV_LIBRARY_CACHE 1
SYS DV_LOCKED_OBJECTS 1
SYS DV_LOCKS 1
SYS DV_LONG_SQL 1
SYS DV_MEM_STATS 1
SYS DV_OPEN_CURSORS 1
SYS DV_PARAMETERS 1
SYS DV_SEGMENT_STATS 1
SYS DV_SESSIONS 1
SYS DV_SESSION_EVENTS 1
SYS DV_SQLS 1
SYS DV_SQL_POOL 1
SYS DV_SYSTEM 1
SYS DV_SYS_EVENTS 1
SYS DV_SYS_STATS 1
SYS DV_TABLESPACES 1
SYS DV_TEMP_POOLS 1
SYS DV_TRANSACTIONS 1
SYS DV_UNDO_SEGMENTS 1
SYS DV_WAIT_STATS 1
SYS V$PARAMETER 1
SYS WSR_CONTROL 1
SYS WSR_EXCEPTION_LOG 1
SYS WSR_INSTANCE_SNAP 26
SYS WSR_INSTANCE_SNAP 26
SYS WSR_LATCH 1
SYS WSR_LIBRARYCACHE 1
SYS WSR_LOCK_OBJECT 26
SYS WSR_LOCK_OBJECT 26
SYS WSR_LONGSQL 19
SYS WSR_PARAMETER 1
SYS WSR_SEGMENT 24
SYS WSR_SEGMENT 24
SYS WSR_SESSION_EVENTS 24
SYS WSR_SESSION_EVENTS 24
SYS WSR_SESSION_SQL 26
SYS WSR_SESSION_SQL 26
SYS WSR_SNAPSHOT 1
SYS WSR_SQLAREA 14
SYS WSR_SQLAREA 14
SYS WSR_SQLPLAN 26
SYS WSR_SQLTEXT 26
SYS WSR_SQLTEXT 26
SYS WSR_SYSTEM 1
SYS WSR_SYSTEM_EVENT 1
SYS WSR_SYS_STAT 1
SYS WSR_TRANSACTION 14
SYS WSR_TRANSACTION 13
SYS WSR_WAITSTAT 1
66 rows fetched.
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。




