--- 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 -----------------------------------------------------------------