Re: Slow SQL performance

From: Finn Jorgensen <>
Date: Mon, 21 Apr 2008 14:21:03 -0400
Message-ID: <>

This may be a little more radical than what you're looking for, but "alter system flush shared_pool" would definitely handle it.


On 4/21/08, Maureen English <> wrote:
> All;
> We are having a performance problem with our production server that
> is not occurring on our test server (a copy of the production server).
> Both instances are 10g ( on HP Tru64 hardware.
> The known difference between the two instances is that when the test
> system was upgraded, I generated statistics on the table using the
> 'FOR ALL COLUMNS' clause in dbms_gather_table_stats. In the production
> system, I couldn't afford the time it took to gather statistics for
> all columns, so I used the 'FOR ALL INDEXED COLUMNS' clause.
> The main table in our slow query happens to not have any indexes on
> it. I've since generated stats on that table, but it seems to have
> made no difference.
> I'm thinking that since the query is used constantly, it is still
> in memory, and will stay that way until something forces it out....
> Since the query is constantly used, is there a way that I can clear
> it from the cache? I'm looking into the DBMS_SHARED_POOL package's
> UNKEEP procedure, but the description of the KEEP procedure makes it
> sound like this will not work for tables.
> Any suggestions?
> - Maureen
> University of Alaska
> --

Received on Mon Apr 21 2008 - 13:21:03 CDT

Original text of this message