RE: transactions

Hi David,

Distributed queries have to be turned into transactions implicitly so that the branches of the query can be related to one-another through the global transaction mapping table. The commit is needed to free up the transaction slot.

@ 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: David Barbour [mailto:DBarbour_at_connectsouth.com] Sent: Wednesday, 20 September 2000 6:56
To: Multiple recipients of list ORACLE-L Subject: RE: transactions

Steve,

What is the purpose of a commit in regards to a query? [He queried/commit;]

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
Sent: Tuesday, September 19, 2000 2:26 PM To: Multiple recipients of list ORACLE-L

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-----
Sent: Wednesday, 20 September 2000 1:51
To: Multiple recipients of list ORACLE-L

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
also send the HELP command for other information (like subscribing).
--
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

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: David Barbour
  INET: DBarbour_at_connectsouth.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