Re: wow lots of changes in sgastat in 11.2 versus 11.1

From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Thu, 28 Mar 2013 14:07:43 -0500 (CDT)
Message-ID: <480f6bd2e8b04e4b91a6a74f2b87f0df.squirrel_at_society.servebeer.com>

John writes:

> No one at least on medium sized systems should
> be absolutely petrified of a flush of the shared pool

Unless a "medium" sized system included Oracle 10.1.0.5 with dynamic SGA sizing and a 3rd party app that didn't use bind variables. Stats collection that invalidated dependent cursors afterwards (the default) would effectively hang the instance for a few minutes. I would suspect that a flush would also have some similar negative affect.

Rich

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 28 2013 - 20:07:43 CET

This message: [ Message body ]
Next message: Maureen English: "Re: 1 minutes: best downtime story"
Previous message: Job Miller: "Re: Beat this...."
Maybe in reply to: John Hurley: "wow lots of changes in sgastat in 11.2 versus 11.1"
Next in thread: Austin Hackett: "RE: wow lots of changes in sgastat in 11.2 versus 11.1"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message