Session Stats Grouped By Session
Notes SQL Source Snapshot Date: 10/28/02 00:32:57 Database: VENUS
Username Usage Parameter
SYS(22) 527CPU used by this session
ORACLE PROC(1) 1CPU used by this session
ORACLE PROC(10) 1CPU used by this session
ORACLE PROC(12) 1CPU used by this session
SYS(22) 527CPU used when call started
ORACLE PROC(8) 5804CR blocks created
SYS(22) 2CR blocks created
ORACLE PROC(5) 1CR blocks created
ORACLE PROC(2) 12732DBWR buffers scanned
ORACLE PROC(2) 14069DBWR checkpoint buffers written
ORACLE PROC(3) 2DBWR checkpoints
ORACLE PROC(2) 12576DBWR free buffers found
ORACLE PROC(2) 32DBWR lru scans
ORACLE PROC(2) 32DBWR make free requests
ORACLE PROC(2) 12732DBWR summed scan depth
ORACLE PROC(2) 981DBWR transaction table writes
ORACLE PROC(2) 12216DBWR undo block writes
SYS(22) 407SQL*Net roundtrips to/from client
ORACLE PROC(8) 1active txn count during cleanout
ORACLE PROC(4) 2background checkpoints completed
ORACLE PROC(3) 2background checkpoints started
ORACLE PROC(3) 60043background timeouts
ORACLE PROC(2) 59924background timeouts
ORACLE PROC(4) 59790background timeouts
ORACLE PROC(7) 35974background timeouts
ORACLE PROC(10) 11995background timeouts
ORACLE PROC(12) 2971background timeouts
ORACLE PROC(13) 600background timeouts
ORACLE PROC(6) 101background timeouts
ORACLE PROC(8) 1673949buffer is not pinned count
ORACLE PROC(5) 161548buffer is not pinned count
SYS(22) 56863buffer is not pinned count
ORACLE PROC(7) 12963buffer is not pinned count
ORACLE PROC(6) 11buffer is not pinned count
ORACLE PROC(8) 232269buffer is pinned count
SYS(22) 28862buffer is pinned count
ORACLE PROC(5) 1205buffer is pinned count
ORACLE PROC(7) 216buffer is pinned count
SYS(22) 73054bytes received via SQL*Net from client
SYS(22) 258768bytes sent via SQL*Net to client
ORACLE PROC(8) 1126939calls to get snapshot scn: kcmgss
ORACLE PROC(7) 69304calls to get snapshot scn: kcmgss
SYS(22) 6632calls to get snapshot scn: kcmgss
ORACLE PROC(5) 6418calls to get snapshot scn: kcmgss
ORACLE PROC(6) 408calls to get snapshot scn: kcmgss
ORACLE PROC(8) 394676calls to kcmgas
SYS(22) 2966calls to kcmgas
ORACLE PROC(5) 660calls to kcmgas
ORACLE PROC(3) 3calls to kcmgas
ORACLE PROC(5) 599calls to kcmgcs
ORACLE PROC(3) 5calls to kcmgcs
SYS(22) 4calls to kcmgcs
ORACLE PROC(4) 2calls to kcmgcs
ORACLE PROC(12) 1calls to kcmgcs
ORACLE PROC(13) 1calls to kcmgcs
ORACLE PROC(8) 3493change write time
ORACLE PROC(5) 23change write time
SYS(22) 2change write time
ORACLE PROC(8) 1cleanout - number of ktugct calls
SYS(22) 24136cluster key scan block gets
ORACLE PROC(5) 12664cluster key scan block gets
ORACLE PROC(8) 616cluster key scan block gets
ORACLE PROC(6) 5cluster key scan block gets
ORACLE PROC(7) 5cluster key scan block gets
SYS(22) 15079cluster key scans
ORACLE PROC(5) 2341cluster key scans
ORACLE PROC(8) 456cluster key scans
ORACLE PROC(6) 5cluster key scans
ORACLE PROC(7) 5cluster key scans
ORACLE PROC(8) 383065commit cleanouts
ORACLE PROC(5) 634commit cleanouts
SYS(22) 97commit cleanouts
ORACLE PROC(8) 383065commit cleanouts successfully completed
ORACLE PROC(5) 634commit cleanouts successfully completed
SYS(22) 97commit cleanouts successfully completed
ORACLE PROC(8) 272788consistent changes
SYS(22) 25consistent changes
ORACLE PROC(8) 2151363consistent gets
ORACLE PROC(5) 167416consistent gets
ORACLE PROC(7) 111767consistent gets
SYS(22) 61957consistent gets
ORACLE PROC(6) 327consistent gets
ORACLE PROC(8) 767840consistent gets - examination
SYS(22) 22912consistent gets - examination
ORACLE PROC(5) 2731consistent gets - examination
ORACLE PROC(7) 20consistent gets - examination
ORACLE PROC(6) 16consistent gets - examination
ORACLE PROC(8) 26cursor authentications
ORACLE PROC(5) 24cursor authentications
ORACLE PROC(6) 1cursor authentications
ORACLE PROC(8) 272788data blocks consistent reads - undo records applied
SYS(22) 2data blocks consistent reads - undo records applied
ORACLE PROC(8) 1538193db block changes
ORACLE PROC(5) 2953db block changes
SYS(22) 453db block changes
ORACLE PROC(8) 1073661db block gets
ORACLE PROC(5) 9080db block gets
SYS(22) 485db block gets
ORACLE PROC(8) 237974deferred (CURRENT) block cleanout applications
ORACLE PROC(5) 616deferred (CURRENT) block cleanout applications
SYS(22) 65deferred (CURRENT) block cleanout applications
SYS(22) 2dirty buffers inspected
ORACLE PROC(5) 54enqueue conversions
ORACLE PROC(8) 812681enqueue releases
ORACLE PROC(4) 71798enqueue releases
ORACLE PROC(7) 35995enqueue releases
ORACLE PROC(5) 9386enqueue releases
ORACLE PROC(12) 5950enqueue releases
SYS(22) 3079enqueue releases
ORACLE PROC(6) 102enqueue releases
ORACLE PROC(3) 22enqueue releases
ORACLE PROC(13) 14enqueue releases
ORACLE PROC(2) 7enqueue releases
ORACLE PROC(10) 3enqueue releases
ORACLE PROC(1) 1enqueue releases
ORACLE PROC(9) 1enqueue releases
ORACLE PROC(18) 1enqueue releases
ORACLE PROC(17) 1enqueue releases
ORACLE PROC(11) 1enqueue releases
ORACLE PROC(8) 812681enqueue requests
ORACLE PROC(4) 71799enqueue requests
ORACLE PROC(7) 35995enqueue requests
ORACLE PROC(5) 9387enqueue requests
ORACLE PROC(12) 5950enqueue requests
SYS(22) 3079enqueue requests
ORACLE PROC(6) 102enqueue requests
ORACLE PROC(3) 23enqueue requests
ORACLE PROC(2) 19enqueue requests
ORACLE PROC(13) 14enqueue requests
ORACLE PROC(10) 3enqueue requests
ORACLE PROC(1) 1enqueue requests
ORACLE PROC(9) 1enqueue requests
ORACLE PROC(11) 1enqueue requests
ORACLE PROC(17) 1enqueue requests
ORACLE PROC(18) 1enqueue requests
ORACLE PROC(8) 186544execute count
ORACLE PROC(7) 69303execute count
SYS(22) 3284execute count
ORACLE PROC(5) 2154execute count
ORACLE PROC(6) 107execute count
ORACLE PROC(8) 7free buffer inspected
SYS(22) 2free buffer inspected
ORACLE PROC(8) 593892free buffer requested
ORACLE PROC(5) 104200free buffer requested
SYS(22) 5672free buffer requested
ORACLE PROC(7) 4free buffer requested
ORACLE PROC(6) 2free buffer requested
ORACLE PROC(8) 8021hot buffers moved to head of LRU
ORACLE PROC(2) 1677hot buffers moved to head of LRU
ORACLE PROC(5) 1531hot buffers moved to head of LRU
SYS(22) 435hot buffers moved to head of LRU
SYS(22) 24immediate (CURRENT) block cleanout applications
ORACLE PROC(5) 1immediate (CURRENT) block cleanout applications
ORACLE PROC(8) 383664index fetch by key
SYS(22) 31836index fetch by key
ORACLE PROC(5) 2541index fetch by key
ORACLE PROC(7) 7index fetch by key
ORACLE PROC(6) 6index fetch by key
ORACLE PROC(8) 116417index scans kdiixs1
ORACLE PROC(7) 105261index scans kdiixs1
ORACLE PROC(5) 1245index scans kdiixs1
SYS(22) 37index scans kdiixs1
ORACLE PROC(6) 2index scans kdiixs1
ORACLE PROC(1) 1logons cumulative
ORACLE PROC(2) 1logons cumulative
SYS(22) 1logons cumulative
ORACLE PROC(18) 1logons cumulative
ORACLE PROC(17) 1logons cumulative
ORACLE PROC(13) 1logons cumulative
ORACLE PROC(12) 1logons cumulative
ORACLE PROC(11) 1logons cumulative
ORACLE PROC(10) 1logons cumulative
ORACLE PROC(9) 1logons cumulative
ORACLE PROC(8) 1logons cumulative
ORACLE PROC(7) 1logons cumulative
ORACLE PROC(6) 1logons cumulative
ORACLE PROC(5) 1logons cumulative
ORACLE PROC(4) 1logons cumulative
ORACLE PROC(3) 1logons cumulative
ORACLE PROC(1) 1logons current
SYS(22) 1logons current
ORACLE PROC(18) 1logons current
ORACLE PROC(17) 1logons current
ORACLE PROC(13) 1logons current
ORACLE PROC(12) 1logons current
ORACLE PROC(11) 1logons current
ORACLE PROC(10) 1logons current
ORACLE PROC(9) 1logons current
ORACLE PROC(8) 1logons current
ORACLE PROC(7) 1logons current
ORACLE PROC(6) 1logons current
ORACLE PROC(5) 1logons current
ORACLE PROC(2) 1logons current
ORACLE PROC(3) 1logons current
ORACLE PROC(4) 1logons current
ORACLE PROC(3) 56381messages received
ORACLE PROC(2) 6304messages received
ORACLE PROC(4) 40messages received
ORACLE PROC(12) 6messages received
ORACLE PROC(13) 6messages received
ORACLE PROC(7) 1messages received
ORACLE PROC(8) 50124messages sent
ORACLE PROC(2) 6266messages sent
ORACLE PROC(5) 677messages sent
SYS(22) 16messages sent
ORACLE PROC(3) 12messages sent
ORACLE PROC(4) 7messages sent
ORACLE PROC(10) 4messages sent
ORACLE PROC(12) 1messages sent
ORACLE PROC(13) 1messages sent
ORACLE PROC(8) 907125no work - consistent read gets
ORACLE PROC(5) 161485no work - consistent read gets
SYS(22) 35452no work - consistent read gets
ORACLE PROC(7) 6483no work - consistent read gets
ORACLE PROC(6) 8no work - consistent read gets
ORACLE PROC(8) 116561opened cursors cumulative
SYS(22) 3256opened cursors cumulative
ORACLE PROC(5) 2058opened cursors cumulative
ORACLE PROC(6) 107opened cursors cumulative
ORACLE PROC(7) 11opened cursors cumulative
ORACLE PROC(7) 9opened cursors current
SYS(22) 4opened cursors current
ORACLE PROC(8) 1opened cursors current
ORACLE PROC(8) 54parse count (hard)
ORACLE PROC(5) 33parse count (hard)
SYS(22) 17parse count (hard)
ORACLE PROC(7) 4parse count (hard)
ORACLE PROC(6) 1parse count (hard)
ORACLE PROC(8) 116610parse count (total)
SYS(22) 3253parse count (total)
ORACLE PROC(5) 2058parse count (total)
ORACLE PROC(6) 107parse count (total)
ORACLE PROC(7) 11parse count (total)
ORACLE PROC(8) 1132parse time cpu
SYS(22) 37parse time cpu
ORACLE PROC(5) 19parse time cpu
ORACLE PROC(8) 1277parse time elapsed
ORACLE PROC(5) 114parse time elapsed
SYS(22) 47parse time elapsed
ORACLE PROC(7) 12parse time elapsed
ORACLE PROC(6) 5parse time elapsed
ORACLE PROC(8) 451066physical reads
ORACLE PROC(5) 104185physical reads
SYS(22) 5661physical reads
ORACLE PROC(4) 22physical reads
ORACLE PROC(2) 12physical reads
ORACLE PROC(3) 12physical reads
ORACLE PROC(7) 4physical reads
ORACLE PROC(6) 2physical reads
ORACLE PROC(4) 22physical reads direct
ORACLE PROC(2) 12physical reads direct
ORACLE PROC(3) 12physical reads direct
ORACLE PROC(2) 14317physical writes
ORACLE PROC(4) 22physical writes
ORACLE PROC(3) 11physical writes
SYS(22) 2physical writes
ORACLE PROC(4) 22physical writes direct
ORACLE PROC(3) 11physical writes direct
SYS(22) 2physical writes direct
ORACLE PROC(2) 10374physical writes non checkpoint
ORACLE PROC(4) 22physical writes non checkpoint
ORACLE PROC(3) 11physical writes non checkpoint
SYS(22) 2physical writes non checkpoint
ORACLE PROC(8) 7pinned buffers inspected
ORACLE PROC(8) 418103prefetched blocks
ORACLE PROC(5) 95675prefetched blocks
SYS(22) 2432prefetched blocks
ORACLE PROC(7) 1prefetched blocks
SYS(22) 20prefetched blocks aged out before use
ORACLE PROC(8) 311859recursive calls
ORACLE PROC(7) 138829recursive calls
SYS(22) 67424recursive calls
ORACLE PROC(5) 10929recursive calls
ORACLE PROC(6) 1996recursive calls
ORACLE PROC(13) 3recursive calls
ORACLE PROC(12) 2recursive calls
SYS(22) 192recursive cpu usage
ORACLE PROC(3) 395356redo blocks written
ORACLE PROC(8) 4redo buffer allocation retries
ORACLE PROC(8) 772024redo entries
ORACLE PROC(2) 6263redo entries
ORACLE PROC(5) 1594redo entries
SYS(22) 260redo entries
ORACLE PROC(8) 5redo log space requests
ORACLE PROC(8) 228redo log space wait time
ORACLE PROC(8) 165102440redo size
ORACLE PROC(2) 479592redo size
ORACLE PROC(5) 433812redo size
SYS(22) 71720redo size
SYS(22) 6redo synch writes
ORACLE PROC(3) 14942376redo wastage
ORACLE PROC(3) 26310redo write time
ORACLE PROC(3) 51redo writer latching time
ORACLE PROC(3) 62464redo writes
ORACLE PROC(8) 29020rollbacks only - consistent read gets
SYS(22) 2rollbacks only - consistent read gets
ORACLE PROC(8) 383217rows fetched via callback
SYS(22) 10696rows fetched via callback
ORACLE PROC(5) 15rows fetched via callback
ORACLE PROC(7) 2rows fetched via callback
ORACLE PROC(6) 1rows fetched via callback
ORACLE PROC(8) 3225024session logical reads
ORACLE PROC(5) 176496session logical reads
ORACLE PROC(7) 111767session logical reads
SYS(22) 62442session logical reads
ORACLE PROC(6) 327session logical reads
ORACLE PROC(3) 5444524session pga memory
ORACLE PROC(12) 4438560session pga memory
ORACLE PROC(13) 4438560session pga memory
ORACLE PROC(8) 2970368session pga memory
ORACLE PROC(2) 2107144session pga memory
ORACLE PROC(4) 1177004session pga memory
SYS(22) 508084session pga memory
ORACLE PROC(9) 480316session pga memory
ORACLE PROC(11) 480316session pga memory
ORACLE PROC(18) 480316session pga memory
ORACLE PROC(17) 398348session pga memory
ORACLE PROC(5) 331904session pga memory
ORACLE PROC(10) 322176session pga memory
ORACLE PROC(6) 208272session pga memory
ORACLE PROC(7) 208272session pga memory
ORACLE PROC(1) 199760session pga memory
ORACLE PROC(3) 5444524session pga memory max
ORACLE PROC(12) 4438560session pga memory max
ORACLE PROC(13) 4438560session pga memory max
ORACLE PROC(8) 2970368session pga memory max
ORACLE PROC(2) 2107144session pga memory max
SYS(22) 1556660session pga memory max
ORACLE PROC(4) 1178268session pga memory max
ORACLE PROC(9) 480316session pga memory max
ORACLE PROC(11) 480316session pga memory max
ORACLE PROC(18) 480316session pga memory max
ORACLE PROC(17) 398348session pga memory max
ORACLE PROC(5) 331904session pga memory max
ORACLE PROC(10) 322176session pga memory max
ORACLE PROC(6) 208272session pga memory max
ORACLE PROC(7) 208272session pga memory max
ORACLE PROC(1) 199760session pga memory max
ORACLE PROC(8) 207888session uga memory
SYS(22) 207888session uga memory
ORACLE PROC(1) 76960session uga memory
ORACLE PROC(2) 76960session uga memory
ORACLE PROC(4) 76960session uga memory
ORACLE PROC(3) 76960session uga memory
ORACLE PROC(18) 76960session uga memory
ORACLE PROC(17) 76960session uga memory
ORACLE PROC(13) 76960session uga memory
ORACLE PROC(12) 76960session uga memory
ORACLE PROC(11) 76960session uga memory
ORACLE PROC(10) 76960session uga memory
ORACLE PROC(9) 76960session uga memory
ORACLE PROC(7) 76960session uga memory
ORACLE PROC(6) 76960session uga memory
ORACLE PROC(5) 76960session uga memory
SYS(22) 1255312session uga memory max
ORACLE PROC(8) 207888session uga memory max
ORACLE PROC(1) 76960session uga memory max
ORACLE PROC(3) 76960session uga memory max
ORACLE PROC(6) 76960session uga memory max
ORACLE PROC(4) 76960session uga memory max
ORACLE PROC(2) 76960session uga memory max
ORACLE PROC(5) 76960session uga memory max
ORACLE PROC(18) 76960session uga memory max
ORACLE PROC(17) 76960session uga memory max
ORACLE PROC(13) 76960session uga memory max
ORACLE PROC(12) 76960session uga memory max
ORACLE PROC(11) 76960session uga memory max
ORACLE PROC(10) 76960session uga memory max
ORACLE PROC(9) 76960session uga memory max
ORACLE PROC(7) 76960session uga memory max
ORACLE PROC(8) 145479shared hash latch upgrades - no wait
ORACLE PROC(7) 105262shared hash latch upgrades - no wait
ORACLE PROC(5) 1280shared hash latch upgrades - no wait
SYS(22) 36shared hash latch upgrades - no wait
ORACLE PROC(6) 2shared hash latch upgrades - no wait
ORACLE PROC(7) 35969sorts (memory)
ORACLE PROC(8) 6179sorts (memory)
SYS(22) 124sorts (memory)
ORACLE PROC(5) 47sorts (memory)
ORACLE PROC(6) 4sorts (memory)
SYS(22) 43836sorts (rows)
ORACLE PROC(7) 3310sorts (rows)
ORACLE PROC(8) 1839sorts (rows)
ORACLE PROC(5) 126sorts (rows)
ORACLE PROC(6) 24sorts (rows)
ORACLE PROC(2) 243summed dirty queue length
ORACLE PROC(8) 127689switch current to new buffer
ORACLE PROC(8) 383670table fetch by rowid
SYS(22) 10787table fetch by rowid
ORACLE PROC(7) 6586table fetch by rowid
ORACLE PROC(5) 48table fetch by rowid
ORACLE PROC(6) 3table fetch by rowid
ORACLE PROC(8) 894168table scan blocks gotten
ORACLE PROC(5) 147551table scan blocks gotten
SYS(22) 11271table scan blocks gotten
ORACLE PROC(8) 1578750table scan rows gotten
ORACLE PROC(5) 373628table scan rows gotten
SYS(22) 18807table scan rows gotten
ORACLE PROC(8) 5804table scans (long tables)
ORACLE PROC(5) 130table scans (long tables)
SYS(22) 12table scans (long tables)
ORACLE PROC(8) 150941table scans (short tables)
ORACLE PROC(5) 649table scans (short tables)
SYS(22) 104table scans (short tables)
ORACLE PROC(6) 100table scans (short tables)
SYS(22) 563user calls
ORACLE PROC(1) 2user calls
ORACLE PROC(6) 2user calls
ORACLE PROC(18) 2user calls
ORACLE PROC(17) 2user calls
ORACLE PROC(13) 2user calls
ORACLE PROC(12) 2user calls
ORACLE PROC(11) 2user calls
ORACLE PROC(10) 2user calls
ORACLE PROC(9) 2user calls
ORACLE PROC(8) 2user calls
ORACLE PROC(7) 2user calls
ORACLE PROC(5) 2user calls
ORACLE PROC(2) 2user calls
ORACLE PROC(4) 2user calls
ORACLE PROC(3) 2user calls
SYS(22) 6user commits
ORACLE PROC(7) 6474workarea executions - optimal
ORACLE PROC(8) 530workarea executions - optimal
SYS(22) 202workarea executions - optimal
ORACLE PROC(5) 40workarea executions - optimal
ORACLE PROC(6) 4workarea executions - optimal
SYS(22) 20workarea memory allocated