Re: OEM select statement take 3 minutes to finish???

From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Mon, 19 Apr 2010 10:33:04 -0400
Message-ID: <u2rf30139791004190733o5fd3d60fi50dbdc8c6f0b14b2_at_mail.gmail.com>

I had to have a bug fix added to the latest oem grid patch for an oem query that ran for hours and we had to kill it several times/day. It took 6 months to get the patch done (not exaggerating).

open a ticket for support, but be prepared to wait.

On Tue, Apr 13, 2010 at 4:01 PM, dba1 mcc <mccdba1_at_yahoo.com> 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?
>
>
>
> ======================================================
>
> /* OracleOEM */
> select 'table_space_quotas', USERNAME, TABLESPACE_NAME
> from dba_ts_quotas
> where (max_bytes = -1 OR max_blocks = -1)
> AND
> username not in ('SYS', 'SYSTEM', 'SYSMAN', 'CTXSYS', 'MDSYS',
> 'ORDSYS', 'ORDPLUGINS','OLAPSYS', 'DBSNMP', 'MGMT_VIEW', 'OUTLN',
> 'ANONYMOUS', 'DMSYS',
> 'EXFSYS','LBACSYS', 'SI_INFORMTN_SCHEMA', 'SYSMAN', 'WKPROXY', 'WKSYS',
> 'WK_TEST','WMSYS', 'XDB', 'TRACESVR', 'SCOTT', 'ADAMS', 'BLAKE', 'CLARK',
> 'JONES', 'HR')
> AND rownum <= decode(:1,'-1',2147483647,:1)
> ORDER BY USERNAME
>
>
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Mon Apr 19 2010 - 09:33:04 CDT