RE: transactions

Hi Joan,

Are you failing to COMMIT after queries over a database link?

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/
@   
@   Going to OpenWorld?
@   Catch the Ixora performance tuning seminar too!
@   See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: Joan Hsieh [mailto:jhsieh_at_infonet.tufts.edu] Sent: Wednesday, 20 September 2000 1:51
To: Multiple recipients of list ORACLE-L 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

------------------------------ ------------------- ---------------
---------- ----------
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
> also send the HELP command for other information (like subscribing).

-- 
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