Message-Id: <10624.117352@fatcity.com> From: Joan Hsieh Date: Tue, 19 Sep 2000 10:49:39 -0400 Subject: Re: transactions Thanks, Mladen. I think that number is very useful. I can create a temp table download to excel and make a nice graph from there. Do you know how to get average respond time? Another question which puzzled me is v$resouce_limit, I can't figure out why current_utilization of transactions is not match v$transaction? What kind of relationship of these two numbers? Thanks again, Joan select * from v$resource_limit; RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL LIMIT_VALU ------------------------------ ------------------- --------------- ---------- ---------- processes 26 32 200 200 sessions 27 34 225 225 lm_procs 0 0 0 0 lm_ress 0 0 0 UNLIMITED lm_locks 0 0 0 UNLIMITED enqueue_locks 49 53 2931 2931 enqueue_resources 52 93 520 520 dml_locks 0 37 500 500 temporary_table_locks 0 0 UNLIMITED UNLIMITED transactions 213 214 247 247 sort_segment_locks 0 3 UNLIMITED UNLIMITED max_rollback_segments 11 11 31 31 distributed_transactions 3 8 61 61 mts_max_servers 0 0 20 20 parallel_max_servers 0 0 6 6 select count(*) from v$transaction; COUNT(*) ---------- 1 "Gogala, Mladen" wrote: > > 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----- > Sent: Monday, September 18, 2000 2:56 PM > To: Multiple recipients of list ORACLE-L > > 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@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@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). > -- > Author: Gogala, Mladen > INET: MGogala@oxhp.com > > 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@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