SQL Performance (MOSC)

MOSC Banner

understanding duplicates statements

edited Mar 2, 2016 4:03AM in SQL Performance (MOSC) 9 commentsAnswered

hello gurus !!!!

       I would like understand duplicate statement. in my OEM screen I have got :


I see in my screen OEM the duplicate statement : this time 41 and sometimes 250.

Then I would like understand if it is a problem or not : but I suppose, yes, because it is in memory.

1 - I do not understand why it is the same plan hash value ?

2 - if it is the same plan hash value duplicated, why Oracle OEM appear duplicate statement ? because for me it is the same query.

3 - how may I see if it is a problem or not ?

4 - I join you several screenshoot for it and better explain to you .

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center