openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/MONITOR_SM_ORASESSION:
    post:
      tags:
      - STD9
      summary: Oracle Session Monitor Data Collector
      operationId: /rfc/MONITOR_SM_ORASESSION
      requestBody:
        content:
          application/json:
            schema:
              properties:
                INST_ID:
                  type: integer
                  format: int64
                  description: 'Oracle monitor: Instance ID'
                SNAPSHOT_TO:
                  type: integer
                  format: int64
                  description: 'Oracle monitor: snapshot ID'
                PROCESSLIST:
                  type: array
                  items:
                    type: object
                    properties:
                      SID:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: SID (Session)'
                      INSTANCE_NUMBER:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: instance number'
                      INSTANCE_NAME:
                        type: string
                        maxLength: 48
                        description: 'Oracle monitoring: instance_name'
                      PADDR:
                        type: string
                        format: byte
                        description: 'Oracle monitoring: PADDR: Address of  proc. owning the sess.'
                      USERNAME:
                        type: string
                        maxLength: 30
                        description: 'Oracle monitoring: USERNAME: Oracle username'
                      SQL_ADDRESS:
                        type: string
                        format: byte
                        description: 'Oracle monitoring: SQL_ADDRESS: SQL Statement ID'
                      SQL_HASH_VALUE:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: SQL_HASH_VALUE: SQL statement hash'
                      SPID:
                        type: string
                        maxLength: 12
                        description: 'Oracle monitoring: Operating system process identifier'
                      PROCPROG:
                        type: string
                        maxLength: 48
                        description: 'Oracle monitoring: PROGRAM: Operating system program name'
                      PROCESS:
                        type: string
                        maxLength: 12
                        description: 'Oracle monitoring: OS Process Id'
                      MACHINE:
                        type: string
                        maxLength: 64
                        description: 'Oracle monitoring: MACHINE: Operating system machine name'
                      SESSPROG:
                        type: string
                        maxLength: 48
                        description: 'Oracle monitoring: PROGRAM: Operating system program name'
                      COMMAND:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: COMMAND: Command in progress'
                      STATUS:
                        type: string
                        maxLength: 12
                        description: 'Oracle monitoring: Current process status'
                      TYPE:
                        type: string
                        maxLength: 2
                        description: 'Oracle Monitoring: Type of user or system lock'
                      EVENT:
                        type: string
                        maxLength: 64
                        description: 'Oracle monitor: EVENT'
                      BLOCK_GETS:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: ORA_BLOCK_GETS: Block gets for this sessi'
                      CONSIST_GETS:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: CONSISTENT_GETS: Consistent gets for sess'
                      PHYS_READS:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: PHYSICAL_READS: Physical reads for sess.'
                      BLOCK_CHG:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: BLOCK_CHANGES: Block changes for session'
                      LOGICAL_READS:
                        type: integer
                        format: int64
                        description: 'Oracle Monitoring: Logical Reads'
                      SECONDS_IN_WAIT:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: SECONDS_IN_WAIT:'
                      WAIT_P1TEXT:
                        type: string
                        maxLength: 64
                        description: 'Oracle monitoring: ORA_P1TEXT: Description of 1. param.'
                      WAIT_P1:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: ORA_P1: First additional parameter'
                      WAIT_P2TEXT:
                        type: string
                        maxLength: 64
                        description: 'Oracle monitoring: ORA_P1TEXT: Description of 2. param.'
                      WAIT_P2:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: ORA_P2: Second additional parameter'
                      WAIT_P3TEXT:
                        type: string
                        maxLength: 64
                        description: 'Oracle monitoring: ORA_P1TEXT: Description of 3. param.'
                      WAIT_P3:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: ORA_P3: Third additional parameter'
                      SQLTEXT:
                        type: string
                        maxLength: 1000
                        description: 'Oracle Monitoring: SQL_TEXT: SQL Text of current cursor'
                      PGA_USED_MEM:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: PGA memory currently used by the process'
                      PGA_ALLOC_MEM:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: PGA memory allocated by the process'
                      PGA_FREEABLE_MEM:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: Allocated PGA memory which can be freed'
                      PGA_MAX_MEM:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: Max PGA memory allocated by the process'
                SQLTABLE:
                  type: array
                  items:
                    type: object
                    properties:
                      INST_ID:
                        type: integer
                        format: int64
                        description: 'Oracle monitor: Instance ID'
                      ADDRESS:
                        type: string
                        format: byte
                        description: 'Oracle monitoring: ADDRESS: Address of a cursor'
                      HASH_VALUE:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: HASH_VALUE: Cursor hash'
                      COMMAND_TYPE:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: COMMAND_TYPE: Code for the type of SQL'
                      PIECE:
                        type: integer
                        format: int64
                        description: 'Oracle monitoring: PIECE: Seq. No of SQL pieces'
                      SQL_TEXT:
                        type: string
                        maxLength: 64
                        description: 'Oracle monitoring: SQL_TEXT: A column containing 1 SQL Text'
                WPSERVERLIST:
                  type: array
                  items:
                    type: object
                    properties:
                      NAME:
                        type: string
                        maxLength: 40
                        description: 'Oracle Monitoring: ORA_MSNAME2'
                      HOST:
                        type: string
                        maxLength: 32
                        description: 'Oracle Monitoring: ORA_MSHOST2'
                      SERV:
                        type: string
                        maxLength: 20
                        description: 'Oracle Monitoring: ORA_MSSERV'
                      MSGTYPES:
                        type: string
                        format: byte
                        description: 'Oracle Monitoring: ORA_MSTYPES'
                      HOSTADR:
                        type: string
                        format: byte
                        description: 'Oracle Monitoring: ORA_MSHOSTADR'
                      SERVNO:
                        type: string
                        format: byte
                        description: 'Oracle Monitoring: MSSERVNO'
                      STATE:
                        type: string
                        format: byte
                        description: 'Oracle Monitoring: ORA_MSSTATE'
                WPTOTALINFO:
                  type: array
                  items:
                    type: object
                    properties:
                      WP_NO:
                        type: string
                        maxLength: 2
                        description: 'Oracle Monitoring: WPNO: Work process number'
                      WP_ITYPE:
                        type: integer
                        format: int32
                        description: 'Oracle Monitoring: WPITYPE : Internal work process type'
                      WP_TYP:
                        type: string
                        maxLength: 3
                        description: 'Oracle Monitoring: WPTYP: Type'
                      WP_PID:
                        type: string
                        maxLength: 8
                        description: 'Oracle Monitoring : WPPID: Work process PID'
                      WP_ISTATUS:
                        type: integer
                        format: int32
                        description: 'Oracle Monitoring: WPISTATUS: Work process status'
                      WP_STATUS:
                        type: string
                        maxLength: 7
                        description: 'Oracle Monitoring: WPSTATUS: Work process status'
                      WP_IWAIT:
                        type: integer
                        format: int32
                        description: 'Oracle Monitorign: WPIWAITING: Reason for wait'
                      WP_WAITING:
                        type: string
                        maxLength: 5
                        description: 'Oracle Monitoring: WPWAITING: Work process is waiting'
                      WP_SEM:
                        type: string
                        maxLength: 2
                        description: 'Oracle Monitoring: WPSEM: Semaphore, for which the work proc'
                      WP_IRESTRT:
                        type: integer
                        format: int32
                        description: 'Oracle Monitoring: WPIRESTART : Restart after error?'
                      WP_RESTART:
                        type: string
                        maxLength: 4
                        description: 'Oracle Monitoring: WPRESTART: Restart work process after dum'
                      WP_DUMPS:
                        type: string
                        maxLength: 2
                        description: 'Oracle Monitoring: WPDUMPS: Number of dumps.'
                      WP_CPU:
                        type: string
                        maxLength: 8
                        description: 'Oracle Monitoring: WPCPU: CPU'
                      WP_ELTIME:
                        type: string
                        maxLength: 6
                        description: 'Oracle Monitoring: WPELZEIT: Previous execution time of requ'
                      WP_MANDT:
                        type: string
                        maxLength: 3
                        description: Client
                      WP_BNAME:
                        type: string
                        maxLength: 12
                        description: 'Oracle Monitoring: WPBNAME: User currently served'
                      WP_REPORT:
                        type: string
                        maxLength: 40
                        description: 'Oracle Monitoring: WPREPORT: Report currently being executed'
                      WP_IACTION:
                        type: integer
                        format: int32
                        description: 'Oracle Monitoring: WPIACTION: Current activity of the work p'
                      WP_ACTION:
                        type: string
                        maxLength: 25
                        description: 'Oracle Monitoring: WPACTION: Currently activity of WP'
                      WP_TABLE:
                        type: string
                        maxLength: 30
                        description: 'Oracle Monitoring: WPTABLE: DB table last accessed by the WP'
                      WP_SERVER:
                        type: string
                        maxLength: 20
                        description: 'Oracle Monitoring: MSNAME: Servername'
                      WP_WAITINF:
                        type: string
                        maxLength: 40
                        description: 'Oracle Monitoring: WPWAITINF: add. wait information'
                      WP_WAITTIM:
                        type: string
                        maxLength: 8
                        description: 'Oracle Monitoring: WPWAITTIME: Time when waiting started'
                      WP_SEMSTAT:
                        type: integer
                        format: int32
                        description: 'Oracle Monitoring: WPITYPE : Internal work process type'
                      WP_INDEX:
                        type: integer
                        format: int32
                        description: 'Oracle Monitoring: ORA_WPINDEX: Index of work process'
                      STARTDATE:
                        type: string
                        format: date
                        description: 'Oracle Monitoring: Start date for dialog step'
                      STARTTIME:
                        type: string
                        maxLength: 6
                        description: 'Oracle Monitoring: Start time for dialog step'
                      DYNPRONR:
                        type: string
                        maxLength: 4
                        description: 'Oracle Monitoring: Screen number or transaction name'
                      TCODE:
                        type: string
                        maxLength: 20
                        description: 'Oracle Monitoring: Transaction code'
                      CUAPROGRAM:
                        type: string
                        maxLength: 40
                        description: 'Oracle Monitoring: CUA program name'
                      FCODE:
                        type: string
                        maxLength: 4
                        description: 'Oracle Monitoring: WPTOTINFFC:Function code'
                      BTCJOBNAME:
                        type: string
                        maxLength: 32
                        description: 'Oracle Monitoring:BTCJOB: Background job name'
                      BTCJOBCNT:
                        type: string
                        maxLength: 8
                        description: Oracle Monitoring:_BTCJOBCNT:Job ID
                      MEMSUM:
                        type: integer
                        format: int64
                        description: 'Oracle Monitoring: MEMSUM: Extended memory'
                      PRIVSUM:
                        type: integer
                        format: int64
                        description: Oracle Monitoring:Heap (private) Memory
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  PROCESSLIST:
                    type: array
                    items:
                      type: object
                      properties:
                        SID:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: SID (Session)'
                        INSTANCE_NUMBER:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: instance number'
                        INSTANCE_NAME:
                          type: string
                          maxLength: 48
                          description: 'Oracle monitoring: instance_name'
                        PADDR:
                          type: string
                          format: byte
                          description: 'Oracle monitoring: PADDR: Address of  proc. owning the sess.'
                        USERNAME:
                          type: string
                          maxLength: 30
                          description: 'Oracle monitoring: USERNAME: Oracle username'
                        SQL_ADDRESS:
                          type: string
                          format: byte
                          description: 'Oracle monitoring: SQL_ADDRESS: SQL Statement ID'
                        SQL_HASH_VALUE:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: SQL_HASH_VALUE: SQL statement hash'
                        SPID:
                          type: string
                          maxLength: 12
                          description: 'Oracle monitoring: Operating system process identifier'
                        PROCPROG:
                          type: string
                          maxLength: 48
                          description: 'Oracle monitoring: PROGRAM: Operating system program name'
                        PROCESS:
                          type: string
                          maxLength: 12
                          description: 'Oracle monitoring: OS Process Id'
                        MACHINE:
                          type: string
                          maxLength: 64
                          description: 'Oracle monitoring: MACHINE: Operating system machine name'
                        SESSPROG:
                          type: string
                          maxLength: 48
                          description: 'Oracle monitoring: PROGRAM: Operating system program name'
                        COMMAND:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: COMMAND: Command in progress'
                        STATUS:
                          type: string
                          maxLength: 12
                          description: 'Oracle monitoring: Current process status'
                        TYPE:
                          type: string
                          maxLength: 2
                          description: 'Oracle Monitoring: Type of user or system lock'
                        EVENT:
                          type: string
                          maxLength: 64
                          description: 'Oracle monitor: EVENT'
                        BLOCK_GETS:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: ORA_BLOCK_GETS: Block gets for this sessi'
                        CONSIST_GETS:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: CONSISTENT_GETS: Consistent gets for sess'
                        PHYS_READS:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: PHYSICAL_READS: Physical reads for sess.'
                        BLOCK_CHG:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: BLOCK_CHANGES: Block changes for session'
                        LOGICAL_READS:
                          type: integer
                          format: int64
                          description: 'Oracle Monitoring: Logical Reads'
                        SECONDS_IN_WAIT:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: SECONDS_IN_WAIT:'
                        WAIT_P1TEXT:
                          type: string
                          maxLength: 64
                          description: 'Oracle monitoring: ORA_P1TEXT: Description of 1. param.'
                        WAIT_P1:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: ORA_P1: First additional parameter'
                        WAIT_P2TEXT:
                          type: string
                          maxLength: 64
                          description: 'Oracle monitoring: ORA_P1TEXT: Description of 2. param.'
                        WAIT_P2:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: ORA_P2: Second additional parameter'
                        WAIT_P3TEXT:
                          type: string
                          maxLength: 64
                          description: 'Oracle monitoring: ORA_P1TEXT: Description of 3. param.'
                        WAIT_P3:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: ORA_P3: Third additional parameter'
                        SQLTEXT:
                          type: string
                          maxLength: 1000
                          description: 'Oracle Monitoring: SQL_TEXT: SQL Text of current cursor'
                        PGA_USED_MEM:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: PGA memory currently used by the process'
                        PGA_ALLOC_MEM:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: PGA memory allocated by the process'
                        PGA_FREEABLE_MEM:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: Allocated PGA memory which can be freed'
                        PGA_MAX_MEM:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: Max PGA memory allocated by the process'
                  SQLTABLE:
                    type: array
                    items:
                      type: object
                      properties:
                        INST_ID:
                          type: integer
                          format: int64
                          description: 'Oracle monitor: Instance ID'
                        ADDRESS:
                          type: string
                          format: byte
                          description: 'Oracle monitoring: ADDRESS: Address of a cursor'
                        HASH_VALUE:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: HASH_VALUE: Cursor hash'
                        COMMAND_TYPE:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: COMMAND_TYPE: Code for the type of SQL'
                        PIECE:
                          type: integer
                          format: int64
                          description: 'Oracle monitoring: PIECE: Seq. No of SQL pieces'
                        SQL_TEXT:
                          type: string
                          maxLength: 64
                          description: 'Oracle monitoring: SQL_TEXT: A column containing 1 SQL Text'
                  WPSERVERLIST:
                    type: array
                    items:
                      type: object
                      properties:
                        NAME:
                          type: string
                          maxLength: 40
                          description: 'Oracle Monitoring: ORA_MSNAME2'
                        HOST:
                          type: string
                          maxLength: 32
                          description: 'Oracle Monitoring: ORA_MSHOST2'
                        SERV:
                          type: string
                          maxLength: 20
                          description: 'Oracle Monitoring: ORA_MSSERV'
                        MSGTYPES:
                          type: string
                          format: byte
                          description: 'Oracle Monitoring: ORA_MSTYPES'
                        HOSTADR:
                          type: string
                          format: byte
                          description: 'Oracle Monitoring: ORA_MSHOSTADR'
                        SERVNO:
                          type: string
                          format: byte
                          description: 'Oracle Monitoring: MSSERVNO'
                        STATE:
                          type: string
                          format: byte
                          description: 'Oracle Monitoring: ORA_MSSTATE'
                  WPTOTALINFO:
                    type: array
                    items:
                      type: object
                      properties:
                        WP_NO:
                          type: string
                          maxLength: 2
                          description: 'Oracle Monitoring: WPNO: Work process number'
                        WP_ITYPE:
                          type: integer
                          format: int32
                          description: 'Oracle Monitoring: WPITYPE : Internal work process type'
                        WP_TYP:
                          type: string
                          maxLength: 3
                          description: 'Oracle Monitoring: WPTYP: Type'
                        WP_PID:
                          type: string
                          maxLength: 8
                          description: 'Oracle Monitoring : WPPID: Work process PID'
                        WP_ISTATUS:
                          type: integer
                          format: int32
                          description: 'Oracle Monitoring: WPISTATUS: Work process status'
                        WP_STATUS:
                          type: string
                          maxLength: 7
                          description: 'Oracle Monitoring: WPSTATUS: Work process status'
                        WP_IWAIT:
                          type: integer
                          format: int32
                          description: 'Oracle Monitorign: WPIWAITING: Reason for wait'
                        WP_WAITING:
                          type: string
                          maxLength: 5
                          description: 'Oracle Monitoring: WPWAITING: Work process is waiting'
                        WP_SEM:
                          type: string
                          maxLength: 2
                          description: 'Oracle Monitoring: WPSEM: Semaphore, for which the work proc'
                        WP_IRESTRT:
                          type: integer
                          format: int32
                          description: 'Oracle Monitoring: WPIRESTART : Restart after error?'
                        WP_RESTART:
                          type: string
                          maxLength: 4
                          description: 'Oracle Monitoring: WPRESTART: Restart work process after dum'
                        WP_DUMPS:
                          type: string
                          maxLength: 2
                          description: 'Oracle Monitoring: WPDUMPS: Number of dumps.'
                        WP_CPU:
                          type: string
                          maxLength: 8
                          description: 'Oracle Monitoring: WPCPU: CPU'
                        WP_ELTIME:
                          type: string
                          maxLength: 6
                          description: 'Oracle Monitoring: WPELZEIT: Previous execution time of requ'
                        WP_MANDT:
                          type: string
                          maxLength: 3
                          description: Client
                        WP_BNAME:
                          type: string
                          maxLength: 12
                          description: 'Oracle Monitoring: WPBNAME: User currently served'
                        WP_REPORT:
                          type: string
                          maxLength: 40
                          description: 'Oracle Monitoring: WPREPORT: Report currently being executed'
                        WP_IACTION:
                          type: integer
                          format: int32
                          description: 'Oracle Monitoring: WPIACTION: Current activity of the work p'
                        WP_ACTION:
                          type: string
                          maxLength: 25
                          description: 'Oracle Monitoring: WPACTION: Currently activity of WP'
                        WP_TABLE:
                          type: string
                          maxLength: 30
                          description: 'Oracle Monitoring: WPTABLE: DB table last accessed by the WP'
                        WP_SERVER:
                          type: string
                          maxLength: 20
                          description: 'Oracle Monitoring: MSNAME: Servername'
                        WP_WAITINF:
                          type: string
                          maxLength: 40
                          description: 'Oracle Monitoring: WPWAITINF: add. wait information'
                        WP_WAITTIM:
                          type: string
                          maxLength: 8
                          description: 'Oracle Monitoring: WPWAITTIME: Time when waiting started'
                        WP_SEMSTAT:
                          type: integer
                          format: int32
                          description: 'Oracle Monitoring: WPITYPE : Internal work process type'
                        WP_INDEX:
                          type: integer
                          format: int32
                          description: 'Oracle Monitoring: ORA_WPINDEX: Index of work process'
                        STARTDATE:
                          type: string
                          format: date
                          description: 'Oracle Monitoring: Start date for dialog step'
                        STARTTIME:
                          type: string
                          maxLength: 6
                          description: 'Oracle Monitoring: Start time for dialog step'
                        DYNPRONR:
                          type: string
                          maxLength: 4
                          description: 'Oracle Monitoring: Screen number or transaction name'
                        TCODE:
                          type: string
                          maxLength: 20
                          description: 'Oracle Monitoring: Transaction code'
                        CUAPROGRAM:
                          type: string
                          maxLength: 40
                          description: 'Oracle Monitoring: CUA program name'
                        FCODE:
                          type: string
                          maxLength: 4
                          description: 'Oracle Monitoring: WPTOTINFFC:Function code'
                        BTCJOBNAME:
                          type: string
                          maxLength: 32
                          description: 'Oracle Monitoring:BTCJOB: Background job name'
                        BTCJOBCNT:
                          type: string
                          maxLength: 8
                          description: Oracle Monitoring:_BTCJOBCNT:Job ID
                        MEMSUM:
                          type: integer
                          format: int64
                          description: 'Oracle Monitoring: MEMSUM: Extended memory'
                        PRIVSUM:
                          type: integer
                          format: int64
                          description: Oracle Monitoring:Heap (private) Memory
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
