ORASQLAREA SAP (DDIC Structure According to Oracle Table V$SQLAREA) Structure details

Dictionary Type: Structure
Description: DDIC Structure According to Oracle Table V$SQLAREA




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




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

ORASQLAREA 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 "DDIC Structure According to Oracle Table V$SQLAREA" 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_ORASQLAREA TYPE ORASQLAREA.

The ORASQLAREA table consists of various fields, each holding specific information or linking keys about DDIC Structure According to Oracle Table V$SQLAREA data available in SAP. These include SHARABLE_M (Total shareable memory), PERSISTENT (Total 'persistent memory'), RUNTIME_ME (Total 'runtime memory'), SORTS (Sum of the number of sorts).. 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: Not classified


SAP ORASQLAREA 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
SQL_TEXTStart of SQL statement ORASQLTEXTCHAR60CHAR60
SHARABLE_MTotal shareable memory ORASHARMEMDEC31ORAPNUMBER
PERSISTENTTotal 'persistent memory' ORAPERSMEMINT410ORAMEMORY
RUNTIME_METotal 'runtime memory' ORARUNTMEMINT410ORAMEMORY
SORTSSum of the number of sorts ORASORTSINT410ORANUMB8
VERSION_CONumber of children ORAVERSCOUINT410ORANUMBER
LOADED_VERLoaded cursor versions ORALOADVERINT410ORANUMB8
OPEN_VERSINumber of opened cursor versions ORAOPENVERINT410ORANUMB8
USERS_OPENNumber of users who have opened cursor version ORAUSROPENINT410ORANUMB8
EXECUTIONSTotal number of executions ORAEXECNUMDEC31ORAPNUMBER
USERS_EXECNumber of users executing ORAUSREXECINT410ORANUMB7
LOADSNumber of loads or reloads ORALOADSINT410ORANUMB5
FIRST_LOADTime SQL statement loaded ORALOAD_TCHAR19ORATIMESTA
INVALIDATINumber of 'invalidations' for all versions ORAINVALIDINT410ORANUMB8
PARSE_CALLSum of all 'parse calls' ORAPARSECINT410ORANUMB8
DISK_READSSum of all 'disk reads' ORADISKRDEC31ORAPNUMBER
BUFFER_GETTotal number of 'buffer gets' ORABUFFERGDEC31ORAPNUMBER
ROWS_PROCENumber of processed rows ORAROWPROCDEC31ORAPNUMBER
COMMAND_TYOracle command type definition ORACOMTYPEINT410ORANUMBER
OPTIM_MODEOptimizer mode ORAOPTMODECHAR10ORAOPTMODE
PARSING_USID of the user who built this child cursor ORAPARSUSRINT410ORANUMBER
PARSING_SCSchema ID ORAPARSSCHINT410ORANUMBER
KEPT_VERSIIndicator for using DBMS_SHARED_POOL ORAKEPTVERINT410ORANUMBER
ADDRESSAddress of statement in the cache ORAADDRESSCHAR16CHAR16
HASH_VALUEHash value of statement ORAHASHVALFLTP16(16) ORAP16
MODULEProgram Name ORAMODULECHAR64ORACHAR64
DB_USERColumn USERNAME in V$SESSION ORAUSERCHAR10CHAR10
MODULE_HASHash value of module ORAMODULEHFLTP16(16) ORAP16
ACTIONAction name ORAACTIONCHAR64CHAR64
ACTION_HASHash value of action ORAACTIONHFLTP16(16) ORAP16
SERIALIZABNumber of producing ORA-8177 ORASERIALINT410ORANUMBER
CHILD_LATCChild Latch Number ORACHILDLAINT410ORANUMBER
CPU_TIMECPU Time in Miroseconds ORACPUTIMEDEC31ORAPNUMBER
ELAPSED_TIElapsed Time in Microseconds ORAELAPSEDDEC31ORAPNUMBER
DISKRPER_ENumber of 'disk reads' for each execution ORADRPEREDEC31(1) ORADEC16
BUFFGPER_ENumber of 'buffer gets' for each execution ORABGPEREDEC31(1) ORADEC16
PARSCPER_EParse calls per execution ORAPCPEREDEC31(1) ORADEC16
ROWSPPER_ENumber of rows processed for each execution ORARPPEREDEC31(1) ORADEC16
BUFFGPER_RNumber of 'buffer gets' for each row ORABGPERRDEC31(1) ORADEC16
COLFIELDField for controlling colors in ABAP List Viewer ORACOLFIELCHAR3CHAR3
WAIT_TIMEWait time ORAWAITTIMDEC31ORAPNUMBER
CPU_TIME_ECPU Time per Execution ORACTPEREDEC31(1) ORADEC16
ELAPSEDTIEElapsed Time per Execution ORAELAPEREDEC31(1) ORADEC16
WAITTIME_EWait Time per Execution ORAWTPEREDEC31(1) ORADEC16

Key field Non-key field



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

As ORASQLAREA 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 ORASQLAREA as there is no data to select.

How to access SAP table ORASQLAREA

Within an ECC or HANA version of SAP you can also view further information about ORASQLAREA 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!