/SDF/NEWVSQLAREA SAP (Fields of Shared Cursor Cache in ST04) Structure details

Dictionary Type: Structure
Description: Fields of Shared Cursor Cache in ST04




ABAP Code to SELECT data from /SDF/NEWVSQLAREA
Related tables to /SDF/NEWVSQLAREA
Access table /SDF/NEWVSQLAREA




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

/SDF/NEWVSQLAREA 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 "Fields of Shared Cursor Cache in ST04" 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_/SDF/NEWVSQLAREA TYPE /SDF/NEWVSQLAREA.

The /SDF/NEWVSQLAREA table consists of various fields, each holding specific information or linking keys about Fields of Shared Cursor Cache in ST04 data available in SAP. These include INST_NAME (Instance Name), SQL_ID (SQL identifier of the parent cursor in the library cache), SQL_TEXT (Start of SQL Statement), EXPL_SOURCE (Source of the explain plan).. 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 /SDF/NEWVSQLAREA 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
INST_ID Instance ID0
INST_NAME Instance Name0
SQL_ID SQL identifier of the parent cursor in the library cache0
SQL_TEXT Start of SQL Statement0
EXPL_SOURCE Source of the explain plan0
SHAR_MEM Sum of 'sharable memory'0
PERS_MEM Sum of 'persistent memory'0
RUNTIM_MEM Sum of 'runtime memory'0
SQLSORTS Sum of the number of sorts0
LOAD_VERSN 1 if context heap is loaded0
OPEN_VERSN 1 if child cursor is locked0
USERS_OPEN number of users executing the statement0
FETCHES Number of fetches associated with the SQL statement0
EXECUTIONS number of executions since object came into cache0
PX_SERV_EXECS Total number of executions performed by Parallel eXecution0
END_OF_FETCHES Number of times this cursor was fully executed0
USERS_EXEC number of users executing the statement0
LOADS number of times the object was loaded or reloaded0
FIRST_LOAD time stamp of the parent creation time0
INVALIDATN number of times this child cursor has been invalidated0
PARSE_CALL number of parse calls for this child cursor0
DISK_READS number of disk reads for this child cursor0
DR_PERCENTDatenelement Dec länge 10 decimalstellen 2 /SDF/DEC10_2DEC10(2) /SDF/DEC10_2
BUFFER_GET number of buffer gets for this child cursor0
BG_PERCENTDatenelement Dec länge 10 decimalstellen 2 /SDF/DEC10_2DEC10(2) /SDF/DEC10_2
RECS_PROCE total number of rows the parsed SQL statement returns0
ADDRESS Address of statement in the cache0
HASH_VALUE Hash value of statement0
CHILD_NUM Child number of statement0
MODULENAME Program Name0
ACTION Action name0
SHOW Used for table search0
INVALID valid or invalid0
DISKRD_EXC disk reads per execution0
BUFGET_EXC buffer gets per execution0
PARCAL_EXC Parse calls per execution0
RECPRO_EXC number of records per execution0
BUFGET_ROW Number of buffer gets per row0
PARSUSERID Parsing User ID0
USER_NAME User Name0
CPU_TIME CPU Time0
CPU_TIME_PERC cpu time percentage0
ELAP_TIME Elapsed Time0
ELAP_TIME_PERC elapsed time percentage0
WAIT_TIME Wait Time = Elapsed Time - CPU0
CPU_EXC CPU Time per execution0
ELAP_EXC Elapsed Time per execution0
WAIT_EXC Wait Time per execution0
APPLW_EXEC Application Wait time per exec0
CONCW_EXEC concurrency wait time per exec0
CLUSTW_EXEC cluster wait time per exec0
OUTL_CAT Outline Category0
OUTL_SID Outline SID0
RP_PERCENTDatenelement Dec länge 10 decimalstellen 2 /SDF/DEC10_2DEC10(2) /SDF/DEC10_2
RE_PERCENTDatenelement Dec länge 10 decimalstellen 2 /SDF/DEC10_2DEC10(2) /SDF/DEC10_2
LAST_LOAD_TIME Last time the query plan was loaded into the library cache0
LAST_ACTIVE_TIME Last time the query plan was active0
DIRECT_WRITES Number of direct writes for this child cursor0
OBJECT_STATUS Status of the cursor0
OVERFLOW Flag for overflow (D disk reads, B buffer gets)0
APPL_WAIT_TIME Application wait time (in micr0
APPLW_PERCDatenelement Dec länge 10 decimalstellen 2 /SDF/DEC10_2DEC10(2) /SDF/DEC10_2
CONC_WAIT_TIME Concurrency wait time (in micr0
CONCW_PERCDatenelement Dec länge 10 decimalstellen 2 /SDF/DEC10_2DEC10(2) /SDF/DEC10_2
CLUST_WAIT_TIME Cluster wait time (in microsec0
CLUSTW_PERCDatenelement Dec länge 10 decimalstellen 2 /SDF/DEC10_2DEC10(2) /SDF/DEC10_2
USR_IO_WAIT_TIME User I/O Wait Time (in microse0
PLSQL_EXEC_TIME PL/SQL execution time (in micr0
USR_IO_PER_EXEC User I/O Wait Time per exec. in microsecs0
PLSQL_PER_EXEC PL/SQL exec. time per exec. in microsecs0
STMT_SOURCE DBA HIST (D) or Cache (C)0
DBA_HIST_B_TS Start timestamp for statement selection from DBA HIST0
DBA_HIST_E_TS End timestamp for statement selection from DBA HIST0
SQL_PROFILE SQL profile0
PLAN_HASH_VALUE Numerical representation of the SQL plan for this cursor0
OPTIMIZER_MODE SQL Statement is Execution Mode0
PARSING_SCHEMA_NAME Schema name to originally build this child0
IS_OBSOLETE Indicates whether the cursor is obsolete (Y)0
IS_BIND_SENSITIVE Indicates whether the cursor is bind-sensitive Y or not N.0
IS_BIND_AWARE Indicates whether the cursor is bind aware (Y) or not (N).0
SQL_PATCH SQL patch used for this statement, if any0
SQL_PLAN_BASELINE SQL plan baseline used for this statement, if any0
SERVICE Service Name0
AVG_HARD_PARSE_TIME Average hard parse time (microseconds)0
AVG_HARD_PARSE_TIME_EXC % of total0
IO_CEL_OFL_ELIG_BYT Number of I/O bytes which can be filtered by the Exadata0
IO_CEL_OFL_ELIG_BYT_EXC % of total0
IO_INTCON_BYT Number of I/O bytes exchanged between Oracle DB and storage0
IO_INTCON_BYT_EXC % of total0
PHYS_READ_REQ Number of physical read I/O reqs issued by the monitored SQL0
PHYS_READ_REQ_EXC % of total0
PHYS_READ_BYT Number of bytes read from disks by the monitored SQL0
PHYS_READ_BYT_EXC % of total0
PHYS_WRITE_REQ No. of physical write I/O reqs issued by the monitored SQL0
PHYS_WRITE_REQ_EXC % of total0
PHYS_WRITE_BYT Number of bytes written from disks by the monitored SQL0
PHYS_WRITE_BYT_EXC % of total0
EXACT_MATCHING_SIG Signature used with CURSOR_SHARING set to EXACT0
FORCE_MATCHING_SIG Signature used with CURSOR_SHARING set to FORCE0
IO_CEL_UNCOMP_BYT Number of uncompressed bytes that are offloaded to the Exada0
IO_CEL_UNCOMP_BYT_EXC % of total0
IO_CEL_OFL_RET_BYT Number of bytes returned by the Exadata cell for smart scan0
IO_CEL_OFL_RB_EXC % of total0
OPT_PHYS_READS Cumulative value of number of physical reads from flash cach0
OPT_PHYS_READS_EXC % of total0

Key field Non-key field



How do I retrieve data from SAP structure /SDF/NEWVSQLAREA using ABAP code?

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

How to access SAP table /SDF/NEWVSQLAREA

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