Re: OEM select statement take 3 minutes to finish???
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: mccdba1@xxxxxxxxx
- Date: Tue, 13 Apr 2010 15:28:34 -0700
Are the dictionary stats recent either by the auto job or
dbms_stats.gather_dictionary_stats ?
On Tue, Apr 13, 2010 at 1:01 PM, dba1 mcc <mccdba1@xxxxxxxxx> wrote:
>
> We have OEM 10.2.0.5 monitor ORACLE database 10.2.0.4. Recently I found one
> statement take 185 seconds to finish and it actually cause by OEM. I list
> this SQL statement for reference and anyone have ideal?
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
