Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Locked Objects while flushing shared_pool?

538022Jul 15 2007 — edited Jul 16 2007
Hello 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2007
Added on Jul 15 2007
5 comments
686 views