Have you tried a few sample queries after anlayzing tables and indexes, with
histograms for all indxed columns? We had fair amount of success doing that
during our migration from 7.3 to 8.1.5. I am now using the dbms_stats
package to do the same in 8.1.6.
- Kirti Deshpande
> -----Original Message-----
> From: Louis BROUILLETTE [SMTP:Louis_Brouillette_at_UQTR.UQuebec.CA]
> Sent: Thursday, May 18, 2000 1:03 PM
> To: ORACLE-L_at_fatcity.com
> Cc: oracledba_at_QuickDOC.co.uk
> Subject: 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
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
Received on Fri May 19 2000 - 08:18:12 CDT
