Can resizing datafiles affect the shared pool?
From: neil kodner <nkodner_at_gmail.com>
Date: Thu, 17 Sep 2009 08:41:47 -0400
Message-Id: <89881092-2FE7-43B4-9257-55CB6D3CD2F3_at_gmail.com>
Recently we had an issue where queries received a non-desirable explain plan, after weeks and weeks of production use. This lead to hundreds of sessions waiting on direct path write temp. I suspect this might be related to bind variable peeking but am not 100% sure.
Date: Thu, 17 Sep 2009 08:41:47 -0400
Message-Id: <89881092-2FE7-43B4-9257-55CB6D3CD2F3_at_gmail.com>
Recently we had an issue where queries received a non-desirable explain plan, after weeks and weeks of production use. This lead to hundreds of sessions waiting on direct path write temp. I suspect this might be related to bind variable peeking but am not 100% sure.
It is interesting to note that this happened shortly after a half- dozen datafiles were resized(by someone else of course :D). Does resizing datafiles during heavy production use invalidate cursors in the shared pool? This is on a single-instance database with about 2000 connections.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 17 2009 - 07:41:47 CDT