Re: DB performance after upgrade from 9i to 11gR2
- From: Sayan Sergeevich Malakshinov <malakshinovss@xxxxxxxxx>
- To: baitha@xxxxxxxxxxxxxxxxx
- Date: Thu, 8 May 2014 11:29:27 +0400
I would start with checking the parameters:
select name as parameter
,decode
(p.type
,1,'boolean'
,2,'string'
,3,'number'
,4,'file'
,6,'size(bytes)'
,'Unknown: '||p.type) type
,description
,decode(p.type,6,p.display_value,p.value) as value
,update_comment
,ISMODIFIED
,ISADJUSTED
,ISDEPRECATED
,ISBASIC
,ISSES_MODIFIABLE
,ISSYS_MODIFIABLE
,ISINSTANCE_MODIFIABLE
from v$parameter p
where p.isdefault='FALSE'
and p.name not like 'log_archive_dest%'
/
--
Best regards,
Sayan Malakshinov
http://orasql.org
> 2014-05-08 8:39 GMT+02:00 Bheemsen Aitha <baitha@xxxxxxxxxxxxxxxxx>:
> ...Some of the queries have differences in plan (FTS to index scans on
small tables)
> when compared to QA environment. We gathered stats with default auto
> sample size and default method_opt options.
> Thanks
> BA
>
Other related posts:
