target	--default--
	sid		=	%auto-target-name%
	globalname	=	undef
	snmp-community	=	public
	target-type	=	undef
	directory-desc	=	"Oracle RDBMS"

# All of these OIDs are nicely explained and documented on OTN at:
# http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/em.817/a85249/toc.htm

OID	rdbmsSrvInfoStartupTime	1.3.6.1.2.1.39.1.6.1.1
OID	rdbmsDbName	1.3.6.1.2.1.39.1.1.1.4
OID	rdbmsDbInfoSizeUnits	1.3.6.1.2.1.39.1.2.1.3
OID	rdbmsDbInfoSizeAllocated	1.3.6.1.2.1.39.1.2.1.4
OID	rdbmsDbInfoSizeUsed	1.3.6.1.2.1.39.1.2.1.5
OID	rdbmsSrvInfoFinishedTransactions	1.3.6.1.2.1.39.1.6.1.2
OID	rdbmsSrvInfoDiskReads	1.3.6.1.2.1.39.1.6.1.3
OID	rdbmsSrvInfoLogicalReads	1.3.6.1.2.1.39.1.6.1.4
OID	rdbmsSrvInfoDiskWrites	1.3.6.1.2.1.39.1.6.1.5
OID	rdbmsSrvInfoLogicalWrites	1.3.6.1.2.1.39.1.6.1.6
OID	rdbmsSrvInfoPageReads	1.3.6.1.2.1.39.1.6.1.7
OID	rdbmsSrvInfoPageWrites	1.3.6.1.2.1.39.1.6.1.8
OID	rdbmsSrvInfoDiskOutOfSpaces	1.3.6.1.2.1.39.1.6.1.9
OID	rdbmsSrvInfoHandledRequests	1.3.6.1.2.1.39.1.6.1.10
OID	rdbmsSrvInfoRequestRecvs	1.3.6.1.2.1.39.1.6.1.11
OID	rdbmsSrvInfoRequestSends	1.3.6.1.2.1.39.1.6.1.12
OID	rdbmsSrvInfoHighwaterInboundAssociations	1.3.6.1.2.1.39.1.6.1.13
OID	rdbmsSrvInfoMaxInboundAssociations	1.3.6.1.2.1.39.1.6.1.14
OID	oraDbSysPhysReads	1.3.6.1.4.1.111.4.1.1.1.8
OID	oraDbSysPhysWrites	1.3.6.1.4.1.111.4.1.1.1.9
OID	oraDbSysTableScanBlocks	1.3.6.1.4.1.111.4.1.1.1.18
OID	oraDbSysTableScanRows	1.3.6.1.4.1.111.4.1.1.1.19
OID	oraDbSysTableScansLong	1.3.6.1.4.1.111.4.1.1.1.20
OID	oraDbSysTableScansShort	1.3.6.1.4.1.111.4.1.1.1.21
OID	oraDbTablespaceName	1.3.6.1.4.1.111.4.1.2.1.2
OID	oraDbTablespaceSizeAllocated	1.3.6.1.4.1.111.4.1.2.1.3
OID	oraDbTablespaceSizeUsed	1.3.6.1.4.1.111.4.1.2.1.4
OID	oraDbTablespaceLargestAvailableChunk	1.3.6.1.4.1.111.4.1.2.1.6
OID	oraDbDataFileName	1.3.6.1.4.1.111.4.1.3.1.2
OID	oraDbDataFileDiskReads	1.3.6.1.4.1.111.4.1.3.1.4
OID	oraDbDataFileDiskWrites	1.3.6.1.4.1.111.4.1.3.1.5
OID	oraDbDataFileDiskReadBlocks	1.3.6.1.4.1.111.4.1.3.1.6
OID	oraDbDataFileDiskWrittenBlocks	1.3.6.1.4.1.111.4.1.3.1.7
OID	oraDbDataFileDiskReadTimeTicks	1.3.6.1.4.1.111.4.1.3.1.8
OID	oraDbDataFileDiskWriteTimeTicks	1.3.6.1.4.1.111.4.1.3.1.9
OID	oraDbLibraryCacheNameSpace	1.3.6.1.4.1.111.4.1.4.1.2
OID	oraDbLibraryCacheGets	1.3.6.1.4.1.111.4.1.4.1.3
OID	oraDbLibraryCacheGetHits	1.3.6.1.4.1.111.4.1.4.1.4
OID	oraDbLibraryCachePins	1.3.6.1.4.1.111.4.1.4.1.5
OID	oraDbLibraryCachePinHits	1.3.6.1.4.1.111.4.1.4.1.6
OID	oraDbLibraryCacheReloads	1.3.6.1.4.1.111.4.1.4.1.7
OID	oraDbLibraryCacheInvalidations	1.3.6.1.4.1.111.4.1.4.1.8
OID	oraDbLibraryCacheSumGets	1.3.6.1.4.1.111.4.1.5.1.1
OID	oraDbLibraryCacheSumGetHits	1.3.6.1.4.1.111.4.1.5.1.2
OID	oraDbLibraryCacheSumPins	1.3.6.1.4.1.111.4.1.5.1.3
OID	oraDbLibraryCacheSumPinHits	1.3.6.1.4.1.111.4.1.5.1.4
OID	oraDbLibraryCacheSumReloads	1.3.6.1.4.1.111.4.1.5.1.5
OID	oraDbLibraryCacheSumInvalidations	1.3.6.1.4.1.111.4.1.5.1.6


