暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

GaussDB T 的问题报告:DV_DC_RANKINGS 的查询输出成对出现

原创 eygle 2020-02-27
966

在 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进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论