DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008

    Oracle 9i - number of transactions per table/user


    I'm troubleshooting a 9i (on AIX) database that's performing badly.

    In the process I've spotted a few tables that I do not recognise that are rather large and fragmented and I'm curious to know how frequently these are being used.

    Is there a way I can pull figures for how often certain objects are accessed? And the associated load these put on the DB?

    Thanks in advance, finding the site very useful!

  2. #2
    Join Date
    Jul 2002
    Lake Worth, FL

    Talking Statspack

    1) Check that your statistics are up to date.

    2) Install the STATSPACK package (?/rdbms/admin/spcreate).

    3) Also, the number of transactions per table could be monitored by setting "MONITORING" on such tables.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Nov 2008
    if you like you could use logminer.
    it will help you find the operations about the tables you want check.

    becase the operation use archivelog,
    1、if few impact the database
    2、long time data have more persuasion

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.