/SDF/NEWVSQLAREA SAP (Fields of Shared Cursor Cache in ST04) Structure details
Description: Fields of Shared Cursor Cache in ST04
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 ID | 0 | |||||||
INST_NAME | Instance Name | 0 | |||||||
SQL_ID | SQL identifier of the parent cursor in the library cache | 0 | |||||||
SQL_TEXT | Start of SQL Statement | 0 | |||||||
EXPL_SOURCE | Source of the explain plan | 0 | |||||||
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 sorts | 0 | |||||||
LOAD_VERSN | 1 if context heap is loaded | 0 | |||||||
OPEN_VERSN | 1 if child cursor is locked | 0 | |||||||
USERS_OPEN | number of users executing the statement | 0 | |||||||
FETCHES | Number of fetches associated with the SQL statement | 0 | |||||||
EXECUTIONS | number of executions since object came into cache | 0 | |||||||
PX_SERV_EXECS | Total number of executions performed by Parallel eXecution | 0 | |||||||
END_OF_FETCHES | Number of times this cursor was fully executed | 0 | |||||||
USERS_EXEC | number of users executing the statement | 0 | |||||||
LOADS | number of times the object was loaded or reloaded | 0 | |||||||
FIRST_LOAD | time stamp of the parent creation time | 0 | |||||||
INVALIDATN | number of times this child cursor has been invalidated | 0 | |||||||
PARSE_CALL | number of parse calls for this child cursor | 0 | |||||||
DISK_READS | number of disk reads for this child cursor | 0 | |||||||
DR_PERCENT | Datenelement Dec länge 10 decimalstellen 2 | /SDF/DEC10_2 | DEC | 10(2) | /SDF/DEC10_2 | ||||
BUFFER_GET | number of buffer gets for this child cursor | 0 | |||||||
BG_PERCENT | Datenelement Dec länge 10 decimalstellen 2 | /SDF/DEC10_2 | DEC | 10(2) | /SDF/DEC10_2 | ||||
RECS_PROCE | total number of rows the parsed SQL statement returns | 0 | |||||||
ADDRESS | Address of statement in the cache | 0 | |||||||
HASH_VALUE | Hash value of statement | 0 | |||||||
CHILD_NUM | Child number of statement | 0 | |||||||
MODULENAME | Program Name | 0 | |||||||
ACTION | Action name | 0 | |||||||
SHOW | Used for table search | 0 | |||||||
INVALID | valid or invalid | 0 | |||||||
DISKRD_EXC | disk reads per execution | 0 | |||||||
BUFGET_EXC | buffer gets per execution | 0 | |||||||
PARCAL_EXC | Parse calls per execution | 0 | |||||||
RECPRO_EXC | number of records per execution | 0 | |||||||
BUFGET_ROW | Number of buffer gets per row | 0 | |||||||
PARSUSERID | Parsing User ID | 0 | |||||||
USER_NAME | User Name | 0 | |||||||
CPU_TIME | CPU Time | 0 | |||||||
CPU_TIME_PERC | cpu time percentage | 0 | |||||||
ELAP_TIME | Elapsed Time | 0 | |||||||
ELAP_TIME_PERC | elapsed time percentage | 0 | |||||||
WAIT_TIME | Wait Time = Elapsed Time - CPU | 0 | |||||||
CPU_EXC | CPU Time per execution | 0 | |||||||
ELAP_EXC | Elapsed Time per execution | 0 | |||||||
WAIT_EXC | Wait Time per execution | 0 | |||||||
APPLW_EXEC | Application Wait time per exec | 0 | |||||||
CONCW_EXEC | concurrency wait time per exec | 0 | |||||||
CLUSTW_EXEC | cluster wait time per exec | 0 | |||||||
OUTL_CAT | Outline Category | 0 | |||||||
OUTL_SID | Outline SID | 0 | |||||||
RP_PERCENT | Datenelement Dec länge 10 decimalstellen 2 | /SDF/DEC10_2 | DEC | 10(2) | /SDF/DEC10_2 | ||||
RE_PERCENT | Datenelement Dec länge 10 decimalstellen 2 | /SDF/DEC10_2 | DEC | 10(2) | /SDF/DEC10_2 | ||||
LAST_LOAD_TIME | Last time the query plan was loaded into the library cache | 0 | |||||||
LAST_ACTIVE_TIME | Last time the query plan was active | 0 | |||||||
DIRECT_WRITES | Number of direct writes for this child cursor | 0 | |||||||
OBJECT_STATUS | Status of the cursor | 0 | |||||||
OVERFLOW | Flag for overflow (D disk reads, B buffer gets) | 0 | |||||||
APPL_WAIT_TIME | Application wait time (in micr | 0 | |||||||
APPLW_PERC | Datenelement Dec länge 10 decimalstellen 2 | /SDF/DEC10_2 | DEC | 10(2) | /SDF/DEC10_2 | ||||
CONC_WAIT_TIME | Concurrency wait time (in micr | 0 | |||||||
CONCW_PERC | Datenelement Dec länge 10 decimalstellen 2 | /SDF/DEC10_2 | DEC | 10(2) | /SDF/DEC10_2 | ||||
CLUST_WAIT_TIME | Cluster wait time (in microsec | 0 | |||||||
CLUSTW_PERC | Datenelement Dec länge 10 decimalstellen 2 | /SDF/DEC10_2 | DEC | 10(2) | /SDF/DEC10_2 | ||||
USR_IO_WAIT_TIME | User I/O Wait Time (in microse | 0 | |||||||
PLSQL_EXEC_TIME | PL/SQL execution time (in micr | 0 | |||||||
USR_IO_PER_EXEC | User I/O Wait Time per exec. in microsecs | 0 | |||||||
PLSQL_PER_EXEC | PL/SQL exec. time per exec. in microsecs | 0 | |||||||
STMT_SOURCE | DBA HIST (D) or Cache (C) | 0 | |||||||
DBA_HIST_B_TS | Start timestamp for statement selection from DBA HIST | 0 | |||||||
DBA_HIST_E_TS | End timestamp for statement selection from DBA HIST | 0 | |||||||
SQL_PROFILE | SQL profile | 0 | |||||||
PLAN_HASH_VALUE | Numerical representation of the SQL plan for this cursor | 0 | |||||||
OPTIMIZER_MODE | SQL Statement is Execution Mode | 0 | |||||||
PARSING_SCHEMA_NAME | Schema name to originally build this child | 0 | |||||||
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 any | 0 | |||||||
SQL_PLAN_BASELINE | SQL plan baseline used for this statement, if any | 0 | |||||||
SERVICE | Service Name | 0 | |||||||
AVG_HARD_PARSE_TIME | Average hard parse time (microseconds) | 0 | |||||||
AVG_HARD_PARSE_TIME_EXC | % of total | 0 | |||||||
IO_CEL_OFL_ELIG_BYT | Number of I/O bytes which can be filtered by the Exadata | 0 | |||||||
IO_CEL_OFL_ELIG_BYT_EXC | % of total | 0 | |||||||
IO_INTCON_BYT | Number of I/O bytes exchanged between Oracle DB and storage | 0 | |||||||
IO_INTCON_BYT_EXC | % of total | 0 | |||||||
PHYS_READ_REQ | Number of physical read I/O reqs issued by the monitored SQL | 0 | |||||||
PHYS_READ_REQ_EXC | % of total | 0 | |||||||
PHYS_READ_BYT | Number of bytes read from disks by the monitored SQL | 0 | |||||||
PHYS_READ_BYT_EXC | % of total | 0 | |||||||
PHYS_WRITE_REQ | No. of physical write I/O reqs issued by the monitored SQL | 0 | |||||||
PHYS_WRITE_REQ_EXC | % of total | 0 | |||||||
PHYS_WRITE_BYT | Number of bytes written from disks by the monitored SQL | 0 | |||||||
PHYS_WRITE_BYT_EXC | % of total | 0 | |||||||
EXACT_MATCHING_SIG | Signature used with CURSOR_SHARING set to EXACT | 0 | |||||||
FORCE_MATCHING_SIG | Signature used with CURSOR_SHARING set to FORCE | 0 | |||||||
IO_CEL_UNCOMP_BYT | Number of uncompressed bytes that are offloaded to the Exada | 0 | |||||||
IO_CEL_UNCOMP_BYT_EXC | % of total | 0 | |||||||
IO_CEL_OFL_RET_BYT | Number of bytes returned by the Exadata cell for smart scan | 0 | |||||||
IO_CEL_OFL_RB_EXC | % of total | 0 | |||||||
OPT_PHYS_READS | Cumulative value of number of physical reads from flash cach | 0 | |||||||
OPT_PHYS_READS_EXC | % of total | 0 |
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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects