Re: Largest shared pool
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 5 Apr 2004 15:08:39 -0700 (PDT)
--- Paul Baumgartel <treegarden@xxxxxxxxx> wrote:
> What's the largest shared pool size you've ever
> seen?
> TIA
> Paul Baumgartel
Paul,
I heard Gaja mention that a site had a 4 GB shared
pool, for which "SELECT sysdate FROM dual;" took 15
minutes to execute. That was back at IOUG-A 2001.
But this is secondhand info at best.
If a huge shared pool caused oracle to _run_faster
wouldn't all the TPC-C runs have huge shared pools?
Paul
__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
