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: Utilisation ratio for an index

Re: Utilisation ratio for an index

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 07 Apr 2006 17:33:34 +0200
Message-ID: <8h1d32d84544q3tmv24s1sr5h8dp4luu75@4ax.com>


On 7 Apr 2006 08:08:59 -0700, stevedhoward_at_gmail.com wrote:

>That's really interesting. Since if I select against someone elses
>table, it will use their index, I wonder what the idea was behind
>restricting it to the owner

Must be a bug in the v$object_usage view.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Apr 07 2006 - 10:33:34 CDT

Original text of this message

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