Negative Value Appears in v$rowcache (Doc ID 1390006.1)

Last updated on DECEMBER 08, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.7 to 11.1.0.7 [Release 9.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 07-Dec-2016***

Symptoms

Negative values are seen in v$rowcache like below:

SQL> select PARAMETER, sum(gets) from v$rowcache group by PARAMETER;

PARAMETER                          SUM(GETS)
-------------------------------- -----------
dc_app_role                                0
dc_constraints                          3393
dc_database_links                      52744
dc_encrypted_objects                       0
dc_encryption_profiles                     0
dc_files                           267117867
dc_free_extents                            0
dc_global_oids                       1974696
dc_histogram_data                      86118
dc_histogram_data_values                   0
dc_histogram_defs                 -999121677
dc_object_ids                     1118189909
dc_objects                         810027414
dc_outlines                                0
dc_partition_scns                          0
dc_profiles                          8797394
dc_qmc_cache_entries                       0
dc_qmc_ldap_cache_entries                  0
dc_rollback_segments               153565231
dc_segments                      -1190580076
dc_sequences                         5136138
dc_table_scns                          19356
dc_tablespace_quotas                 2445751
dc_tablespaces                      55509323
dc_used_extents                            0
dc_user_grants                      38569173
dc_usernames                        29458788
dc_users                         -1263320850

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms