Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Largest shared pool
> 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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Apr 05 2004 - 17:05:00 CDT
![]() |
![]() |