map	sid
	base-oid	rdbmsDbName
	match		%sid%
map	table
	base-oid	oraDbTablespaceName
	match		%table%
map	datafile
	base-oid	oraDbDataFileName
	match		%datafile%
map	libcache
	base-oid	oraDbLibraryCacheNameSpace
	match		%libcache%


datasource	--default--
	rrd-ds-type	= COUNTER

datasource	rdbmsDbInfoSizeAllocated
	ds-source	= snmp://%snmp%/rdbmsDbInfoSizeAllocated.%inst%
	rrd-ds-type	= GAUGE
datasource	rdbmsDbInfoSizeUsed
	ds-source	= snmp://%snmp%/rdbmsDbInfoSizeUsed.%inst%
	rrd-ds-type	= GAUGE

datasource	rdbmsSrvInfoFinishedTransactions
	ds-source	= snmp://%snmp%/rdbmsSrvInfoFinishedTransactions.%inst%
datasource	rdbmsSrvInfoDiskReads
	ds-source	= snmp://%snmp%/rdbmsSrvInfoDiskReads.%inst%
datasource	rdbmsSrvInfoLogicalReads
	ds-source	= snmp://%snmp%/rdbmsSrvInfoLogicalReads.%inst%
datasource	rdbmsSrvInfoDiskWrites
	ds-source	= snmp://%snmp%/rdbmsSrvInfoDiskWrites.%inst%
datasource	rdbmsSrvInfoLogicalWrites
	ds-source	= snmp://%snmp%/rdbmsSrvInfoLogicalWrites.%inst%
datasource	rdbmsSrvInfoPageReads
	ds-source	= snmp://%snmp%/rdbmsSrvInfoPageReads.%inst%
datasource	rdbmsSrvInfoPageWrites
	ds-source	= snmp://%snmp%/rdbmsSrvInfoPageWrites.%inst%
datasource	rdbmsSrvInfoHandledRequests
	ds-source	= snmp://%snmp%/rdbmsSrvInfoHandledRequests.%inst%
datasource	rdbmsSrvInfoRequestRecvs
	ds-source	= snmp://%snmp%/rdbmsSrvInfoRequestRecvs.%inst%
datasource	rdbmsSrvInfoRequestSends
	ds-source	= snmp://%snmp%/rdbmsSrvInfoRequestSends.%inst%
datasource	rdbmsSrvInfoHighwaterInboundAssociations
	ds-source	= snmp://%snmp%/rdbmsSrvInfoHighwaterInboundAssociations.%inst%
	rrd-ds-type	= GAUGE
datasource	oraDbSysPhysReads
	ds-source	= snmp://%snmp%/oraDbSysPhysReads.%inst%
datasource	oraDbSysPhysWrites
	ds-source	= snmp://%snmp%/oraDbSysPhysWrites.%inst%
datasource	oraDbSysTableScanBlocks
	ds-source	= snmp://%snmp%/oraDbSysTableScanBlocks.%inst%
