Re: many schemas

Hi Vivek,

	First, increase the number of data buffers to hold the table data
	without affecting your other data.

	Change init.ora parameter CACHE_SIZE_THRESHOLD (In db blocks) to a
	large enough value to hold the table.

	alter table "table_name" cache;

	Bounce the database, bring it up in restricted mode.

	Select * from "table_name";

	Disable restricted mode.

	All of this will allow the table to be cached as one unit in the
	SGA. If the SGA is not big enough you will find that the data will 
	slowly age out as other queries use the data space. If
CACHE_THRESHOLD_SIZE
	is not set high enough Oracle will not cache the table despite all
	the other settings.

	I believe the CACHE_THRESHOLD_SIZE setting is being replaced by the 
	MULTIPLE_BUFFER_POOL settings in Oracle 8I.

	The $ORACLE_HOME/rdbms/admin/catparr.sql script will provide a number 
	of useful views for monitoring your buffer cache.

HTH
Dave

VIVEK_SHARMA wrote:
>
> Dave wrote "We cached a 150M table to fix the performance problem below."
>
> HOW ??
>

-- 
Dave Morgan
Senior Database Administrator
Internet Barter Inc.