SAP ABAP Domain ORA_EM_SVPAWRI_DSOURCE (Datasource for SVPAWRI: Aggregate By)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_ORA_COCKPIT (Package) DBACockpit: Oracle Monitors

Basic Data

Domain Name	ORA_EM_SVPAWRI_DSOURCE
Short Description	Datasource for SVPAWRI: Aggregate By

Definition

Data Type	CHAR	Character String
No. Characters	40
Decimal Places
Output Length	40
Conversion Routine
Sign	☐
Lower Case	☐

Value Range

#	Lower Limit	Upper Limit	Short Description
1	1		consistent gets - examination
2	2		DBWR checkpoints
3	3		gc kbytes saved
4	4		session uga memory
5	5		gc claim blocks lost
6	6		LOB table id lookup cache misses
7	7		securefile allocation chunks
8	8		CC Total Columns for Decompression
9	9		hot buffers moved to head of LRU
10	10		Workload Capture: size (in bytes) of recording
11	11		HSC OLTP Compressed Blocks
12	12		redo entries for lost write detection
13	13		prefetch warmup blocks flushed out before use
14	14		commit batch requested
15	15		java call heap collected count
16	16		PX remote messages recv'd
17	17		securefile dedup flush too low
18	18		enqueue releases
19	19		physical reads direct (lob)
20	20		index crx upgrade (positioned)
21	21		buffer is not pinned count
22	22		DFO trees parallelized
23	23		index fetch by key
24	24		user calls
25	25		cell smart IO session cache soft misses
26	26		cell CUs sent compressed
27	27		physical write IO requests
28	28		commit cleanouts
29	29		java call heap live object count max
30	30		bytes sent via SQL*Net to client
31	31		cell physical IO bytes eligible for predicate offload
32	32		segment prealloc tasks
33	33		rows fetched via callback
34	34		active txn count during cleanout
35	35		Batched IO single block count
36	36		CC Total Pieces for Decompression
37	37		java call heap object count
38	38		redo entries
39	39		rollback changes - undo records applied
40	40		lob reads
41	41		gc local grants
42	42		CC Query Low CUs Compressed
43	43		securefile inode ioreap time
44	44		global enqueue get time
45	45		deferred CUR cleanouts (index blocks)
46	46		redo size for lost write detection
47	47		consistent changes
48	48		queue ocp pages
49	49		DBWR thread checkpoint buffers written
50	50		java session heap collected bytes
51	51		transaction lock background gets
52	52		recursive cpu usage
53	53		Effective IO time
54	54		calls to kcmgrs
55	55		enqueue conversions
56	56		IMU undo allocation size
57	57		HSC OLTP negative compression
58	58		cell smart IO session cache hits
59	59		redo k-bytes read (memory)
60	60		cell blocks processed by index layer
61	61		CC Query High CUs Compressed
62	62		consistent gets direct
63	63		parse count (describe)
64	64		table fetch by rowid
65	65		doubling up with imu segment
66	66		commit cleanout failures: block lost
67	67		securefile dedup fits inline
68	68		session stored procedure space
69	69		db block changes
70	70		No. of Namespaces Created
71	71		cleanouts and rollbacks - consistent read gets
72	72		cell scans
73	73		cell CUs processed for compressed
74	74		redo size
75	75		global enqueue gets sync
76	76		gc remote grants
77	77		table fetch continued row
78	78		CC Rowid CUs Decompressed
79	79		java session heap used size max
80	80		CC Scan CUs Decompressed
81	81		gc cr block receive time
82	82		native hash arithmetic fail
83	83		redo log space requests
84	84		process last non-idle time
85	85		IMU Flushes
86	86		IMU CR rollbacks
87	87		securefile inode write time
88	88		heap block compress
89	89		prefetch clients - 32k
90	90		physical read requests optimized
91	91		commit cleanout failures: hot backup in progress
92	92		flash cache insert skip: corrupt
93	93		DBWR revisited being-written buffer
94	94		gc cr blocks received
95	95		cell flash cache read hits
96	96		cell physical IO interconnect bytes
97	97		recovery array read time
98	98		securefile uncompressed bytes
99	99		background checkpoints started
100	100		cell physical IO interconnect bytes returned by smart scan
101	101		Batched IO (full) vector count
102	102		bytes via SQL*Net vector from dblink
103	103		securefile direct write bytes
104	104		RowCR hits
105	105		Workload Capture: dbtime
106	106		CC Compressed Length Decompressed
107	107		DB time
108	108		user rollbacks
109	109		sorts (rows)
110	110		session uga memory max
111	111		Number of read IOs issued
112	112		cell CUs sent head piece
113	113		transaction lock foreground wait time
114	114		cursor authentications
115	115		table scans (cache partitions)
116	116		bytes received via SQL*Net from client
117	117		redo log space wait time
118	118		cell num smart IO sessions in rdbms block IO due to big payl
119	119		native hash arithmetic execute
120	120		gc current blocks received
121	121		cell physical IO bytes saved during optimized file creation
122	122		total number of times SMON posted
123	123		securefile dedup hash collision
124	124		CC CU Row Pieces Compressed
125	125		gc blocks lost
126	126		physical reads retry corrupt
127	127		DX/BB enqueue lock foreground requests
128	128		java call heap total size max
129	129		java call heap used size max
130	130		commit batch/immediate requested
131	131		root node splits
132	132		GTX processes spawned by autotune
133	133		cell num smart IO sessions in rdbms block IO due to user
134	134		Batched IO slow jump count
135	135		CC Query High CUs Decompressed
136	136		physical writes direct temporary tablespace
137	137		Workload Capture: user calls
138	138		cell blocks processed by cache layer
139	139		No. of Roles Enabled or Disabled
140	140		PX local messages recv'd
141	141		redo synch writes
142	142		global enqueue releases
143	143		index fast full scans (rowid ranges)
144	144		CC CUs Compressed
145	145		java call heap object count max
146	146		java session heap live size max
147	147		segment chunks allocation from disepnser
148	148		DBWR lru scans
149	149		RowCR attempts
150	150		opened cursors current
151	151		enqueue waits
152	152		redo blocks written
153	153		Commit SCN cached
154	154		bytes via SQL*Net vector from client
155	155		Batched IO (bound) vector count
156	156		queue single row
157	157		CC Check CUs Decompressed
158	158		consistent gets from cache
159	159		global enqueue gets async
160	160		physical reads prefetch warmup
161	161		flashback log writes
162	162		prefetch clients - 4k
163	163		flash cache insert skip: exists
164	164		global undo segment hints were stale
165	165		user I/O wait time
166	166		gc kbytes sent
167	167		cell simulated session smart scan efficiency
168	168		transaction lock background get time
169	169		Clusterwide global transactions spanning RAC nodes
170	170		SMON posted for dropping temp segment
171	171		flash cache insert skip: not useful
172	172		flash cache eviction: invalidated
173	173		total cf enq hold time
174	174		session cursor cache hits
175	175		securefile bytes cleartext
176	176		table scan blocks gotten
177	177		java session heap collected count
178	178		workarea executions - multipass
179	179		gc reader bypass grants
180	180		securefile bytes non-transformed
181	181		transaction rollbacks
182	182		securefile inode read time
183	183		prefetch clients - recycle
184	184		consistent gets
185	185		physical reads cache
186	186		CC Analyze CUs Decompressed
187	187		securefile dedup prefix hash match
188	188		No. of XS Sessions Created
189	189		opened cursors cumulative
190	190		cell CUs processed for uncompressed
191	191		db block gets direct
192	192		tune down retentions in space pressure
193	193		transaction lock foreground requests
194	194		parse time cpu
195	195		java session heap live object count
196	196		temp space allocated (bytes)
197	197		physical reads cache prefetch
198	198		securefile create dedup set
199	199		number of map operations
200	200		prefetch clients - 2k
201	201		segment prealloc ufs2cfs bytes
202	202		index reclamation/extension switch
203	203		prefetch clients - keep
204	204		OS CPU Qt wait time
205	205		cell num smart IO sessions using passthru mode due to cellsr
206	206		Block Cleanout Optim referenced
207	207		CCursor + sql area evicted
208	208		CC Decompressed Length Compressed
209	209		frame signature mismatch
210	210		max cf enq hold time
211	211		local undo segment hints helped
212	212		cell commit cache queries
213	213		RowCR - row contention
214	214		leaf node 90-10 splits
215	215		CC Dump CUs Decompressed
216	216		commit batch performed
217	217		table scan rows gotten
218	218		DX/BB enqueue lock background get time
219	219		redo buffer allocation retries
220	220		undo change vector size
221	221		TBS Extension: tasks created
222	222		cell num smart IO sessions using passthru mode due to timezo
223	223		physical read flash cache hits
224	224		session connect time
225	225		cluster key scan block gets
226	226		commit cleanout failures: write disabled
227	227		scheduler wait time
228	228		physical reads
229	229		Heap Segment Array Updates
230	230		java call heap gc count
231	231		HSC IDL Compressed Blocks
232	232		java call heap live size
233	233		physical write total bytes
234	234		CC Total Rows for Decompression
235	235		non-idle wait time
236	236		physical reads direct
237	237		physical writes non checkpoint
238	238		recovery array reads
239	239		HSC OLTP compression block checked
240	240		cell num smart file creation sessions using rdbms block IO m
241	241		physical reads direct temporary tablespace
242	242		gcs messages sent
243	243		no work - consistent read gets
244	244		commit wait requested
245	245		IMU contention
246	246		logons current
247	247		segemnt dispenser load empty
248	248		redo k-bytes read total
249	249		physical write bytes
250	250		rollbacks only - consistent read gets
251	251		auto extends on undo tablespace
252	252		Workload Capture: unreplayable user calls
253	253		physical writes direct (lob)
254	254		recovery blocks read
255	255		deferred (CURRENT) block cleanout applications
256	256		free buffer requested
257	257		HSC OLTP Compression skipped rows
258	258		redo wastage
259	259		commit immediate performed
260	260		flash cache insert skip: DBWR overloaded
261	261		no buffer to keep pinned count
262	262		physical write total multi block requests
263	263		securefile allocation bytes
264	264		OTC commit optimization failure - setup
265	265		commit batch/immediate performed
266	266		Batched IO (space) vector count
267	267		cell simulated physical IO bytes eligible for predicate offl
268	268		redo k-bytes read (memory) by LNS
269	269		steps of tune down ret. in space pressure
270	270		SMON posted for instance recovery
271	271		OTC commit optimization hits
272	272		java session heap object count
273	273		gc CPU used by this session
274	274		DDL statements parallelized
275	275		flash cache insert skip: modification
276	276		session pga memory
277	277		write clones created in foreground
278	278		IPC CPU used by this session
279	279		Parallel operations downgraded to serial
280	280		parse count (total)
281	281		physical writes from cache
282	282		total number of cf enq holders
283	283		segment prealloc time (ms)
284	284		CC Decompressed Length Decompressed
285	285		Batched IO block miss count
286	286		commit nowait performed
287	287		PX local messages sent
288	288		CPU used when call started
289	289		java call heap live object count
290	290		cold recycle reads
291	291		IMU pool not allocated
292	292		spare statistic 3
293	293		securefile number of flushes
294	294		bytes via SQL*Net vector to client
295	295		Batched IO vector block count
296	296		commit immediate requested
297	297		background timeouts
298	298		flashback log write bytes
299	299		HSC OLTP positive compression
300	300		CC Query Low CUs Decompressed
301	301		transaction tables consistent reads - undo records applied
302	302		Workload Capture: errors
303	303		java call heap live size max
304	304		cell blocks skipped due to chained rows
305	305		gc current block receive time
306	306		prefetch clients - 8k
307	307		No. of Principal Cache Misses
308	308		drop segment calls in space pressure
309	309		commit wait/nowait performed
310	310		index fast full scans (direct read)
311	311		flash cache insert skip: not current
312	312		Batched IO double miss count
313	313		IMU commits
314	314		cell simulated physical IO bytes returned by predicate offlo
315	315		redo ordering marks
316	316		redo write broadcast ack count
317	317		cell blocks helped by commit cache
318	318		Workload Replay: deadlocks resolved
319	319		cleanout - number of ktugct calls
320	320		IMU recursive-transaction flush
321	321		remote Oradebug requests
322	322		HSC OLTP inline compression
323	323		recovery blocks read for lost write detection
324	324		failed probes on index block reclamation
325	325		Misses for writing mapping
326	326		pinned cursors current
327	327		Workload Replay: network time
328	328		min active SCN optimization applied on CR
329	329		segment dispenser allocations
330	330		recursive aborts on index block reclamation
331	331		commit cleanout failures: callback failure
332	332		workarea executions - optimal
333	333		securefile direct read ops
334	334		Parallel operations downgraded 50 to 75 pct
335	335		table scans (direct read)
336	336		CC Columns Decompressed
337	337		index scans kdiixs1
338	338		IMU mbu flush
339	339		DML statements parallelized
340	340		CC Pieces Buffered for Decompression
341	341		db corrupt blocks recovered
342	342		concurrency wait time
343	343		segment cfs allocations
344	344		write clones created for recovery
345	345		Clusterwide global transactions
346	346		TBS Extension: bytes extended
347	347		cell smart IO session cache lookups
348	348		TBS Extension: files extended
349	349		segment prealloc bytes
350	350		segment prealloc ops
351	351		undo segment header was pinned
352	352		gc cr block build time
353	353		HSC Compressed Segment Block Changes
354	354		Workload Replay: user calls
355	355		recovery blocks skipped lost write checks
356	356		redo size for direct writes
357	357		HSC OLTP Space Saving
358	358		shared io pool buffer get failure
359	359		No. of Decrypt ops
360	360		ges messages sent
361	361		DBWR checkpoint buffers written
362	362		commit txn count during cleanout
363	363		bytes sent via SQL*Net to dblink
364	364		commit cleanout failures: buffer being written
365	365		java session heap used size
366	366		summed dirty queue length
367	367		global undo segment hints helped
368	368		serializable aborts
369	369		cell num smart IO sessions using passthru mode due to user
370	370		bytes received via SQL*Net from dblink
371	371		local undo segment hints were stale
372	372		IMU undo retention flush
373	373		sorts (memory)
374	374		DBWR transaction table writes
375	375		Workload Capture: unsupported user calls
376	376		gc blocks corrupt
377	377		DX/BB enqueue lock background gets
378	378		enqueue requests
379	379		securefile reject deduplication
380	380		DBWR tablespace checkpoint buffers written
381	381		recursive calls
382	382		redo blocks read for recovery
383	383		sql area purged
384	384		CC Archive CUs Compressed
385	385		flash cache inserts
386	386		cell smart IO session cache hwm
387	387		flash cache eviction: buffer pinned
388	388		current blocks converted for CR
389	389		queue flush
390	390		cell blocks processed by txn layer
391	391		shared hash latch upgrades - wait
392	392		cell index scans
393	393		CC Archive CUs Decompressed
394	394		commit cleanouts successfully completed
395	395		number of map misses
396	396		total number of undo segments dropped
397	397		securefile bytes deduplicated
398	398		securefile dedup callback oper final
399	399		IMU Redo allocation size
400	400		file io service time
401	401		CC Turbo Scan CUs Decompressed
402	402		calls to kcmgas
403	403		gc current block flush time
404	404		securefile number of non-transformed flushes
405	405		cell CUs sent uncompressed
406	406		redo synch time
407	407		lob writes unaligned
408	408		exchange deadlocks
409	409		gc current blocks served
410	410		immediate CR cleanouts (index blocks)
411	411		parse count (hard)
412	412		securefile compressed bytes
413	413		cell session smart scan efficiency
414	414		commit cleanout failures: cannot pin
415	415		java call heap used size
416	416		spare statistic 1
417	417		cell blocks processed by data layer
418	418		securefile rmv from dedup set
419	419		cell transactions found in commit cache
420	420		Parallel operations downgraded 75 to 99 pct
421	421		table scans (short tables)
422	422		redo blocks checksummed by FG (exclusive)
423	423		redo k-bytes read for recovery
424	424		Workload Replay: dbtime
425	425		CC DML CUs Decompressed
426	426		java session heap object count max
427	427		physical reads for flashback new
428	428		CR blocks created
429	429		CC CUs Decompressed
430	430		SMON posted for undo segment shrink
431	431		securefile direct read bytes
432	432		cell blocks helped by minscn optimization
433	433		physical read IO requests
434	434		prefetch clients - 16k
435	435		workarea executions - onepass
436	436		db block gets from cache (fastpath)
437	437		gc cr blocks served
438	438		No. of Principal Invalidations
439	439		securefile direct write ops
440	440		Batched IO same unit count
441	441		physical writes
442	442		redo write broadcast ack time
443	443		Workload Capture: user logins
444	444		dirty buffers inspected
445	445		leaf node splits
446	446		parse time elapsed
447	447		Heap Segment Array Inserts
448	448		Batched IO zero block count
449	449		DBWR parallel query checkpoint buffers written
450	450		index crx upgrade (prefetch)
451	451		redo blocks checksummed by LGWR
452	452		TBS Extension: tasks executed
453	453		redo k-bytes read total by LNS
454	454		physical read total multi block requests
455	455		redo k-bytes read for terminal recovery
456	456		SMON posted for undo segment recovery
457	457		Workload Replay: time loss
458	458		Workload Capture: user calls flushed
459	459		cell physical IO bytes saved by storage index
460	460		java session heap live size
461	461		DBWR fusion writes
462	462		Parallel operations not downgraded
463	463		IMU- failed to get a private strand
464	464		enqueue timeouts
465	465		cluster wait time
466	466		workarea memory allocated
467	467		background checkpoints completed
468	468		execute count
469	469		OTC commit optimization attempts
470	470		messages sent
471	471		PX remote messages sent
472	472		lob writes
473	473		gc current block send time
474	474		IMU bind flushes
475	475		cleanouts only - consistent read gets
476	476		data blocks consistent reads - undo records applied
477	477		shared io pool buffer get success
478	478		write clones created in background
479	479		queue qno pages
480	480		Workload Capture: user txns
481	481		redo write time
482	482		calls to get snapshot scn: kcmgss
483	483		session logical reads
484	484		flash cache eviction: aged out
485	485		queries parallelized
486	486		immediate (CR) block cleanout applications
487	487		Parallel operations downgraded 25 to 50 pct
488	488		java session heap gc count
489	489		No. of Encrypt ops
490	490		recovery block gets from cache
491	491		spare statistic 4
492	492		cluster key scans
493	493		Batched IO buffer defrag count
494	494		commit nowait requested
495	495		Parallel operations downgraded 1 to 25 pct
496	496		commit wait/nowait requested
497	497		Batched IO vector read count
498	498		db block gets from cache
499	499		Workload Replay: think time
500	500		index fast full scans (full)
501	501		CPU used by this session
502	502		non-idle wait count
503	503		HSC OLTP recursive compression
504	504		DBWR undo block writes
505	505		bytes via SQL*Net vector to dblink
506	506		gc current block pin time
507	507		GTX processes stopped by autotune
508	508		enqueue deadlocks
509	509		physical read bytes
510	510		queue update without cp update
511	511		gc cr block flush time
512	512		HSC OLTP Drop Column
513	513		session cursor cache count
514	514		DBWR object drop buffers written
515	515		pinned buffers inspected
516	516		space was not found by tune down
517	517		free buffer inspected
518	518		securefile destroy dedup set
519	519		db corrupt blocks detected
520	520		application wait time
521	521		cell IO uncompressed bytes
522	522		CC Compressed Length Compressed
523	523		SMON posted for txn recovery for other instances
524	524		table scans (rowid ranges)
525	525		switch current to new buffer
526	526		physical write total IO requests
527	527		cell physical IO bytes saved during optimized RMAN file rest
528	528		CC Analyzer Calls
529	529		db block gets
530	530		java call heap total size
531	531		DX/BB enqueue lock foreground wait time
532	532		redo writes
533	533		consistent gets from cache (fastpath)
534	534		total number of slots
535	535		Cached Commit SCN referenced
536	536		gc cr block send time
537	537		SQL*Net roundtrips to/from dblink
538	538		shared hash latch upgrades - no wait
539	539		sorts (disk)
540	540		queue position update
541	541		physical read total bytes
542	542		RowCR - resume
543	543		logons cumulative
544	544		immediate (CURRENT) block cleanout applications
545	545		physical writes direct
546	546		calls to kcmgcs
547	547		securefile bytes encrypted
548	548		change write time
549	549		segment dispenser load tasks
550	550		No. of User Callbacks Executed
551	551		sql area evicted
552	552		prefetch warmup blocks aged out before use
553	553		cell smart IO session cache hard misses
554	554		CC Rows Not Compressed
555	555		physical read total IO requests
556	556		global enqueue CPU used by this session
557	557		gc blocks compressed
558	558		java call heap collected bytes
559	559		java session heap live object count max
560	560		spare statistic 2
561	561		Forwarded 2PC commands across RAC nodes
562	562		gc cr block read wait time
563	563		commit wait performed
564	564		SQL*Net roundtrips to/from client
565	565		HSC OLTP Non Compressible Blocks
566	566		segment total chunk allocation
567	567		space was found by tune down
568	568		branch node splits
569	569		HSC Heap Segment Block Changes
570	570		securefile add dedupd lob to set
571	571		redo subscn max counts
572	572		session pga memory max
573	573		user commits
574	574		CC Rows Compressed
575	575		recursive system API invocations
576	576		Workload Replay: time gain
577	577		table scans (long tables)
578	578		parse count (failures)
579	579		queue splits
580	580		IMU ktichg flush
581	581		No. of XS Sessions Attached
582	582		file io wait time
583	583		buffer is pinned count
584	584		messages received
585	585		transaction tables consistent read rollbacks
586	586		index crx upgrade (found)
587	587		prefetched blocks aged out before use
588	588		prefetch clients - default

History

Last changed by/on	SAP	20141013
SAP Release Created in	740