eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: SYS.APPLY$_BATCH_SQL_STATS

Object Details

Object Name:	APPLY$_BATCH_SQL_STATS
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	SYSTEM
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
APPLY$_BATCH_SQL_STATS_I	NORMAL	NONUNIQUE	SYSTEM	APPLY# SERVER_ID SAVE_TIME

Columns

Name	Datatype	Length
APPLY#	NUMBER
SAVE_TIME	DATE
SERVER_ID	NUMBER
BATCH_OPEATIONS	NUMBER
BATCHES	NUMBER
BATCHES_EXECUTED	NUMBER
QUEUES	NUMBER
BATCHES_IN_ERROR	NUMBER
NORMAL_MODE_OPS	NUMBER
IMMEDIATE_FLUSH_OPS	NUMBER
PK_COLLISIONS	NUMBER
UK_COLLISIONS	NUMBER
FK_COLLISIONS	NUMBER
THREAD_BATCH_GROUPS	NUMBER
NUM_COMMITS	NUMBER
NUM_ROLLBACKS	NUMBER
QUEUE_FLUSH_CALLS	NUMBER
OPS_PER_BATCH	NUMBER
OPS_PER_BATCH_EXECUTED	NUMBER
OPS_PER_QUEUE	NUMBER
PARALLEL_BATCH_RATE	NUMBER
SPARE1	NUMBER
SPARE2	NUMBER
SPARE3	NUMBER
SPARE4	NUMBER
SPARE5	NUMBER
SPARE6	NUMBER
SPARE7	NUMBER
SPARE8	NUMBER
SPARE9	NUMBER
SPARE10	NUMBER
SPARE11	NUMBER
SPARE12	NUMBER
SPARE13	NUMBER
SPARE14	NUMBER
SPARE15	NUMBER
SPARE16	VARCHAR2	(4000)
SPARE17	VARCHAR2	(4000)
SPARE18	VARCHAR2	(4000)
SPARE19	VARCHAR2	(4000)
SPARE20	RAW	(1000)
SPARE21	RAW	(1000)
SPARE22	RAW	(1000)
SPARE23	DATE
SPARE24	DATE
SPARE25	DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLY#
,      SAVE_TIME
,      SERVER_ID
,      BATCH_OPEATIONS
,      BATCHES
,      BATCHES_EXECUTED
,      QUEUES
,      BATCHES_IN_ERROR
,      NORMAL_MODE_OPS
,      IMMEDIATE_FLUSH_OPS
,      PK_COLLISIONS
,      UK_COLLISIONS
,      FK_COLLISIONS
,      THREAD_BATCH_GROUPS
,      NUM_COMMITS
,      NUM_ROLLBACKS
,      QUEUE_FLUSH_CALLS
,      OPS_PER_BATCH
,      OPS_PER_BATCH_EXECUTED
,      OPS_PER_QUEUE
,      PARALLEL_BATCH_RATE
,      SPARE1
,      SPARE2
,      SPARE3
,      SPARE4
,      SPARE5
,      SPARE6
,      SPARE7
,      SPARE8
,      SPARE9
,      SPARE10
,      SPARE11
,      SPARE12
,      SPARE13
,      SPARE14
,      SPARE15
,      SPARE16
,      SPARE17
,      SPARE18
,      SPARE19
,      SPARE20
,      SPARE21
,      SPARE22
,      SPARE23
,      SPARE24
,      SPARE25
FROM SYS.APPLY$_BATCH_SQL_STATS;

Dependencies

[top of page]

SYS.APPLY$_BATCH_SQL_STATS does not reference any database object

SYS.APPLY$_BATCH_SQL_STATS is referenced by following:

SYS: _DBA_APPLY_BATCH_SQL_STATS