Select data from sap tables ORA_S

Display SAP table details
  



ORAIS - Table Parameters for ORACLE, Version 8

ORAISQCTRL - RSORAISQ Index Storage Quality Maintenance Control Table

ORATS - Table Parameters for ORACLE, Version 8

ORATSPINFO - Tablespace Information

ORAVSQLAR - Restictions on Display of Cursor Cache Statistical Data

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)

Return Table index