Sign in or 
Share this
Monitor Session Information for Multidimensional Datatype Access (11.1.0)
set lines 110 pages 5000
col userid format a10
col client_type for a16
col atat hea 'AVG TXN|TIME'
col ttat hea 'TTL TXN|TIME'
col atct hea 'AVG TXN|CPU TIME'
col ttct hea 'TTL TXN|CPU TIME'
col sdsr for a12 hea 'SID,SERIAL#'
select userid
, a.inst_id
, session_id||','||serial# sdsr, client_type
, round(average_transaction_time,3) atat
, round(total_transaction_time,3) ttat
, round(average_transaction_time,3) atct
, round(total_transaction_cpu_time,3) ttct
from gv$aw_session_info a, gv$session b
where userid=username and session_id=sid and a.inst_id=b.inst_id
order by userid, a.inst_id;
...................................................... AVG TXN .. TTL TXN .. AVG TXN .. TTL TXN
USERID ... .. INST_ID SID,SERIAL#. CLIENT_TYPE .... ..... TIME ..... TIME . CPU TIME . CPU TIME
---------- ---------- ------------ ---------------- ---------- ---------- ---------- ----------
OLAPTRAIN. .........1 139,6 ...... CLIENT_TYPE_OLAP ... 18.612 ... 37.225 ... 18.612 ... 16.266
col userid format a10
col client_type for a16
col atat hea 'AVG TXN|TIME'
col ttat hea 'TTL TXN|TIME'
col atct hea 'AVG TXN|CPU TIME'
col ttct hea 'TTL TXN|CPU TIME'
col sdsr for a12 hea 'SID,SERIAL#'
select userid
, a.inst_id
, session_id||','||serial# sdsr, client_type
, round(average_transaction_time,3) atat
, round(total_transaction_time,3) ttat
, round(average_transaction_time,3) atct
, round(total_transaction_cpu_time,3) ttct
from gv$aw_session_info a, gv$session b
where userid=username and session_id=sid and a.inst_id=b.inst_id
order by userid, a.inst_id;
...................................................... AVG TXN .. TTL TXN .. AVG TXN .. TTL TXN
USERID ... .. INST_ID SID,SERIAL#. CLIENT_TYPE .... ..... TIME ..... TIME . CPU TIME . CPU TIME
---------- ---------- ------------ ---------------- ---------- ---------- ---------- ----------
OLAPTRAIN. .........1 139,6 ...... CLIENT_TYPE_OLAP ... 18.612 ... 37.225 ... 18.612 ... 16.266
olapdba |
Latest page update: made by olapdba
, Jul 9 2009, 1:27 PM EDT
(about this update
About This Update
Edited by olapdba
1 word added 1 word deleted view changes - complete history) |
|
Keyword tags:
None
More Info: links to this page
|
There are no threads for this page.
Be the first to start a new thread.
