SAP ABAP Table DB02N_DATA (Data to be displayed in new DB02N.)

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	DB02N_DATA	Table Relationship Diagram
Short Description	Data to be displayed in new DB02N.

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	DB_NAME	☐	DB02N_DB_NAME	ORA_CHAR_30	CHAR	30	0	Database name.
2	DB_SYSDATE	☐	DB02N_DB_SYSDATE	SYDATS	DATS	8	0	Database current date.
3	DB_SYSTIME	☐	DB02N_DB_SYSTIME	SYTIME	TIMS	6	0	Database Current time.
4	DB_ANALYD	☐	DB02N_DB_ANALYD	SYDATS	DATS	8	0	Database Last analysis date.
5	DB_ANALYT	☐	DB02N_DB_ANALYT	SYTIME	TIMS	6	0	Database Last analysis time.
6	DB_CREATDAT	☐	DB02N_DB_CREDAT	CHAR20	CHAR	20	0	Database creation date.
7	DB_SYSTEM	☐	DB02N_DB_SYSTEM	ORA_CHAR_20	CHAR	20	0	Oracle Monitoring: DB System
8	DB_SIZE	☐	DB02N_DB_SIZE	DB02N_NUMBER_15	DEC	15	2	Database size.(generic for Total, Free)
9	DB_TOT_PER_USED	☐	DB02N_TOT_PER_USED	DB02N_NUMBER_5	DEC	5	0	Database total percentage usage
10	DB_TOT_FREE	☐	DB02N_TOT_FREE	DB02N_NUMBER_15	DEC	15	2	Database total free size
11	DB_TOT_SIZE	☐	DB02N_TOT_SIZE	DB02N_NUMBER_15	DEC	15	2	Database total size
12	DB_FREE	☐	DB02N_DB_FREESIZE	DB02N_NUMBER_15	DEC	15	2	Database free space size.
13	DB_PER_USED	☐	DB02N_DB_USED	DB02N_NUMBER_5	DEC	5	0	Database usage percentage.
14	US_NUM	☐	DB02N_US_NBUSER	DB02N_NUMBER_5	DEC	5	0	Number of users.
15	US_MAX_SIZE	☐	DB02N_US_MAXSIZE	DB02N_NUMBER_15	DEC	15	2	Maximum size used by the corresponding user.
16	US_MAX_SIZE_WHO	☐	DB02N_US_MAXNME	CHAR30	CHAR	30	0	User that is using the maximum of it.
17	US_MAX_SEG	☐	DB02N_US_MAXSEG	DB02N_NUMBER_10	NUMC	10	0	Maximum number of segments used.
18	US_MAX_SEG_WHO	☐	DB02N_US_MAXSGWHO	CHAR30	CHAR	30	0	User that is using the maximum nbr of segments
19	TS_NUM	☐	DB02N_TS_NBTS	DB02N_NUMBER_5	DEC	5	0	Number of tablespaces.
20	TS_MAX_SIZE	☐	DB02N_TS_MAXSIZE	DB02N_NUMBER_15	DEC	15	2	Maximum tablespace size.
21	TS_MAX_SIZE_WHO	☐	DB02N_TS_MAXNM	CHAR30	CHAR	30	0	Biggest tablespace name.
22	TS_MIN_FREE	☐	DB02N_TS_FREESP	DB02N_NUMBER_15	DEC	15	2	Minimum free space not used by a corresponding tablespace.
23	TS_MIN_FREE_WHO	☐	DB02N_TS_FREESPNM	CHAR30	CHAR	30	0	The tablespace that has the minimum free space .
24	SE_TAB_NUM	☐	DB02N_SE_TAB_NUM	DB02N_INTNUM_15	DEC	15	0	Number of tables.
25	SE_TAB_SIZE	☐	DB02N_SE_TAB_SIZE_MB	DB02N_NUMBER_15	DEC	15	2	Size of tables in MB.
26	SE_TAB_NUM_M100	☐	DB02N_SE_TAB_NUM_M100	DB02N_INTNUM_15	DEC	15	0	Number of tables that have more than 100 extents.
27	SE_TAB_NUM_COMP	☐	DB02N_SE_TAB_NUM_COMP	DB02N_INTNUM_15	DEC	15	0	Number of tables that are compressed.
28	SE_TAB_NUM_NOLOG	☐	DB02N_SE_TAB_NUM_NOLOG	DB02N_INTNUM_15	DEC	15	0	Number of tables that have no-logging.
29	SE_TAB_NUM_CRIT	☐	DB02N_SE_TAB_NUM_CRIT	DB02N_INTNUM_15	DEC	15	0	Number of tables that are critical.
30	SE_TAB_NUM_M_DB	☐	DB02N_SE_TAB_NUM_M_DB	DB02N_INTNUM_15	DEC	15	0	Number of tables that are missing in DB.
31	SE_TAB_NUM_M_R3	☐	DB02N_SE_TAB_NUM_M_R3	DB02N_INTNUM_15	DEC	15	0	Number of tables that are missing in ABAP Dictionary.
32	SE_IND_NUM	☐	DB02N_SE_IND_NUM	DB02N_INTNUM_15	DEC	15	0	Number of indexes.
33	SE_IND_SIZE	☐	DB02N_SE_IND_SIZE_MB	DB02N_NUMBER_15	DEC	15	2	Size of indexes in MB.
34	SE_IND_NUM_M100	☐	DB02N_SE_IND_NUM_M100	DB02N_INTNUM_15	DEC	15	0	Number of indexes that have more than 100 extents.
35	SE_IND_NUM_COMP	☐	DB02N_SE_IND_NUM_COMP	DB02N_INTNUM_15	DEC	15	0	Number of indexes that are compressed.
36	SE_IND_NUM_NOLOG	☐	DB02N_SE_IND_NUM_NOLOG	DB02N_INTNUM_15	DEC	15	0	Number of indexes that have no-logging.
37	SE_IND_NUM_CRIT	☐	DB02N_SE_IND_NUM_CRIT	DB02N_INTNUM_15	DEC	15	0	Number of indexes that are critical.
38	SE_IND_NUM_M_DB	☐	DB02N_SE_IND_NUM_M_DB	DB02N_INTNUM_15	DEC	15	0	Number of indexes that are missing in DB.
39	SE_IND_NUM_M_R3	☐	DB02N_SE_IND_NUM_M_R3	DB02N_INTNUM_15	DEC	15	0	Number of indexes that are missing in ABAP Dictionary.
40	SE_OTH_NUM	☐	DB02N_SE_OTH_NUM	DB02N_INTNUM_15	DEC	15	0	Number of other segments.
41	SE_OTH_SIZE	☐	DB02N_SE_OTH_SIZE_MB	DB02N_NUMBER_15	DEC	15	2	Size of other segments in MB.
42	SE_OTH_NUM_M100	☐	DB02N_SE_OTH_NUM_M100	DB02N_INTNUM_15	DEC	15	0	Number of other segments that have more than 100 extents.
43	SE_OTH_NUM_COMP	☐	DB02N_SE_OTH_NUM_COMP	DB02N_INTNUM_15	DEC	15	0	Number of other segments that are compressed.
44	SE_OTH_NUM_NOLOG	☐	DB02N_SE_OTH_NUM_NOLOG	DB02N_INTNUM_15	DEC	15	0	Number of other objects that have no-logging.
45	SE_OTH_NUM_CRIT	☐	DB02N_SE_OTH_NUM_CRIT	DB02N_INTNUM_15	DEC	15	0	Number of other segments that are critical.
46	SE_OTH_NUM_M_DB	☐	DB02N_SE_OTH_NUM_M_DB	DB02N_INTNUM_15	DEC	15	0	Number of other segments that are missing in DB.
47	SE_OTH_NUM_M_R3	☐	DB02N_SE_OTH_NUM_M_R3	DB02N_INTNUM_15	DEC	15	0	Number of other segments that are missing in ABAP Dictionary
48	SE_TOT_NUM	☐	DB02N_SE_TOT_NUM	DB02N_INTNUM_15	DEC	15	0	Number of All segments.
49	SE_TOT_SIZE	☐	DB02N_SE_TOT_SIZE_MB	DB02N_NUMBER_15	DEC	15	2	Size of other segments in MB.
50	SE_TOT_NUM_M100	☐	DB02N_SE_TOT_NUM_M100	DB02N_INTNUM_15	DEC	15	0	Number of all segments that have more than 100 extents.
51	SE_TOT_NUM_COMP	☐	DB02N_SE_TOT_NUM_COMP	DB02N_INTNUM_15	DEC	15	0	Number of all segments that are compressed.
52	SE_TOT_NUM_NOLOG	☐	DB02N_SE_TOT_NUM_NOLOG	DB02N_INTNUM_15	DEC	15	0	Number of all objects that have no-logging.
53	SE_TOT_NUM_CRIT	☐	DB02N_SE_TOT_NUM_CRIT	DB02N_INTNUM_15	DEC	15	0	Number of all segments that are critical.
54	SE_TOT_NUM_M_DB	☐	DB02N_SE_TOT_NUM_M_DB	DB02N_INTNUM_15	DEC	15	0	Number of all segments that are missing in DB.
55	SE_TOT_NUM_M_R3	☐	DB02N_SE_TOT_NUM_M_R3	DB02N_INTNUM_15	DEC	15	0	Number of all segments that are missing in ABAP Dictionary.

History

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