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: Index vs. table scans in statspack reports

Re: Index vs. table scans in statspack reports

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Sun, 30 Nov 2003 18:49:10 +0200
Message-ID: <3fca1f89$1_1@news.estpak.ee> 





I hit "send" too early in last post...



Personally, I would add an where rownum = 1 condition to the view on x$dual
(in addition to this inst_id check), in case there will be more than rows
per instance in future releases (who knows). Or even better, just use where
rownum = 1 and forget about the userenv('INSTANCE') part, this requires some
CPU power as well on every execution...



Tanel.
Received on Sun Nov 30 2003 - 10:49:10 CST












Original text of this message













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