the most accessed tables
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: the most accessed tables

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    15
    Im intending create a tablespace to the most accessed tables and i dont known how. Does anyone can help me???

  2. #2
    Join Date
    Jul 2000
    Posts
    53
    HI,
    If you can assign various datafiles to various physical devices wouldn't it be better to split up the most accessed tables ad spread the load over as many devices as you can?

    Just a though.

    SQLLAB is a good product for object accesses by the way.

    Regards,
    Steve

  3. #3
    Join Date
    Feb 2001
    Posts
    15
    thanks for the suggestion. But How do i get the most acessed tables???

  4. #4
    Join Date
    Feb 2001
    Posts
    15
    SELECT OBJECT, COUNT(SID) FROM V$ACCESS
    WHERE TYPE = 'TABLE'
    GROUP BY OBJECT
    ORDER BY COUNT(SID);

    Doing this query do i have the most accessed tables?????

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