Number of transactions in the DB

[former_member199632]

Hello,

How can i find out the number of transactions occurred in a Database. (... for a given day / within 1 hr)

like;

Numbers of inserts/deletes/selects/updates occurred in the db?

Is it possible to get such information.

regards,

Zerandib

[Former Member · Accepted solution]

check st04 --> statistical info --> performance db

and under same tree System Summary metrics.

[lbreddemann]

Hmm... since you already got your reply, maybe you can answer a question yourself:

What do you do with these information?

What does it tell you if you know that your database does 100000 or 120000 transactions a day?

Really, I'm curious: what is the benefit of this kind of information (besides that it's extremely easy to gather at DB engine level)?

regards,

Lars

[former_member199632]

Hello Lars,

Main idea is to get an idea about the DB

currently in the PRD DB auditing is disabled.

Im thinking of enabling the DB auditing.

Therefore i'm looking to get rough idea about, number of transactions that will occur in the DB

audit_sys_operations boolean FALSE

audit_trail string NONE

Will enabling auditing, make additional overhead to the database.!

> (besides that it's extremely easy to gather at DB engine

how can i check these stats in DB level. (table/view)

regards,

Zerandib

[lbreddemann]

> Main idea is to get an idea about the DB

>

> currently in the PRD DB auditing is disabled.

> Im thinking of enabling the DB auditing.

> Therefore i'm looking to get rough idea about, number of transactions that will occur in the DB

>

> audit_sys_operations boolean FALSE

> audit_trail string NONE

>

> Will enabling auditing, make additional overhead to the database.!

I see.

Just my two cents on this:

- you enable auditing, when there is a requirement for it (business/legal wise), so it isn't really about the technical overhead

- and of course there is overhead. It's just the question whether or not your users will see a increased response time because of that.

> how can i check these stats in DB level. (table/view)

Check V$SYSSTAT and V$SYSMETRIC on Oracle level.

These should contain the information you like to see.

(btw: in my first reply I referred to how easy it is to create these statistic information on DB kernel level )

regards,

Lars