Select data from sap tables ORA_
Display SAP table details
ORAADDIN80 - ST04 (Oracle8): Additional Info for Exclusive Lock Waits
ORAADMLOG - ORA: Simple message layout
ORAALLUSR - Abbrev.DDIC Struct. Corresponds to Oracle Tab. DBA_ALL_USERS
ORAALOGCLS - Oracle monitoring: Alert log classification structure
ORAALOGOUTS - Oracle monitoring: Alert log structure
ORABLKANAL - Detailed Analysis of Oracle Tables
ORACCACHST - Status of Cursor Cache Display
ORACC_ACTION_ASH - Data for action 'active session history' (oracle monitor)
ORACC_ACTION_MET_FL - All system MEtrics type definitions
ORACC_ACTION_MET_SS - All System Summary Metrics definitions
ORACC_ACTION_MET_SYS - All System Metrics type definitions
ORACC_ACTION_MET_WT - All system MEtrics type definitions
ORACLE_RELEASE - Oracle release
ORAEVENTS - Oracle: Wait Events (V$System_Event, V$Session_Event)
ORAEXPLAIN - Explain Plan for Oracle Statement
ORAEXPLPAR - Parameter for Explain from v$sql_plan
ORAEXPLTRE - Oracle: Explain Tree Additional Info. for Hierarchy Nodes
ORAIDXCOL2 - Information About Index Columns
ORAIDXFLDS - ORACLE: Download SQL SE11 Index Fields
ORAIDXHEAD - ORACLE Download SQL SE11 Index Header
ORAIDXINF2 - Statistical Index Information
ORAIDXINFO - Index Information
ORAINDANAL - Detailed Analysis of Oracle Indexes (fr. V.7)
ORAINDINFO - Information About the Storage Quality of the Indexes
ORAINDSTOR - Index Parameters for ORACLE
ORAINDXCOL - Columns and Distinct Keys of an Index
ORAINST_LIST - List of RAC Nodes
ORAIOPATH - Oracle I/O Statistics per Device
ORAIOSUM - Oracle I/O Statistics per Data File, Total By Device
ORAIS - Table Parameters for ORACLE, Version 8
ORAISQCTRL - RSORAISQ Index Storage Quality Maintenance Control Table
ORAJOICOND - Oracle: Download Join Conditions
ORAPARTADMDAT - Control Data for Oracle Partition
ORAPARTADMIN - Control Data for Oracle Partition Engine
ORAPARTAL - Analysed Data for Oracle Partition Engine
ORAPARTGENDDL - Generated DDL Statements for partitioning
ORAPHYTABL - ORACLE: Download Physical Tables for Joins
ORASAREA_A - Structure for Field Catalog Creation 'Cursor Cache Stats'
ORASAREA_B - Structure for Base List: 'Oracle Cursor Cache Statistics'
ORASAREA_E - Additional Fields for 'Oracle Cursor Cache Stats' List
ORASELCOND - Oracle: Download Selection Conditions
ORASESS - Oracle: Sessions
ORASESSION - Basis List 'Oracle Session' Structure for the ALV
ORASQLADER - Derived Columns for V$SQLAREA
ORASQLAREA - DDIC Structure According to Oracle Table V$SQLAREA
ORASTATS_TTYPE - Structure for Oracle System Statistics
ORASYSTABH - Oracle System Table (V$ table)
ORATABCOL2 - Information About Table Columns
ORATABCOLS - Oracle: Dates of Table Analysis
ORATABFLDS - ORACLE: Download SQL SE11 Table Fields
ORATABHEAD - ORACLE: Download SQL SE11 Table Header
ORATABINFO - Statistical Table Information
ORATABPAR - Table Parameters for ORACLE, Version 8, Internal Represent.
ORATABSTI - Table Parameters for ORACLE, Version 8, Internal Represent.
ORATABSTOR - Table Parameters for ORACLE, Version 8
ORATS - Table Parameters for ORACLE, Version 8
ORATSPINFO - Tablespace Information
ORAVSQLAR - Restictions on Display of Cursor Cache Statistical Data
ORAV_SQL - DDIC Structure According to Oracle Table V$SQL
ORAV_SQLTX - DDIC Structure According to Oracle Table V$SQLTEXT
ORA_083_DBSNP - Structure used by report RSORA083
ORA_ADD_IN - ST04 (Oracle): Additional Info for Exclusive Lock Waits
ORA_ASHGSET - Oracle ASH monitor graphic settings
ORA_ASHGSETID - Oracle ASH monitor graphic settings
ORA_ASHR_REPORT - Oracle monitoring: data for AWR/ASH report
ORA_AUXSTAT_STRUCTURE - Structure of table SAP_AUXSTAT
ORA_AUXSTAT_STUCTURE - Structure from Table SAP_AUXSTAT
ORA_AWR_ASH_REPORT - Oracle monitoring: data for AWR and ASH reports
ORA_AWR_REPORT - Oracle monitoring: data for AWR report
ORA_BUFF_BUSY_WAIT_MON - Structure for use in the Buffer Busy Wait Monitor
ORA_CHECKPOINT_STRUCTURE - Oracle Checkpoint Structure for Submonitor Checkpoint.
ORA_COL_USAGE - Oracle-Monitor: Structure for COL_USAGE-Monitor
ORA_DBA_EXTENTS - Copy of DBA_EXTENTS (currently not provided with snapshots)
ORA_DBA_OBJECTS - Copy of DBA_OBJECTS (currently not provided with snapshots)
ORA_DBA_RESUMABLE - Structure for DBA_RESUMABLE Structure
ORA_DBA_RESUMABLE_STRUCTURE - Structure from table SAP_RESUAMBLE
ORA_DBA_RESUMABLE_STRUC_ORG - Structure for DBA_RESUMABLE Structure
ORA_DBA_SEGMENTS - Copy of DBA_SEGMENTS (currently not provided with snapshots)
ORA_DBA_TABLES - Copy of DBA_TABLES (currently not provided with snapshots)
ORA_DBA_TCOL - Oracle monitoring: Transparent table for table columns
ORA_DBA_TCOLUMNS - Oracle monitoring: Transparent table for table columns
ORA_DBH_CONFIG - Oracle DBH Settings
ORA_DBMS_STAT_TABLE_CHAR_STR - Structure of type stat-table. submonitor system statistics
ORA_DBMS_STAT_TABLE_STRUCTURE - Structure of type stat-table. submonitor system statistics
ORA_EVENT_STRUC - Oralce Event Structure
ORA_FEAT_USED - ORA: Used Oracle Features for DBACockpit
ORA_FIELD_CATALOG - ORA: Basic element of a ALV field catalog
ORA_GV_PX_SESSION_STRUCTURE - Table Structure of GV$PX_SESSION
ORA_HISTPAR - Parameter values for oracle history collector
ORA_IDLE_EVENTS - Oracle: Idle events
ORA_IND_QLTY - Oracle monitoring: Index storage quality
ORA_INSTANCE_S - Structure for the lock monitor
ORA_ISQ_DETAIL - Index Storage Quality - Objects of a Workingset
ORA_ISQ_HEADER - Index Storage Quality - Header of a Workingset
ORA_ISQ_HISTORY - Index Storage Quality - Objectshistory Data
ORA_ISQ_PARAM - Index Storage Quality - Parameters
ORA_JSEL_STAT - Runtime + other statistics line for ORA arbitrary join mon.
ORA_JSEL_STMT - Oracle 'arbitrary join select monitor' statement
ORA_JSEL_STMTID - Oracle 'arbitrary join select monitor' statement IDs
ORA_LCK - Structure for the lock monitor
ORA_LCK_2 - Structure for the lock monitor (scripts 1 & 2)
ORA_LIST - Oracle monitoring: Oracle list
ORA_LK_INSTANCE - SDD - Oracle lock monitor: instance list
ORA_LK_LOCKS - SDD - Oracle lock monitor: lock summary
ORA_LK_OBJECTS - SDD - Oracle lock monitor: list of loced objects
ORA_LK_PROCESS - SDD - Oracle lock monitor: process list
ORA_MISS - Export Structure for Module DB_ORA_MISSING_INDICES
ORA_MON_DBCON - Oracle monitoring: list of external Oracle connections
ORA_OBJ - DBA Cockpit: Structure for the lock monitor
ORA_ORANET_STRUC - ORA: Oracle Net Output Structure
ORA_PERFORMANCE_DB_STRUCTURE - Oracle Structure for Sub-Monitor Performance Database
ORA_PG_PEROPT - SDD - Oracle PGA monitor: PEROPT
ORA_PG_PGAADV - SDD - Oracle PGA monitor: PGAADV
ORA_PG_PGAHIS - SDD - Oracle PGA monitor: PGAHIS
ORA_PG_PGASTA - SDD - Oracle PGA monitor: PGASTA
ORA_PG_PROCES - SDD - Oracle PGA monitor: PROCESS
ORA_PG_SQLHIS - SDD - Oracle PGA monitor: SQLHIS
ORA_PG_SQLOMP - SDD - Oracle PGA monitor: SQLOMP
ORA_PG_SQLTEXT - SDD - Oracle PGA monitor: SQLTEXT
ORA_PG_SQLWOA - SDD - Oracle PGA monitor: SQLWOA
ORA_PG_WOAACT - SDD - Oracle PGA monitor: WOAACT
ORA_PG_WOAEXE - SDD - Oracle PGA monitor: WOAEXE
ORA_PROCESSROW - Oracle Monitoring: Processes-row type
ORA_PROCESS_S - Structure for the lock monitor
ORA_PX_DETAIL_STRUCTURE - Parallel Query Detail Process Infos
ORA_PX_PROC_INFO_VIEW - Show physical infos about a parallel query process
ORA_RESUMABLE - Oracle monitor: Copy of DBA_RESUMABLE
ORA_RESUMABLE_VIEW_STRUCTURE - Part of DBA_RESUMABLE Structure
ORA_SAPKCBFWAIT - Copy of SAP$KCBFWAIT
ORA_SAP_AUXSTATS - Oracle monitor: Copy of SAP_AUXSTATS
ORA_SEM_BWSUM - SDD - Oracle system event monitor: busy wait summary
ORA_SEM_BWSUM_STRUC - SDD - Oracle system event monitor: busy wait summary
ORA_SEM_SEDT - SDD - Oracle system event monitor: s. event details
ORA_SEM_SEDT_STRUC - SDD - Oracle system event monitor: s. event details
ORA_SEM_SYSEV - SDD - Oracle system event monitor: system events
ORA_SEM_SYSEV_STRUC - SDD - Oracle system event monitor: system events
ORA_SERVERLISTROW - Oracle Monitoring : Serverlist Row
ORA_SESSION_LCK - Structure for the lock monitor
ORA_SG_BPS - SDD - Oracle SGA monitor: BPS
ORA_SG_CRO - SDD - Oracle SGA monitor: CRO
ORA_SG_DCA - SDD - Oracle SGA monitor: DCA
ORA_SG_SDC - SDD - Oracle SGA monitor: SDC
ORA_SG_SGA - SDD - Oracle SGA monitor: SGA
ORA_SG_SGASTAT - SDD - Oracle SGA monitor: SGASTAT
ORA_SG_SPA - SDD - Oracle SGA monitor: SPA
ORA_SG_SRO - SDD - Oracle SGA monitor: SRO
ORA_SM_SESSIONS - SDD - Oracle session monitor: session list
ORA_SNAPSHOT - Master data of an oracle monitor snapshot
ORA_SNAPSHOT_STRUC - Structure for table ORA_SNAPSHOT
ORA_SNAP_MAILRCV - Oracle snapshot: log mail receiver
ORA_SQLCN_STMT - Oracle SQL Command Editor statement
ORA_SQLCN_STMTID - Oracle SQL Command Editor statement IDs
ORA_SQLC_DATA - ORA: SQL Command Editor Data Table
ORA_SQLC_HEAD - ORA: SQL Command Editor Header Table
ORA_SQLC_STMT - Table with statements used by the SQL Command Editor
ORA_SQLC_S_HEAD - ORA_SQLC_HEAD-STRUCTURE
ORA_SQLTEXTROW - Oracle Monitoring - SQL TEXT row
ORA_SQLTEXT_S - Structure for the lock monitor
ORA_STMT - Oracle: SQL Statement and Length
ORA_STT_DATA - DBACockpit: Data table for RSORASTT
ORA_STT_HEAD - DBACockpit: Header table for RSORASTT
ORA_SYSEVT_STRUC - Oracle montor: System events
ORA_SYSTEM_EVENT_HISTORY - Oracle Structure for Sub-Monitor GV$SYSTEM_EVENT History
ORA_SYSTEM_EVENT_HISTORY_2 - Oracle Structure for Sub-Monitor GV$SYSTEM_EVENT History
ORA_S_ASHR_SEL_DATE - Oracle monitoring: Select structure for history data for ASH
ORA_S_ASH_BLOCKLIST - Oracle monitoring: List of blocks accessed (ASH monitor)
ORA_S_ASH_GENERAL_SELECTION - General selections / settings for Oracle Ash Monitor
ORA_S_ASH_GRAPHDATA - ASH graphic data
ORA_S_ASH_GRAPH_SELECTION1 - Selections / Settings for Oracle ASH Monitor graphic (flds)
ORA_S_ASH_GRAPH_SELECTION2 - Selections / Settings for Oracle ASH Monitor graphic (table)
ORA_S_ASH_SELECTION - Selections / Settings for Oracle ASH Monitor
ORA_S_ASH_SQLTSTAMP - Oracle monitoring: List of timestamps (ASH monitor)
ORA_S_AWR_SEL_SNAPID - Oracle monitoring: Select structure for SQL IDs
ORA_S_AWR_SEL_SNAPID_SUB - Oracle monitoring: Select structure for SQL IDs
ORA_S_AWR_SEL_SQLID - Oracle monitoring: Select structure for history snapshots
ORA_S_CBO_SELECTION - Screen Selection for CBO Special Statistics
ORA_S_DATA_TYPE - Structure for Database Views Column Types
ORA_S_DBAOBJECTS - structure of objects that exist in the DBA_OBJECTS
ORA_S_DBA_FILE_NAME - filename and tablespacename for file metric selection
ORA_S_DBA_HIST_METRIC_NAME - Oracle Monitoring: Structure for DBA_HIST_METRIC_NAME
ORA_S_DB_HIST_SNAP - DB HIST SNAPSHOT Time
ORA_S_DG_DATABASE - ORA: Dataguard Database Structure
ORA_S_DG_INFO - ORA: Dataguard Info Structure
ORA_S_DG_MNG - ORA: Dataguard Managed Standby Structure
ORA_S_DG_OVERVIEW - ORA_ Dataguard Overview Structure
ORA_S_DIAGALERT - Alert Log with V$DIAG_ALERT_EXT
ORA_S_DML_LOCK - DML Locks
ORA_S_DML_TIMESTAMP - TimeStamp for DML Locks
ORA_S_DNFS_CHANNELS - Oracle DNFS channels
ORA_S_DNFS_CHANNSUM - Oracle DNFS channels with sums
ORA_S_DNFS_SERVER - Oracle DNFS servers
ORA_S_EM_CG - Structure for ConsistentGets
ORA_S_EM_CHAINEDROWS - Structure for ChainedRows
ORA_S_EM_CPU - Structure for CPU
ORA_S_EM_DBWR - Structure for DBWR
ORA_S_EM_DR - Structure for DiskReads
ORA_S_EM_FTSCAN - Structure for FullTableScans
ORA_S_EM_GENERAL - General Selections/ Settings for EventMetrics Tabs
ORA_S_EM_KEYF - Structure for KeyFigures
ORA_S_EM_KS - Structure for KeySysmetrics
ORA_S_EM_MVPMI - Structure for MetricValuePerMetrciInterval
ORA_S_EM_MVPMI_AGGR - General Selections/ Settings for MVPMI
ORA_S_EM_NW - Structure for Network
ORA_S_EM_PE - Structure for ParallelExecutions
ORA_S_EM_PRSNG - Structure for Parsing
ORA_S_EM_RW - Structure for RedoWrites
ORA_S_EM_SQLWA - Structure for SQL WorkAreas
ORA_S_EM_SVPAWRI - Structure for StaticValuePerAWRI
ORA_S_EM_SVPAWRI_AGGR - Table for SVPAWRI
ORA_S_EM_SYSMETRICS - General selections / settings for Key System Metrics
ORA_S_EVENT_HISTOGRAM - Structure for Timed Events, event histograms
ORA_S_EVENT_HISTOGRAM_PER_AWR - Structure for event histogram, per AWR interval
ORA_S_EVENT_INFO - Oracle Event Details
ORA_S_EVENT_LIST - ORA: Oracle wait event with special number
ORA_S_EXT_STAT - Structure to Display Existing Extended Statistics
ORA_S_FCRA - Structure for fragmentation and chained row analysis
ORA_S_FCRA_GENERAL_SELECTION - Input Selection for fragmentation and chained row analysis
ORA_S_FILEMETRIC - Database Metrics:structure for filemetric_history
ORA_S_FILE_INFO - Oracle file statistics, mainly from gv$filestat (ASHmonitor)
ORA_S_FLASHBACK_DATABASE_STAT - Structure of V$FLASHBACK_DATABASE_STAT
ORA_S_FLASH_RECOVERY_AREA_USE - Structure of V$FLASH_RECOVERY_AREA_USAGE
ORA_S_GV_ACTIVE_SESSION_HIS - Oracle View: gv$active_session_history
ORA_S_GV_CURRENT_BLOCK_SERVER - structure for gv_current_block_server table
ORA_S_GV_SQL - Oracle Monitoring: GV$SQL
ORA_S_GV_SYSMETRICS - Database Metrics:structure for sysmetric
ORA_S_ILM_OBJ_DETAILS - Oracle ILM object details
ORA_S_ILM_PARAMETERS - ILM Parameters
ORA_S_ILM_POLICIES - ILM Policies
ORA_S_ILM_POL_OBJECTS - Oracle ILM objects with given policy
ORA_S_ILM_TASKS - Oracle ILM tasks
ORA_S_ILM_TASKSDETAILS - Oracle ILM tasks details
ORA_S_IM_AREA - Oracle in-memory-area
ORA_S_IM_COLUMN - Oracle IM column
ORA_S_IM_PARAMETER - Oracle in-memory parameters
ORA_S_IM_SEGMENT - Oracle IM segments
ORA_S_IOACT - Structure for IO Activities
ORA_S_IOACT_GENERAL_SELECTION - General selections / settings for IO Activities Monitor
ORA_S_IOREDO - Structure for IO Redo Logs Per Hour
ORA_S_IOREDO_SELECTION - Screen Selection area for Min and Max sec between Log Switch
ORA_S_KEYF - Oracle: Header Line for Performance Overview
ORA_S_LOCK_MISS - ORA: Locked/Missing Table Statistics
ORA_S_MET_FL_SELECTION - General selections / settings for File Metrics Monitor
ORA_S_MET_SS_SELECTION - General selections / Settings System Summary Metrics Monitr
ORA_S_MET_SYS_SELECTION - General selections / settings for System Metrics Monitor
ORA_S_MET_WT_SELECTION - General selections / settings for Wait Class Metrics Monitor
ORA_S_PARALDEGACT - Structure for Parallel Degree Active
ORA_S_PARALSESS - Structure for Parallel Execution Sessions
ORA_S_PATCH - Structure for the Configutration Patches
ORA_S_RECOVERY_FILE_DEST - Structure of V$RECOVERY_FILE_DEST
ORA_S_RESTART - Restart information of an oracle instance
ORA_S_RMO - SGA - structure for resources memory overview
ORA_S_SEGMENT_SELECTION - Storing selection criteria for Oracle Segments
ORA_S_SEL_WAITEVCLS - ASH graphic selected wait event classes
ORA_S_SEL_WAITEVENTS - ASH graphic selected wait events (structure)
ORA_S_SESSION_BLOCKGRAPH - DBACockpit: Lock-Monitor: Blocking Graph
ORA_S_SPL_STAT - Structure to Display Special Statistics
ORA_S_SQLC_RESULT - ORA: Structure defining the result of SQLC-Monitor
ORA_S_SQLKEY - Structure for SQL Key Figures
ORA_S_SQL_INFO - Oracle Monitoring: SQL Information
ORA_S_SQL_MONITORING_BIND - SQL Monitoring Bind Values
ORA_S_SQL_MONITORING_EXECPLAN - SQL Monitoring: Execution plan
ORA_S_SQL_MONITORING_OVERVIEW - SQL Monitoring Overview
ORA_S_SQL_MONITORING_REPORT - SQL Monitoring Report
ORA_S_SQL_MONI_SQL_RTADDM - SQL Monitoring Overview: SQL RTADDM
ORA_S_SQL_MONI_TOP_RTADDM - SQL Monitoring Overview: TopSQL RTADDM
ORA_S_ST04_MAIN_DATA - DBACockpit: Oracle Performance Main Data
ORA_S_STRING - Oracle monitoring: Structure with string (text)
ORA_S_STT_DATA - DBACockpit: Structure for data table for RSORASTT
ORA_S_STT_HEAD - DBACockpit: Structure for header table for RSORASTT
ORA_S_SYSMETRIC_SUMMARY - Database Metrics:structure for sysmetric summary
ORA_S_TABLE_ANALYZED - ORA: Tablename and last analyzed date
ORA_S_TE_GENERAL_SELECTION - General selections / settings for Oracle Timed Event Monitor
ORA_S_TOP_EVENTS - ORA: Top Events
ORA_S_TOP_SEGMENTS - Strcuture for Top Segments per Segment Statistics
ORA_S_TOP_SEGMENTS_DATA - Structure for Top Segments per Segment Statistics from DB
ORA_S_TOP_SEGMENTS_SELECTION - Screen Selection for top segments
ORA_S_TOP_SEGMENTS_SQL - Structure to capture details about selected Segment Name
ORA_S_TOP_SEGMENTS_STATS - Structure for quering statistics for selected table
ORA_S_TOP_SEGMENTS_TABLE - Structure containing info related to selected table
ORA_S_VIEWS - Dispalying views data
ORA_S_V_EVENT_NAME - Oracle View: v$event_name
ORA_S_WAITCLASSMETRIC - Database Metrics:structure for waitclassmetric_history
ORA_S_WAITEVCLASS - Oracle wait event class (structure)
ORA_S_WAITEVENT - Oracle wait event (structure)
ORA_TABACCESS - Oracle Table Access Monitor Structure
ORA_TABLESPACES - Oracle monitor: Copy of DBA_TABLESPACES
ORA_TABLE_ACCESS - Structure for the table access monitor
ORA_TA_SEGSTAT - Relevant Segment Statistics for the Table Access Monitor
ORA_TA_TABSEGSTAT - Structure for the Table Access Monitor
ORA_WPTOTALINFROW - Oracle Monitoring: WP information: row
Return Table index