RE: More selective means slower?

  • From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
  • To: <breitliw@xxxxxxxxxxxxx>, <>
  • Date: Thu, 20 Jan 2005 12:07:55 -0800

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wolfgang Breitling

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


Other related posts: