Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

ORA_S_ST04_MAIN_DATA SAP (DBACockpit: Oracle Performance Main Data) Structure details

Dictionary Type: Structure
Description: DBACockpit: Oracle Performance Main Data

ABAP Code to SELECT data from ORA_S_ST04_MAIN_DATA
Related tables to ORA_S_ST04_MAIN_DATA
Access table ORA_S_ST04_MAIN_DATA

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

Structure field list including key, data, relationships and ABAP select examples

ORA_S_ST04_MAIN_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DBACockpit: Oracle Performance Main Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_ORA_S_ST04_MAIN_DATA TYPE ORA_S_ST04_MAIN_DATA.

The ORA_S_ST04_MAIN_DATA table consists of various fields, each holding specific information or linking keys about DBACockpit: Oracle Performance Main Data data available in SAP. These include DB_INST_ID (Instance ID), DB_INSTANCE (Name of the current database instance), DB_NODE (Current Database node (host name)), DB_RELEASE (Database release).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP ORA_S_ST04_MAIN_DATA structure fields - Full list of fields found in SAP data dictionary

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
DB_INST_ID	Instance ID	ST04N_DB_INST_ID	DEC	22			ORA_INST_ID
DB_INSTANCE	Name of the current database instance	ST04N_DB_INSTANCE	CHAR	16			CHAR16
DB_NODE	Current Database node (host name)	ST04N_DB_NODE	CHAR	64			CHAR64
DB_RELEASE	Database release	ST04N_DB_RELEASE	CHAR	17			CHAR17
DB_SYS_TIMESTAMP	Current Day and Time from DB system	ST04N_DB_SYS_TIMESTAMP	CHAR	20			CHAR20
DB_SYSDATE	System date of the data base	ST04N_DB_SYSDATE	DATS	8			SYDATS
DB_SYSTIME	Time from the db system time stamp	ST04N_DB_SYSTIME	TIMS	6			SYTIME
DB_STARTUP_TIMESTAMP	Startup timestamp	ST04N_DB_STARTUP_TIMESTAMP	CHAR	20			CHAR20
DB_STARTDATE	Startup date of the data base	ST04N_DB_STARTDATE	DATS	8			SYDATS
DB_STARTTIME	Startup time of the DB	ST04N_DB_STARTTIME	TIMS	6			SYTIME
DB_ELAPSED	Elapsed time since db start in sec.	ST04N_DB_ELAPSED	DEC	16			ST04N_NUMBER_16
DB_SNAPDIFF	Seconds between two snapshots	ST04N_DB_SNAPDIFF	DEC	16			ST04N_NUMBER_16
DATABUFFER_SIZE	Data buffer size in kB			0
NDATABUFFER_SIZE	number: Data buffer size in kB			0
DBUFF_QUALITY	Data buffer quality			0
NDBUFF_QUALITY	number: Data buffer quality			0
SIZE_DEFAULT_POOL	Size Default Pool			0
NSIZE_DEFAULT_POOL	number: Size Default Pool			0
SIZE_KEEP_POOL	Size Keep Pool			0
NSIZE_KEEP_POOL	number: Size Keep Pool			0
SIZE_OTHERS	Size other pools			0
NSIZE_OTHERS	number: Size other pools			0
DBUFF_LOGREADS	Logical Reads			0
NDBUFF_LOGREADS	number: Logical Reads			0
DBUFF_PHYSREADS	Physical reads			0
NDBUFF_PHYSREADS	number: Physical reads			0
DBUFF_PHYSWRITES	Physical writes			0
NDBUFF_PHYSWRITES	number: Physical writes			0
DBUFF_PHYSREADD	Physical reads (direct)			0
NDBUFF_PHYSREADD	number: Physical reads (direct)			0
DBUFF_PHYSREADDL	Physical reads (direct lob)			0
NDBUFF_PHYSREADDL	number: Physical reads (direct lob)			0
DBUFF_BUSYWAITS	Buffer busy waits			0
NDBUFF_BUSYWAITS	number: Buffer busy waits			0
DBUFF_WAITTIME	Buffer wait time in sec.			0
NDBUFF_WAITTIME	number: Buffer wait time in sec.			0
SHPL_SIZE	Shared pool size in kB			0
NSHPL_SIZE	number: Shared pool size in kB			0
SHPL_CAQUAL	DD-cache quality in %			0
NSHPL_CAQUAL	number: DD-cache quality in %			0
SHPL_GETRATIO	SQL area getratio in %			0
NSHPL_GETRATIO	number: SQL area getratio in %			0
SHPL_PINRATIO	SQL area pinratio in %			0
NSHPL_PINRATIO	number: SQL area pinratio in %			0
SHPL_RELOADSPINS	SQL area reloads / pins in %			0
NSHPL_RELOADSPINS	number: SQL area reloads / pins in %			0
LGBF_SIZE	Log buffer size in kB			0
NLGBF_SIZE	number: Log buffer size in kB			0
LGBF_ENTRIES	Log buffer entries			0
NLGBF_ENTRIES	number: Log buffer entries			0
LGBF_ALLORETR	Allocation retries			0
NLGBF_ALLORETR	number: Allocation retries			0
LGBF_ALLOFRAT	Allocation fault rate in %			0
NLGBF_ALLOFRAT	number: Allocation fault rate in %			0
LGBF_REDLGWT	Redo log wait in sec.			0
NLGBF_REDLGWT	number: Redo log wait in sec.			0
LGBF_LOGFILES	Number of log files			0
NLGBF_LOGFILES	number: Number of log files			0
LGBF_LOGFUSE	Number of log files in use			0
NLGBF_LOGFUSE	number: Number of log files in use			0
CLL_USERCALLS	User calls			0
NCLL_USERCALLS	number: User calls			0
CLL_USERCOMM	User commits			0
NCLL_USERCOMM	number: User commits			0
CLL_USERROLLB	User rollbacks			0
NCLL_USERROLLB	number: User rollbacks			0
CLL_RECURSIVE	Recursive calls			0
NCLL_RECURSIVE	number: Recursive calls			0
CLL_PARSECNT	Parse count			0
NCLL_PARSECNT	number: Parse count			0
CLL_USR_PER_RCCLL	User calls per recursive call			0
NCLL_USR_PER_RCCLL	number: User calls per recursive call			0
CLL_RDS_PER_UCLL	Logical reads per user call			0
NCLL_RDS_PER_UCLL	number: Logical reads per user call			0
TIMS_BUSYWT	Busy wait time in seconds			0
NTIMS_BUSYWT	number: Busy wait time in seconds			0
TIMS_CPUTIME	CPU time used by this session			0
NTIMS_CPUTIME	number: CPU time used by this session			0
TIMS_TIM_PER_UCLL	Time per user call in msec.			0
NTIMS_TIM_PER_UCLL	number: Time per user call in msec.			0
TIMS_SESS_BUSY	Session busy %			0
NTIMS_SESS_BUSY	number: Session busy %			0
TIMS_CPUUSAGE	CPU usage %			0
NTIMS_CPUUSAGE	number: CPU usage %			0
TIMS_CPUCOUNT	CPU count / Number of CPUs			0
NTIMS_CPUCOUNT	number: CPU count / Number of CPUs			0
RDLG_WRITES	Redo writes			0
NRDLG_WRITES	number: Redo writes			0
RDLG_OSBLCKWRT	OS blocks written			0
NRDLG_OSBLCKWRT	number: OS blocks written			0
RDLG_LTCHTIM	Latching time in sec.			0
NRDLG_LTCHTIM	number: Latching time in sec.			0
RDLG_WRTTIM	Redo write time in sec.			0
NRDLG_WRTTIM	number: Redo write time in sec.			0
RDLG_MBWRITTEN	Megabytes written			0
NRDLG_MBWRITTEN	number: Megabytes written			0
TABSF_SHTABSCAN	Short table scans			0
NTABSF_SHTABSCAN	number: Short table scans			0
TABSF_LGTABSCAN	Long table scans			0
NTABSF_LGTABSCAN	number: Long table scans			0
TABSF_FBYROWID	Table fetch by rowid			0
NTABSF_FBYROWID	number: Table fetch by rowid			0
TABSF_FBYCONTROW	Table fetch by continued row			0
NTABSF_FBYCONTROW	number: Table fetch by continued row			0
SORT_MEMORY	Sorts in memory			0
NSORT_MEMORY	number: Sorts in memory			0
SORT_DISK	Sorts on disk			0
NSORT_DISK	number: Sorts on disk			0
SORT_ROWS	Rows sorted			0
NSORT_ROWS	number: Rows sorted			0
SORT_WAEXOPT	Workarea execution in optimal mode			0
NSORT_WAEXOPT	number: Workarea execution in optimal mode			0
SORT_WAEXONEP	Workarea execution in one pass mode			0
NSORT_WAEXONEP	number: Workarea execution in one pass mode			0
SORT_WAEXMULTP	Workarea execution in multipass mode			0
NSORT_WAEXMULTP	number: Workarea execution in multipass mode			0
IEFF_SOFTPARSE	Soft parse ratio			0
NIEFF_SOFTPARSE	number: Soft parse ratio			0
IEFF_INMEM_SORT	In-memory sort ratio			0
NIEFF_INMEM_SORT	number: In-memory sort ratio			0
IEFF_PARSTOEXEC	Parse to execute ratio			0
NIEFF_PARSTOEXEC	number: Parse to execute ratio			0
IEFF_PARSCPUTOTOT	Parse CPU to total CPU ratio			0
NIEFF_PARSCPUTOTOT	number: Parse CPU to total CPU ratio			0
IEFF_PTCPU_PTELPS	Parse time CPU to parse time elapsed			0
NIEFF_PTCPU_PTELPS	number: Parse time CPU to parse time elapsed			0
NTOTGETS	number: sum(gets) from gv$rowcache			0
NTOTGETMISS	number: sum(getmisses) from gv$rowcache			0
NGETHITS	number: sum(gethits) from hv$librarycache			0
NPINHITS	number: sum(pinhits) from hv$librarycache			0
NGETS	number: sum(gets) from hv$librarycache			0
NPINS	number: sum(pins) from hv$librarycache			0
NRELOADS	number: sum(reloads) from gv$librarycache			0
NLOGICALIO	number: session logical reads from gv$sysstat			0
NPARSECOUNTHARD	number: parse count (hard) from gv$sysstat			0
NPARSECOUNTTOTAL	number: parse count (total) from gv$sysstat			0
NSORTSMEMORY	number: sorts (memory) from gv$sysstat			0
NSORTSDISK	number: sorts (disk) from gv$sysstat			0
NEXECUTECOUNT	number: execute count from gv$sysstat			0
NPARSETIMECPU	number: parse time cpu from gv$sysstat			0
NCPUSESSION	number: CPU used by this session from gv$sysstat			0
NPARSETIMEELAPSED	number: parse time elapsed from gv$sysstat			0
NELAPSETIMESEC	number: elapsed time since instance startup in [sec]			0
NTOTALWAITTIME	number: total wait time from gv$system_event			0
NDB_CACHE_SIZE	number: db_cache_size from gv$parameter			0
NDBBUFSIZE_DBCACHE0	number: data buffer size if parameter db_cache_size = 0			0
NDBBUFSIZE_DEFPOOL0	number: size of default pool if parameter db_cache_size = 0			0
NMEMORY_TARGET	number: MEMORY_TARGET (Oralce Rel. 11)			0

Key field

Non-key field

How do I retrieve data from SAP structure ORA_S_ST04_MAIN_DATA using ABAP code?

As ORA_S_ST04_MAIN_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on ORA_S_ST04_MAIN_DATA as there is no data to select.

How to access SAP table ORA_S_ST04_MAIN_DATA

Within an ECC or HANA version of SAP you can also view further information about ORA_S_ST04_MAIN_DATA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!