Re: Length of a Transaction

From: Sanjay Kumar <ora_user_at_hotmail.com>
Date: Thu, 16 Nov 2000 16:46:24 -0800
Message-Id: <10682.122335@fatcity.com>

Hi,

Sorry about the confusion and ambiguity in my question.

What I meant by length of a transaction is the duration a transaction takes to complete.

What I meant by open connections was the number of connections that are active and inactive.

Sanjay
----- Original Message -----
From: "Ron Rogers" <RROGERS_at_galottery.org> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, November 16, 2000 12:27 PM Subject: Re: Length of a Transaction

What do you mean by "length of a transaction"? Is it the time from connection to disconnect?, The cpu time? one particular transaction or all transactions individually?
By open connections do you mean the oracle licensed connections that are active at the time you querry? or the connections that are connected but inactive as well as active?.

To find the connections to the database ,I use==== ===== start======
COLUMN SU FORMAT A8 HEADING 'ORACLE|USER ID' JUSTIFY LEFT COLUMN OSU FORMAT A8 HEADING 'SYSTEM|USER ID' JUSTIFY LEFT COLUMN STAT FORMAT A8 HEADING 'SESSION|STATUS' JUSTIFY LEFT

COLUMN SSID FORMAT 999999 HEADING 'ORACLE|SESSION|ID' JUSTIFY RIGHT
COLUMN SSER FORMAT 999999 HEADING 'ORACLE|SERIAL|NO' JUSTIFY RIGHT
COLUMN SPID FORMAT 999999 HEADING 'ORACLE|SESSION|ID' JUSTIFY RIGHT

COLUMN TXT FORMAT A28 HEADING 'CURRENT STATEMENT' JUSTIFY CENTER WORD SELECT

S.USERNAME SU,
S.OSUSER OSU,
S.STATUS STAT,
S.SID SSID,
S.SERIAL# SSER,

LPAD(P.SPID,7) SPID,
SUBSTR(SA.SQL_TEXT,1,540) TXT
FROM V$PROCESS P,
V$SESSION S,
V$SQLAREA SA
WHERE P.ADDR=S.PADDR

AND S.USERNAME IS NOT NULL
AND S.SQL_ADDRESS=SA.ADDRESS (+)
AND S.SQL_HASH_VALUE=SA.HASH_VALUE (+)

ORDER BY 1,3,6 =====end=====
ROR mª¿ªm

>>> ora_user_at_hotmail.com 11/16/00 02:18PM >>>
Hi,

Can anyone help me with the following:

How to find the length of a transaction.
How to find the number of open connections in Oracle

Sanjay

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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 Thu Nov 16 2000 - 18:46:24 CST