datasource	oraDbSysTableScanRows
	ds-source	= snmp://%snmp%/oraDbSysTableScanRows.%inst%
datasource	oraDbSysTableScansLong
	ds-source	= snmp://%snmp%/oraDbSysTableScansLong.%inst%
datasource	oraDbSysTableScansShort
	ds-source	= snmp://%snmp%/oraDbSysTableScansShort.%inst%

datasource	oraDbTablespaceSizeAllocated
	ds-source	= snmp://%snmp%/oraDbTablespaceSizeAllocated.%inst%
	rrd-ds-type	= GAUGE
datasource	oraDbTablespaceSizeUsed
	ds-source	= snmp://%snmp%/oraDbTablespaceSizeUsed.%inst%
	rrd-ds-type	= GAUGE
datasource	oraDbTablespaceLargestAvailableChunk
	ds-source	= snmp://%snmp%/oraDbTablespaceLargestAvailableChunk.%inst%
	rrd-ds-type	= GAUGE

datasource	oraDbDataFileDiskReads
	ds-source	= snmp://%snmp%/oraDbDataFileDiskReads.%inst%
datasource	oraDbDataFileDiskWrites
	ds-source	= snmp://%snmp%/oraDbDataFileDiskWrites.%inst%
datasource	oraDbDataFileDiskReadBlocks
	ds-source	= snmp://%snmp%/oraDbDataFileDiskReadBlocks.%inst%
datasource	oraDbDataFileDiskWrittenBlocks
	ds-source	= snmp://%snmp%/oraDbDataFileDiskWrittenBlocks.%inst%
datasource	oraDbDataFileDiskReadTimeTicks
	ds-source	= snmp://%snmp%/oraDbDataFileDiskReadTimeTicks.%inst%
datasource	oraDbDataFileDiskWriteTimeTicks
	ds-source	= snmp://%snmp%/oraDbDataFileDiskWriteTimeTicks.%inst%

datasource	oraDbLibraryCacheGets
	ds-source	= snmp://%snmp%/oraDbLibraryCacheGets.%inst%
datasource	oraDbLibraryCacheGetHits
	ds-source	= snmp://%snmp%/oraDbLibraryCacheGetHits.%inst%
datasource	oraDbLibraryCachePins
	ds-source	= snmp://%snmp%/oraDbLibraryCachePins.%inst%
datasource	oraDbLibraryCachePinHits
	ds-source	= snmp://%snmp%/oraDbLibraryCachePinHits.%inst%

datasource	oraDbLibraryCacheSumGets
	ds-source	= snmp://%snmp%/oraDbLibraryCacheSumGets.%inst%
datasource	oraDbLibraryCacheSumGetHits
	ds-source	= snmp://%snmp%/oraDbLibraryCacheSumGetHits.%inst%
datasource	oraDbLibraryCacheSumPins
	ds-source	= snmp://%snmp%/oraDbLibraryCacheSumPins.%inst%
datasource	oraDbLibraryCacheSumPinHits
	ds-source	= snmp://%snmp%/oraDbLibraryCacheSumPinHits.%inst%


TargetType	dbSize
	ds =	"rdbmsDbInfoSizeAllocated,
		rdbmsDbInfoSizeUsed"
	view =	"Total Storage Footprint:
		rdbmsDbInfoSizeAllocated
		rdbmsDbInfoSizeUsed"

TargetType	dbSrvActivity
	ds =	"rdbmsSrvInfoFinishedTransactions,
		rdbmsSrvInfoHandledRequests,
		rdbmsSrvInfoDiskReads,
		rdbmsSrvInfoLogicalReads,
		rdbmsSrvInfoDiskWrites,
		rdbmsSrvInfoLogicalWrites,
		rdbmsSrvInfoPageReads,
		rdbmsSrvInfoPageWrites,
		oraDbSysTableScanBlocks,
		oraDbSysTableScanRows,
		oraDbSysTableScansLong,
		oraDbSysTableScansShort"
	view =	"Transactions:
		rdbmsSrvInfoFinishedTransactions,
		Requests:
		rdbmsSrvInfoHandledRequests,
		Disk Activity:
		rdbmsSrvInfoDiskReads
		rdbmsSrvInfoDiskWrites
		rdbmsSrvInfoPageReads
		rdbmsSrvInfoPageWrites,
		Logical Activity:
		rdbmsSrvInfoLogicalReads
		rdbmsSrvInfoLogicalWrites,
		Table Scan Performance:
		oraDbSysTableScanBlocks
		oraDbSysTableScanRows,
		Table Scan Operations:
		oraDbSysTableScansLong
		oraDbSysTableScansShort"

