It would be useful is to see DBMS cache activity by individual table, index
etc.  EG how many times a specific index has been been utilized or how many
locks on a specific table.

Paul

-----Original Message-----
From: Ball, David [mailto:David.Ball@npower.com]
Sent: Tuesday, 28 June 2005 1:06 AM
To: 'martin.bowes@ctsu.ox.ac.uk'; MacKayro
Cc: info-ingres@cariboulake.com
Subject: RE: [Info-ingres] Table usage

Kay/Martin,

The 'audstat' shell script from DBHygiene (a downloadable tool @ NAIUA) does
some nice reporting on the output from auditdb (including usage and hit
rates etc).

Dave

-----Original Message-----
From: martin.bowes@ctsu.ox.ac.uk [mailto:martin.bowes@ctsu.ox.ac.uk]
Sent: 27 June 2005 15:00
To: MacKayro
Cc: info-ingres@cariboulake.com
Subject: Re: [Info-ingres] Table usage

Hi Kay,

    Assuming you define highest activity as inserts,updates and
deletes then auditdb is probably the best option.

Auiditdb will be quite happy to span checkpoint boundaries. It only
requires that the journals exist. - well there are a few complications, but
this is the major point.

So auditdb -b -e and place the data into a file.
Then try this:
grep Table <your_file> | \
perl -ne '/^\s*(\S+)\s*: Transaction Id (\S+).*Table \[(\S+)\]/ && print "$1

$3\n"' | \
sort | uniq -c | sort -nr | head -100

That'll produce a listing of highest number of inserts, updates, deletes
activity on the tables.

Martin Bowes
--
Random Duckman Quote #68:
Cornfed: It'll make Bosnia look like a foot rub from Perry Como.

On 27 Jun 2005 at 7:27, MacKayro wrote:

_______________________________________________
Info-ingres mailing list
Info-ingres@cariboulake.com
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres

**********************************************************************

The information contained in this e-mail is confidential and intended only
for the use of the addressee. If the reader of this message is not the
addressee, you are hereby notified that you have received this e-mail in
error and you must not copy, disseminate, distribute, use or take any action
as a result of the information contained in it.
   
If you have any queries, please contact the IT Service Desk on 1870
(01384-275454).
   
postmaster@npower.com

**********************************************************************

This e-mail is provided for general information purposes only and does not
constitute investment or transactional advice. For  the avoidance of doubt
the contents of this email are subject to contract and will not constitute a
legally binding contract.

The information contained in this e-mail is confidential and intended only
for the use of the addressee. If the reader of this message is not the
addressee, you are hereby notified that you have received this e-mail in
error and you must not copy, disseminate, distribute, use or take any action
as a result of the information contained in it.
   
If you have received this e-mail in error, please notify
postmaster@npower.com (UK 01384 275454) and delete it immediately from your
system.
   
Neither Npower nor any of the other companies in the RWE Npower group from
whom this e-mail originates accept any responsibility for losses or damage
as a result of any viruses and it is your responsibility to check
attachments (if any) for viruses.
Npower Limited Registered office: Windmill Hill Business Park, Whitehill
Way, Swindon SN5 6PB. Registered in England and Wales: number 3653277.  This
e-mail may be sent on behalf of a member of the RWE Npower group of
companies.

**********************************************************************

_______________________________________________
Info-ingres mailing list
Info-ingres@cariboulake.com
http://mailman.cariboulake.com/mailman/listinfo.py/info-ingres