SQL Performance (MOSC)

MOSC Banner

Does flush shared pool really flushes he cursors. ?

I am seeing a strange behavior, Even i after flushing the shared pool. load in v$ SQL is not 0, it increases by 1 since my query goes for hard parse. My understanding is if we flush the shared pool, it will create a new parent and load should be 0. Can someone please help me understand why load is not 0 and where v$ information is stored.


see in the below example, i am running a simple select (select * from departments;). in Column H_Parses value increased to 2 after shared pool flush, does that mean it did not flush the parent or from where it is getting that info.

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