Re: Length of a Transaction

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 16 Nov 2000 15:26:36 -0500
Message-Id: <10682.122299@fatcity.com>

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=3D=3D=3D=3D =3D=3D=3D=3D=3D start=3D=3D=3D=3D=3D=3D
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=20

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=3DS.PADDR

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

ORDER BY 1,3,6 =3D=3D=3D=3D=3Dend=3D=3D=3D=3D=3D
ROR m=AA=BF=AAm

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

Can anyone help me with the following:

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

Received on Thu Nov 16 2000 - 14:26:36 CST