RE: transactions

Select name, value from v$sysstat where name='user commits'; That will give you the number of user issued COMMIT statements (which is probably the number your boss wants). The other alternative is so called "scientific method" in which you invent the data, create a lovely and colorfull diagram and tell your boss that the diagram looks so well because your database is mauve and such databases use the least memory.

-----Original Message-----
From: Joan Hsieh [mailto:jhsieh_at_infonet.tufts.edu] Sent: Monday, September 18, 2000 2:56 PM To: Multiple recipients of list ORACLE-L Subject: transactions

Hi Listers,

I am wondering how to find the high water mark of number transactions as daily basis. I tried v$resource_limit, but max_utilization of transactions always reached the max value which is 247. My boss like to generate monthly graph representation of # transactions, users and average respond time kind of report. I can produced all kind of performance related report except this one. License high water mark cannot reflect our # of users too. Since we use application server. All the uers just has 3 tier connections.

Thanks in advance,

Joan

-- 
Author: Joan Hsieh
  INET: jhsieh_at_infonet.tufts.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).