openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MCOD_ORA_GET_INFOS:
    post:
      tags:
      - NORA
      operationId: /rfc/MCOD_ORA_GET_INFOS
      requestBody:
        content:
          application/json:
            schema:
              properties:
                DATA_DL:
                  type: string
                  default: ' '
                  maxLength: 1
                  description: General Flag
                ALL_SYSTEM_EVENT:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      EVENT:
                        type: string
                        maxLength: 30
                        description: Event
                      TOT_WAITS:
                        type: integer
                        format: int64
                        description: Total Waits
                      TOTTIMOUTS:
                        type: integer
                        format: int64
                        description: Total Timeouts
                      TIMEWAITED:
                        type: integer
                        format: int64
                        description: Time Waited
                      AVGWAIT:
                        type: integer
                        format: int64
                        description: Average Wait Time
                      SYSTOTWAIT:
                        type: integer
                        format: int64
                        description: Total Waits in the System
                      SYSTIMWAIT:
                        type: integer
                        format: int64
                        description: Time Waited in the System
                ALL_SYSTEM_EVENT_SUM:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      EVENT:
                        type: string
                        maxLength: 30
                        description: Event
                      TOT_WAITS:
                        type: integer
                        format: int64
                        description: Total Waits
                      TOTTIMOUTS:
                        type: integer
                        format: int64
                        description: Total Timeouts
                      TIMEWAITED:
                        type: integer
                        format: int64
                        description: Time Waited
                      AVGWAIT:
                        type: integer
                        format: int64
                        description: Average Wait Time
                      SYSTOTWAIT:
                        type: integer
                        format: int64
                        description: Total Waits in the System
                      SYSTIMWAIT:
                        type: integer
                        format: int64
                        description: Time Waited in the System
                CPU_PER_USER:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      SID:
                        type: string
                        maxLength: 10
                        description: SID
                      STAT:
                        type: string
                        maxLength: 10
                        description: Statistical Number
                      CPU:
                        type: integer
                        format: int64
                        description: CPU Time
                CPU_PER_USER_PER_SID:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      SID:
                        type: string
                        maxLength: 10
                        description: SID
                      STAT:
                        type: string
                        maxLength: 10
                        description: Statistical Number
                      CPU:
                        type: integer
                        format: int64
                        description: CPU Time
                CPU_PER_USER_SUM:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      SID:
                        type: string
                        maxLength: 10
                        description: SID
                      STAT:
                        type: string
                        maxLength: 10
                        description: Statistical Number
                      CPU:
                        type: integer
                        format: int64
                        description: CPU Time
                CPU_WAIT_PER_USER:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      CPUTIME:
                        type: integer
                        format: int64
                        description: cputime(user)
                      WAITTIME:
                        type: integer
                        format: int64
                        description: waittime(user)
                      SYSCPU:
                        type: integer
                        format: int64
                        description: cputime(system)
                      SYSWAIT:
                        type: integer
                        format: int64
                        description: waittime(system)
                      CPURATIO:
                        type: integer
                        format: int64
                        description: cpu(user) / cpu(system)
                      WAITRATIO:
                        type: integer
                        format: int64
                        description: waittime(user) / waittime(system)
                      CPU&WAIT:
                        type: integer
                        format: int64
                        description: cputime + waittime
                      CPU_CPUWT:
                        type: integer
                        format: int64
                        description: cputime / cpu + waittime
                      WAIT_CPUWT:
                        type: integer
                        format: int64
                        description: waittime / cpu + waittime
                SESSION_EVENT:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      EVENT:
                        type: string
                        maxLength: 30
                        description: Event
                      TOT_WAITS:
                        type: integer
                        format: int64
                        description: Total Waits
                      TOTTIMOUTS:
                        type: integer
                        format: int64
                        description: Total Timeouts
                      TIMEWAITED:
                        type: integer
                        format: int64
                        description: Time Waited
                      AVGWAIT:
                        type: integer
                        format: int64
                        description: Average Wait Time
                      SYSTOTWAIT:
                        type: integer
                        format: int64
                        description: Total Waits in the System
                      SYSTIMWAIT:
                        type: integer
                        format: int64
                        description: Time Waited in the System
                SESSION_EVENT_USER:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      EVENT:
                        type: string
                        maxLength: 30
                        description: Event
                      TOT_WAITS:
                        type: integer
                        format: int64
                        description: Total Waits
                      TOTTIMOUTS:
                        type: integer
                        format: int64
                        description: Total Timeouts
                      TIMEWAITED:
                        type: integer
                        format: int64
                        description: Time Waited
                      AVGWAIT:
                        type: integer
                        format: int64
                        description: Average Wait Time
                      SYSTOTWAIT:
                        type: integer
                        format: int64
                        description: Total Waits in the System
                      SYSTIMWAIT:
                        type: integer
                        format: int64
                        description: Time Waited in the System
                SQL_SESSTAT_TAB:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      SQL_DR_PU:
                        type: integer
                        format: int64
                        description: Disk Reads per User from v$sql
                      SESS_DR_PU:
                        type: integer
                        format: int64
                        description: Disk Reads per User from v$sesstat
                      SQL_DR:
                        type: integer
                        format: int64
                        description: Disk Reads System-Wide from v$sql
                      SESS_DR:
                        type: integer
                        format: int64
                        description: Disk Reads System-Wide from v$sesstat
                      SQL_BG_PU:
                        type: integer
                        format: int64
                        description: Buffer Gets per User from v$sql
                      SESS_BG_PU:
                        type: integer
                        format: int64
                        description: Buffer Gets per User from v$sesstat
                      SQL_BG:
                        type: integer
                        format: int64
                        description: Buffer Gets System-Wide from v$sql
                      SESS_BG:
                        type: integer
                        format: int64
                        description: Buffer Gets System-Wide from v$sesstat
                      SQL_BG_PER:
                        type: integer
                        format: int64
                        description: Percentage of Buffer Gets per User from v$sql in System BG
                      SES_BG_PER:
                        type: integer
                        format: int64
                        description: Percentage of Buffer Gets per User from v$sessta in System B
                      SQL_DR_PER:
                        type: integer
                        format: int64
                        description: Percentage of Disk Reads per User from v$sql in System DR
                      SES_DR_PER:
                        type: integer
                        format: int64
                        description: Percentage of Disk Reads per User from v$sessta in System DR
                      BG_AVG_PER:
                        type: integer
                        format: int64
                        description: Average of Buffer Gets from v$sql and v$sesstat
                      DR_AVG_PER:
                        type: integer
                        format: int64
                        description: Average of Disk Reads from v$sql and v$sesstat
                SQL_TAB:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      STATEMENT:
                        type: string
                        maxLength: 12
                        description: Statement Type
                      ANZAHL:
                        type: integer
                        format: int32
                        description: lines
                      DR_PR_STMT:
                        type: integer
                        format: int64
                        description: Disk Reads per Statement
                      DR_ST_PERC:
                        type: integer
                        format: int64
                        description: Disk Reads per Statement (Percentage)
                      DR_PR_USER:
                        type: integer
                        format: int64
                        description: Disk Reads per User
                      SUM_DR:
                        type: integer
                        format: int64
                        description: Sum of Disk Reads
                      DR_PERCENT:
                        type: integer
                        format: int64
                        description: Disk Reads (Percentage)
                      BG_PR_STMT:
                        type: integer
                        format: int64
                        description: Buffer Gets per Statement
                      BG_ST_PERC:
                        type: integer
                        format: int64
                        description: Buffer Gets per Statement (Percentage)
                      BG_PR_USER:
                        type: integer
                        format: int64
                        description: Buffer Gets per User
                      SUM_BG:
                        type: integer
                        format: int64
                        description: Sum of Disk Buffer Gets
                      BG_PERCENT:
                        type: integer
                        format: int64
                        description: Buffer Gets (Percentage)
                      ST_USR_QUA:
                        type: integer
                        format: int64
                        description: Quality of Statement Type per User
                      USR_QUAL:
                        type: integer
                        format: int64
                        description: Quality per User
                SYSTEM_EVENT:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      CPUTIME:
                        type: integer
                        format: int64
                        description: cputime(user)
                      WAITTIME:
                        type: integer
                        format: int64
                        description: waittime(user)
                      SYSCPU:
                        type: integer
                        format: int64
                        description: cputime(system)
                      SYSWAIT:
                        type: integer
                        format: int64
                        description: waittime(system)
                      CPURATIO:
                        type: integer
                        format: int64
                        description: cpu(user) / cpu(system)
                      WAITRATIO:
                        type: integer
                        format: int64
                        description: waittime(user) / waittime(system)
                      CPU&WAIT:
                        type: integer
                        format: int64
                        description: cputime + waittime
                      CPU_CPUWT:
                        type: integer
                        format: int64
                        description: cputime / cpu + waittime
                      WAIT_CPUWT:
                        type: integer
                        format: int64
                        description: waittime / cpu + waittime
                SYSTEM_EVENT_SUM:
                  type: array
                  items:
                    type: object
                    properties:
                      USR#:
                        type: string
                        maxLength: 10
                        description: User Number
                      USERNAME:
                        type: string
                        maxLength: 20
                        description: User Name
                      CPUTIME:
                        type: integer
                        format: int64
                        description: cputime(user)
                      WAITTIME:
                        type: integer
                        format: int64
                        description: waittime(user)
                      SYSCPU:
                        type: integer
                        format: int64
                        description: cputime(system)
                      SYSWAIT:
                        type: integer
                        format: int64
                        description: waittime(system)
                      CPURATIO:
                        type: integer
                        format: int64
                        description: cpu(user) / cpu(system)
                      WAITRATIO:
                        type: integer
                        format: int64
                        description: waittime(user) / waittime(system)
                      CPU&WAIT:
                        type: integer
                        format: int64
                        description: cputime + waittime
                      CPU_CPUWT:
                        type: integer
                        format: int64
                        description: cputime / cpu + waittime
                      WAIT_CPUWT:
                        type: integer
                        format: int64
                        description: waittime / cpu + waittime
              required:
              - DATA_DL
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  ALL_SYSTEM_EVENT:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        EVENT:
                          type: string
                          maxLength: 30
                          description: Event
                        TOT_WAITS:
                          type: integer
                          format: int64
                          description: Total Waits
                        TOTTIMOUTS:
                          type: integer
                          format: int64
                          description: Total Timeouts
                        TIMEWAITED:
                          type: integer
                          format: int64
                          description: Time Waited
                        AVGWAIT:
                          type: integer
                          format: int64
                          description: Average Wait Time
                        SYSTOTWAIT:
                          type: integer
                          format: int64
                          description: Total Waits in the System
                        SYSTIMWAIT:
                          type: integer
                          format: int64
                          description: Time Waited in the System
                  ALL_SYSTEM_EVENT_SUM:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        EVENT:
                          type: string
                          maxLength: 30
                          description: Event
                        TOT_WAITS:
                          type: integer
                          format: int64
                          description: Total Waits
                        TOTTIMOUTS:
                          type: integer
                          format: int64
                          description: Total Timeouts
                        TIMEWAITED:
                          type: integer
                          format: int64
                          description: Time Waited
                        AVGWAIT:
                          type: integer
                          format: int64
                          description: Average Wait Time
                        SYSTOTWAIT:
                          type: integer
                          format: int64
                          description: Total Waits in the System
                        SYSTIMWAIT:
                          type: integer
                          format: int64
                          description: Time Waited in the System
                  CPU_PER_USER:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        SID:
                          type: string
                          maxLength: 10
                          description: SID
                        STAT:
                          type: string
                          maxLength: 10
                          description: Statistical Number
                        CPU:
                          type: integer
                          format: int64
                          description: CPU Time
                  CPU_PER_USER_PER_SID:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        SID:
                          type: string
                          maxLength: 10
                          description: SID
                        STAT:
                          type: string
                          maxLength: 10
                          description: Statistical Number
                        CPU:
                          type: integer
                          format: int64
                          description: CPU Time
                  CPU_PER_USER_SUM:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        SID:
                          type: string
                          maxLength: 10
                          description: SID
                        STAT:
                          type: string
                          maxLength: 10
                          description: Statistical Number
                        CPU:
                          type: integer
                          format: int64
                          description: CPU Time
                  CPU_WAIT_PER_USER:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        CPUTIME:
                          type: integer
                          format: int64
                          description: cputime(user)
                        WAITTIME:
                          type: integer
                          format: int64
                          description: waittime(user)
                        SYSCPU:
                          type: integer
                          format: int64
                          description: cputime(system)
                        SYSWAIT:
                          type: integer
                          format: int64
                          description: waittime(system)
                        CPURATIO:
                          type: integer
                          format: int64
                          description: cpu(user) / cpu(system)
                        WAITRATIO:
                          type: integer
                          format: int64
                          description: waittime(user) / waittime(system)
                        CPU&WAIT:
                          type: integer
                          format: int64
                          description: cputime + waittime
                        CPU_CPUWT:
                          type: integer
                          format: int64
                          description: cputime / cpu + waittime
                        WAIT_CPUWT:
                          type: integer
                          format: int64
                          description: waittime / cpu + waittime
                  SESSION_EVENT:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        EVENT:
                          type: string
                          maxLength: 30
                          description: Event
                        TOT_WAITS:
                          type: integer
                          format: int64
                          description: Total Waits
                        TOTTIMOUTS:
                          type: integer
                          format: int64
                          description: Total Timeouts
                        TIMEWAITED:
                          type: integer
                          format: int64
                          description: Time Waited
                        AVGWAIT:
                          type: integer
                          format: int64
                          description: Average Wait Time
                        SYSTOTWAIT:
                          type: integer
                          format: int64
                          description: Total Waits in the System
                        SYSTIMWAIT:
                          type: integer
                          format: int64
                          description: Time Waited in the System
                  SESSION_EVENT_USER:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        EVENT:
                          type: string
                          maxLength: 30
                          description: Event
                        TOT_WAITS:
                          type: integer
                          format: int64
                          description: Total Waits
                        TOTTIMOUTS:
                          type: integer
                          format: int64
                          description: Total Timeouts
                        TIMEWAITED:
                          type: integer
                          format: int64
                          description: Time Waited
                        AVGWAIT:
                          type: integer
                          format: int64
                          description: Average Wait Time
                        SYSTOTWAIT:
                          type: integer
                          format: int64
                          description: Total Waits in the System
                        SYSTIMWAIT:
                          type: integer
                          format: int64
                          description: Time Waited in the System
                  SQL_SESSTAT_TAB:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        SQL_DR_PU:
                          type: integer
                          format: int64
                          description: Disk Reads per User from v$sql
                        SESS_DR_PU:
                          type: integer
                          format: int64
                          description: Disk Reads per User from v$sesstat
                        SQL_DR:
                          type: integer
                          format: int64
                          description: Disk Reads System-Wide from v$sql
                        SESS_DR:
                          type: integer
                          format: int64
                          description: Disk Reads System-Wide from v$sesstat
                        SQL_BG_PU:
                          type: integer
                          format: int64
                          description: Buffer Gets per User from v$sql
                        SESS_BG_PU:
                          type: integer
                          format: int64
                          description: Buffer Gets per User from v$sesstat
                        SQL_BG:
                          type: integer
                          format: int64
                          description: Buffer Gets System-Wide from v$sql
                        SESS_BG:
                          type: integer
                          format: int64
                          description: Buffer Gets System-Wide from v$sesstat
                        SQL_BG_PER:
                          type: integer
                          format: int64
                          description: Percentage of Buffer Gets per User from v$sql in System BG
                        SES_BG_PER:
                          type: integer
                          format: int64
                          description: Percentage of Buffer Gets per User from v$sessta in System B
                        SQL_DR_PER:
                          type: integer
                          format: int64
                          description: Percentage of Disk Reads per User from v$sql in System DR
                        SES_DR_PER:
                          type: integer
                          format: int64
                          description: Percentage of Disk Reads per User from v$sessta in System DR
                        BG_AVG_PER:
                          type: integer
                          format: int64
                          description: Average of Buffer Gets from v$sql and v$sesstat
                        DR_AVG_PER:
                          type: integer
                          format: int64
                          description: Average of Disk Reads from v$sql and v$sesstat
                  SQL_TAB:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        STATEMENT:
                          type: string
                          maxLength: 12
                          description: Statement Type
                        ANZAHL:
                          type: integer
                          format: int32
                          description: lines
                        DR_PR_STMT:
                          type: integer
                          format: int64
                          description: Disk Reads per Statement
                        DR_ST_PERC:
                          type: integer
                          format: int64
                          description: Disk Reads per Statement (Percentage)
                        DR_PR_USER:
                          type: integer
                          format: int64
                          description: Disk Reads per User
                        SUM_DR:
                          type: integer
                          format: int64
                          description: Sum of Disk Reads
                        DR_PERCENT:
                          type: integer
                          format: int64
                          description: Disk Reads (Percentage)
                        BG_PR_STMT:
                          type: integer
                          format: int64
                          description: Buffer Gets per Statement
                        BG_ST_PERC:
                          type: integer
                          format: int64
                          description: Buffer Gets per Statement (Percentage)
                        BG_PR_USER:
                          type: integer
                          format: int64
                          description: Buffer Gets per User
                        SUM_BG:
                          type: integer
                          format: int64
                          description: Sum of Disk Buffer Gets
                        BG_PERCENT:
                          type: integer
                          format: int64
                          description: Buffer Gets (Percentage)
                        ST_USR_QUA:
                          type: integer
                          format: int64
                          description: Quality of Statement Type per User
                        USR_QUAL:
                          type: integer
                          format: int64
                          description: Quality per User
                  SYSTEM_EVENT:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        CPUTIME:
                          type: integer
                          format: int64
                          description: cputime(user)
                        WAITTIME:
                          type: integer
                          format: int64
                          description: waittime(user)
                        SYSCPU:
                          type: integer
                          format: int64
                          description: cputime(system)
                        SYSWAIT:
                          type: integer
                          format: int64
                          description: waittime(system)
                        CPURATIO:
                          type: integer
                          format: int64
                          description: cpu(user) / cpu(system)
                        WAITRATIO:
                          type: integer
                          format: int64
                          description: waittime(user) / waittime(system)
                        CPU&WAIT:
                          type: integer
                          format: int64
                          description: cputime + waittime
                        CPU_CPUWT:
                          type: integer
                          format: int64
                          description: cputime / cpu + waittime
                        WAIT_CPUWT:
                          type: integer
                          format: int64
                          description: waittime / cpu + waittime
                  SYSTEM_EVENT_SUM:
                    type: array
                    items:
                      type: object
                      properties:
                        USR#:
                          type: string
                          maxLength: 10
                          description: User Number
                        USERNAME:
                          type: string
                          maxLength: 20
                          description: User Name
                        CPUTIME:
                          type: integer
                          format: int64
                          description: cputime(user)
                        WAITTIME:
                          type: integer
                          format: int64
                          description: waittime(user)
                        SYSCPU:
                          type: integer
                          format: int64
                          description: cputime(system)
                        SYSWAIT:
                          type: integer
                          format: int64
                          description: waittime(system)
                        CPURATIO:
                          type: integer
                          format: int64
                          description: cpu(user) / cpu(system)
                        WAITRATIO:
                          type: integer
                          format: int64
                          description: waittime(user) / waittime(system)
                        CPU&WAIT:
                          type: integer
                          format: int64
                          description: cputime + waittime
                        CPU_CPUWT:
                          type: integer
                          format: int64
                          description: cputime / cpu + waittime
                        WAIT_CPUWT:
                          type: integer
                          format: int64
                          description: waittime / cpu + waittime
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
