Oracle 9i - number of transactions per table/user
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle 9i - number of transactions per table/user

  1. #1
    Join Date
    Nov 2008
    Posts
    1

    Oracle 9i - number of transactions per table/user

    Hello,

    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!
    Adam

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,471

    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
    Posts
    9
    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