SQL_ID changing for same/identical SQL TEXT
Hello
We have one report(select statement) which is running on database every day and every time sqlid is getting change.
Both session have same sql text(identical) no change other than where clause values or bind variable.
We checked on Hot objects as well in v$db_object_cache we dont see any objects pinned.
We have one report(select statement) which is running on database every day and every time sqlid is getting change.
Both session have same sql text(identical) no change other than where clause values or bind variable.
We checked on Hot objects as well in v$db_object_cache we dont see any objects pinned.
Tagged:
0