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

------------------------------ ------------------- ---------------
---------- ----------
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_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).
> --
> Author: Gogala, Mladen
> INET: MGogala_at_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_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
Received on Tue Sep 19 2000 - 09:49:39 CDT