My Oracle Support Banner

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

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 07-Dec-2016***


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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.