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