TargetType	dbTableSpace
	ds =	"oraDbTablespaceSizeAllocated,
		oraDbTablespaceSizeUsed,
		oraDbTablespaceLargestAvailableChunk"
	view =	"TableSpace Utilization:
		oraDbTablespaceSizeAllocated
		oraDbTablespaceSizeUsed
		oraDbTablespaceLargestAvailableChunk"

TargetType	dbDatafile
	ds =	"oraDbDataFileDiskReads,
		oraDbDataFileDiskWrites,
		oraDbDataFileDiskReadBlocks,
		oraDbDataFileDiskWrittenBlocks,
		oraDbDataFileDiskReadTimeTicks,
		oraDbDataFileDiskWriteTimeTicks"
	view =	"I/O Operations:
		oraDbDataFileDiskReads
		oraDbDataFileDiskWrites,
		I/O Blocks:
		oraDbDataFileDiskReadBlocks
		oraDbDataFileDiskWrittenBlocks,
		I/O Duration:
		oraDbDataFileDiskReadTimeTicks
		oraDbDataFileDiskWriteTimeTicks"

TargetType	dbLibraryCache
	ds =	"oraDbLibraryCacheGets,
		oraDbLibraryCacheGetHits,
		oraDbLibraryCachePins,
		oraDbLibraryCachePinHits"
	view =	"Get Ratio:
		oraDbLibraryCacheGets
		oraDbLibraryCacheGetHits,
		Pin Ratio:
		oraDbLibraryCachePins
		oraDbLibraryCachePinHits"

TargetType	dbLibCacheSum
	ds =	"oraDbLibraryCacheSumGets,
		oraDbLibraryCacheSumGetHits,
		oraDbLibraryCacheSumPins,
		oraDbLibraryCacheSumPinHits"
	view =	"Get Ratio:
		oraDbLibraryCacheSumGets
		oraDbLibraryCacheSumGetHits,
		Pin Ratio:
		oraDbLibraryCacheSumPins
		oraDbLibraryCacheSumPinHits"


graph	rdbmsDbInfoSizeAllocated
	color	=	"blue"
	draw-as	=	LINE2
	units	=	"Bytes"
	legend	=	"Bytes Allocated"
	bytes	=	"true"
	scale	=	"1024,*"
	y-axis	=	"Bytes"
graph	rdbmsDbInfoSizeUsed
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"Bytes"
	legend	=	"Bytes Used"
	scale	=	"1024,*"
	bytes	=	"true"

graph	rdbmsSrvInfoFinishedTransactions
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"transactions"
	legend	=	"Transactions Finished"
	y-axis	=	"transactions"

graph	rdbmsSrvInfoHandledRequests
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"requests"
	legend	=	"Requests Handled"
	y-axis	=	"requests"

graph	rdbmsSrvInfoRequestRecvs
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"actions"
	legend	=	"Requests Received"
graph	rdbmsSrvInfoRequestSends
	color	=	"blue"
	draw-as	=	LINE2
	units	=	"actions"
	legend	=	"Requests Sent"
graph	rdbmsSrvInfoHighwaterInboundAssociations
	color	=	"red"
	draw-as	=	LINE2
	units	=	"actions"
	legend	=	"High water Received"

graph	rdbmsSrvInfoDiskReads
	color	=	"dark-green"
	units	=	"Operations"
	legend	=	"Disk Reads"
	y-axis	=	"Operations"
graph	rdbmsSrvInfoDiskWrites
	color	=	"dark-blue"
	units	=	"Operations"
	legend	=	"Disk Writes"
graph	rdbmsSrvInfoPageReads
	color	=	"green"
	units	=	"Operations"
	legend	=	"Page Reads"
