SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

ORA_DBA_TABLES Table in SAP | Copy of DBA_TABLES (currently not provided with snapshots) Table & Fields List

ORA_DBA_TABLES is a SAP table coming under BC module and SAP_BASIS component.View details, Fields & related tables of ORA_DBA_TABLES in SAP.

  • Table description : Copy of DBA_TABLES (currently not provided with snapshots)
  • Module : BC-CCM-MON-TUN
  • Parent Module : BC
  • Package : STUN
  • Software Component : SAP_BASIS
ORA_DBA_TABLES table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP ORA_DBA_TABLES Table Fields structure

FieldNoteData ElementDomain
SNAPSHOT_IDOracle monitor: snapshot IDORA_SNAPSHOT_IDORA_SNAPSHOT_ID
OWNEROracle monitoring: Owner of the objectORA_OWNER_30ORA_CHAR_30
TABLE_NAMEOracle monitoring: table nameORA_TABLE_NAMEORA_CHAR_30
TABLESPACE_NAMEOracle monitoring: Tablespacename to which objects belongORA_TABLESPACE_NAMEORA_CHAR_30
CLUSTER_NAMEOracle monitoring: cluster nameORA_CLUSTER_NAMEORA_CHAR_30
IOT_NAMEOracle monitoring: IOT nameORA_IOT_NAMEORA_CHAR_30
PCT_FREEOracle monitoring:percentage of free space in a blockORA_PCT_FREEORA_NUM_22
PCT_USEDOracle monitoring: percentage of used space in a blockORA_PCT_USEDORA_NUM_22
INI_TRANSOracle monitoring: Initial number of transactionsORA_INI_TRANSORA_NUM_22
MAX_TRANSOracle monitoring: Maximum number of transactionsORA_MAX_TRANSORA_NUM_22
INITIAL_EXTENTOracle monitoring: Size of the initial extent in bytesORA_INITIAL_EXTENTORA_NUM_22
NEXT_EXTENTOracle monitor: Next extentORA_NEXT_EXTENTORA_NUM_22
MIN_EXTENTSOracle monitor: Minimum extentORA_MIN_EXTENTSORA_NUM_22
MAX_EXTENTSOracle monitor: Maximum extentORA_MAX_EXTENTSORA_NUM_22
PCT_INCREASEOracle monitor. PCT increaseORA_PCT_INCREASEORA_NUM_22
FREELISTSOracle monitoring: Number of process freelists allocatedORA_FREELISTSORA_NUM_22
FREELIST_GROUPSOracle monitoring: Number of freelist groups allocatedORA_FREELIST_GROUPSORA_NUM_22
LOGGINGOracle monitoring: Logging attributeORA_LOGGINGAORA_CHAR_3
BACKED_UPOracle monitoring: Has table been backed up since last changORA_BACKED_UPORA_CHAR_1
NUM_ROWSOracle monitoring: Number of rows in the tableORA_NUM_ROWSORA_NUM_22
BLOCKSOracle monitoring: Number of used data blocks in the tableORA_BLOCKS_USEDORA_NUM_22
EMPTY_BLOCKSOracle monitoring: Number of empty (never used) data blocksORA_EMPTY_BLOCKSORA_NUM_22
AVG_SPACEOracle monitoring: avg. free space (bytes) in a data blockORA_AVG_SPACEORA_NUM_22
CHAIN_CNTOracle monitoring: Number of rows in table that are chainedORA_CHAIN_CNTORA_NUM_22
AVG_ROW_LENOracle monitoring: Average length of a row in table (bytes)ORA_AVG_ROW_LENORA_NUM_22
AVG_SPACE_FREEOracle monitoring: avg. freespace of all blocks on freelistORA_AVG_SPACE_FREEORA_NUM_22
NUM_FREELIST_BLKOracle monitoring: number of blocks on the freelistORA_NUM_FREELIST_BLKORA_NUM_22
DEGREEOracle monitoring: number of threads per instance for scanORA_DEGREEORA_DEC_22
INSTANCESOracle monitoring:inst. across which table is to be scannedORA_INSTANCESORA_CHAR_10
CACHEOracle monitoring:Whether the cluster is to be cached in bufORA_CACHE_DBAORA_CHAR_5
TABLE_LOCKOracle monitoring: Whether table locking is enabled or disabORA_TABLE_LOCKORA_CHAR_8
SAMPLE_SIZEOracle monitoring: Sample size used in analyzing this tableORA_SAMPLE_SIZEORA_NUM_22
LAST_ANALYZED_DOracle monitoring: Date of last table analysis (date field)ORA_LAST_ANALYZED_DORA_DATE
LAST_ANALYZED_TOracle monitoring: Date of last table analysis (time field)ORA_LAST_ANALYZED_TORA_TIME
PARTITIONEDOracle monitoring: Indicates whether table is partitionedORA_PARTITIONEDORA_CHAR_3
IOT_TYPEOracle monitoring: IOT typeORA_IOT_TYPEORA_CHAR_12
TEMPORARY_DBAOracle monitoring: data visible which is placed by this sessORA_TEMPORARYORA_CHAR_1
SECONDARYOracle monitoring: Is trigger a secondary objectORA_SECONDARYORA_CHAR_1
NESTEDOracle monitoring: Is the table a nested table?ORA_NESTEDORA_CHAR_3
BUFFER_POOLOracle monitoring: The default buffer pool for the objectORA_BUFFER_POOLORA_CHAR_7
ROW_MOVEMENTOracle monitoring: partitioned row movement is enabled ?ORA_ROW_MOVEMENTORA_CHAR_8
GLOBAL_STATSOracle monitoring: Stats collected for whole table or estimaORA_GLOBAL_STATSORA_CHAR_3
USER_STATSOracle monitoring: Were statistics entered directly by user?ORA_USER_STATSORA_CHAR_3
DURATIONOracle monitoring: duration of a temporary tableORA_DURATIONORA_CHAR_15
SKIP_CORRUPTOracle monitoring: If Oracle ignores blocks marked corruptORA_SKIP_CORRUPTORA_CHAR_8
MONITORINGOracle monitoring: table has the MONITORING attribute setORA_MONITORINGORA_CHAR_3
CLUSTER_OWNEROracle monitoring: Cluster ownerORA_CLUSTER_OWNERORA_CHAR_30
DEPENDENCIESOracle monitoring: DependenciesORA_DEPENDENCIESORA_CHAR_8
COMPRESSIONOracle monitoring: CompressionORA_COMPRESSIONORA_CHAR_8

