RE: [Q] Flush share pool can improve performance?

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 9 Jan 2001 09:27:19 +1000
Message-Id: <10735.126065@fatcity.com>

Hi there,

This is often true, but normally indicates an oversized shared pool. There's lot of discussion of the issues on the Ixora web site.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
From: L [mailto:leed_at_chele.cais.net]
Sent: Tuesday, 9 January 2001 8:15
To: oracle-l_at_fatcity.com; oracledba_at_quickdoc.co.uk Subject: [Q] Flush share pool can improve performance?

One of our vendor suggest us run "ALTER SYSTEM FLUSH SHARED_POOL" every 5 minutes on ORACLE 8 environment. They claim it will improve ORACLE performance. I need your opinion. Thanks.

---

Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Received on Mon Jan 08 2001 - 17:27:19 CST