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:

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-l

Received on Thu May 08 2014 - 09:29:27 CEST