SAP ABAP Table STR_TEMPFILE (Oracle monitoring: structure for V$TEMPFILE.)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Basic Data

Table Category	INTTAB	Structure
Structure	STR_TEMPFILE	Table Relationship Diagram
Short Description	Oracle monitoring: structure for V$TEMPFILE.

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	FILE_NUM	☐	ORA_FILE_NUM	ORA_NUM_22	DEC	22	0	Oracle monitor: File#
2	CREATION_CHG_NUM	☐	ORA_CREATION_CHG_NUM	ORA_NUM_22	DEC	22	0	Oracle monitor: Cretaion change number
3	CREATION_TIME_D	☐	ORA_CREAT_TIME_D	ORA_DATE	DATS	8	0	Oracle monitor: Creation time (date)
4	CREATION_TIME_T	☐	ORA_CREAT_TIME_T	ORA_TIME	TIMS	6	0	Oracle monitor: Creation time
5	TS_NUM	☐	ORA_TS_NUM	ORA_NUM_22	DEC	22	0	Oracle monitor: TS#
6	RFILE_NUM	☐	ORA_RFILE_NUM	ORA_NUM_22	DEC	22	0	Oracle monitor: RFILE NUMBER
7	STATUS	☐	ORA_STATUS_TMPFILE	ORA_CHAR_7	CHAR	7	0	Oracle monitoring: Current status temp. file
8	ENABLED	☐	ORA_ENEBLED	ORA_CHAR_10	CHAR	10	0	Oracle monitor: Gtemp. File ENABLED
9	BYTES	☐	ORA_BYTES	ORA_SVALUE	DEC	22	0	Oracle monitoring: BYTES: Memory size in bytes
10	BLOCKS	☐	ORA_BLOCKS	ORA_DEC_22	DEC	22	0	Oracle monitoring: Size of the archived redo log in 512-byte
11	CREATE_BYTES	☐	ORA_CREATE_BYTES	ORA_NUM_22	DEC	22	0	Oracle monitor: CREATE BYTES
12	BLOCK_SIZE	☐	ORA_BLOCK_SIZE	ORA_NUM_22	DEC	22	0	Oracle monitor: BLOCK SIZE
13	NAME_LENGTH	☐	ORA_TEXT_LENGTH	ORA_LCHAR_LENGTH	INT4	10	0	Oracle Monitoring: Field to store length of long char types
14	NAME	☐	ORA_TMPFIL_NAME	ORA_CHAR_513	LCHR	513	0	Oracle Monitoring: Temp file name

History

Last changed by/on	SAP	20070813
SAP Release Created in	700