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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: More selective means slower?

RE: More selective means slower?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 20 Jan 2005 12:07:55 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87C05@irvmbxw02> 





Some dba_ views use x$ objects, and for those views the explain plan
will only show you the plan if you are signed on as SYS.



-----Original Message-----


From: oracle-l-bounce_at_freelists.org


[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling
...



c) Why wouldn't explain plan not work on dictionary objects?



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


Received on Thu Jan 20 2005 - 15:19:38 CST












Original text of this message













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