And these would be CPM (commits per minute) and RPM (rollbacks per minute).
If you really want a transaction, you have to code it yourself, otherwise all you can
get is CPM and RPM.
If your transactions_per_minute ( or commits_per_minute) is low use this handy script
to bump it up.
create
I've been asked to provide value for the Transactions Per Minute
going through our primary OLTP production database.
I believe I can use deltas in SCN values to measure transactions
which do INSERT/UPDATE/DELETE and then COMMIT;
Is there any way to measure/count the number of SELECTs which
Charlie,
I understand a transaction as a succession of SQL statements between two successive
COMMITs or ROLLBACKs - you will find inside V$SYSSTAT how many COMMITs and ROLLBACKs
were issued.
If you are interested, besides transactions proper, in the number of statements
executed, then have
Well, as you are well aware of, you cannot measure without
impacting. I know of the following methods:
1) Turn on auditing, count all transactions from dba_audit_trail
table within a day and divide by the number of minutes in 9 hours.
That will give you an average TPM number during the working
To: Multiple recipients of list ORACLE-L
Subject: measuring TPM
I've been asked to provide value for the Transactions Per
Minute going through our primary OLTP production database.
I believe I can use deltas in SCN values to measure
transactions which do INSERT/UPDATE/DELETE
Charlie,
I use the following to determine this:
EXEC SQL SELECT ROUND(VALUE/((SYSDATE-STARTUP_TIME)*1440),1)
INTO :tp
FROM V$SYSSTAT, V$INSTANCE
WHERE NAME='user commits';
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original
Logminer has been of use in looking at past activity as far as INSERT/UPDATE/DELETE
and then COMMIT;. Looking at a day of lofs we have been able to measure activity to
all of our tables, indexes and queues and as been very helpful in giving us infor we
need for future capacity planning.
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:measuring TPM
I've been asked to provide value for the Transactions Per Minute
going through our primary OLTP production database.
I believe I can use deltas in SCN values to measure transactions
Charlie,
What is the perceived relevance of gaining this information? You would be
much better off correlating statistics such as overall non idle wait time
and database workload (# Users, Ion's/CPU etc...) to actual business
functions the database is performing (invoices, sales orders, etc...).
On 01/28/2004 12:34:26 PM, Post, Ethan wrote:
Charlie,
What is the perceived relevance of gaining this information?
The information is necessary so that manager and director can make a
lovely excell spreadsheet for the VP, who will, in turn, insert it into
a slide show for the CIO.
--
Mladen
If that is what this is for, the formula is very simple. TPM = x*42 where
x is a number sufficient to justify the really cool hardware system you
want.
Mladen Gogala wrote:
On 01/28/2004 12:34:26 PM, Post, Ethan wrote:
Charlie,
What is the perceived relevance of gaining this information?
Hey Charlie,
I made a DBMS_JOB here that runs this procedure every 5 minutes:
CREATE OR REPLACE PROCEDURE QT_TX_MONITOR AS
-- 06/17/2001 REJesse Created.
v_value NUMBER;
BEGIN
SELECT SUM(VALUE) INTO v_value
FROM V$SYSSTAT
WHERE NAME IN ('user
Daniel Fink scribbled on the wall in glitter crayon:
If that is what this is for, the formula is very simple. TPM = x*42
where x is a number sufficient to justify the really cool hardware
system you want.
as a serious question, is TPM a valid measurement for a database? or are
there other
I would say that it depends on the system. If we are talking about a stock
trading system, then TPM is very important as is
transaction-time-to-completion. For a data warehouse, this may be absolutely
meaningless. Of course, does TPM describe the width of the database pipe or
it's depth? In the
14 matches
Mail list logo