Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Slow query against ALL_OBJECTS view

Re: Slow query against ALL_OBJECTS view

From: Glenn Folue <nospam_at_nospam.com>
Date: Tue, 18 Feb 2003 19:29:37 GMT
Message-ID: <BQv4a.165875$be.148087@rwcrnsc53>


Similar problems hitting DBA_EXTENTS. Oracle seems to be having trouble with these views. Check Metalink to see if a bug has been entered.

--
Best of Breed Oracle Tools

* ER Diagramming Tool - DBArtisan
by http://www.embarcadero.com

* PL/SQL Editor - SQL Navigator
by http://www.quest.com

* Database Monitoring - DBFlash for Oracle
by http://www.confio.com

* SQL Tuning/Optimization - DB Expert
by http://www.leccotech.com

"Stephan Bressler" <stephan.bressler_at_siemens.com> wrote in message
news:b2tc7v$mgg$1_at_news.mch.sbs.de...

> Same on my dba (9.0.1.3 solaris).
>
> Seems that the execution plan is different depending on the user.
>
> No idea how to solve that problem.
>
> Stephan
> >
> >
> >
>
>
Received on Tue Feb 18 2003 - 13:29:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US