The Same SQL_TEXT From V$SQLAREA Has Different SQL_IDs
(Doc ID 2995839.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database Cloud Exadata Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
Symptoms
Using the following command to view the same SQL_TEXT, there are many different SQL_IDs which occupy a lot of shared pool.
The sql is not marked hot as described in document "Different Sql_id's But Sql Is The Same Text When Sql Is Marked Hot <Document 2234171.1>".
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |