Frequently Accessed tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Frequently Accessed tables

Hybrid View

  1. #1
    Join Date
    Sep 2000
    Posts
    155

    Is there any metadata table(s)/views(s) that would tell you the number of time a table or object has been accessed?

    Any suggestions or ideas if there is no metadata table...

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I think this is what the MONITORING feature is used for. See http://technet.oracle.com/docs/produ...2a.htm#2056158 for details.

    Anybody ever used monitoring?

    Also, there is a script called catio.sql in your $OH/rdbms/admin directory that can help you with this also.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3

    catio

    Hi there.
    funnily enough, I jusy used catio.sql ...

    Be wary of the results that script gives you. The way it gets the stats is a little ropey to say the least. What oracl esay is that you can rely on the ranking of the tables (IE which get hit the most) but you cant rely on the numbers being accurate. Also the scripts are BUGGED big time. I have fixed and used the v7 script and cn send you a copy if you like. I havent gotten around to fixing the v8 version yet...


    -Bob

  4. #4
    Join Date
    Sep 2000
    Posts
    155

    Could you please email me the scripts (v7 scripts
    that you have fixed) to "nannep@yahoo.com"

    I am assuming that they would work on Oracle 8i.

    Thanks in advance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width