This discussion is archived
7 Replies Latest reply: Nov 16, 2012 1:12 AM by Osama_Mustafa RSS

v$object_usage

Pavel Explorer
Currently Being Moderated
Hello!

could You please explain how many rows created (replaced ?) und stored in v$object_usage on each fact of index scan?
I'm usung 11.2 version of database server

Thanks and regards,
Pavel
  • 1. Re: v$object_usage
    sb92075 Guru
    Currently Being Moderated
    Pavel wrote:
    Hello!

    could You please explain how many rows created (replaced ?) und stored in v$object_usage on each fact of index scan?
    I'm usung 11.2 version of database server

    Thanks and regards,
    Pavel
    SQL> select count(*) from  v$object_usage;
    
      COUNT(*)
    ----------
             0
    
    SQL> show user
    USER is "SYS"
    SQL> 
  • 2. Re: v$object_usage
    Chanchal Wankhade Journeyer
    Currently Being Moderated
    Better you have a look below link.......

    [http://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_2077.htm]
  • 3. Re: v$object_usage
    Pavel Explorer
    Currently Being Moderated
    Hello Sb92075

    Does Youre post mean that
    no object was monitoring or corresponding records qas cleaned ?

    Thanks and regards,
    Pavel
  • 4. Re: v$object_usage
    sb92075 Guru
    Currently Being Moderated
    Pavel wrote:
    Hello Sb92075

    Does Youre post mean that
    no object was monitoring or corresponding records qas cleaned ?

    Thanks and regards,
    Pavel
    I saw your post, queried my DB & posted the results.

    What is the default/expected content of v$object_usage?
  • 5. Re: v$object_usage
    Girish Sharma Guru
    Currently Being Moderated
    [url http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_2079.htm#REFRN30162]V$OBJECT_USAGE  is saying "statistics about index usage..." How it collects the index usage? It just collects the statistics of those index use who have enabled index monitoring i.e. ALTER INDEX index MONITORING USAGE; Now, on each use of index Oracle will populate this view. It just shows the name of those indexes whose index monitoring is enabled. On each index monitoring Oracle adds a new line in this view. It does not tells that how many time a specific index has been used i.e. it is not a counter of use of index.

    Regards
    Girish Sharma
  • 6. Re: v$object_usage
    Pavel Explorer
    Currently Being Moderated
    Hello Girish

    Thank You very much

    Best regards,
    Pavel
  • 7. Re: v$object_usage
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Mark this thread as answered please since you thread has been answered .

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points