On Tue, 18 Feb 2003, Mark Boyd wrote:
> All -
>
> I am writing an Oracle PMDA and am wondering if someone can do me a
> favor. It is my understanding that there is a "commercial" Oracle PMDA
> for the IRIX platform and I would be interested in seeing the output of
> the pminfo -fT command, if possible. I have been writing my agent for a
> while now and am gathering quite a few metrics, but would like to have
> an idea of the metrics SGI found to be important when they wrote their
> agent. I would really appreciate any help on this. Thank you very much
> for your time, in advance.
The Oracle PMDA we developed was for Oracle 7, and that part of the
PCP product has been retired for a number of reasons.
The namespace we used was quite complicated because there is one set
of metrics per oracle server, so we used the ORA SID name as part of
the namespace at the top level ... so one PMDA per oracle server,
each providing oracle.SID.* metrics.
And then there are metrics per _session_ and we aggregated them over
all sessions, again for each oracle server ... so the namespace gets
_real_ ugly.
Here is an example for 2 oracle servers (SID_A and SID_B) ...
rattle 46% pminfo -m -n demo-root
oracle.SID_A.all.logons PMID: 32.1.0
oracle.SID_A.all.curlogons PMID: 32.1.1
oracle.SID_A.all.opencurs PMID: 32.1.2
oracle.SID_A.all.curopencurs PMID: 32.1.3
oracle.SID_A.all.ucommits PMID: 32.1.4
oracle.SID_A.all.urollbacks PMID: 32.1.5
oracle.SID_A.all.ucalls PMID: 32.1.6
oracle.SID_A.all.recursecalls PMID: 32.1.7
oracle.SID_A.all.recursecpu PMID: 32.1.8
oracle.SID_A.all.transrollbacks PMID: 32.1.121
oracle.SID_A.all.rollbackchangeundo PMID: 32.1.120
oracle.SID_A.all.selreadds PMID: 32.1.9
oracle.SID_A.all.seprocspace PMID: 32.1.10
oracle.SID_A.all.cpucall PMID: 32.1.11
oracle.SID_A.all.secpu PMID: 32.1.12
oracle.SID_A.all.secontime PMID: 32.1.13
oracle.SID_A.all.procidle PMID: 32.1.14
oracle.SID_A.all.semem PMID: 32.1.15
oracle.SID_A.all.maxsemem PMID: 32.1.16
oracle.SID_A.all.msgxmit PMID: 32.1.17
oracle.SID_A.all.msgrecv PMID: 32.1.18
oracle.SID_A.all.bgtimeouts PMID: 32.1.19
oracle.SID_A.all.sepgamem PMID: 32.1.20
oracle.SID_A.all.semaxpgamem PMID: 32.1.21
oracle.SID_A.all.enqueue.timeouts PMID: 32.1.22
oracle.SID_A.all.enqueue.waits PMID: 32.1.23
oracle.SID_A.all.enqueue.deadlocks PMID: 32.1.24
oracle.SID_A.all.enqueue.requests PMID: 32.1.25
oracle.SID_A.all.enqueue.conversions PMID: 32.1.26
oracle.SID_A.all.enqueue.releases PMID: 32.1.27
oracle.SID_A.all.globlock.gets PMID: 32.1.28
oracle.SID_A.all.globlock.agets PMID: 32.1.29
oracle.SID_A.all.globlock.gettime PMID: 32.1.30
oracle.SID_A.all.globlock.cvts PMID: 32.1.31
oracle.SID_A.all.globlock.acvts PMID: 32.1.32
oracle.SID_A.all.globlock.cvttime PMID: 32.1.33
oracle.SID_A.all.globlock.rels PMID: 32.1.34
oracle.SID_A.all.globlock.arels PMID: 32.1.35
oracle.SID_A.all.globlock.reltime PMID: 32.1.36
oracle.SID_A.all.dbbgets PMID: 32.1.37
oracle.SID_A.all.consgets PMID: 32.1.38
oracle.SID_A.all.preads PMID: 32.1.39
oracle.SID_A.all.pwrites PMID: 32.1.40
oracle.SID_A.all.wreqs PMID: 32.1.41
oracle.SID_A.all.dirtyqlen PMID: 32.1.42
oracle.SID_A.all.dbbchanges PMID: 32.1.43
oracle.SID_A.all.chwrtime PMID: 32.1.44
oracle.SID_A.all.conschanges PMID: 32.1.45
oracle.SID_A.all.consread.datablkundo PMID: 32.1.115
oracle.SID_A.all.consread.noworkgets PMID: 32.1.116
oracle.SID_A.all.consread.cleangets PMID: 32.1.117
oracle.SID_A.all.consread.rollbackgets PMID: 32.1.118
oracle.SID_A.all.consread.cleanrollbackgets PMID: 32.1.119
oracle.SID_A.all.consread.transtable.undo PMID: 32.1.113
oracle.SID_A.all.consread.transtable.rollback PMID: 32.1.114
oracle.SID_A.all.exdeadlocks PMID: 32.1.48
oracle.SID_A.all.buffer.freereqs PMID: 32.1.49
oracle.SID_A.all.buffer.dirtyinsp PMID: 32.1.50
oracle.SID_A.all.buffer.freeinsp PMID: 32.1.51
oracle.SID_A.all.dbwr.timeouts PMID: 32.1.52
oracle.SID_A.all.dbwr.mkfreereqs PMID: 32.1.53
oracle.SID_A.all.dbwr.freebuffnd PMID: 32.1.54
oracle.SID_A.all.dbwr.lruscans PMID: 32.1.55
oracle.SID_A.all.dbwr.sumscandepth PMID: 32.1.56
oracle.SID_A.all.dbwr.bufsscanned PMID: 32.1.57
oracle.SID_A.all.dbwr.checkpoints PMID: 32.1.58
oracle.SID_A.all.dbwr.xinstwrites PMID: 32.1.59
oracle.SID_A.all.remote.instundowr PMID: 32.1.60
oracle.SID_A.all.remote.instundoreq PMID: 32.1.61
oracle.SID_A.all.recovery.breads PMID: 32.1.105
oracle.SID_A.all.recovery.areads PMID: 32.1.106
oracle.SID_A.all.recovery.areadtime PMID: 32.1.107
oracle.SID_A.all.kcmg.cscalls PMID: 32.1.63
oracle.SID_A.all.kcmg.rscalls PMID: 32.1.64
oracle.SID_A.all.kcmg.ascalls PMID: 32.1.65
oracle.SID_A.all.xinstcrrd PMID: 32.1.62
oracle.SID_A.all.nodlmscnsgets PMID: 32.1.66
oracle.SID_A.all.redo.syncwr PMID: 32.1.46
oracle.SID_A.all.redo.synctime PMID: 32.1.47
oracle.SID_A.all.redo.entries PMID: 32.1.67
oracle.SID_A.all.redo.size PMID: 32.1.68
oracle.SID_A.all.redo.entslin PMID: 32.1.69
oracle.SID_A.all.redo.bufallret PMID: 32.1.70
oracle.SID_A.all.redo.smallcpys PMID: 32.1.71
oracle.SID_A.all.redo.wastage PMID: 32.1.72
oracle.SID_A.all.redo.wrlatchtime PMID: 32.1.73
oracle.SID_A.all.redo.writes PMID: 32.1.74
oracle.SID_A.all.redo.bwrites PMID: 32.1.75
oracle.SID_A.all.redo.wrtime PMID: 32.1.76
oracle.SID_A.all.redo.logspreqs PMID: 32.1.77
oracle.SID_A.all.redo.logspwaittime PMID: 32.1.78
oracle.SID_A.all.redo.logswintrs PMID: 32.1.79
oracle.SID_A.all.redo.ordermarks PMID: 32.1.80
oracle.SID_A.all.hashlwgets PMID: 32.1.81
oracle.SID_A.all.bgchkpts.started PMID: 32.1.82
oracle.SID_A.all.bgchkpts.completed PMID: 32.1.83
oracle.SID_A.all.tranlock.fgreqs PMID: 32.1.84
oracle.SID_A.all.tranlock.fgwaittime PMID: 32.1.85
oracle.SID_A.all.tranlock.bggets PMID: 32.1.86
oracle.SID_A.all.tranlock.bggettime PMID: 32.1.87
oracle.SID_A.all.table.shortscans PMID: 32.1.88
oracle.SID_A.all.table.longscans PMID: 32.1.89
oracle.SID_A.all.table.rowidrngscans PMID: 32.1.108
oracle.SID_A.all.table.cachepartscans PMID: 32.1.109
oracle.SID_A.all.table.dirreadscans PMID: 32.1.125
oracle.SID_A.all.table.scanrows PMID: 32.1.90
oracle.SID_A.all.table.scanblocks PMID: 32.1.91
oracle.SID_A.all.table.rowidfetches PMID: 32.1.92
oracle.SID_A.all.table.contfetches PMID: 32.1.93
oracle.SID_A.all.clustkey.scans PMID: 32.1.94
oracle.SID_A.all.clustkey.scanblocks PMID: 32.1.95
oracle.SID_A.all.sql.parsecpu PMID: 32.1.96
oracle.SID_A.all.sql.parsereal PMID: 32.1.97
oracle.SID_A.all.sql.parsed PMID: 32.1.98
oracle.SID_A.all.sql.executed PMID: 32.1.99
oracle.SID_A.all.sql.memsorts PMID: 32.1.100
oracle.SID_A.all.sql.disksorts PMID: 32.1.101
oracle.SID_A.all.sql.rowsorts PMID: 32.1.102
oracle.SID_A.all.sccachehits PMID: 32.1.103
oracle.SID_A.all.sccachecount PMID: 32.1.126
oracle.SID_A.all.cursauths PMID: 32.1.104
oracle.SID_A.all.cleanout.immedcurr PMID: 32.1.122
oracle.SID_A.all.cleanout.defercurr PMID: 32.1.124
oracle.SID_A.all.cleanout.immedcr PMID: 32.1.123
oracle.SID_A.all.cr.createblk PMID: 32.1.110
oracle.SID_A.all.cr.convcurrblk PMID: 32.1.111
oracle.SID_A.all.unnecprocclnscn PMID: 32.1.112
oracle.SID_A.session.logons PMID: 32.8.0
oracle.SID_A.session.curlogons PMID: 32.8.1
oracle.SID_A.session.opencurs PMID: 32.8.2
oracle.SID_A.session.curopencurs PMID: 32.8.3
oracle.SID_A.session.ucommits PMID: 32.8.4
oracle.SID_A.session.urollbacks PMID: 32.8.5
oracle.SID_A.session.ucalls PMID: 32.8.6
oracle.SID_A.session.recursecalls PMID: 32.8.7
oracle.SID_A.session.recursecpu PMID: 32.8.8
oracle.SID_A.session.transrollbacks PMID: 32.8.121
oracle.SID_A.session.rollbackchangeundo PMID: 32.8.120
oracle.SID_A.session.selreadds PMID: 32.8.9
oracle.SID_A.session.seprocspace PMID: 32.8.10
oracle.SID_A.session.cpucall PMID: 32.8.11
oracle.SID_A.session.secpu PMID: 32.8.12
oracle.SID_A.session.secontime PMID: 32.8.13
oracle.SID_A.session.procidle PMID: 32.8.14
oracle.SID_A.session.semem PMID: 32.8.15
oracle.SID_A.session.maxsemem PMID: 32.8.16
oracle.SID_A.session.msgxmit PMID: 32.8.17
oracle.SID_A.session.msgrecv PMID: 32.8.18
oracle.SID_A.session.bgtimeouts PMID: 32.8.19
oracle.SID_A.session.sepgamem PMID: 32.8.20
oracle.SID_A.session.semaxpgamem PMID: 32.8.21
oracle.SID_A.session.enqueue.timeouts PMID: 32.8.22
oracle.SID_A.session.enqueue.waits PMID: 32.8.23
oracle.SID_A.session.enqueue.deadlocks PMID: 32.8.24
oracle.SID_A.session.enqueue.requests PMID: 32.8.25
oracle.SID_A.session.enqueue.conversions PMID: 32.8.26
oracle.SID_A.session.enqueue.releases PMID: 32.8.27
oracle.SID_A.session.globlock.gets PMID: 32.8.28
oracle.SID_A.session.globlock.agets PMID: 32.8.29
oracle.SID_A.session.globlock.gettime PMID: 32.8.30
oracle.SID_A.session.globlock.cvts PMID: 32.8.31
oracle.SID_A.session.globlock.acvts PMID: 32.8.32
oracle.SID_A.session.globlock.cvttime PMID: 32.8.33
oracle.SID_A.session.globlock.rels PMID: 32.8.34
oracle.SID_A.session.globlock.arels PMID: 32.8.35
oracle.SID_A.session.globlock.reltime PMID: 32.8.36
oracle.SID_A.session.dbbgets PMID: 32.8.37
oracle.SID_A.session.consgets PMID: 32.8.38
oracle.SID_A.session.preads PMID: 32.8.39
oracle.SID_A.session.pwrites PMID: 32.8.40
oracle.SID_A.session.wreqs PMID: 32.8.41
oracle.SID_A.session.dirtyqlen PMID: 32.8.42
oracle.SID_A.session.dbbchanges PMID: 32.8.43
oracle.SID_A.session.chwrtime PMID: 32.8.44
oracle.SID_A.session.conschanges PMID: 32.8.45
oracle.SID_A.session.consread.datablkundo PMID: 32.8.115
oracle.SID_A.session.consread.noworkgets PMID: 32.8.116
oracle.SID_A.session.consread.cleangets PMID: 32.8.117
oracle.SID_A.session.consread.rollbackgets PMID: 32.8.118
oracle.SID_A.session.consread.cleanrollbackgets PMID: 32.8.119
oracle.SID_A.session.consread.transtable.undo PMID: 32.8.113
oracle.SID_A.session.consread.transtable.rollback PMID: 32.8.114
oracle.SID_A.session.exdeadlocks PMID: 32.8.48
oracle.SID_A.session.buffer.freereqs PMID: 32.8.49
oracle.SID_A.session.buffer.dirtyinsp PMID: 32.8.50
oracle.SID_A.session.buffer.freeinsp PMID: 32.8.51
oracle.SID_A.session.dbwr.timeouts PMID: 32.8.52
oracle.SID_A.session.dbwr.mkfreereqs PMID: 32.8.53
oracle.SID_A.session.dbwr.freebuffnd PMID: 32.8.54
oracle.SID_A.session.dbwr.lruscans PMID: 32.8.55
oracle.SID_A.session.dbwr.sumscandepth PMID: 32.8.56
oracle.SID_A.session.dbwr.bufsscanned PMID: 32.8.57
oracle.SID_A.session.dbwr.checkpoints PMID: 32.8.58
oracle.SID_A.session.dbwr.xinstwrites PMID: 32.8.59
oracle.SID_A.session.remote.instundowr PMID: 32.8.60
oracle.SID_A.session.remote.instundoreq PMID: 32.8.61
oracle.SID_A.session.recovery.breads PMID: 32.8.105
oracle.SID_A.session.recovery.areads PMID: 32.8.106
oracle.SID_A.session.recovery.areadtime PMID: 32.8.107
oracle.SID_A.session.kcmg.cscalls PMID: 32.8.63
oracle.SID_A.session.kcmg.rscalls PMID: 32.8.64
oracle.SID_A.session.kcmg.ascalls PMID: 32.8.65
oracle.SID_A.session.xinstcrrd PMID: 32.8.62
oracle.SID_A.session.nodlmscnsgets PMID: 32.8.66
oracle.SID_A.session.redo.syncwr PMID: 32.8.46
oracle.SID_A.session.redo.synctime PMID: 32.8.47
oracle.SID_A.session.redo.entries PMID: 32.8.67
oracle.SID_A.session.redo.size PMID: 32.8.68
oracle.SID_A.session.redo.entslin PMID: 32.8.69
oracle.SID_A.session.redo.bufallret PMID: 32.8.70
oracle.SID_A.session.redo.smallcpys PMID: 32.8.71
oracle.SID_A.session.redo.wastage PMID: 32.8.72
oracle.SID_A.session.redo.wrlatchtime PMID: 32.8.73
oracle.SID_A.session.redo.writes PMID: 32.8.74
oracle.SID_A.session.redo.bwrites PMID: 32.8.75
oracle.SID_A.session.redo.wrtime PMID: 32.8.76
oracle.SID_A.session.redo.logspreqs PMID: 32.8.77
oracle.SID_A.session.redo.logspwaittime PMID: 32.8.78
oracle.SID_A.session.redo.logswintrs PMID: 32.8.79
oracle.SID_A.session.redo.ordermarks PMID: 32.8.80
oracle.SID_A.session.hashlwgets PMID: 32.8.81
oracle.SID_A.session.bgchkpts.started PMID: 32.8.82
oracle.SID_A.session.bgchkpts.completed PMID: 32.8.83
oracle.SID_A.session.tranlock.fgreqs PMID: 32.8.84
oracle.SID_A.session.tranlock.fgwaittime PMID: 32.8.85
oracle.SID_A.session.tranlock.bggets PMID: 32.8.86
oracle.SID_A.session.tranlock.bggettime PMID: 32.8.87
oracle.SID_A.session.table.shortscans PMID: 32.8.88
oracle.SID_A.session.table.longscans PMID: 32.8.89
oracle.SID_A.session.table.rowidrngscans PMID: 32.8.108
oracle.SID_A.session.table.cachepartscans PMID: 32.8.109
oracle.SID_A.session.table.dirreadscans PMID: 32.8.125
oracle.SID_A.session.table.scanrows PMID: 32.8.90
oracle.SID_A.session.table.scanblocks PMID: 32.8.91
oracle.SID_A.session.table.rowidfetches PMID: 32.8.92
oracle.SID_A.session.table.contfetches PMID: 32.8.93
oracle.SID_A.session.clustkey.scans PMID: 32.8.94
oracle.SID_A.session.clustkey.scanblocks PMID: 32.8.95
oracle.SID_A.session.sql.parsecpu PMID: 32.8.96
oracle.SID_A.session.sql.parsereal PMID: 32.8.97
oracle.SID_A.session.sql.parsed PMID: 32.8.98
oracle.SID_A.session.sql.executed PMID: 32.8.99
oracle.SID_A.session.sql.memsorts PMID: 32.8.100
oracle.SID_A.session.sql.disksorts PMID: 32.8.101
oracle.SID_A.session.sql.rowsorts PMID: 32.8.102
oracle.SID_A.session.sccachehits PMID: 32.8.103
oracle.SID_A.session.sccachecount PMID: 32.8.126
oracle.SID_A.session.cursauths PMID: 32.8.104
oracle.SID_A.session.cleanout.immedcurr PMID: 32.8.122
oracle.SID_A.session.cleanout.defercurr PMID: 32.8.124
oracle.SID_A.session.cleanout.immedcr PMID: 32.8.123
oracle.SID_A.session.cr.createblk PMID: 32.8.110
oracle.SID_A.session.cr.convcurrblk PMID: 32.8.111
oracle.SID_A.session.unnecprocclnscn PMID: 32.8.112
oracle.SID_A.latch.gets PMID: 32.2.0
oracle.SID_A.latch.misses PMID: 32.2.1
oracle.SID_A.latch.sleeps PMID: 32.2.2
oracle.SID_A.latch.imgets PMID: 32.2.3
oracle.SID_A.latch.immisses PMID: 32.2.4
oracle.SID_A.latch.wakes PMID: 32.2.5
oracle.SID_A.latch.holds PMID: 32.2.6
oracle.SID_A.latch.spingets PMID: 32.2.7
oracle.SID_A.event.waits PMID: 32.10.0
oracle.SID_A.event.timeouts PMID: 32.10.1
oracle.SID_A.event.time_waited PMID: 32.10.2
oracle.SID_A.event.average_wait PMID: 32.10.3
oracle.SID_A.objcache.sharemem PMID: 32.9.0
oracle.SID_A.file.phyreads PMID: 32.3.0
oracle.SID_A.file.phywrites PMID: 32.3.1
oracle.SID_A.file.phyblkreads PMID: 32.3.2
oracle.SID_A.file.phyblkwrites PMID: 32.3.3
oracle.SID_A.file.readtime PMID: 32.3.4
oracle.SID_A.file.writetime PMID: 32.3.5
oracle.SID_A.rollback.rssize PMID: 32.4.0
oracle.SID_A.rollback.writes PMID: 32.4.1
oracle.SID_A.rollback.xacts PMID: 32.4.2
oracle.SID_A.rollback.gets PMID: 32.4.3
oracle.SID_A.rollback.waits PMID: 32.4.4
oracle.SID_A.rollback.hwmsize PMID: 32.4.5
oracle.SID_A.rollback.shrinks PMID: 32.4.6
oracle.SID_A.rollback.wraps PMID: 32.4.7
oracle.SID_A.rollback.extends PMID: 32.4.8
oracle.SID_A.rollback.avshrink PMID: 32.4.9
oracle.SID_A.rollback.avactive PMID: 32.4.10
oracle.SID_A.reqdist PMID: 32.5.0
oracle.SID_A.rowcache.count PMID: 32.7.0
oracle.SID_A.rowcache.gets PMID: 32.7.1
oracle.SID_A.rowcache.getmisses PMID: 32.7.2
oracle.SID_A.rowcache.scans PMID: 32.7.3
oracle.SID_A.rowcache.scanmisses PMID: 32.7.4
oracle.SID_A.license.maxsess PMID: 32.0.0
oracle.SID_A.license.cursess PMID: 32.0.1
oracle.SID_A.license.warnsess PMID: 32.0.2
oracle.SID_A.license.highsess PMID: 32.0.3
oracle.SID_A.license.maxusers PMID: 32.0.4
oracle.SID_A.backup.status PMID: 32.6.0
oracle.SID_B.all.logons PMID: 33.1.0
oracle.SID_B.all.curlogons PMID: 33.1.1
oracle.SID_B.all.opencurs PMID: 33.1.2
oracle.SID_B.all.curopencurs PMID: 33.1.3
oracle.SID_B.all.ucommits PMID: 33.1.4
oracle.SID_B.all.urollbacks PMID: 33.1.5
oracle.SID_B.all.ucalls PMID: 33.1.6
oracle.SID_B.all.recursecalls PMID: 33.1.7
oracle.SID_B.all.recursecpu PMID: 33.1.8
oracle.SID_B.all.transrollbacks PMID: 33.1.121
oracle.SID_B.all.rollbackchangeundo PMID: 33.1.120
oracle.SID_B.all.selreadds PMID: 33.1.9
oracle.SID_B.all.seprocspace PMID: 33.1.10
oracle.SID_B.all.cpucall PMID: 33.1.11
oracle.SID_B.all.secpu PMID: 33.1.12
oracle.SID_B.all.secontime PMID: 33.1.13
oracle.SID_B.all.procidle PMID: 33.1.14
oracle.SID_B.all.semem PMID: 33.1.15
oracle.SID_B.all.maxsemem PMID: 33.1.16
oracle.SID_B.all.msgxmit PMID: 33.1.17
oracle.SID_B.all.msgrecv PMID: 33.1.18
oracle.SID_B.all.bgtimeouts PMID: 33.1.19
oracle.SID_B.all.sepgamem PMID: 33.1.20
oracle.SID_B.all.semaxpgamem PMID: 33.1.21
oracle.SID_B.all.enqueue.timeouts PMID: 33.1.22
oracle.SID_B.all.enqueue.waits PMID: 33.1.23
oracle.SID_B.all.enqueue.deadlocks PMID: 33.1.24
oracle.SID_B.all.enqueue.requests PMID: 33.1.25
oracle.SID_B.all.enqueue.conversions PMID: 33.1.26
oracle.SID_B.all.enqueue.releases PMID: 33.1.27
oracle.SID_B.all.globlock.gets PMID: 33.1.28
oracle.SID_B.all.globlock.agets PMID: 33.1.29
oracle.SID_B.all.globlock.gettime PMID: 33.1.30
oracle.SID_B.all.globlock.cvts PMID: 33.1.31
oracle.SID_B.all.globlock.acvts PMID: 33.1.32
oracle.SID_B.all.globlock.cvttime PMID: 33.1.33
oracle.SID_B.all.globlock.rels PMID: 33.1.34
oracle.SID_B.all.globlock.arels PMID: 33.1.35
oracle.SID_B.all.globlock.reltime PMID: 33.1.36
oracle.SID_B.all.dbbgets PMID: 33.1.37
oracle.SID_B.all.consgets PMID: 33.1.38
oracle.SID_B.all.preads PMID: 33.1.39
oracle.SID_B.all.pwrites PMID: 33.1.40
oracle.SID_B.all.wreqs PMID: 33.1.41
oracle.SID_B.all.dirtyqlen PMID: 33.1.42
oracle.SID_B.all.dbbchanges PMID: 33.1.43
oracle.SID_B.all.chwrtime PMID: 33.1.44
oracle.SID_B.all.conschanges PMID: 33.1.45
oracle.SID_B.all.consread.datablkundo PMID: 33.1.115
oracle.SID_B.all.consread.noworkgets PMID: 33.1.116
oracle.SID_B.all.consread.cleangets PMID: 33.1.117
oracle.SID_B.all.consread.rollbackgets PMID: 33.1.118
oracle.SID_B.all.consread.cleanrollbackgets PMID: 33.1.119
oracle.SID_B.all.consread.transtable.undo PMID: 33.1.113
oracle.SID_B.all.consread.transtable.rollback PMID: 33.1.114
oracle.SID_B.all.exdeadlocks PMID: 33.1.48
oracle.SID_B.all.buffer.freereqs PMID: 33.1.49
oracle.SID_B.all.buffer.dirtyinsp PMID: 33.1.50
oracle.SID_B.all.buffer.freeinsp PMID: 33.1.51
oracle.SID_B.all.dbwr.timeouts PMID: 33.1.52
oracle.SID_B.all.dbwr.mkfreereqs PMID: 33.1.53
oracle.SID_B.all.dbwr.freebuffnd PMID: 33.1.54
oracle.SID_B.all.dbwr.lruscans PMID: 33.1.55
oracle.SID_B.all.dbwr.sumscandepth PMID: 33.1.56
oracle.SID_B.all.dbwr.bufsscanned PMID: 33.1.57
oracle.SID_B.all.dbwr.checkpoints PMID: 33.1.58
oracle.SID_B.all.dbwr.xinstwrites PMID: 33.1.59
oracle.SID_B.all.remote.instundowr PMID: 33.1.60
oracle.SID_B.all.remote.instundoreq PMID: 33.1.61
oracle.SID_B.all.recovery.breads PMID: 33.1.105
oracle.SID_B.all.recovery.areads PMID: 33.1.106
oracle.SID_B.all.recovery.areadtime PMID: 33.1.107
oracle.SID_B.all.kcmg.cscalls PMID: 33.1.63
oracle.SID_B.all.kcmg.rscalls PMID: 33.1.64
oracle.SID_B.all.kcmg.ascalls PMID: 33.1.65
oracle.SID_B.all.xinstcrrd PMID: 33.1.62
oracle.SID_B.all.nodlmscnsgets PMID: 33.1.66
oracle.SID_B.all.redo.syncwr PMID: 33.1.46
oracle.SID_B.all.redo.synctime PMID: 33.1.47
oracle.SID_B.all.redo.entries PMID: 33.1.67
oracle.SID_B.all.redo.size PMID: 33.1.68
oracle.SID_B.all.redo.entslin PMID: 33.1.69
oracle.SID_B.all.redo.bufallret PMID: 33.1.70
oracle.SID_B.all.redo.smallcpys PMID: 33.1.71
oracle.SID_B.all.redo.wastage PMID: 33.1.72
oracle.SID_B.all.redo.wrlatchtime PMID: 33.1.73
oracle.SID_B.all.redo.writes PMID: 33.1.74
oracle.SID_B.all.redo.bwrites PMID: 33.1.75
oracle.SID_B.all.redo.wrtime PMID: 33.1.76
oracle.SID_B.all.redo.logspreqs PMID: 33.1.77
oracle.SID_B.all.redo.logspwaittime PMID: 33.1.78
oracle.SID_B.all.redo.logswintrs PMID: 33.1.79
oracle.SID_B.all.redo.ordermarks PMID: 33.1.80
oracle.SID_B.all.hashlwgets PMID: 33.1.81
oracle.SID_B.all.bgchkpts.started PMID: 33.1.82
oracle.SID_B.all.bgchkpts.completed PMID: 33.1.83
oracle.SID_B.all.tranlock.fgreqs PMID: 33.1.84
oracle.SID_B.all.tranlock.fgwaittime PMID: 33.1.85
oracle.SID_B.all.tranlock.bggets PMID: 33.1.86
oracle.SID_B.all.tranlock.bggettime PMID: 33.1.87
oracle.SID_B.all.table.shortscans PMID: 33.1.88
oracle.SID_B.all.table.longscans PMID: 33.1.89
oracle.SID_B.all.table.rowidrngscans PMID: 33.1.108
oracle.SID_B.all.table.cachepartscans PMID: 33.1.109
oracle.SID_B.all.table.dirreadscans PMID: 33.1.125
oracle.SID_B.all.table.scanrows PMID: 33.1.90
oracle.SID_B.all.table.scanblocks PMID: 33.1.91
oracle.SID_B.all.table.rowidfetches PMID: 33.1.92
oracle.SID_B.all.table.contfetches PMID: 33.1.93
oracle.SID_B.all.clustkey.scans PMID: 33.1.94
oracle.SID_B.all.clustkey.scanblocks PMID: 33.1.95
oracle.SID_B.all.sql.parsecpu PMID: 33.1.96
oracle.SID_B.all.sql.parsereal PMID: 33.1.97
oracle.SID_B.all.sql.parsed PMID: 33.1.98
oracle.SID_B.all.sql.executed PMID: 33.1.99
oracle.SID_B.all.sql.memsorts PMID: 33.1.100
oracle.SID_B.all.sql.disksorts PMID: 33.1.101
oracle.SID_B.all.sql.rowsorts PMID: 33.1.102
oracle.SID_B.all.sccachehits PMID: 33.1.103
oracle.SID_B.all.sccachecount PMID: 33.1.126
oracle.SID_B.all.cursauths PMID: 33.1.104
oracle.SID_B.all.cleanout.immedcurr PMID: 33.1.122
oracle.SID_B.all.cleanout.defercurr PMID: 33.1.124
oracle.SID_B.all.cleanout.immedcr PMID: 33.1.123
oracle.SID_B.all.cr.createblk PMID: 33.1.110
oracle.SID_B.all.cr.convcurrblk PMID: 33.1.111
oracle.SID_B.all.unnecprocclnscn PMID: 33.1.112
oracle.SID_B.session.logons PMID: 33.8.0
oracle.SID_B.session.curlogons PMID: 33.8.1
oracle.SID_B.session.opencurs PMID: 33.8.2
oracle.SID_B.session.curopencurs PMID: 33.8.3
oracle.SID_B.session.ucommits PMID: 33.8.4
oracle.SID_B.session.urollbacks PMID: 33.8.5
oracle.SID_B.session.ucalls PMID: 33.8.6
oracle.SID_B.session.recursecalls PMID: 33.8.7
oracle.SID_B.session.recursecpu PMID: 33.8.8
oracle.SID_B.session.transrollbacks PMID: 33.8.121
oracle.SID_B.session.rollbackchangeundo PMID: 33.8.120
oracle.SID_B.session.selreadds PMID: 33.8.9
oracle.SID_B.session.seprocspace PMID: 33.8.10
oracle.SID_B.session.cpucall PMID: 33.8.11
oracle.SID_B.session.secpu PMID: 33.8.12
oracle.SID_B.session.secontime PMID: 33.8.13
oracle.SID_B.session.procidle PMID: 33.8.14
oracle.SID_B.session.semem PMID: 33.8.15
oracle.SID_B.session.maxsemem PMID: 33.8.16
oracle.SID_B.session.msgxmit PMID: 33.8.17
oracle.SID_B.session.msgrecv PMID: 33.8.18
oracle.SID_B.session.bgtimeouts PMID: 33.8.19
oracle.SID_B.session.sepgamem PMID: 33.8.20
oracle.SID_B.session.semaxpgamem PMID: 33.8.21
oracle.SID_B.session.enqueue.timeouts PMID: 33.8.22
oracle.SID_B.session.enqueue.waits PMID: 33.8.23
oracle.SID_B.session.enqueue.deadlocks PMID: 33.8.24
oracle.SID_B.session.enqueue.requests PMID: 33.8.25
oracle.SID_B.session.enqueue.conversions PMID: 33.8.26
oracle.SID_B.session.enqueue.releases PMID: 33.8.27
oracle.SID_B.session.globlock.gets PMID: 33.8.28
oracle.SID_B.session.globlock.agets PMID: 33.8.29
oracle.SID_B.session.globlock.gettime PMID: 33.8.30
oracle.SID_B.session.globlock.cvts PMID: 33.8.31
oracle.SID_B.session.globlock.acvts PMID: 33.8.32
oracle.SID_B.session.globlock.cvttime PMID: 33.8.33
oracle.SID_B.session.globlock.rels PMID: 33.8.34
oracle.SID_B.session.globlock.arels PMID: 33.8.35
oracle.SID_B.session.globlock.reltime PMID: 33.8.36
oracle.SID_B.session.dbbgets PMID: 33.8.37
oracle.SID_B.session.consgets PMID: 33.8.38
oracle.SID_B.session.preads PMID: 33.8.39
oracle.SID_B.session.pwrites PMID: 33.8.40
oracle.SID_B.session.wreqs PMID: 33.8.41
oracle.SID_B.session.dirtyqlen PMID: 33.8.42
oracle.SID_B.session.dbbchanges PMID: 33.8.43
oracle.SID_B.session.chwrtime PMID: 33.8.44
oracle.SID_B.session.conschanges PMID: 33.8.45
oracle.SID_B.session.consread.datablkundo PMID: 33.8.115
oracle.SID_B.session.consread.noworkgets PMID: 33.8.116
oracle.SID_B.session.consread.cleangets PMID: 33.8.117
oracle.SID_B.session.consread.rollbackgets PMID: 33.8.118
oracle.SID_B.session.consread.cleanrollbackgets PMID: 33.8.119
oracle.SID_B.session.consread.transtable.undo PMID: 33.8.113
oracle.SID_B.session.consread.transtable.rollback PMID: 33.8.114
oracle.SID_B.session.exdeadlocks PMID: 33.8.48
oracle.SID_B.session.buffer.freereqs PMID: 33.8.49
oracle.SID_B.session.buffer.dirtyinsp PMID: 33.8.50
oracle.SID_B.session.buffer.freeinsp PMID: 33.8.51
oracle.SID_B.session.dbwr.timeouts PMID: 33.8.52
oracle.SID_B.session.dbwr.mkfreereqs PMID: 33.8.53
oracle.SID_B.session.dbwr.freebuffnd PMID: 33.8.54
oracle.SID_B.session.dbwr.lruscans PMID: 33.8.55
oracle.SID_B.session.dbwr.sumscandepth PMID: 33.8.56
oracle.SID_B.session.dbwr.bufsscanned PMID: 33.8.57
oracle.SID_B.session.dbwr.checkpoints PMID: 33.8.58
oracle.SID_B.session.dbwr.xinstwrites PMID: 33.8.59
oracle.SID_B.session.remote.instundowr PMID: 33.8.60
oracle.SID_B.session.remote.instundoreq PMID: 33.8.61
oracle.SID_B.session.recovery.breads PMID: 33.8.105
oracle.SID_B.session.recovery.areads PMID: 33.8.106
oracle.SID_B.session.recovery.areadtime PMID: 33.8.107
oracle.SID_B.session.kcmg.cscalls PMID: 33.8.63
oracle.SID_B.session.kcmg.rscalls PMID: 33.8.64
oracle.SID_B.session.kcmg.ascalls PMID: 33.8.65
oracle.SID_B.session.xinstcrrd PMID: 33.8.62
oracle.SID_B.session.nodlmscnsgets PMID: 33.8.66
oracle.SID_B.session.redo.syncwr PMID: 33.8.46
oracle.SID_B.session.redo.synctime PMID: 33.8.47
oracle.SID_B.session.redo.entries PMID: 33.8.67
oracle.SID_B.session.redo.size PMID: 33.8.68
oracle.SID_B.session.redo.entslin PMID: 33.8.69
oracle.SID_B.session.redo.bufallret PMID: 33.8.70
oracle.SID_B.session.redo.smallcpys PMID: 33.8.71
oracle.SID_B.session.redo.wastage PMID: 33.8.72
oracle.SID_B.session.redo.wrlatchtime PMID: 33.8.73
oracle.SID_B.session.redo.writes PMID: 33.8.74
oracle.SID_B.session.redo.bwrites PMID: 33.8.75
oracle.SID_B.session.redo.wrtime PMID: 33.8.76
oracle.SID_B.session.redo.logspreqs PMID: 33.8.77
oracle.SID_B.session.redo.logspwaittime PMID: 33.8.78
oracle.SID_B.session.redo.logswintrs PMID: 33.8.79
oracle.SID_B.session.redo.ordermarks PMID: 33.8.80
oracle.SID_B.session.hashlwgets PMID: 33.8.81
oracle.SID_B.session.bgchkpts.started PMID: 33.8.82
oracle.SID_B.session.bgchkpts.completed PMID: 33.8.83
oracle.SID_B.session.tranlock.fgreqs PMID: 33.8.84
oracle.SID_B.session.tranlock.fgwaittime PMID: 33.8.85
oracle.SID_B.session.tranlock.bggets PMID: 33.8.86
oracle.SID_B.session.tranlock.bggettime PMID: 33.8.87
oracle.SID_B.session.table.shortscans PMID: 33.8.88
oracle.SID_B.session.table.longscans PMID: 33.8.89
oracle.SID_B.session.table.rowidrngscans PMID: 33.8.108
oracle.SID_B.session.table.cachepartscans PMID: 33.8.109
oracle.SID_B.session.table.dirreadscans PMID: 33.8.125
oracle.SID_B.session.table.scanrows PMID: 33.8.90
oracle.SID_B.session.table.scanblocks PMID: 33.8.91
oracle.SID_B.session.table.rowidfetches PMID: 33.8.92
oracle.SID_B.session.table.contfetches PMID: 33.8.93
oracle.SID_B.session.clustkey.scans PMID: 33.8.94
oracle.SID_B.session.clustkey.scanblocks PMID: 33.8.95
oracle.SID_B.session.sql.parsecpu PMID: 33.8.96
oracle.SID_B.session.sql.parsereal PMID: 33.8.97
oracle.SID_B.session.sql.parsed PMID: 33.8.98
oracle.SID_B.session.sql.executed PMID: 33.8.99
oracle.SID_B.session.sql.memsorts PMID: 33.8.100
oracle.SID_B.session.sql.disksorts PMID: 33.8.101
oracle.SID_B.session.sql.rowsorts PMID: 33.8.102
oracle.SID_B.session.sccachehits PMID: 33.8.103
oracle.SID_B.session.sccachecount PMID: 33.8.126
oracle.SID_B.session.cursauths PMID: 33.8.104
oracle.SID_B.session.cleanout.immedcurr PMID: 33.8.122
oracle.SID_B.session.cleanout.defercurr PMID: 33.8.124
oracle.SID_B.session.cleanout.immedcr PMID: 33.8.123
oracle.SID_B.session.cr.createblk PMID: 33.8.110
oracle.SID_B.session.cr.convcurrblk PMID: 33.8.111
oracle.SID_B.session.unnecprocclnscn PMID: 33.8.112
oracle.SID_B.latch.gets PMID: 33.2.0
oracle.SID_B.latch.misses PMID: 33.2.1
oracle.SID_B.latch.sleeps PMID: 33.2.2
oracle.SID_B.latch.imgets PMID: 33.2.3
oracle.SID_B.latch.immisses PMID: 33.2.4
oracle.SID_B.latch.wakes PMID: 33.2.5
oracle.SID_B.latch.holds PMID: 33.2.6
oracle.SID_B.latch.spingets PMID: 33.2.7
oracle.SID_B.event.waits PMID: 33.10.0
oracle.SID_B.event.timeouts PMID: 33.10.1
oracle.SID_B.event.time_waited PMID: 33.10.2
oracle.SID_B.event.average_wait PMID: 33.10.3
oracle.SID_B.objcache.sharemem PMID: 33.9.0
oracle.SID_B.file.phyreads PMID: 33.3.0
oracle.SID_B.file.phywrites PMID: 33.3.1
oracle.SID_B.file.phyblkreads PMID: 33.3.2
oracle.SID_B.file.phyblkwrites PMID: 33.3.3
oracle.SID_B.file.readtime PMID: 33.3.4
oracle.SID_B.file.writetime PMID: 33.3.5
oracle.SID_B.rollback.rssize PMID: 33.4.0
oracle.SID_B.rollback.writes PMID: 33.4.1
oracle.SID_B.rollback.xacts PMID: 33.4.2
oracle.SID_B.rollback.gets PMID: 33.4.3
oracle.SID_B.rollback.waits PMID: 33.4.4
oracle.SID_B.rollback.hwmsize PMID: 33.4.5
oracle.SID_B.rollback.shrinks PMID: 33.4.6
oracle.SID_B.rollback.wraps PMID: 33.4.7
oracle.SID_B.rollback.extends PMID: 33.4.8
oracle.SID_B.rollback.avshrink PMID: 33.4.9
oracle.SID_B.rollback.avactive PMID: 33.4.10
oracle.SID_B.reqdist PMID: 33.5.0
oracle.SID_B.rowcache.count PMID: 33.7.0
oracle.SID_B.rowcache.gets PMID: 33.7.1
oracle.SID_B.rowcache.getmisses PMID: 33.7.2
oracle.SID_B.rowcache.scans PMID: 33.7.3
oracle.SID_B.rowcache.scanmisses PMID: 33.7.4
oracle.SID_B.license.maxsess PMID: 33.0.0
oracle.SID_B.license.cursess PMID: 33.0.1
oracle.SID_B.license.warnsess PMID: 33.0.2
oracle.SID_B.license.highsess PMID: 33.0.3
oracle.SID_B.license.maxusers PMID: 33.0.4
oracle.SID_B.backup.status PMID: 33.6.0
|