Locked Objects while flushing shared_pool?
538022Jul 15 2007 — edited Jul 16 2007Hello guys,
a little understanding about flushing shared pool and the stored objects in it.
What happens to objects (SQL Statements, DDIC cache, and so) that are needed at this time for execution.
For example an user is executing a select statement on a table and its is running while i am executing "alter system flush shared_pool".
What happens to the parsed sql statment which is used at this time by the sql query... and what is happens to the row cache (ddic cache) of the table which is queried at this time?
For my understanding this objects have to be locked (latch) by the user that is executing the query... are they invalidated after the query ends or what happens?
I know that this are internals but maybe someone of you knows it.
Regards
Stefan