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 -> Speed of DBA_TRIGGER_COLS view

Speed of DBA_TRIGGER_COLS view

From: Jim Katsos <jkatsos_at_oz.quests.com>
Date: Tue, 11 Jan 2000 06:05:11 GMT
Message-ID: <rKze4.19227$lv5.75732@news-server.bigpond.net.au>


I am running a query like this:

  select column_name from dba_trigger_cols

     where trigger_owner = 'FRED'
          and trigger_name = 'FREDSTRIGGER';

This takes quite a long time. I tried removing the hint from the view to no avail. Does anyone know how I can speed up this query.

--
Jim Katsos
Quest Software Pty Ltd
http://www.quests.com
tel +61 3 9811 8068
mob 0411088578 Received on Tue Jan 11 2000 - 00:05:11 CST

Original text of this message

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