SAP ABAP Class CL_ORA_ACTION (ORACLE: DBA Cockpit)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷
S_ORA_COCKPIT (Package) DBACockpit: Oracle Monitors
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors⤷
S_ORA_COCKPIT (Package) DBACockpit: Oracle MonitorsMeta Relationship - Using
| # | Relationship type | Using | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_DBA_ACTION | Meta data for DB-dependent DBA actions | 20080129 |
Properties
| Class | CL_ORA_ACTION | |
| Short Description | ORACLE: DBA Cockpit | |
| Super Class | CL_DBA_ACTION | Meta data for DB-dependent DBA actions |
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | S_ORA_COCKPIT | DBACockpit: Oracle Monitors |
| Created | 20080129 | SAP |
| Last change | 20140121 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
Class CL_ORA_ACTION has no forward declaration.
Interfaces
Class CL_ORA_ACTION has no interface implemented.
Friends
Class CL_ORA_ACTION has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | ARCHHIST_LIST |
Constant | Public | Type reference (TYPE) | I | 77 | Archive History List | 20080129 | |
| 2 | BACKUPLOGS |
Constant | Public | Type reference (TYPE) | I | 74 | Backup Logs | 20080129 | |
| 3 | BACKUPLOGS_LIST |
Constant | Public | Type reference (TYPE) | I | 75 | Backup Logs List | 20080129 | |
| 4 | DB02_DBO |
Constant | Public | Type reference (TYPE) | I | 44 | DB02: Database overview | 20080129 | |
| 5 | DB02_DISPLAY_BW_A |
Constant | Public | Type reference (TYPE) | I | 80 | DB02 : Additional Functions - BW Analysis | 20080129 | |
| 6 | DB02_DISPLAY_COS |
Constant | Public | Type reference (TYPE) | I | 53 | DB02 :Collector statistics | 20080129 | |
| 7 | DB02_DISPLAY_DBA |
Constant | Public | Type reference (TYPE) | I | 52 | DB02 : Display DBA tables | 20080129 | |
| 8 | DB02_GENERAL |
Constant | Public | Type reference (TYPE) | I | 60 | DB02: General | 20080129 | |
| 9 | DB02_SEGMENTS_SG_A |
Constant | Public | Type reference (TYPE) | I | 61 | DB02 : Segments Specific (Aggregated) | 20080129 | |
| 10 | DB02_SEGMENTS_SG_G |
Constant | Public | Type reference (TYPE) | I | 62 | DB02 : Segments - General | 20080129 | |
| 11 | DB02_SEGMENTS_SG_S |
Constant | Public | Type reference (TYPE) | I | 63 | DB02 : Segments - Specific Data (Single Segments) | 20080129 | |
| 12 | DB02_TABLESPACES |
Constant | Public | Type reference (TYPE) | I | 47 | DB02 : Tablespaces General | 20080129 | |
| 13 | DB02_TABLESPACES_S |
Constant | Public | Type reference (TYPE) | I | 48 | DB02 : Tablespaces Specific | 20080129 | |
| 14 | DB02_USERS |
Constant | Public | Type reference (TYPE) | I | 45 | DB02 : Users General | 20080129 | |
| 15 | DB02_USERS_S |
Constant | Public | Type reference (TYPE) | I | 46 | DB02 : Users Specific | 20080129 | |
| 16 | DB02_UT |
Constant | Public | Type reference (TYPE) | I | 777 | db02 : Display USER tables | 20080129 | |
| 17 | DB13_CONFIG |
Constant | Public | Type reference (TYPE) | I | 606 | Oracle DB13 setup | 20080129 | |
| 18 | DB16ORA |
Constant | Public | Type reference (TYPE) | I | 610 | Dbcheck Results | 20080129 | |
| 19 | DB16ORA_DETAIL |
Constant | Public | Type reference (TYPE) | I | 611 | Dbcheck Results Detail | 20080129 | |
| 20 | DB17ORA |
Constant | Public | Type reference (TYPE) | I | 612 | Check Conditions | 20080129 | |
| 21 | DB17ORA_DETAIL |
Constant | Public | Type reference (TYPE) | I | 613 | Check Condtions Detail | 20080129 | |
| 22 | DB17ORA_PRINT |
Constant | Public | Type reference (TYPE) | I | 614 | Check Condtions Print | 20080129 | |
| 23 | DBALOGS |
Constant | Public | Type reference (TYPE) | I | 71 | DBA Logs from Planning calendar | 20080129 | |
| 24 | DBA_FID |
Constant | Public | Type reference (TYPE) | I | 73 | DBA Logs FID | 20080129 | |
| 25 | DBA_SDBAH |
Constant | Public | Type reference (TYPE) | I | 72 | DBA Logs SDBAH | 20080129 | |
| 26 | ORAACT_ASH |
Constant | Public | Type reference (TYPE) | I | 42 | Action: Active Session History | 20080129 | |
| 27 | ORAACT_ASH_REPORT |
Constant | Public | Type reference (TYPE) | I | 4410 | ST04: ASH Reporting | 20080129 | |
| 28 | ORAACT_AWR_REPORT |
Constant | Public | Type reference (TYPE) | I | 51 | Action: AWR Report | 20080129 | |
| 29 | ORAACT_DB02 |
Constant | Public | Type reference (TYPE) | I | 2 | 20080129 | ||
| 30 | ORAACT_EXPLAIN_EDITOR |
Constant | Public | Type reference (TYPE) | I | 615 | Explain | 20080312 | |
| 31 | ORAACT_JSEL |
Constant | Public | Type reference (TYPE) | I | 43 | ST04: Arbitrary monitoring - Join selects | 20080129 | |
| 32 | ORAACT_MET_FL |
Constant | Public | Type reference (TYPE) | I | 3240 | Metrics: File | 20080129 | |
| 33 | ORAACT_MET_SES |
Constant | Public | Type reference (TYPE) | I | 3230 | Metrics: Session | 20080129 | |
| 34 | ORAACT_MET_SS |
Constant | Public | Type reference (TYPE) | I | 3200 | Metrics: System Summary | 20080129 | |
| 35 | ORAACT_MET_SYS |
Constant | Public | Type reference (TYPE) | I | 3210 | Metrics: System | 20080129 | |
| 36 | ORAACT_MET_WT |
Constant | Public | Type reference (TYPE) | I | 3220 | Metrics: Wait Class | 20080129 | |
| 37 | ORAACT_ST04 |
Constant | Public | Type reference (TYPE) | I | 1 | 20080129 | ||
| 38 | ORA_ACTIVITY |
Constant | Public | Type reference (TYPE) | I | 1001 | parent: ST04: Activity | 20080129 | |
| 39 | ORA_ADDITIONAL |
Constant | Public | Type reference (TYPE) | I | 1004 | parent: ST04: Additional Function | 20080129 | |
| 40 | ORA_ADDITIONAL_FCTS |
Constant | Public | Type reference (TYPE) | I | 1010 | parent :DB02: Additional functions | 20080129 | |
| 41 | ORA_AWR |
Constant | Public | Type reference (TYPE) | I | 1015 | parent: ST04: Automatic Workload Repository | 20080129 | |
| 42 | ORA_AWR_ADMIN_DATA |
Constant | Public | Type reference (TYPE) | I | 1016 | parent: ST04: AWR Admin Data | 20080129 | |
| 43 | ORA_AWR_PERF_ANA |
Constant | Public | Type reference (TYPE) | I | 1017 | parent: ST04: AWR Performance Analysis | 20080129 | |
| 44 | ORA_AWR_REPORTING |
Constant | Public | Type reference (TYPE) | I | 10108 | parent: ST04: AWR Reporting | 20080129 | |
| 45 | ORA_CLIENT_STATS |
Constant | Public | Type reference (TYPE) | I | 601 | Oracle Client End to End Stats | 20080129 | |
| 46 | ORA_CLIENT_TRACE |
Constant | Public | Type reference (TYPE) | I | 600 | Oracle Client End to End Trace | 20080129 | |
| 47 | ORA_CL_ST_DISPLAY |
Constant | Public | Type reference (TYPE) | I | 602 | Oracle Client Stats Display | 20080129 | |
| 48 | ORA_DATABASE |
Constant | Public | Type reference (TYPE) | I | 1006 | parent :DB02: Database | 20080129 | |
| 49 | ORA_EXCEPTIONAL |
Constant | Public | Type reference (TYPE) | I | 1003 | parent: ST04: Exceptional conditions | 20080129 | |
| 50 | ORA_FEAT_MON |
Constant | Public | Type reference (TYPE) | I | 1015 | parent ST04: Feature Monitoring | 20080129 | |
| 51 | ORA_PROGRAM_STATS |
Constant | Public | Type reference (TYPE) | I | 604 | Oracle Program End to End Stats | 20080129 | |
| 52 | ORA_PROGRAM_TRACE |
Constant | Public | Type reference (TYPE) | I | 603 | Oracle Program End to End Trace | 20080129 | |
| 53 | ORA_PR_ST_DISPLAY |
Constant | Public | Type reference (TYPE) | I | 605 | Oracle Program Stats Display | 20080129 | |
| 54 | ORA_RESOURCE |
Constant | Public | Type reference (TYPE) | I | 1002 | parent: ST04: Resource consumption | 20080129 | |
| 55 | ORA_SEGMENTS |
Constant | Public | Type reference (TYPE) | I | 1009 | parent :DB02: Segments | 20080129 | |
| 56 | ORA_SQL_STMT |
Constant | Public | Type reference (TYPE) | I | 1012 | parent ST04: SQL Statement Analysis | 20080129 | |
| 57 | ORA_STATS_INF |
Constant | Public | Type reference (TYPE) | I | 1014 | parent ST04: Statistical Information | 20080129 | |
| 58 | ORA_TABLESPACES |
Constant | Public | Type reference (TYPE) | I | 1008 | parent :DB02: Tablespaces | 20080129 | |
| 59 | ORA_USERS |
Constant | Public | Type reference (TYPE) | I | 1007 | parent :DB02: Users | 20080129 | |
| 60 | ORA_WAIT |
Constant | Public | Type reference (TYPE) | I | 1011 | parent ST04: Wait Event Analysis | 20080129 | |
| 61 | RECOVERY_REPORT |
Constant | Public | Type reference (TYPE) | I | 78 | Recovery Report | 20080129 | |
| 62 | REDOLOGS_LIST |
Constant | Public | Type reference (TYPE) | I | 76 | Redo Logs List | 20080129 | |
| 63 | RZ20SEGFEW |
Constant | Public | Type reference (TYPE) | I | 616 | RZ20 Analysis | 20080129 | |
| 64 | RZ20SEGMAX |
Constant | Public | Type reference (TYPE) | I | 620 | RZ20 Analysis | 20080129 | |
| 65 | RZ20SEGMAXF |
Constant | Public | Type reference (TYPE) | I | 621 | RZ20 Analysis | 20080129 | |
| 66 | RZ20SEGMOST |
Constant | Public | Type reference (TYPE) | I | 622 | RZ20 Analysis | 20080129 | |
| 67 | RZ20SEGPCTIN |
Constant | Public | Type reference (TYPE) | I | 623 | RZ20 Analysis | 20080129 | |
| 68 | RZ20SEGTOOF |
Constant | Public | Type reference (TYPE) | I | 619 | RZ20 Analysis | 20080129 | |
| 69 | RZ20TBLSP |
Constant | Public | Type reference (TYPE) | I | 624 | RZ20 Analysis | 20080129 | |
| 70 | RZ20TBLSPFREE |
Constant | Public | Type reference (TYPE) | I | 618 | RZ20 Analysis | 20080129 | |
| 71 | RZ20TBLSPSTAT |
Constant | Public | Type reference (TYPE) | I | 625 | RZ20 Analysis | 20080129 | |
| 72 | RZ20TBLSPUSED |
Constant | Public | Type reference (TYPE) | I | 617 | RZ20 Analysis | 20080129 | |
| 73 | ST04_ASSM |
Constant | Public | Type reference (TYPE) | I | 32 | ST04: ASSM | 20080129 | |
| 74 | ST04_BBW_TEST |
Constant | Public | Type reference (TYPE) | I | 99004 | ST04: BBW Test | 20080129 | |
| 75 | ST04_BUFFER_BUSY_WAIT |
Constant | Public | Type reference (TYPE) | I | 4 | ST04: Buffer Busy Waits Monitor | 20080129 | |
| 76 | ST04_CBO |
Constant | Public | Type reference (TYPE) | I | 37 | ST04: System Statistics for CBO | 20080129 | |
| 77 | ST04_CHKPT |
Constant | Public | Type reference (TYPE) | I | 405 | ST04: Checkpoints | 20080129 | |
| 78 | ST04_COL_USAGE |
Constant | Public | Type reference (TYPE) | I | 54 | ST04: Col Usage Monitor | 20080129 | |
| 79 | ST04_DML |
Constant | Public | Type reference (TYPE) | I | 40 | ST04 : Database Message Log | 20080129 | |
| 80 | ST04_DNFS |
Constant | Public | Type reference (TYPE) | I | 101 | ST04: DNFS Monitor | 20090907 | |
| 81 | ST04_EM |
Constant | Public | Type reference (TYPE) | I | 2900 | Event Metrics | 20130206 | |
| 82 | ST04_ENQUEUE_STAT |
Constant | Public | Type reference (TYPE) | I | 5 | ST04: Enqueue Stat Monitor | 20080129 | |
| 83 | ST04_FCRA |
Constant | Public | Type reference (TYPE) | I | 3100 | ST04: FCRA | 20130108 | |
| 84 | ST04_FSR |
Constant | Public | Type reference (TYPE) | I | 34 | ST04: Filesystem Requests | 20080129 | |
| 85 | ST04_GVTABLES |
Constant | Public | Type reference (TYPE) | I | 28 | ST04: Display GV$ tables | 20080129 | |
| 86 | ST04_IOACT |
Constant | Public | Type reference (TYPE) | I | 1801 | IO Activities | 20120913 | |
| 87 | ST04_IOREDOLOG |
Constant | Public | Type reference (TYPE) | I | 1901 | ST04: IO Redolog Per hour | 20120405 | |
| 88 | ST04_LOCK |
Constant | Public | Type reference (TYPE) | I | 401 | ST04 : Lock Monitor | 20080129 | |
| 89 | ST04_LTC |
Constant | Public | Type reference (TYPE) | I | 33 | ST04: Latch Monitor | 20080129 | |
| 90 | ST04_MM |
Constant | Public | Type reference (TYPE) | I | 400 | ST04: Main Monitor | 20121127 | |
| 91 | ST04_MM2 |
Constant | Public | Type reference (TYPE) | I | 410 | ST04: Main Monitor (Version 2) | 20091104 | |
| 92 | ST04_ORANET |
Constant | Public | Type reference (TYPE) | I | 3500 | ST04: Oracle net | 20080129 | |
| 93 | ST04_ORA_EXAMPLE |
Constant | Public | Type reference (TYPE) | I | 607 | WD example | 20080129 | |
| 94 | ST04_PARALDEGACT |
Constant | Public | Type reference (TYPE) | I | 2601 | ST04: Parallel Degree Active | 20120412 | |
| 95 | ST04_PARAMCONFIG |
Constant | Public | Type reference (TYPE) | I | 29 | ST04: Parameters configuration | 20080129 | |
| 96 | ST04_PATCH |
Constant | Public | Type reference (TYPE) | I | 1501 | Configurations Patch | 20120607 | |
| 97 | ST04_PERF_DB |
Constant | Public | Type reference (TYPE) | I | 38 | ST04: Peformance database | 20080129 | |
| 98 | ST04_PERF_DB_2 |
Constant | Public | Type reference (TYPE) | I | 55 | ST04: Peformance database 2 | 20080129 | |
| 99 | ST04_PES |
Constant | Public | Type reference (TYPE) | I | 2801 | ST04: Parallel Execution Sessions | 20120620 | |
| 100 | ST04_PGA |
Constant | Public | Type reference (TYPE) | I | 49 | ST04: PGA Monitor | 20080129 | |
| 101 | ST04_PQ |
Constant | Public | Type reference (TYPE) | I | 36 | ST04: Parallel Query | 20080129 | |
| 102 | ST04_RSA |
Constant | Public | Type reference (TYPE) | I | 41 | ST04: Resumable Space Allocation | 20080129 | |
| 103 | ST04_RSORASTT |
Constant | Public | Type reference (TYPE) | I | 4000 | RSORASTT: Dyn. Load. Monitors | 20090325 | |
| 104 | ST04_SESSION |
Constant | Public | Type reference (TYPE) | I | 499 | ST04: Oracle Session | 20080129 | |
| 105 | ST04_SGA |
Constant | Public | Type reference (TYPE) | I | 50 | ST04: SGA Monitor | 20080129 | |
| 106 | ST04_SM |
Constant | Public | Type reference (TYPE) | I | 402 | ST04: Session Monitor | 20080129 | |
| 107 | ST04_SQLC |
Constant | Public | Type reference (TYPE) | I | 56 | ST04: SQL Command Editor II | 20080129 | |
| 108 | ST04_SQLC_N |
Constant | Public | Type reference (TYPE) | I | 57 | General SQL Command Editor | 20110809 | |
| 109 | ST04_SQLREQUEST |
Constant | Public | Type reference (TYPE) | I | 31 | ST04: SQLrequest | 20080129 | |
| 110 | ST04_SQLREQUEST_STMTA |
Constant | Public | Type reference (TYPE) | I | 312 | ST04: SQLRequest->Stmt Analysis | 20090630 | |
| 111 | ST04_SQLREQUEST_TABLE |
Constant | Public | Type reference (TYPE) | I | 311 | ST04: SQLrequest->Table filter | 20080129 | |
| 112 | ST04_SYSEVT_HIST_2 |
Constant | Public | Type reference (TYPE) | I | 500 | ST04: Session History: Test | 20080129 | |
| 113 | ST04_SYSTEM_EVENT_3 |
Constant | Public | Type reference (TYPE) | I | 333 | ST04: System Event Monitor (new) | 20100325 | |
| 114 | ST04_SYSTEM_EVENT_WEBDYN |
Constant | Public | Type reference (TYPE) | I | 608 | WD test w/ sys evt | 20080129 | |
| 115 | ST04_TA |
Constant | Public | Type reference (TYPE) | I | 404 | ST04: Table Access | 20080129 | |
| 116 | ST04_TE |
Constant | Public | Type reference (TYPE) | I | 2700 | ST04: Timed Events | 20121119 | |
| 117 | ST04_TOPSQL |
Constant | Public | Type reference (TYPE) | I | 403 | ST04: Top SQL Statements | 20080129 | |
| 118 | ST04_TS |
Constant | Public | Type reference (TYPE) | I | 2501 | Segment Statistics | 20130124 | |
| 119 | ST04_TUN_ADV |
Constant | Public | Type reference (TYPE) | I | 1700 | ST04: SQL Tuning Advisor | 20080129 | |
| 120 | ST04_UNDO_STATS |
Constant | Public | Type reference (TYPE) | I | 30 | ST04: Undo statistics | 20080129 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | CHECK_FEATURE_USED |
Instance method | Private | Method | Check if Oracle Feature is used | 20080129 |
| 2 | CONSTRUCTOR |
Instance method | Public | Constructor | CONSTRUCTOR | 20080129 |
Events
Class CL_ORA_ACTION has no event.
Types
Class CL_ORA_ACTION has no local type.
Method Signatures
Method CHECK_FEATURE_USED Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
P_FEATURE | Call by reference | Type reference (TYPE) | STRING | Oracle Feature | 20080129 | ||
| 2 |  Returning |
P_IS_USED | Value transfer | Type reference (TYPE) | STRING | X = is used, ' ' = not used | 20080129 | ||
| 3 | Importing |
P_REMSYS | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20080129 |
Method CHECK_FEATURE_USED on class CL_ORA_ACTION has no exception.
Method CONSTRUCTOR Signature
Method CONSTRUCTOR on class CL_ORA_ACTION has no parameter.
Method CONSTRUCTOR on class CL_ORA_ACTION has no exception.
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in | 703 |
