Column PLAN_HASH_VALUE IN V$SQLSTATS Continuously Changes (Doc ID 1345516.1)

Last updated on JUNE 30, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

On an active database instance, the PLAN_HASH_VALUE column of the V$SQLSTATS view will change periodically, even when queried against the same SQL_ID.

SQL> SELECT sql_id, plan_hash_value
  2  FROM v$sqlstats
  3  WHERE sql_id = '7qqk2mb9413n1';

SQL_ID        PLAN_HASH_VALUE
------------- --------------- 
7qqk2mb9413n1       417671951

SQL> /

SQL_ID        PLAN_HASH_VALUE
------------- ---------------
7qqk2mb9413n1      2752876211

Changes

You've made no changes to the database release level nor to the database parameters.

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