8.1.5 much slower than 7.3.4

Here is a summary of what I got from all of you: 1) if in cost base optimizer, did I analyze the tables --> Yes
2) the changes I made to the init.ora are:

• remove obsolete parameters
• set compatible to 8.1.5
• set shared_pool_size and db_block_buffers to higher values
• add DB_DOMAIN='.world'
• set java_pool_size to '1000K' --> should not do any harm 3) Did you use a different location for the 8.1.5 db? --> the 8.1.5 database is on the same disks than the 7.3.4 database 4) I understand there's some bug when timed_statistics=true in 8.1.5 --> I switched it to false with no results

Thanks for your input. I guess there is nothing obvious so I'll look at it more closely and tell you what I find.

Louis Brouillette
Analyste en informatique (DBA)
Universite du Quebec a Trois-Rivieres
Tel: (819) 376-5011 ext. 2435
Email: Louis_Brouillette_at_uqtr.uquebec.ca

 From: Dave Morgan <dmorgan_at_bartertrust.com>  Date: Thu, 18 May 2000 10:50:40 -0700
 Subject: 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.
www.bartertrust.com
408-910-4183


------------------------------

 From: "Tran, Chieu Minh" <tranc_at_recralab.com>
 Date: 18 May 2000 14:08:00 -0400
 Subject: RE: One Peta Byte = ??

To my understanding, the prefix mega (M) , giga (G), peta (P), ... will be =