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