What do you infer from the results?

You noticed a high number of SQL statements with the same PLAN_HASH_VALUES.
View Exhibit1 to see the details.
View Exhibit2 to see the details of the SQL text for the statements.
What do you infer from the results?
Exhibit 1 (exhibit):
Exhibit 2 (exhibit):

You noticed a high number of SQL statements with the same PLAN_HASH_VALUES.
View Exhibit1 to see the details.

View Exhibit2 to see the details of the SQL text for the statements.

What do you infer from the results?

A.
The statements are using the same cursor.

B.
The statements are not using the same cursor.

C.
Removing the bind variable would improve performance.

D.
The cursor for the statement is aging out of the shared pool very quickly.



Leave a Reply 1

Your email address will not be published. Required fields are marked *