Home » SQL & PL/SQL » SQL & PL/SQL » Estimating cache size
Estimating cache size [message #187520] Mon, 14 August 2006 05:55 Go to next message
Messages: 24
Registered: October 2004
Junior Member
I want to know how to estimate the size of tha cache memory, that is the value of the parameter:


is there any criteria to estimate it??

I'm working with partiotioned tables of ten millions rows. This tables are indexed and a normal query on this tables return about 10000 rows.

The maximun number of users working simultaneous and making sql's to this tables are 60.

Any advice about cache size will be greatly apreciatted.

Thanks in advance
Re: Estimating cache size [message #187523 is a reply to message #187520] Mon, 14 August 2006 05:59 Go to previous messageGo to next message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
By and large, the bigger it is, the faster queries will run.

However, if your queries do lots of full table scans of large tables, then you'll flush most of the frequently used blocks out of the table anyway, and it won't make much difference.

There is a system view V$DB_CACHE_ADVICE that will show you the probably effect of changing the size of the cache on a running system.
Re: Estimating cache size [message #187526 is a reply to message #187520] Mon, 14 August 2006 06:22 Go to previous message
Messages: 48
Registered: July 2006
Configuring and Using the Buffer Cache
Previous Topic: TRUNCATE
Next Topic: select/describe not working on table present in all_tables from sqlplus
Goto Forum:

Current Time: Wed Jul 26 08:03:29 CDT 2017

Total time taken to generate the page: 0.16535 seconds