graph	rdbmsSrvInfoPageWrites
	color	=	"blue"
	units	=	"Operations"
	legend	=	"Page Writes"

graph	rdbmsSrvInfoLogicalReads
	color	=	"dark-green"
	units	=	"Operations"
	legend	=	"Logical Reads"
	y-axis	=	"Operations"
graph	rdbmsSrvInfoLogicalWrites
	color	=	"blue"
	units	=	"Operations"
	legend	=	"Logical Writes"

graph	oraDbSysTableScanBlocks
	color	=	"blue"
	draw-as	=	LINE2
	units	=	"Scan Units"
	legend	=	"Blocks"
	y-axis	=	"Scan Units"
graph	oraDbSysTableScanRows
	color	=	"dark-green"
	draw-as	=	LINE2
	units	=	"Scan Units"
	legend	=	"Rows"

graph	oraDbSysTableScansLong
	color	=	"red"
	draw-as	=	LINE2
	units	=	"Scans"
	legend	=	"Long"
	y-axis	=	"Scans"
graph	oraDbSysTableScansShort
	color	=	"dark-green"
	draw-as	=	LINE2
	units	=	"Scans"
	legend	=	"Short"

graph	oraDbTablespaceSizeAllocated
	color	=	"blue"
	draw-as	=	LINE2
	units	=	"Bytes"
	legend	=	"Total Bytes Allocated"
	bytes	=	"true"
	scale	=	"1024,*"
	y-axis	=	"Bytes"
graph	oraDbTablespaceSizeUsed
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"Bytes"
	legend	=	"Bytes Used"
	bytes	=	"true"
	scale	=	"1024,*"
graph	oraDbTablespaceLargestAvailableChunk
	color	=	"red"
	draw-as	=	LINE2
	units	=	"Bytes"
	legend	=	"Largest Chunk Available"
	bytes	=	"true"
	scale	=	"1024,*"

graph	oraDbDataFileDiskReads
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"Operations"
	legend	=	"Reads"
	y-axis	=	"Operations"
graph	oraDbDataFileDiskWrites
	color	=	"red"
	draw-as	=	LINE2
	units	=	"Operations"
	legend	=	"Writes"

graph	oraDbDataFileDiskReadBlocks
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"Blocks"
	legend	=	"Reads"
	y-axis	=	"Blocks"
graph	oraDbDataFileDiskWrittenBlocks
	color	=	"blue"
	draw-as	=	LINE2
	units	=	"Blocks"
	legend	=	"Reads"

graph	oraDbDataFileDiskReadTimeTicks
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"Seconds"
	legend	=	"Reads"
	scale	=	"100,/"
	y-axis	=	"Seconds"
graph	oraDbDataFileDiskWriteTimeTicks
	color	=	"blue"
	draw-as	=	LINE2
	units	=	"Seconds"
	legend	=	"Reads"
	scale	=	"100,/"

graph	oraDbLibraryCacheGets
	color	=	"blue"
	draw-as	=	LINE2
	units	=	"Operations"
	legend	=	"Total Gets"
	y-axis	=	"Operations"
graph	oraDbLibraryCacheGetHits
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"Operations"
	legend	=	"Get Hits"

graph	oraDbLibraryCachePins
	color	=	"blue"
	draw-as	=	LINE2
	units	=	"Operations"
	legend	=	"Total Pins"
	y-axis	=	"Operations"
graph	oraDbLibraryCachePinHits
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"Operations"
	legend	=	"Pin Hits"

graph	oraDbLibraryCacheSumGets
	color	=	"blue"
	draw-as	=	LINE2
	units	=	"Operations"
	legend	=	"Total Gets"
	y-axis	=	"Operations"
graph	oraDbLibraryCacheSumGetHits
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"Operations"
	legend	=	"Get Hits"

graph	oraDbLibraryCacheSumPins
	color	=	"blue"
	draw-as	=	LINE2
	units	=	"Operations"
	legend	=	"Total Pins"
	y-axis	=	"Operations"
graph	oraDbLibraryCacheSumPinHits
	color	=	"dark-green"
	draw-as	=	AREA
	units	=	"Operations"
	legend	=	"Pin Hits"