ORA_DBA_TABLES related tables

TableNote
ORA_DBA_TABLESCopy of DBA_TABLES (currently not provided with snapshots)
GVD_DATABASECopy of GV$DATABASE (currently not provided with snapshots)
GVD_LATCHNAMECopy of GV$LATCHNAME (currently not provided with snapshots)
GVD_SESS_IOCopy of GV$SESS_IO (currently not provided with snapshots)
GVD_SQLCopy of GV$SQL (currently not provided with snapshots)
GVD_SQLAREACopy of GV$SQLAREA (currently not provided with snapshots)
GVD_SQLTEXTCopy of GV$SQLTEXT (currently not provided with snapshots)
ORA_DBA_EXTENTSCopy of DBA_EXTENTS (currently not provided with snapshots)
ORA_DBA_OBJECTSCopy of DBA_OBJECTS (currently not provided with snapshots)
ORA_DBA_SEGMENTSCopy of DBA_SEGMENTS (currently not provided with snapshots)
GVD_DB_CACHE_ADVCopy of GV$DB_CACHE_ADVICE (currently not provided w. snaps)
GVD_LATCHHOLDERCopy of GV$LATCHHOLDER (currently not provided with snapsh)
GVD_LATCH_PARENTCopy of GV$LATCH_PARENT (currently not provided with snaps)
GVD_MANGD_STANBYcopy of GV$MANAGED_STANDBY (currently not provided w. snaps)
GVD_PARAMETER2Copy of GV$PARAMETER2 (currently not provided with snapshot
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com