DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Transaction Per Table.

  1. #1
    Join Date
    Dec 1999
    Location
    Alpharetta, GA, US
    Posts
    192
    Hi,
    I would like to know is there any way i can count the
    total number of transaction for a given table.

    Thanks
    Chan

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    In 8.1.6 u can enable table monitoring option and then query dba_tab_modifications to find out the the type of transactions and calculate the total number.

    Also you can query x$bh to get the idea of highest used objects.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    I don't think you'll be able to get the number of transactions per table. In fact, even if you could I don't think this number would actually say a lot. A single transaction can modify milions of rows in a table or it can modify only a single row. A single transaction can modify dozens of tables or it can modify only one table. And so on and so on....

    What you can find out (at least approximately) is I/O activity on specific tables, which qould be much more meaningfull information. To do this, you can use script catio.sql which you can find in your $ORACLE_HOME/rdbms/admin directory. This scripts does what gpsingh sugested - it gets the I/O activty by sampling buffer cache (x$bh).

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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