RE: Querying v$ tables very slow after upgrade

From: Johnson, William L (TEIS) <WLJohnson_at_tycoelectronics.com>
Date: Mon, 25 Jun 2007 14:23:01 -0400
Message-ID: <1C5D8AF23EF60E4C8E86777B7F504D8B1EF4F7E8@us194mx14.tycoelectronics.net>

We are running Oracle 10.2.0.3 - 64 bit HP-UX on PA-RISC hardware and have stats on the SYS owned objects that can have stats - and no performance problems querying any dictionary information...

So, do you have any carry over init.ora/spfile settings from 9i like events, hidden parameters, optimizer settings...

What O/S and release are you using?

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams Sent: Monday, June 25, 2007 2:12 PM
To: Patty.Charlebois_at_greenshield.ca
Cc: Oracle-L_at_freelists.org
Subject: Re: Querying v$ tables very slow after upgrade

Patty,

I haven't experienced 10g yet, but the advice I recall on this list was not to have statistics on SYS tables.

Can anyone else on the list clarify that?

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 25 2007 - 13:23:01 CDT