Re: DB performance after upgrade from 9i to 11gR2
From: Sayan Sergeevich Malakshinov <malakshinovss_at_psbank.ru>
Date: Thu, 8 May 2014 11:29:27 +0400
Message-ID: <OFCD6B65EA.70BCEE46-ON44257CD2.0028BD0B-44257CD2.0029263C_at_psbank.ru>
I would start with checking the parameters:
from v$parameter p
where p.isdefault='FALSE'
and p.name not like 'log_archive_dest%'
/
Date: Thu, 8 May 2014 11:29:27 +0400
Message-ID: <OFCD6B65EA.70BCEE46-ON44257CD2.0028BD0B-44257CD2.0029263C_at_psbank.ru>
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_at_itradenetwork.com>: > ...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 > -- http://www.freelists.org/webpage/oracle-lReceived on Thu May 08 2014 - 09:29:27 CEST