openapi: 3.0.0
info:
  title: SAP API
  version: 1.0.0
servers:
- url: http://localhost:8080
paths:
  /rfc/STUO_BY_CLIENT:
    post:
      tags:
      - STUO
      operationId: /rfc/STUO_BY_CLIENT
      requestBody:
        content:
          application/json:
            schema:
              properties:
                ANALYSIS:
                  type: string
                  default: S
                  maxLength: 1
                CLIENT:
                  type: array
                  items:
                    type: object
                    properties:
                      DB_NAME:
                        type: string
                        maxLength: 3
                        description: Name of database
                      DB_THREAD:
                        type: string
                        maxLength: 8
                        description: Database instance thread ID
                      DB_INSTANC:
                        type: string
                        maxLength: 16
                        description: Database instance (OPS)
                      DB_SERVER:
                        type: string
                        maxLength: 16
                        description: Name of database server
                      CURR_TIME:
                        type: string
                        maxLength: 6
                        description: Current time of query
                      CURR_DATE:
                        type: string
                        format: date
                        description: Current date at time of query
                      DB_UP_TIME:
                        type: string
                        maxLength: 6
                        description: Time of database start
                      DB_UP_DATE:
                        type: string
                        format: date
                        description: Date of database start
                      THREAD_STA:
                        type: string
                        maxLength: 6
                        description: DB thread status
                      SAPDBHOST:
                        type: string
                        maxLength: 32
                        description: SAPDBHOST
                      VERSION:
                        type: string
                        maxLength: 17
                        description: 'Oracle: Release'
                      ELAPSED_TI:
                        type: string
                        maxLength: 14
                        description: 'Oracle: Elapsed time since database startup (sec)'
                      ARCHIVER:
                        type: string
                        maxLength: 7
                        description: 'Oracle: Status of archive writer (stopped/started/failed)'
                      LOG_SWITCH:
                        type: string
                        maxLength: 11
                        description: 'Oracle: Log_switch_wait (Archive log/Clear log/Checkpoint)'
                      BUFSIZE:
                        type: string
                        maxLength: 14
                        description: Data base buffer pool size
                      BUFREADS:
                        type: string
                        maxLength: 14
                        description: Database buffer reads
                      BUFQUAL:
                        type: string
                        maxLength: 6
                        description: Quality of data base buffer pool
                      BUFPWRITES:
                        type: string
                        maxLength: 14
                        description: Physical writes
                      BUFPREADS:
                        type: string
                        maxLength: 14
                        description: Physical reads
                      BUFWAITS:
                        type: string
                        maxLength: 14
                        description: Buffer busy waits
                      BUFWTIME:
                        type: string
                        maxLength: 14
                        description: Buffer busy wait time
                      DICTSIZE:
                        type: string
                        maxLength: 14
                        description: Dictionary cache size
                      DDQUAL:
                        type: string
                        maxLength: 6
                        description: Quality of Data Dictionary cache
                      GETRATIO:
                        type: string
                        maxLength: 6
                        description: Getratio of SQLAREA in ORACLE7
                      PINRATIO:
                        type: string
                        maxLength: 6
                        description: Pinratio of SQLAREA in ORACLE7
                      LOGSIZE:
                        type: string
                        maxLength: 14
                        description: Redo log buffer size
                      LOGENTRIES:
                        type: string
                        maxLength: 14
                        description: Redo log buffer entries
                      LOGALLOC:
                        type: string
                        maxLength: 14
                        description: Redo log buffer allocation retries
                      LOGFAULT:
                        type: string
                        maxLength: 14
                        description: Allocation error rate of redo log buffer
                      USERCALLS:
                        type: string
                        maxLength: 14
                        description: User calls
                      RECURCALLS:
                        type: string
                        maxLength: 14
                        description: Recursive calls
                      COMMITS:
                        type: string
                        maxLength: 14
                        description: Commits
                      PARSES:
                        type: string
                        maxLength: 14
                        description: Parses
                      ROLLBACKS:
                        type: string
                        maxLength: 14
                        description: Rollbacks
                      LOGWRITES:
                        type: string
                        maxLength: 14
                        description: Redo log writes
                      LOGWTIME:
                        type: string
                        maxLength: 14
                        description: Redo log write time
                      LOGBLOCKS:
                        type: string
                        maxLength: 14
                        description: Redo log blocks written
                      LOGWSIZE:
                        type: string
                        maxLength: 14
                        description: Redo log write size
                      LOGLATCH:
                        type: string
                        maxLength: 14
                        description: Redo log latching time
                      SCANSHORT:
                        type: string
                        maxLength: 14
                        description: Short table scans
                      SCANLONG:
                        type: string
                        maxLength: 14
                        description: Long table scans
                      SCANROWS:
                        type: string
                        maxLength: 14
                        description: Table scan rows
                      SCANBLOCKS:
                        type: string
                        maxLength: 14
                        description: Table scan blocks
                      FETCHROWID:
                        type: string
                        maxLength: 14
                        description: Table fetch by row ID
                      FETCHCONT:
                        type: string
                        maxLength: 14
                        description: Table fetch continued row
                      SORTMEM:
                        type: string
                        maxLength: 14
                        description: Sort memory
                      SORTDISK:
                        type: string
                        maxLength: 14
                        description: Sort disk
                      SORTROWS:
                        type: string
                        maxLength: 14
                        description: Sort rows
                      CPUUSAGE:
                        type: string
                        maxLength: 14
                        description: Database CPU usage
                      CPUCALLS:
                        type: string
                        maxLength: 14
                        description: CPU usage when call started
                      CPURECURS:
                        type: string
                        maxLength: 14
                        description: Recursive CPU usage
                      CPUPARSE:
                        type: string
                        maxLength: 14
                        description: Parse Time CPU
                      USERTOREC:
                        type: string
                        maxLength: 5
                        description: ratio of user to recursive calls in oracle 7 monitor
                      READCALLRA:
                        type: string
                        maxLength: 5
                        description: ratio of reads to user calls in 0racle 7
                      DD_GETS:
                        type: string
                        maxLength: 20
                        description: v$rowcache.gets
                      DD_GET_MIS:
                        type: string
                        maxLength: 20
                        description: v$rowcache.getmisses
                      CONSISTGET:
                        type: string
                        maxLength: 20
                        description: consistent gets
                      GLOBLCKCON:
                        type: string
                        maxLength: 20
                        description: Global lock converts
                      LCKHITRATI:
                        type: string
                        maxLength: 6
                        description: Lock hit ratio
                      DBWRCROSSI:
                        type: string
                        maxLength: 24
                        description: DBWR cross instance writes
                      PINGWRITES:
                        type: string
                        maxLength: 6
                        description: Ping/write ratio
                      SQLRELOADS:
                        type: string
                        maxLength: 14
                        description: SQL area reloads (%) from v$librarycache
                      REDO_WAIT:
                        type: string
                        maxLength: 14
                        description: Redo log space wait time (s) from v$sysstat
                      REDO_PROBL:
                        type: string
                        maxLength: 14
                        description: Redo log file problems (from v$logfiles)
                      CPU_TIME:
                        type: string
                        maxLength: 14
                        description: 'Oracle: Total CPU time used by Oracle (sec)'
                      WAIT_TOTAL:
                        type: string
                        maxLength: 14
                        description: 'Oracle: Total wait time (from V$System_Event) (sec)'
                      WAIT_BUSY:
                        type: string
                        maxLength: 14
                        description: 'Oracle: Busy wait time (from V$System_Event) (sec)'
                      SESS_BUSY:
                        type: string
                        maxLength: 14
                        description: 'Oracle: Sessions busy (%)'
                      CPU_BUSY:
                        type: string
                        maxLength: 14
                        description: 'Oracle: CPU usage by Oracle (%)'
                      RESP_TIME:
                        type: string
                        maxLength: 14
                        description: 'Oracle: Time per user call (ms)'
                      CPU_COUNT:
                        type: string
                        maxLength: 6
                        description: Number of CPUs
      responses:
        '200':
          description: OK
          content:
            application/json:
              schema:
                properties:
                  CURR_DATE:
                    type: string
                    format: date
                  CURR_SYSTEM:
                    type: string
                    maxLength: 16
                  CURR_TIME:
                    type: string
                    maxLength: 6
                  CLIENT:
                    type: array
                    items:
                      type: object
                      properties:
                        DB_NAME:
                          type: string
                          maxLength: 3
                          description: Name of database
                        DB_THREAD:
                          type: string
                          maxLength: 8
                          description: Database instance thread ID
                        DB_INSTANC:
                          type: string
                          maxLength: 16
                          description: Database instance (OPS)
                        DB_SERVER:
                          type: string
                          maxLength: 16
                          description: Name of database server
                        CURR_TIME:
                          type: string
                          maxLength: 6
                          description: Current time of query
                        CURR_DATE:
                          type: string
                          format: date
                          description: Current date at time of query
                        DB_UP_TIME:
                          type: string
                          maxLength: 6
                          description: Time of database start
                        DB_UP_DATE:
                          type: string
                          format: date
                          description: Date of database start
                        THREAD_STA:
                          type: string
                          maxLength: 6
                          description: DB thread status
                        SAPDBHOST:
                          type: string
                          maxLength: 32
                          description: SAPDBHOST
                        VERSION:
                          type: string
                          maxLength: 17
                          description: 'Oracle: Release'
                        ELAPSED_TI:
                          type: string
                          maxLength: 14
                          description: 'Oracle: Elapsed time since database startup (sec)'
                        ARCHIVER:
                          type: string
                          maxLength: 7
                          description: 'Oracle: Status of archive writer (stopped/started/failed)'
                        LOG_SWITCH:
                          type: string
                          maxLength: 11
                          description: 'Oracle: Log_switch_wait (Archive log/Clear log/Checkpoint)'
                        BUFSIZE:
                          type: string
                          maxLength: 14
                          description: Data base buffer pool size
                        BUFREADS:
                          type: string
                          maxLength: 14
                          description: Database buffer reads
                        BUFQUAL:
                          type: string
                          maxLength: 6
                          description: Quality of data base buffer pool
                        BUFPWRITES:
                          type: string
                          maxLength: 14
                          description: Physical writes
                        BUFPREADS:
                          type: string
                          maxLength: 14
                          description: Physical reads
                        BUFWAITS:
                          type: string
                          maxLength: 14
                          description: Buffer busy waits
                        BUFWTIME:
                          type: string
                          maxLength: 14
                          description: Buffer busy wait time
                        DICTSIZE:
                          type: string
                          maxLength: 14
                          description: Dictionary cache size
                        DDQUAL:
                          type: string
                          maxLength: 6
                          description: Quality of Data Dictionary cache
                        GETRATIO:
                          type: string
                          maxLength: 6
                          description: Getratio of SQLAREA in ORACLE7
                        PINRATIO:
                          type: string
                          maxLength: 6
                          description: Pinratio of SQLAREA in ORACLE7
                        LOGSIZE:
                          type: string
                          maxLength: 14
                          description: Redo log buffer size
                        LOGENTRIES:
                          type: string
                          maxLength: 14
                          description: Redo log buffer entries
                        LOGALLOC:
                          type: string
                          maxLength: 14
                          description: Redo log buffer allocation retries
                        LOGFAULT:
                          type: string
                          maxLength: 14
                          description: Allocation error rate of redo log buffer
                        USERCALLS:
                          type: string
                          maxLength: 14
                          description: User calls
                        RECURCALLS:
                          type: string
                          maxLength: 14
                          description: Recursive calls
                        COMMITS:
                          type: string
                          maxLength: 14
                          description: Commits
                        PARSES:
                          type: string
                          maxLength: 14
                          description: Parses
                        ROLLBACKS:
                          type: string
                          maxLength: 14
                          description: Rollbacks
                        LOGWRITES:
                          type: string
                          maxLength: 14
                          description: Redo log writes
                        LOGWTIME:
                          type: string
                          maxLength: 14
                          description: Redo log write time
                        LOGBLOCKS:
                          type: string
                          maxLength: 14
                          description: Redo log blocks written
                        LOGWSIZE:
                          type: string
                          maxLength: 14
                          description: Redo log write size
                        LOGLATCH:
                          type: string
                          maxLength: 14
                          description: Redo log latching time
                        SCANSHORT:
                          type: string
                          maxLength: 14
                          description: Short table scans
                        SCANLONG:
                          type: string
                          maxLength: 14
                          description: Long table scans
                        SCANROWS:
                          type: string
                          maxLength: 14
                          description: Table scan rows
                        SCANBLOCKS:
                          type: string
                          maxLength: 14
                          description: Table scan blocks
                        FETCHROWID:
                          type: string
                          maxLength: 14
                          description: Table fetch by row ID
                        FETCHCONT:
                          type: string
                          maxLength: 14
                          description: Table fetch continued row
                        SORTMEM:
                          type: string
                          maxLength: 14
                          description: Sort memory
                        SORTDISK:
                          type: string
                          maxLength: 14
                          description: Sort disk
                        SORTROWS:
                          type: string
                          maxLength: 14
                          description: Sort rows
                        CPUUSAGE:
                          type: string
                          maxLength: 14
                          description: Database CPU usage
                        CPUCALLS:
                          type: string
                          maxLength: 14
                          description: CPU usage when call started
                        CPURECURS:
                          type: string
                          maxLength: 14
                          description: Recursive CPU usage
                        CPUPARSE:
                          type: string
                          maxLength: 14
                          description: Parse Time CPU
                        USERTOREC:
                          type: string
                          maxLength: 5
                          description: ratio of user to recursive calls in oracle 7 monitor
                        READCALLRA:
                          type: string
                          maxLength: 5
                          description: ratio of reads to user calls in 0racle 7
                        DD_GETS:
                          type: string
                          maxLength: 20
                          description: v$rowcache.gets
                        DD_GET_MIS:
                          type: string
                          maxLength: 20
                          description: v$rowcache.getmisses
                        CONSISTGET:
                          type: string
                          maxLength: 20
                          description: consistent gets
                        GLOBLCKCON:
                          type: string
                          maxLength: 20
                          description: Global lock converts
                        LCKHITRATI:
                          type: string
                          maxLength: 6
                          description: Lock hit ratio
                        DBWRCROSSI:
                          type: string
                          maxLength: 24
                          description: DBWR cross instance writes
                        PINGWRITES:
                          type: string
                          maxLength: 6
                          description: Ping/write ratio
                        SQLRELOADS:
                          type: string
                          maxLength: 14
                          description: SQL area reloads (%) from v$librarycache
                        REDO_WAIT:
                          type: string
                          maxLength: 14
                          description: Redo log space wait time (s) from v$sysstat
                        REDO_PROBL:
                          type: string
                          maxLength: 14
                          description: Redo log file problems (from v$logfiles)
                        CPU_TIME:
                          type: string
                          maxLength: 14
                          description: 'Oracle: Total CPU time used by Oracle (sec)'
                        WAIT_TOTAL:
                          type: string
                          maxLength: 14
                          description: 'Oracle: Total wait time (from V$System_Event) (sec)'
                        WAIT_BUSY:
                          type: string
                          maxLength: 14
                          description: 'Oracle: Busy wait time (from V$System_Event) (sec)'
                        SESS_BUSY:
                          type: string
                          maxLength: 14
                          description: 'Oracle: Sessions busy (%)'
                        CPU_BUSY:
                          type: string
                          maxLength: 14
                          description: 'Oracle: CPU usage by Oracle (%)'
                        RESP_TIME:
                          type: string
                          maxLength: 14
                          description: 'Oracle: Time per user call (ms)'
                        CPU_COUNT:
                          type: string
                          maxLength: 6
                          description: Number of CPUs
        '400':
          description: Bad request.
        5XX:
          description: Unexpected error.
