we are facing problems with unknown status on several oracle jobs checks, even we upgrade from check-mk 1.6 to 2.0 ( also the agent on the host ) it still happening and no clue how to solve it.
Any clue of what its going wrong? we got the same mk-oracle pluging that we got on other hosts and this is only happening on this one.
First of all thanks for the support, i launched the local check as you mentioned with another host which some days ago its facing the same issue and this its the output:
OMD[otc]:~$ cmk -IIvv
Discovering services and host labels on:
FETCHING DATA
Source: SourceType.HOST/FetcherType.PROGRAM
[cpu_tracking] Start [7f6ee8e37100]
Calling: LC_ALL=en_US.UTF-8 ssh -i ~/.ssh/id_rsa -tt -o StrictHostKeyChecking=no check_mk@ 10.168.85.164
[ProgramFetcher] Fetch with cache settings: DefaultAgentFileCache(base_path=PosixPath(’/omd/sites/otc/tmp/check_mk/cache/olxdeprdoradb03.prd.otc.hlg.de’), max_age=0, disabled=False, use_outdated=False, simulation=False), Cache enabled: True
Not using cache (Too old. Age is 23 sec, allowed is 0 sec)
[ProgramFetcher] Execute data source
Write data to cache file /omd/sites/otc/tmp/check_mk/cache/olxdeprdoradb03.prd.otc.hlg.de
Try aquire lock on /omd/sites/otc/tmp/check_mk/cache/olxdeprdoradb03.prd.otc.hlg.de
Got lock on /omd/sites/otc/tmp/check_mk/cache/olxdeprdoradb03.prd.otc.hlg.de
Releasing lock on /omd/sites/otc/tmp/check_mk/cache/olxdeprdoradb03.prd.otc.hlg.de
Released lock on /omd/sites/otc/tmp/check_mk/cache/olxdeprdoradb03.prd.otc.hlg.de
[cpu_tracking] Stop [7f6ee8e37100 - Snapshot(process=posix.times_result(user=0.010000000000000009, system=0.009999999999999981, children_user=0.01, children_system=0.02, elapsed=17.939999997615814))]
Source: SourceType.HOST/FetcherType.PIGGYBACK
[cpu_tracking] Start [7f6ee7910280]
No piggyback files for ‘’. Skip processing.
No piggyback files for ‘10.168.85.164’. Skip processing.
[PiggybackFetcher] Fetch with cache settings: NoCache(base_path=PosixPath(’/omd/sites/otc/tmp/check_mk/data_source_cache/piggyback/olxdeprdoradb03.prd.otc.hlg.de’), max_age=0, disabled=False, use_outdated=False, simulation=False), Cache enabled: False
[PiggybackFetcher] Execute data source
Not writing data to cache file (Cache usage disabled)
[cpu_tracking] Stop [7f6ee7910280 - Snapshot(process=posix.times_result(user=0.0, system=0.0, children_user=0.0, children_system=0.0, elapsed=0.0))]
PERFORM HOST LABEL DISCOVERY
Try aquire lock on /omd/sites/otc/var/check_mk/discovered_host_labels/olxdeprdoradb03.prd.otc.hlg.de.mk
Got lock on /omd/sites/otc/var/check_mk/discovered_host_labels/olxdeprdoradb03.prd.otc.hlg.de.mk
Releasing lock on /omd/sites/otc/var/check_mk/discovered_host_labels/olxdeprdoradb03.prd.otc.hlg.de.mk
Released lock on /omd/sites/otc/var/check_mk/discovered_host_labels/olxdeprdoradb03.prd.otc.hlg.de.mk
The problem looks more like a problem with the check as all jobs are crashed.
Can you do a “cmk --debug -vvn hostname” on the command line?
It should stop at the first job and output some exception.
Hi Guys!
First of all thanks for support, this is the output of the debug, let me know if anything else its needed.
THANKS in advance.
Checkmk version 2.0.0p4
Try license usage history update.
Try aquire lock on /omd/sites/otc/var/check_mk/license_usage/next_run
Got lock on /omd/sites/otc/var/check_mk/license_usage/next_run
Try aquire lock on /omd/sites/otc/var/check_mk/license_usage/history.json
Got lock on /omd/sites/otc/var/check_mk/license_usage/history.json
Next run time has not been reached yet. Abort.
Releasing lock on /omd/sites/otc/var/check_mk/license_usage/history.json
Released lock on /omd/sites/otc/var/check_mk/license_usage/history.json
Releasing lock on /omd/sites/otc/var/check_mk/license_usage/next_run
Released lock on /omd/sites/otc/var/check_mk/license_usage/next_run
Loading autochecks from /omd/sites/otc/var/check_mk/autochecks/HOSTNAME.mk
FETCHING DATA
Source: SourceType.HOST/FetcherType.PROGRAM
[cpu_tracking] Start [7f227c719310]
Calling: LC_ALL=en_US.UTF-8 ssh -i ~/.ssh/id_rsa -tt -o StrictHostKeyChecking=no check_mk@
[ProgramFetcher] Fetch with cache settings: DefaultAgentFileCache(base_path=PosixPath(’/omd/sites/otc/tmp/check_mk/cache/olxdeprdoradb03.prd.otc.hlg. de’), max_age=0, disabled=False, use_outdated=False, simulation=False), Cache enabled: False
[ProgramFetcher] Execute data source
Write data to cache file /omd/sites/otc/tmp/check_mk/cache/HOSTNAME
Try aquire lock on /omd/sites/otc/tmp/check_mk/cache/HOSTNAME
Got lock on /omd/sites/otc/tmp/check_mk/cache/HOSTNAME
Releasing lock on /omd/sites/otc/tmp/check_mk/cache/HOSTNAME
Released lock on /omd/sites/otc/tmp/check_mk/cache/HOSTNAME
[cpu_tracking] Stop [7f227c719310 - Snapshot(process=posix.times_result(user=0.020000000000000018, system=0.010000000000000009, children_user=0.01, children_system=0.02, elapsed=18.100000001490116))]
Source: SourceType.HOST/FetcherType.PIGGYBACK
[cpu_tracking] Start [7f227c719a90]
No piggyback files for ‘’. Skip processing.
No piggyback files for ‘’. Skip processing.
[PiggybackFetcher] Fetch with cache settings: NoCache(base_path=PosixPath(’/omd/sites/otc/tmp/check_mk/data_source_cache/piggyback/HOSTNAME’), max_age=0, disabled=False, use_outdated=False, simulation=False), Cache enabled: False
[PiggybackFetcher] Execute data source
Not writing data to cache file (Cache usage disabled)
[cpu_tracking] Stop [7f227c719a90 - Snapshot(process=posix.times_result(user=0.0, system=0.0, children_user=0.0, children_system=0.0, elapsed=0.0))]
[cpu_tracking] Start [7f227de493a0]
PARSE FETCHER RESULTS
Source: SourceType.HOST/FetcherType.PROGRAM
No persisted sections loaded
→ Add sections: [‘check_mk’, ‘cifsmounts’, ‘cpu’, ‘df’, ‘diskstat’, ‘job’, ‘kernel’, ‘labels’, ‘lnx_if’, ‘local’, ‘logwatch’, ‘md’, ‘mem’, ‘mounts’, ‘nfsmounts’, ‘ntp’, ‘oracle_asm_diskgroup’, ‘oracle_crs_res’, ‘oracle_crs_version’, ‘oracle_crs_votedisk’, ‘oracle_dataguard_stats’, ‘oracle_instance’, ‘oracle_jobs’, ‘oracle_locks’, ‘oracle_logswitches’, ‘oracle_longactivesessions’, ‘oracle_performance’, ‘oracle_processes’, ‘oracle_recovery_area’, ‘oracle_recovery_status’, ‘oracle_resumable’, ‘oracle_rman’, ‘oracle_sessions’, ‘oracle_systemparameter’, ‘oracle_tablespaces’, ‘oracle_undostat’, ‘postfix_mailq’, ‘postfix_mailq_status’, ‘ps_lnx’, ‘systemd_units’, ‘tcp_conn_stats’, ‘uptime’, ‘vbox_guest’]
Source: SourceType.HOST/FetcherType.PIGGYBACK
No persisted sections loaded
→ Add sections: []
Received no piggyback data
Loading item states
Try aquire lock on /omd/sites/otc/tmp/check_mk/counters/HOSTNAME
Got lock on /omd/sites/otc/tmp/check_mk/counters/HOSTNAME
Releasing lock on /omd/sites/otc/tmp/check_mk/counters/HOSTNAME
Released lock on /omd/sites/otc/tmp/check_mk/counters/HOSTNAME
ASM Diskgroup DATA 65.14% used (2.61 of 4.00 TiB), trend per 1 day 0 hours: +52.8 MiB, trend per 1 day 0 hours: +<0.01%, Time left until disk full: 75 years 337 days, extern redundancy, 4 disks
ASM Diskgroup FRA 24.90% used (510 GiB of 2.00 TiB), trend per 1 day 0 hours: -19.8 GiB, trend per 1 day 0 hours: -0.97%, extern redundancy, 2 disks
CPU load 15 min load: 1.64 at 16 cores (0.10 per core)
CPU utilization Total CPU: 11.71%
Disk IO SUMMARY Read: 21.7 MB/s, Write: 8.65 MB/s, Latency: 476 microseconds
Filesystem / 22.33% used (7.02 of 31.43 GB), trend: +2.12 MB / 24 hours
Filesystem /u01 65.88% used (168.56 of 255.87 GB), trend: +6.39 MB / 24 hours
Interface 2 [eth0], (up), MAC: FA:16:3E:00:E9:CD, Speed: unknown, In: 3.23 MB/s, Out: 4.13 MB/s
Kernel Performance Process Creations: 18.19/s, Context Switches: 75009.19/s, Major Page Faults: 0.00/s, Page Swap in: 0.00/s, Page Swap Out: 0.00/s
Log /home/hvr/hvr_config/log/hvrremotelistener/hvrremotelistener4343.log No error messages
Log /u01/app/oracle/diag/asm/+asm/+ASM/trace/alert_+ASM.log No error messages
Log /u01/app/oracle/diag/rdbms/cp002a/CP002A1/trace/alert_CP002A1.log 1 WARN messages (Last worst: “TMON (PID:12717): Error 16198 due to hung I/O operation to LOG_ARCHIVE_DEST_2”)
Log /u01/app/oracle/diag/rdbms/cp002a/CP002A1/trace/drcCP002A1.log 460 WARN messages (Last worst: “Physical Standby Database CP002B Warning ORA-16855: transport lag has exceeded specified threshold”)
Log /u01/app/oracle/diag/rdbms/cp003a/CP003A1/trace/alert_CP003A1.log 4 WARN messages (Last worst: “ORA-03135: connection lost contact”)
Log /u01/app/oracle/diag/rdbms/cp003a/CP003A1/trace/drcCP003A1.log 33 WARN messages (Last worst: “Physical Standby Database CP003B Warning ORA-16809: multiple warnings detected for the member”)
Log /u01/app/oracle/diag/rdbms/cp005a/CP005A1/trace/alert_CP005A1.log 16 WARN messages (Last worst: “PP005(3):Session (957,53729): Bad TTC Packet Detected: Client IP Address: 10.168.73.193”)
Log /u01/app/oracle/diag/rdbms/cp005a/CP005A1/trace/drcCP005A1.log No error messages
Log /u01/app/oracle/diag/rdbms/cp006a/CP006A1/trace/alert_CP006A1.log No error messages
Log /u01/app/oracle/diag/rdbms/sp009a/SP009A1/trace/alert_SP009A1.log No error messages
Log /u01/app/oracle/diag/rdbms/sp009a/SP009A1/trace/drcSP009A1.log No error messages
Log /u01/app/oracle/diag/rdbms/sp011a/SP011A1/trace/alert_SP011A1.log No error messages
Log /u01/app/oracle/diag/rdbms/sp011a/SP011A1/trace/drcSP011A1.log No error messages
Log /u01/app/oracle/diag/rdbms/sp016a/SP016A/trace/alert_SP016A.log No error messages
Log /u01/app/oracle/diag/rdbms/sp016a/SP016A/trace/drcSP016A.log No error messages
Log /u01/app/oracle/diag/rdbms/sp016a/SP016A1/trace/alert_SP016A1.log 2 WARN messages (Last worst: “PARSE ERROR: ospid=6622, error=942 for statement:”)
Log /u01/app/oracle/diag/rdbms/sp016a/SP016A1/trace/drcSP016A1.log 3 WARN messages (Last worst: “Physical Standby Database SP016B Warning ORA-16853: apply lag has exceeded specified threshold”)
Log /u01/app/oracle/diag/rdbms/sp020a/SP020A1/trace/alert_SP020A1.log No error messages
Log /u01/app/oracle/diag/rdbms/sp020a/SP020A1/trace/drcSP020A1.log No error messages
Log /u01/app/oracle/diag/rdbms/sp030a/SP030A1/trace/alert_SP030A1.log 4 WARN messages (Last worst: “ORA-03135: connection lost contact”)
Log /u01/app/oracle/diag/rdbms/sp030a/SP030A1/trace/drcSP030A1.log 534 WARN messages (Last worst: “Physical Standby Database SP030B Warning ORA-16855”)
Log /u01/app/oracle/diag/rdbms/sp034a/SP034A1/trace/alert_SP034A1.log No error messages
Log /u01/app/oracle/diag/rdbms/sp034a/SP034A1/trace/drcSP034A1.log No error messages
Log /u01/app/oracle/diag/tnslsnr/olxdeprdoradb03/listener/trace/listener.log No error messages
Memory Total virtual memory: 34.39% - 131.32 GB of 381.92 GB
Mount options of / Mount options exactly as expected
Mount options of /u01 Mount options exactly as expected
NFS mount /u96 79.56% used (1.01 of 1.27 TB), trend: 0.00 B / 24 hours
NFS mount /u98 60.54% used (227.87 of 376.40 GB), trend: +4.16 MB / 24 hours
NFS mount /u99 87.44% used (51.23 of 58.59 TB), trend: -1.06 TB / 24 hours
NTP Time Offset: 0.2180 ms, Time since last sync: 7 minutes 56 seconds
Number of threads Count: 3476 threads, Usage: 0.34%
ORA +ASM Instance Database Name +ASM, Status STARTED, Role ASM, Version 19.0.0.0.0
ORA +ASM Processes 108 of 200 processes are used (54%, warn/crit at 92%/97%)
ORA +ASM Uptime Up since 2019-09-03 08:15:48, uptime: 645 days, 23:29:41
ORA CP002 Recovery Area 6.24 GB out of 500.00 GB used (0.8%, warn/crit at 70.0%/90.0%), 2.46 GB reclaimable
ORA CP002 Recovery Status primary database, oldest Checkpoint 64 m ago
ORA CP002.ARCHIVELOG RMAN Backup Time since last backup: 54 minutes 0 seconds
ORA CP002.AUDITTS Tablespace ONLINE (PERMANENT), Size: 200 MiB, 0.02% used (6.06 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP002.CDB$ROOT.ORACLE_OCM.MGMT_CONFIG_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 01.01.01.976839 AM +01:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.CDB$ROOT.ORACLE_OCM.MGMT_STATS_CONFIG_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 01-JUL-21 01.01.01.247707 AM +01:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.CDB$ROOT.SYS.BSLN_MAINTAIN_STATS_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 3.00 s, Next Run: 13-JUN-21 12.00.00.965312 AM +01:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.CDB$ROOT.SYS.CLEANUP_NON_EXIST_OBJ Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 04.21.20.488869 PM +02:00, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.CLEANUP_ONLINE_IND_BUILD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 08.56.50.425374 AM +01:00, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.CLEANUP_ONLINE_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 08.57.30.405889 AM +01:00, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.CLEANUP_TAB_IOT_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 08.57.00.409797 AM +01:00, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.CLEANUP_TRANSIENT_PKG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 08.57.20.000000 AM +01:00, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.CLEANUP_TRANSIENT_TYPE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 04.21.20.281811 PM +02:00, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.DRA_REEVALUATE_OPEN_FAILURES Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.CDB$ROOT.SYS.FGR$AUTOPURGE_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.FILE_SIZE_UPD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 09-MAR-22 03.19.14.359552 PM +01:00, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.FILE_WATCHER Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.HM_CREATE_OFFLINE_DICTIONARY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.LOAD_OPATCH_INVENTORY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.ORA$AUTOTASK_CLEAN Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.036950 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.CDB$ROOT.SYS.PMO_DEFERRED_GIDX_MAINT_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 02.00.00.605992 AM EUROPE/VIENNA, no log information found (ignored)
ORA CP002.CDB$ROOT.SYS.PURGE_LOG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.034562 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.CDB$ROOT.SYS.RSE$CLEAN_RECOVERABLE_SCRIPT Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.138687 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.CDB$ROOT.SYS.SM$CLEAN_AUTO_SPLIT_MERGE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.125844 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.CDB$ROOT.SYS.XMLDB_NFS_CLEANUP_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP002.CDB$ROOT.TEMP Tablespace ONLINE (TEMPORARY), Size: 190 MiB, 0.02% used (5.00 MiB of max. 32.0 GiB), Free: 32.0 GiB
ORA CP002.CONTROLFILE RMAN Backup Time since last backup: 54 minutes 0 seconds
ORA CP002.CP002A Dataguard-Stats Database Role primary, Protection Mode maximum performance, Broker enabled, Switchover to standby possible
ORA CP002.DB_INCR_0 RMAN Backup Time since last backup: 4 days 4 hours
ORA CP002.DB_INCR_1 RMAN Backup Time since last backup: 6 hours 32 minutes, Incremental SCN 9937256098622
ORA CP002.PDB$SEED Recovery Status primary database, oldest Checkpoint 314 d ago
ORA CP002.PP003 Recovery Status primary database, oldest Checkpoint 64 m ago
ORA CP002.PP003.APP Tablespace ONLINE (PERMANENT), Size: 128 MiB, <0.01% used (1.00 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP002.PP003.AUDITTS Tablespace ONLINE (PERMANENT), Size: 1.62 GiB, 0.41% used (33.2 MiB of max. 8.00 GiB), Free: 7.97 GiB, Space left: 7.97 GiB
ORA CP002.PP003.SYS.BSLN_MAINTAIN_STATS_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 13-JUN-21 12.00.00.398584 AM +01:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.PP003.SYS.CLEANUP_NON_EXIST_OBJ Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 07.18.13.219019 PM +02:00, no log information found (ignored)
ORA CP002.PP003.SYS.CLEANUP_ONLINE_IND_BUILD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 09.07.54.238641 AM +01:00, no log information found (ignored)
ORA CP002.PP003.SYS.CLEANUP_ONLINE_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 09.08.34.617416 AM +01:00, no log information found (ignored)
ORA CP002.PP003.SYS.CLEANUP_TAB_IOT_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 09.08.04.013703 AM +01:00, no log information found (ignored)
ORA CP002.PP003.SYS.CLEANUP_TRANSIENT_PKG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 09.08.24.000000 AM +01:00, no log information found (ignored)
ORA CP002.PP003.SYS.CLEANUP_TRANSIENT_TYPE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 07.18.12.993258 PM +02:00, no log information found (ignored)
ORA CP002.PP003.SYS.DRA_REEVALUATE_OPEN_FAILURES Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.PP003.SYS.FGR$AUTOPURGE_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP002.PP003.SYS.FILE_SIZE_UPD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 09-MAR-22 06.16.13.626104 PM +01:00, no log information found (ignored)
ORA CP002.PP003.SYS.FILE_WATCHER Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP002.PP003.SYS.HM_CREATE_OFFLINE_DICTIONARY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP002.PP003.SYS.LOAD_OPATCH_INVENTORY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP002.PP003.SYS.ORA$AUTOTASK_CLEAN Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.416667 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.PP003.SYS.PMO_DEFERRED_GIDX_MAINT_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 02.00.00.584521 AM EUROPE/VIENNA, no log information found (ignored)
ORA CP002.PP003.SYS.PURGE_LOG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.623649 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.PP003.SYS.RSE$CLEAN_RECOVERABLE_SCRIPT Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.968759 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.PP003.SYS.SM$CLEAN_AUTO_SPLIT_MERGE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.573407 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP002.PP003.SYS.XMLDB_NFS_CLEANUP_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP002.PP003.SYSAUX Tablespace ONLINE (PERMANENT), Size: 225 MiB, 0.63% used (206 MiB of max. 32.0 GiB), Free: 31.8 GiB, Space left: 31.8 GiB
ORA CP002.PP003.SYSTEM Tablespace ONLINE (PERMANENT), Size: 230 MiB, 0.69% used (227 MiB of max. 32.0 GiB), Free: 31.8 GiB, Space left: 31.8 GiB
ORA CP002.PP003.TEMP Tablespace ONLINE (TEMPORARY), Size: 27.0 MiB, 0% used (0 B of max. 32.0 GiB), Free: 32.0 GiB
ORA CP002.PP003.UNDOTBS1 Tablespace ONLINE (UNDO), Size: 275 MiB, 0.10% used (32.2 MiB of max. 32.0 GiB), Free: 32.0 GiB
ORA CP002.PP003.USERS Tablespace ONLINE (PERMANENT), Size: 384 MiB, 0.76% used (248 MiB of max. 32.0 GiB), Free: 31.8 GiB, Space left: 31.8 GiB
ORA CP002.SYSAUX Tablespace ONLINE (PERMANENT), Size: 2.84 GiB, 7.50% used (2.40 GiB of max. 32.0 GiB), Free: 29.6 GiB, Space left: 29.6 GiB
ORA CP002.SYSTEM Tablespace ONLINE (PERMANENT), Size: 960 MiB, 2.91% used (954 MiB of max. 32.0 GiB), Free: 31.1 GiB, Space left: 31.1 GiB
ORA CP002.UNDOTBS1 Tablespace ONLINE (UNDO), Size: 760 MiB, 0.24% used (79.3 MiB of max. 32.0 GiB), Free: 31.9 GiB
ORA CP002.USERS Tablespace ONLINE (PERMANENT), Size: 5.00 MiB, <0.01% used (2.75 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP002A1 Instance CDB Name CP002, Status OPEN, Role PRIMARY, Version 19.0.0.0.0, Logins allowed, Log Mode archivelog, Force Logging yes
ORA CP002A1 Locks No locks existing
ORA CP002A1 Logswitches 0 log switches in the last 60 minutes (warn/crit below -1/-1) (warn/crit at 50/100)
ORA CP002A1 Long Active Sessions 0
ORA CP002A1 Processes 155 of 2000 processes are used (7%, warn/crit at 92%/97%)
ORA CP002A1 Sessions 3.37%, 102 of 3024 sessions
ORA CP002A1 Undo Retention 10 h Undoretention (warn/crit at 10 m/5 m), 160 active undoblocks, 0 max concurrent transactions, 26 m max querylen, 0 space errors
ORA CP002A1 Uptime Up since 2020-03-09 16:21:30, uptime: 457 days, 15:23:59
ORA CP002A1.CDB$ROOT Locks No locks existing
ORA CP002A1.CDB$ROOT Long Active Sessions 0
ORA CP002A1.CDB$ROOT Performance DB Time: 0.00 1/s, DB CPU: 0.00 1/s, DB Non-Idle Wait: 0.00 1/s, Maximum SGA Size: 6.00 GB, Buffer Cache Size: 2.17 GB, Shared Pool Size: 3.58 GB, Redo Buffers: 7.27 MB, Java Pool Size: 160.00 MB, Large Pool Size: 80.00 MB, Streams Pool Size: 0.00 B, Shared IO Pool Size: 128.00 MB, Buffer hit ratio: 99.7%, Library cache hit ratio: 98.8%
ORA CP002A1.CDB$ROOT Sessions 7 sessions
ORA CP002A1.PDB$SEED Instance PDB Name CP002.PDB$SEED, Status READ ONLY, PDB Size 1.00 GB
ORA CP002A1.PDB$SEED Performance limited performance data for PDBSEED and non CDBROOT
ORA CP002A1.PDB$SEED Uptime Up since 2020-07-31 12:35:46, uptime: 313 days, 19:09:43
ORA CP002A1.PP003 Instance PDB Name CP002.PP003, Status READ WRITE, PDB Size 2.86 GB
ORA CP002A1.PP003 Locks No locks existing
ORA CP002A1.PP003 Long Active Sessions 0
ORA CP002A1.PP003 Performance DB Time: 0.01 1/s, DB CPU: 0.01 1/s, DB Non-Idle Wait: 0.00 1/s, limited performance data for PDBSEED and non CDBROOT
ORA CP002A1.PP003 Sessions 20 sessions
ORA CP002A1.PP003 Uptime Up since 2020-03-09 16:21:44, uptime: 457 days, 15:23:45
ORA CP003 Recovery Area 11.13 GB out of 500.00 GB used (1.6%, warn/crit at 70.0%/90.0%), 3.29 GB reclaimable
ORA CP003 Recovery Status primary database, oldest Checkpoint 34 m ago
ORA CP003.ARCHIVELOG RMAN Backup Time since last backup: 33 minutes 0 seconds
ORA CP003.CDB$ROOT.ORACLE_OCM.MGMT_CONFIG_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 11-JUN-21 01.01.01.727536 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.CDB$ROOT.ORACLE_OCM.MGMT_STATS_CONFIG_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 01-JUL-21 01.01.01.191014 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.CDB$ROOT.SYS.BSLN_MAINTAIN_STATS_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 3.00 s, Next Run: 13-JUN-21 12.00.00.443614 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.CDB$ROOT.SYS.CLEANUP_NON_EXIST_OBJ Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 02.22.45.293992 PM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.CLEANUP_ONLINE_IND_BUILD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 09.58.31.062904 AM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.CLEANUP_ONLINE_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 09.59.11.437913 AM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.CLEANUP_TAB_IOT_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 09.58.41.840125 AM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.CLEANUP_TRANSIENT_PKG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 09.59.01.000000 AM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.CLEANUP_TRANSIENT_TYPE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 02.23.50.555788 PM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.DRA_REEVALUATE_OPEN_FAILURES Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.CDB$ROOT.SYS.FGR$AUTOPURGE_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.FILE_SIZE_UPD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 29-JUL-21 02.21.10.430360 PM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.FILE_WATCHER Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.HM_CREATE_OFFLINE_DICTIONARY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.LOAD_OPATCH_INVENTORY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.ORA$AUTOTASK_CLEAN Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.800892 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.CDB$ROOT.SYS.PMO_DEFERRED_GIDX_MAINT_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 02.00.00.285256 AM EUROPE/VIENNA, no log information found (ignored)
ORA CP003.CDB$ROOT.SYS.PURGE_LOG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.803152 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.CDB$ROOT.SYS.RSE$CLEAN_RECOVERABLE_SCRIPT Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.674640 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.CDB$ROOT.SYS.SM$CLEAN_AUTO_SPLIT_MERGE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.063789 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.CDB$ROOT.SYS.XMLDB_NFS_CLEANUP_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.CDB$ROOT.TEMP Tablespace ONLINE (TEMPORARY), Size: 29.0 MiB, 0.03% used (9.00 MiB of max. 32.0 GiB), Free: 32.0 GiB
ORA CP003.CONTROLFILE RMAN Backup Time since last backup: 33 minutes 0 seconds
ORA CP003.CP003A Dataguard-Stats Database Role primary, Protection Mode maximum performance, Broker enabled, Switchover to standby possible
ORA CP003.DB_INCR_0 RMAN Backup Time since last backup: 4 days 12 hours
ORA CP003.DB_INCR_1 RMAN Backup Time since last backup: 10 hours 42 minutes, Incremental SCN 9921316424268
ORA CP003.PDB$SEED Recovery Status primary database, oldest Checkpoint 296 d ago
ORA CP003.PP001 Recovery Status primary database, oldest Checkpoint 34 m ago
ORA CP003.PP001.APP Tablespace ONLINE (PERMANENT), Size: 128 MiB, <0.01% used (1.00 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP003.PP001.CDATA Tablespace ONLINE (PERMANENT), Size: 128 GiB, 39.57% used (101 GiB of max. 256 GiB), Free: 155 GiB, Space left: 155 GiB, 8 data files (8 avail, 8 autoext)
ORA CP003.PP001.CMETA Tablespace ONLINE (PERMANENT), Size: 19.0 GiB, <0.01% used (12.2 MiB of max. 128 GiB), Free: 128 GiB, Space left: 128 GiB, 4 data files (4 avail, 4 autoext)
ORA CP003.PP001.SYS.BSLN_MAINTAIN_STATS_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 13-JUN-21 12.00.00.660294 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP001.SYS.CLEANUP_NON_EXIST_OBJ Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 01.48.57.690370 PM +02:00, no log information found (ignored)
ORA CP003.PP001.SYS.CLEANUP_ONLINE_IND_BUILD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.20.27.719632 AM +02:00, no log information found (ignored)
ORA CP003.PP001.SYS.CLEANUP_ONLINE_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.38.50.697799 AM +02:00, no log information found (ignored)
ORA CP003.PP001.SYS.CLEANUP_TAB_IOT_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.20.37.490589 AM +02:00, no log information found (ignored)
ORA CP003.PP001.SYS.CLEANUP_TRANSIENT_PKG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 11.38.40.000000 AM +02:00, no log information found (ignored)
ORA CP003.PP001.SYS.CLEANUP_TRANSIENT_TYPE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 01.43.24.045297 PM +02:00, no log information found (ignored)
ORA CP003.PP001.SYS.DRA_REEVALUATE_OPEN_FAILURES Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP001.SYS.FGR$AUTOPURGE_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.PP001.SYS.FILE_SIZE_UPD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 03-SEP-21 01.32.52.344821 PM +02:00, no log information found (ignored)
ORA CP003.PP001.SYS.HM_CREATE_OFFLINE_DICTIONARY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.PP001.SYS.LOAD_OPATCH_INVENTORY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.PP001.SYS.ORA$AUTOTASK_CLEAN Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.587313 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP001.SYS.PMO_DEFERRED_GIDX_MAINT_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 02.00.00.322408 AM EUROPE/VIENNA, no log information found (ignored)
ORA CP003.PP001.SYS.PURGE_LOG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 11-JUN-21 03.00.00.374118 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP001.SYS.RSE$CLEAN_RECOVERABLE_SCRIPT Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.429728 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP001.SYS.SM$CLEAN_AUTO_SPLIT_MERGE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.455574 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP001.SYS.XMLDB_NFS_CLEANUP_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.PP001.SYSAUX Tablespace ONLINE (PERMANENT), Size: 1.40 GiB, 3.95% used (1.26 GiB of max. 32.0 GiB), Free: 30.7 GiB, Space left: 30.7 GiB
ORA CP003.PP001.SYSTEM Tablespace ONLINE (PERMANENT), Size: 400 MiB, 0.98% used (322 MiB of max. 32.0 GiB), Free: 31.7 GiB, Space left: 31.7 GiB
ORA CP003.PP001.TEMP Tablespace ONLINE (TEMPORARY), Size: 10.0 GiB, 0% used (0 B of max. 32.0 GiB), Free: 32.0 GiB
ORA CP003.PP001.UNDOTBS1 Tablespace ONLINE (UNDO), Size: 8.63 GiB, 3.08% used (1008 MiB of max. 32.0 GiB), Free: 31.0 GiB
ORA CP003.PP001.USERS Tablespace ONLINE (PERMANENT), Size: 460 GiB, 75.99% used (438 GiB of max. 576 GiB), Free: 138 GiB, Space left: 138 GiB, 18 data files (18 avail, 18 autoext)
ORA CP003.PP004 Recovery Status primary database, oldest Checkpoint 34 m ago
ORA CP003.PP004.APP Tablespace ONLINE (PERMANENT), Size: 128 MiB, <0.01% used (1.00 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP003.PP004.AUDITTS Tablespace ONLINE (PERMANENT), Size: 256 MiB, 1.98% used (162 MiB of max. 8.00 GiB), Free: 7.84 GiB, Space left: 7.84 GiB
ORA CP003.PP004.HVR_REPO Tablespace ONLINE (PERMANENT), Size: 512 MiB, 1.41% used (463 MiB of max. 32.0 GiB), Free: 31.5 GiB, Space left: 31.5 GiB
ORA CP003.PP004.SYS.BSLN_MAINTAIN_STATS_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 13-JUN-21 12.00.00.902553 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP004.SYS.CLEANUP_NON_EXIST_OBJ Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 01.42.35.488456 PM +02:00, no log information found (ignored)
ORA CP003.PP004.SYS.CLEANUP_ONLINE_IND_BUILD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.10.01.462829 AM +02:00, no log information found (ignored)
ORA CP003.PP004.SYS.CLEANUP_ONLINE_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.10.41.699396 AM +02:00, no log information found (ignored)
ORA CP003.PP004.SYS.CLEANUP_TAB_IOT_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.10.11.077358 AM +02:00, no log information found (ignored)
ORA CP003.PP004.SYS.CLEANUP_TRANSIENT_PKG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.10.31.000000 AM +02:00, no log information found (ignored)
ORA CP003.PP004.SYS.CLEANUP_TRANSIENT_TYPE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 01.43.22.487316 PM +02:00, no log information found (ignored)
ORA CP003.PP004.SYS.DRA_REEVALUATE_OPEN_FAILURES Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP004.SYS.FGR$AUTOPURGE_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.PP004.SYS.FILE_SIZE_UPD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 17-SEP-21 01.41.01.505841 PM +02:00, no log information found (ignored)
ORA CP003.PP004.SYS.FILE_WATCHER Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.PP004.SYS.HM_CREATE_OFFLINE_DICTIONARY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.PP004.SYS.LOAD_OPATCH_INVENTORY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.PP004.SYS.ORA$AUTOTASK_CLEAN Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.057618 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP004.SYS.PMO_DEFERRED_GIDX_MAINT_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 02.00.00.304192 AM EUROPE/VIENNA, no log information found (ignored)
ORA CP003.PP004.SYS.PURGE_LOG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.029112 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP004.SYS.RSE$CLEAN_RECOVERABLE_SCRIPT Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.442900 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP004.SYS.SM$CLEAN_AUTO_SPLIT_MERGE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.671562 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP003.PP004.SYS.XMLDB_NFS_CLEANUP_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP003.PP004.SYSAUX Tablespace ONLINE (PERMANENT), Size: 7.09 GiB, 19.58% used (6.26 GiB of max. 32.0 GiB), Free: 25.7 GiB, Space left: 25.7 GiB
ORA CP003.PP004.SYSTEM Tablespace ONLINE (PERMANENT), Size: 230 MiB, 0.68% used (223 MiB of max. 32.0 GiB), Free: 31.8 GiB, Space left: 31.8 GiB
ORA CP003.PP004.TEMP Tablespace ONLINE (TEMPORARY), Size: 27.0 MiB, 0% used (0 B of max. 32.0 GiB), Free: 32.0 GiB
ORA CP003.PP004.UNDOTBS1 Tablespace ONLINE (UNDO), Size: 1.51 GiB, 1.52% used (499 MiB of max. 32.0 GiB), Free: 31.5 GiB
ORA CP003.PP004.USERS Tablespace ONLINE (PERMANENT), Size: 128 MiB, <0.01% used (1.00 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP003.SYSAUX Tablespace ONLINE (PERMANENT), Size: 3.12 GiB, 8.11% used (2.59 GiB of max. 32.0 GiB), Free: 29.4 GiB, Space left: 29.4 GiB
ORA CP003.SYSTEM Tablespace ONLINE (PERMANENT), Size: 700 MiB, 1.61% used (528 MiB of max. 32.0 GiB), Free: 31.5 GiB, Space left: 31.5 GiB
ORA CP003.UNDOTBS1 Tablespace ONLINE (UNDO), Size: 385 MiB, 0.17% used (57.2 MiB of max. 32.0 GiB), Free: 31.9 GiB
ORA CP003.USERS Tablespace ONLINE (PERMANENT), Size: 5.00 MiB, <0.01% used (1.06 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP003A1 Instance CDB Name CP003, Status OPEN, Role PRIMARY, Version 19.0.0.0.0, Logins allowed, Log Mode archivelog, Force Logging yes
ORA CP003A1 Locks No locks existing
ORA CP003A1 Logswitches 2 log switches in the last 60 minutes (warn/crit below -1/-1) (warn/crit at 50/100)
ORA CP003A1 Long Active Sessions 0
ORA CP003A1 Processes 147 of 2000 processes are used (7%, warn/crit at 92%/97%)
ORA CP003A1 Sessions 3.37%, 102 of 3024 sessions
ORA CP003A1 Undo Retention 10 h Undoretention (warn/crit at 10 m/5 m), 160 active undoblocks, 0 max concurrent transactions, 20 m max querylen, 0 space errors
ORA CP003A1 Uptime Up since 2020-08-18 19:12:33, uptime: 295 days, 12:32:56
ORA CP003A1.CDB$ROOT Locks No locks existing
ORA CP003A1.CDB$ROOT Long Active Sessions 0
ORA CP003A1.CDB$ROOT Performance DB Time: 0.52 1/s, DB CPU: 0.08 1/s, DB Non-Idle Wait: 0.44 1/s, Maximum SGA Size: 3.00 GB, Buffer Cache Size: 1.11 GB, Shared Pool Size: 1.78 GB, Redo Buffers: 7.28 MB, Java Pool Size: 0.00 B, Large Pool Size: 80.00 MB, Streams Pool Size: 16.00 MB, Shared IO Pool Size: 128.00 MB, Buffer hit ratio: 99.0%, Library cache hit ratio: 94.7%
ORA CP003A1.CDB$ROOT Sessions 8 sessions
ORA CP003A1.PDB$SEED Instance PDB Name CP003.PDB$SEED, Status READ ONLY, PDB Size 1021.00 MB
ORA CP003A1.PDB$SEED Performance limited performance data for PDBSEED and non CDBROOT
ORA CP003A1.PDB$SEED Uptime Up since 2020-08-18 19:30:24, uptime: 295 days, 12:15:05
ORA CP003A1.PP001 Instance PDB Name CP003.PP001, Status READ WRITE, PDB Size 627.20 GB
ORA CP003A1.PP001 Locks No locks existing
ORA CP003A1.PP001 Long Active Sessions 0
ORA CP003A1.PP001 Performance DB Time: 0.00 1/s, DB CPU: 0.01 1/s, DB Non-Idle Wait: 0.00 1/s, limited performance data for PDBSEED and non CDBROOT
ORA CP003A1.PP001 Sessions 4 sessions
ORA CP003A1.PP001 Uptime Up since 2020-08-18 19:21:15, uptime: 295 days, 12:24:14
ORA CP003A1.PP004 Instance PDB Name CP003.PP004, Status READ WRITE, PDB Size 9.86 GB
ORA CP003A1.PP004 Locks No locks existing
ORA CP003A1.PP004 Long Active Sessions 0
ORA CP003A1.PP004 Performance DB Time: 0.00 1/s, DB CPU: 0.00 1/s, DB Non-Idle Wait: 0.00 1/s, limited performance data for PDBSEED and non CDBROOT
ORA CP003A1.PP004 Sessions 3 sessions
ORA CP003A1.PP004 Uptime Up since 2020-09-17 11:40:56, uptime: 265 days, 20:04:33
ORA CP005 Recovery Area 9.70 GB out of 200.00 GB used (1.5%, warn/crit at 70.0%/90.0%), 6.78 GB reclaimable
ORA CP005 Recovery Status primary database, oldest Checkpoint 43 m ago
ORA CP005.ARCHIVELOG RMAN Backup Time since last backup: 35 minutes 0 seconds
ORA CP005.CDB$ROOT.ORACLE_OCM.MGMT_CONFIG_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 17.0 s, Next Run: 11-JUN-21 01.01.01.266580 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.CDB$ROOT.ORACLE_OCM.MGMT_STATS_CONFIG_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 18.0 s, Next Run: 01-JUL-21 01.01.01.617646 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.CDB$ROOT.SYS.BSLN_MAINTAIN_STATS_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 40.0 s, Next Run: 13-JUN-21 12.00.00.637527 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.CDB$ROOT.SYS.CLEANUP_NON_EXIST_OBJ Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 10-JUN-21 02.45.21.749340 PM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.CLEANUP_ONLINE_IND_BUILD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 10-JUN-21 10.15.33.441889 AM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.CLEANUP_ONLINE_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 10-JUN-21 10.16.13.835718 AM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.CLEANUP_TAB_IOT_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.15.43.851263 AM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.CLEANUP_TRANSIENT_PKG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.16.03.000000 AM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.CLEANUP_TRANSIENT_TYPE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 10-JUN-21 02.45.15.885718 PM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.DRA_REEVALUATE_OPEN_FAILURES Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.CDB$ROOT.SYS.FGR$AUTOPURGE_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.FILE_SIZE_UPD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 08-SEP-21 02.40.14.597884 PM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.FILE_WATCHER Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.HM_CREATE_OFFLINE_DICTIONARY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.LOAD_OPATCH_INVENTORY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.ORA$AUTOTASK_CLEAN Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.858176 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.CDB$ROOT.SYS.PMO_DEFERRED_GIDX_MAINT_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 7.00 s, Next Run: 11-JUN-21 02.00.00.610166 AM EUROPE/VIENNA, no log information found (ignored)
ORA CP005.CDB$ROOT.SYS.PURGE_LOG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 17.0 s, Next Run: 11-JUN-21 03.00.00.709726 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.CDB$ROOT.SYS.RSE$CLEAN_RECOVERABLE_SCRIPT Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 11-JUN-21 12.00.00.194800 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.CDB$ROOT.SYS.SM$CLEAN_AUTO_SPLIT_MERGE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.050978 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.CDB$ROOT.SYS.XMLDB_NFS_CLEANUP_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.CDB$ROOT.TEMP Tablespace ONLINE (TEMPORARY), Size: 95.0 MiB, 0.13% used (42.0 MiB of max. 32.0 GiB), Free: 32.0 GiB
ORA CP005.CONTROLFILE RMAN Backup Time since last backup: 34 minutes 0 seconds
ORA CP005.CP005A Dataguard-Stats Database Role primary, Protection Mode maximum performance, Broker enabled, Switchover to standby possible
ORA CP005.DB_INCR_0 RMAN Backup Time since last backup: 4 days 15 hours
ORA CP005.DB_INCR_1 RMAN Backup Time since last backup: 11 hours 31 minutes, Incremental SCN 9937067939355
ORA CP005.PDB$SEED Recovery Status primary database, oldest Checkpoint 275 d ago
ORA CP005.PP002 Recovery Status primary database, oldest Checkpoint 43 m ago
ORA CP005.PP002.APEX Tablespace ONLINE (PERMANENT), Size: 443 MiB, 1.28% used (421 MiB of max. 32.0 GiB), Free: 31.6 GiB, Space left: 31.6 GiB
ORA CP005.PP002.APEX_200100.ORACLE_APEX_AUTO_APPROVAL Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP002.APEX_200100.ORACLE_APEX_BACKUP Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 11-JUN-21 02.49.56.697408 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.APEX_200100.ORACLE_APEX_DAILY_MAINTENANCE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 5.00 s, Next Run: 11-JUN-21 01.00.00.505887 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.APEX_200100.ORACLE_APEX_DICTIONARY_CACHE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 11.0 s, Next Run: 11-JUN-21 01.00.00.747372 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.APEX_200100.ORACLE_APEX_ISSUE_EMAILS Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 10-JUN-21 10.00.00.681397 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.APEX_200100.ORACLE_APEX_MAIL_QUEUE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 10-JUN-21 09.40.00.287401 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.APEX_200100.ORACLE_APEX_PURGE_SESSIONS Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 10-JUN-21 10.00.56.086371 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.APEX_200100.ORACLE_APEX_WS_NOTIFICATIONS Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 10-JUN-21 10.00.00.826413 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.APP Tablespace ONLINE (PERMANENT), Size: 128 MiB, <0.01% used (1.00 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP005.PP002.MP_IMPORT.PLZ_BASIERT_LM_MENGE_IMPORT_HADV Job Job-State: RUNNING, Enabled: No, Next Run: 22-MAY-21 11.20.00.525327 AM EUROPE/BERLIN, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.MP_IMPORT_DEV.PROCESS_SPAETESTEZUSTELLUNG_TABLE Job Job-State: DISABLED, Enabled: No (ignored), Last Duration: 0.00 s, Next Run: 01-APR-21 09.20.00.000000 AM EUROPE/BERLIN, no log information found (ignored)
ORA CP005.PP002.MP_UTIL.GENERATE_FIXED_FORECAST Job Job-State: DISABLED, Enabled: No (ignored), Last Duration: 1.00 s, Next Run: 03-AUG-20 12.18.37.000000 AM EUROPE/BERLIN, no log information found (ignored)
ORA CP005.PP002.SYS.BSLN_MAINTAIN_STATS_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 13-JUN-21 12.00.00.504262 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.SYS.CLEANUP_NON_EXIST_OBJ Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 10-JUN-21 03.12.04.775700 PM +02:00, no log information found (ignored)
ORA CP005.PP002.SYS.CLEANUP_ONLINE_IND_BUILD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.20.27.446381 AM +02:00, no log information found (ignored)
ORA CP005.PP002.SYS.CLEANUP_ONLINE_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 09.38.50.940382 AM +02:00, no log information found (ignored)
ORA CP005.PP002.SYS.CLEANUP_TAB_IOT_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.20.37.854178 AM +02:00, no log information found (ignored)
ORA CP005.PP002.SYS.CLEANUP_TRANSIENT_PKG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 09.38.40.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP002.SYS.CLEANUP_TRANSIENT_TYPE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 02.45.25.813404 PM +02:00, no log information found (ignored)
ORA CP005.PP002.SYS.DRA_REEVALUATE_OPEN_FAILURES Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.SYS.FGR$AUTOPURGE_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP002.SYS.FILE_SIZE_UPD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 03-JUN-22 05.16.28.486991 PM +02:00, no log information found (ignored)
ORA CP005.PP002.SYS.HM_CREATE_OFFLINE_DICTIONARY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP002.SYS.LOAD_OPATCH_INVENTORY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP002.SYS.ORA$AUTOTASK_CLEAN Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.311376 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.SYS.PMO_DEFERRED_GIDX_MAINT_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 10.0 s, Next Run: 11-JUN-21 02.00.00.866908 AM EUROPE/VIENNA, no log information found (ignored)
ORA CP005.PP002.SYS.PURGE_LOG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 15.0 s, Next Run: 11-JUN-21 03.00.00.228897 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.SYS.RSE$CLEAN_RECOVERABLE_SCRIPT Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.340461 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.SYS.SM$CLEAN_AUTO_SPLIT_MERGE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.034367 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP002.SYS.XMLDB_NFS_CLEANUP_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP002.SYSAUX Tablespace ONLINE (PERMANENT), Size: 4.15 GiB, 12.20% used (3.90 GiB of max. 32.0 GiB), Free: 28.1 GiB, Space left: 28.1 GiB
ORA CP005.PP002.SYSTEM Tablespace ONLINE (PERMANENT), Size: 590 MiB, 1.78% used (584 MiB of max. 32.0 GiB), Free: 31.4 GiB, Space left: 31.4 GiB
ORA CP005.PP002.TEMP Tablespace ONLINE (TEMPORARY), Size: 32.0 GiB, 0% used (0 B of max. 32.0 GiB), Free: 32.0 GiB
ORA CP005.PP002.UNDOTBS1 Tablespace ONLINE (UNDO), Size: 5.67 GiB, 2.38% used (778 MiB of max. 32.0 GiB), Free: 31.2 GiB
ORA CP005.PP002.USERS Tablespace ONLINE (PERMANENT), Size: 6.12 GiB, 3.58% used (4.58 GiB of max. 128 GiB), Free: 123 GiB, Space left: 123 GiB, 4 data files (4 avail, 4 autoext)
ORA CP005.PP005 Recovery Status primary database, oldest Checkpoint 43 m ago
ORA CP005.PP005.APP Tablespace ONLINE (PERMANENT), Size: 128 MiB, <0.01% used (1.00 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP005.PP005.AUDITTS Tablespace ONLINE (PERMANENT), Size: 256 MiB, 1.58% used (130 MiB of max. 8.00 GiB), Free: 7.87 GiB, Space left: 7.87 GiB
ORA CP005.PP005.SYS.BSLN_MAINTAIN_STATS_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 13-JUN-21 12.00.00.689400 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP005.SYS.CLEANUP_NON_EXIST_OBJ Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 10-JUN-21 11.14.46.453673 AM +02:00, no log information found (ignored)
ORA CP005.PP005.SYS.CLEANUP_ONLINE_IND_BUILD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.27.42.419383 AM +02:00, no log information found (ignored)
ORA CP005.PP005.SYS.CLEANUP_ONLINE_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.28.22.048144 AM +02:00, no log information found (ignored)
ORA CP005.PP005.SYS.CLEANUP_TAB_IOT_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.27.52.851426 AM +02:00, no log information found (ignored)
ORA CP005.PP005.SYS.CLEANUP_TRANSIENT_PKG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.28.12.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP005.SYS.CLEANUP_TRANSIENT_TYPE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 10-JUN-21 11.14.45.688775 AM +02:00, no log information found (ignored)
ORA CP005.PP005.SYS.DRA_REEVALUATE_OPEN_FAILURES Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP005.SYS.FGR$AUTOPURGE_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP005.SYS.FILE_SIZE_UPD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 18-DEC-21 10.08.42.279542 AM +01:00, no log information found (ignored)
ORA CP005.PP005.SYS.FILE_WATCHER Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP005.SYS.HM_CREATE_OFFLINE_DICTIONARY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP005.SYS.LOAD_OPATCH_INVENTORY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP005.SYS.ORA$AUTOTASK_CLEAN Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.086081 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP005.SYS.PMO_DEFERRED_GIDX_MAINT_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 7.00 s, Next Run: 11-JUN-21 02.00.00.740233 AM EUROPE/VIENNA, no log information found (ignored)
ORA CP005.PP005.SYS.PURGE_LOG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 18.0 s, Next Run: 11-JUN-21 03.00.00.019181 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP005.SYS.RSE$CLEAN_RECOVERABLE_SCRIPT Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 11-JUN-21 12.00.00.554464 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP005.SYS.SM$CLEAN_AUTO_SPLIT_MERGE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.577253 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP005.SYS.XMLDB_NFS_CLEANUP_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP005.SYSAUX Tablespace ONLINE (PERMANENT), Size: 5.28 GiB, 15.61% used (5.00 GiB of max. 32.0 GiB), Free: 27.0 GiB, Space left: 27.0 GiB
ORA CP005.PP005.SYSTEM Tablespace ONLINE (PERMANENT), Size: 240 MiB, 0.72% used (236 MiB of max. 32.0 GiB), Free: 31.8 GiB, Space left: 31.8 GiB
ORA CP005.PP005.TEMP Tablespace ONLINE (TEMPORARY), Size: 41.0 MiB, 0% used (0 B of max. 32.0 GiB), Free: 32.0 GiB
ORA CP005.PP005.UNDOTBS1 Tablespace ONLINE (UNDO), Size: 590 MiB, 0.16% used (52.2 MiB of max. 32.0 GiB), Free: 31.9 GiB
ORA CP005.PP005.USERS Tablespace ONLINE (PERMANENT), Size: 128 MiB, 0.24% used (79.2 MiB of max. 32.0 GiB), Free: 31.9 GiB, Space left: 31.9 GiB
ORA CP005.PP006 Recovery Status primary database, oldest Checkpoint 43 m ago
ORA CP005.PP006.APP Tablespace ONLINE (PERMANENT), Size: 128 MiB, <0.01% used (1.00 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP005.PP006.AUDITTS Tablespace ONLINE (PERMANENT), Size: 256 MiB, 1.98% used (162 MiB of max. 8.00 GiB), Free: 7.84 GiB, Space left: 7.84 GiB
ORA CP005.PP006.SYS.BSLN_MAINTAIN_STATS_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 13-JUN-21 12.00.00.724439 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP006.SYS.CLEANUP_NON_EXIST_OBJ Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 10-JUN-21 11.40.48.355469 AM +02:00, no log information found (ignored)
ORA CP005.PP006.SYS.CLEANUP_ONLINE_IND_BUILD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.27.42.939373 AM +02:00, no log information found (ignored)
ORA CP005.PP006.SYS.CLEANUP_ONLINE_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.28.22.851567 AM +02:00, no log information found (ignored)
ORA CP005.PP006.SYS.CLEANUP_TAB_IOT_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.27.52.048205 AM +02:00, no log information found (ignored)
ORA CP005.PP006.SYS.CLEANUP_TRANSIENT_PKG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.28.12.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP006.SYS.CLEANUP_TRANSIENT_TYPE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 11.40.45.685483 AM +02:00, no log information found (ignored)
ORA CP005.PP006.SYS.DRA_REEVALUATE_OPEN_FAILURES Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP006.SYS.FGR$AUTOPURGE_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP006.SYS.FILE_SIZE_UPD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 18-DEC-21 10.36.15.297662 AM +01:00, no log information found (ignored)
ORA CP005.PP006.SYS.FILE_WATCHER Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP006.SYS.HM_CREATE_OFFLINE_DICTIONARY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP006.SYS.LOAD_OPATCH_INVENTORY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP006.SYS.ORA$AUTOTASK_CLEAN Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.138819 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP006.SYS.PMO_DEFERRED_GIDX_MAINT_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 7.00 s, Next Run: 11-JUN-21 02.00.00.061819 AM EUROPE/VIENNA, no log information found (ignored)
ORA CP005.PP006.SYS.PURGE_LOG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 17.0 s, Next Run: 11-JUN-21 03.00.00.605384 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP006.SYS.RSE$CLEAN_RECOVERABLE_SCRIPT Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 11-JUN-21 12.00.00.996172 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP006.SYS.SM$CLEAN_AUTO_SPLIT_MERGE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.140376 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP006.SYS.XMLDB_NFS_CLEANUP_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP006.SYSAUX Tablespace ONLINE (PERMANENT), Size: 5.80 GiB, 17.23% used (5.52 GiB of max. 32.0 GiB), Free: 26.5 GiB, Space left: 26.5 GiB
ORA CP005.PP006.SYSTEM Tablespace ONLINE (PERMANENT), Size: 240 MiB, 0.72% used (236 MiB of max. 32.0 GiB), Free: 31.8 GiB, Space left: 31.8 GiB
ORA CP005.PP006.TEMP Tablespace ONLINE (TEMPORARY), Size: 64.0 MiB, 0% used (0 B of max. 32.0 GiB), Free: 32.0 GiB
ORA CP005.PP006.UNDOTBS1 Tablespace ONLINE (UNDO), Size: 1.24 GiB, 0.15% used (48.2 MiB of max. 32.0 GiB), Free: 32.0 GiB
ORA CP005.PP006.USERS Tablespace ONLINE (PERMANENT), Size: 384 MiB, 0.21% used (70.2 MiB of max. 32.0 GiB), Free: 31.9 GiB, Space left: 31.9 GiB
ORA CP005.PP007 Recovery Status primary database, oldest Checkpoint 43 m ago
ORA CP005.PP007.APP Tablespace ONLINE (PERMANENT), Size: 128 MiB, <0.01% used (1.00 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP005.PP007.AUDITTS Tablespace ONLINE (PERMANENT), Size: 128 MiB, 1.19% used (97.6 MiB of max. 8.00 GiB), Free: 7.90 GiB, Space left: 7.90 GiB
ORA CP005.PP007.SYS.BSLN_MAINTAIN_STATS_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 13-JUN-21 12.00.00.959059 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP007.SYS.CLEANUP_NON_EXIST_OBJ Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 10-JUN-21 11.47.43.738766 AM +02:00, no log information found (ignored)
ORA CP005.PP007.SYS.CLEANUP_ONLINE_IND_BUILD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 10-JUN-21 10.27.42.264175 AM +02:00, no log information found (ignored)
ORA CP005.PP007.SYS.CLEANUP_ONLINE_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.28.22.447881 AM +02:00, no log information found (ignored)
ORA CP005.PP007.SYS.CLEANUP_TAB_IOT_PMO Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.27.52.244208 AM +02:00, no log information found (ignored)
ORA CP005.PP007.SYS.CLEANUP_TRANSIENT_PKG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 10-JUN-21 10.28.12.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP007.SYS.CLEANUP_TRANSIENT_TYPE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 1.00 s, Next Run: 10-JUN-21 11.47.42.978119 AM +02:00, no log information found (ignored)
ORA CP005.PP007.SYS.DRA_REEVALUATE_OPEN_FAILURES Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP007.SYS.FGR$AUTOPURGE_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP007.SYS.FILE_SIZE_UPD Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 18-DEC-21 10.43.24.118695 AM +01:00, no log information found (ignored)
ORA CP005.PP007.SYS.FILE_WATCHER Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP007.SYS.HM_CREATE_OFFLINE_DICTIONARY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP007.SYS.LOAD_OPATCH_INVENTORY Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP007.SYS.ORA$AUTOTASK_CLEAN Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 03.00.00.090500 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP007.SYS.PMO_DEFERRED_GIDX_MAINT_JOB Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 7.00 s, Next Run: 11-JUN-21 02.00.00.713217 AM EUROPE/VIENNA, no log information found (ignored)
ORA CP005.PP007.SYS.PURGE_LOG Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 18.0 s, Next Run: 11-JUN-21 03.00.00.282294 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP007.SYS.RSE$CLEAN_RECOVERABLE_SCRIPT Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 2.00 s, Next Run: 11-JUN-21 12.00.00.303812 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP007.SYS.SM$CLEAN_AUTO_SPLIT_MERGE Job Job-State: SCHEDULED, Enabled: Yes, Last Duration: 0.00 s, Next Run: 11-JUN-21 12.00.00.891072 AM EUROPE/VIENNA, Last Run Status: SUCCEEDED (ignored disabled Job)
ORA CP005.PP007.SYS.XMLDB_NFS_CLEANUP_JOB Job Job-State: DISABLED, Enabled: No (ignored), Next Run: 01-JAN-70 12.00.00.000000 AM +02:00, no log information found (ignored)
ORA CP005.PP007.SYSAUX Tablespace ONLINE (PERMANENT), Size: 835 MiB, 2.40% used (785 MiB of max. 32.0 GiB), Free: 31.2 GiB, Space left: 31.2 GiB
ORA CP005.PP007.SYSTEM Tablespace ONLINE (PERMANENT), Size: 240 MiB, 0.71% used (234 MiB of max. 32.0 GiB), Free: 31.8 GiB, Space left: 31.8 GiB
ORA CP005.PP007.TEMP Tablespace ONLINE (TEMPORARY), Size: 41.0 MiB, 0% used (0 B of max. 32.0 GiB), Free: 32.0 GiB
ORA CP005.PP007.UNDOTBS1 Tablespace ONLINE (UNDO), Size: 315 MiB, 0.83% used (273 MiB of max. 32.0 GiB), Free: 31.7 GiB
ORA CP005.PP007.USERS Tablespace ONLINE (PERMANENT), Size: 128 MiB, 0.20% used (65.5 MiB of max. 32.0 GiB), Free: 31.9 GiB, Space left: 31.9 GiB
ORA CP005.SYSAUX Tablespace ONLINE (PERMANENT), Size: 3.61 GiB, 10.25% used (3.28 GiB of max. 32.0 GiB), Free: 28.7 GiB, Space left: 28.7 GiB
ORA CP005.SYSTEM Tablespace ONLINE (PERMANENT), Size: 920 MiB, 2.79% used (914 MiB of max. 32.0 GiB), Free: 31.1 GiB, Space left: 31.1 GiB
ORA CP005.UNDOTBS1 Tablespace ONLINE (UNDO), Size: 770 MiB, 0.20% used (64.3 MiB of max. 32.0 GiB), Free: 31.9 GiB
ORA CP005.USERS Tablespace ONLINE (PERMANENT), Size: 5.00 MiB, <0.01% used (2.75 MiB of max. 32.0 GiB), Free: 32.0 GiB, Space left: 32.0 GiB
ORA CP005A1 Instance CDB Name CP005, Status OPEN, Role PRIMARY, Version 19.0.0.0.0, Logins allowed, Log Mode archivelog, Force Logging yes
ORA CP005A1 Locks No locks existing
ORA CP005A1 Logswitches 0 log switches in the last 60 minutes (warn/crit below -1/-1) (warn/crit at 50/100)
ORA CP005A1 Long Active Sessions 1 Session (sid,serial,proc) 2848 19691 24507 active for 19 d from HOSTNAME osuser oracle program oracle@HOSTNAME (J000) sql_id 37wcwtnkcf8zm
ORA CP005A1 Processes 190 of 2000 processes are used (9%, warn/crit at 92%/97%)
ORA CP005A1 Sessions 3.21%, 97 of 3024 sessions
ORA CP005A1 Undo Retention 10 h Undoretention (warn/crit at 10 m/5 m), 160 active undoblocks, 0 max concurrent transactions, 23 m max querylen, 0 space errors
ORA CP005A1 Uptime Up since 2020-09-10 07:30:20, uptime: 273 days, 0:15:09
ORA CP005A1.CDB$ROOT Locks No locks existing
ORA CP005A1.CDB$ROOT Long Active Sessions 1 Session (sid,serial,proc) 2848 19691 24507 active for 19 d from HOSTNAME osuser oracle program oracle@HOSTNAME (J000) sql_id 37wcwtnkcf8zm
ORA CP005A1.CDB$ROOT Performance DB Time: 0.05 1/s, DB CPU: 0.01 1/s, DB Non-Idle Wait: 0.04 1/s, Maximum SGA Size: 3.00 GB, Buffer Cache Size: 1.11 GB, Shared Pool Size: 1.78 GB, Redo Buffers: 7.28 MB, Java Pool Size: 16.00 MB, Large Pool Size: 80.00 MB, Streams Pool Size: 0.00 B, Shared IO Pool Size: 128.00 MB, Buffer hit ratio: 95.3%, Library cache hit ratio: 97.7%
ORA CP005A1.CDB$ROOT Sessions 11 sessions
ORA CP005A1.PDB$SEED Instance PDB Name CP005.PDB$SEED, Status READ ONLY, PDB Size 1.01 GB
ORA CP005A1.PDB$SEED Performance limited performance data for PDBSEED and non CDBROOT
ORA CP005A1.PDB$SEED Uptime Up since 2020-09-10 07:30:34, uptime: 273 days, 0:14:55
ORA CP005A1.PP002 Instance PDB Name CP005.PP002, Status READ WRITE, PDB Size 49.08 GB
ORA CP005A1.PP002 Locks No locks existing
ORA CP005A1.PP002 Long Active Sessions 1 Session (sid,serial,proc) 2848 19691 24507 active for 19 d from HOSTNAME osuser oracle program oracle@HOSTNAME (J000) sql_id 37wcwtnkcf8zm
ORA CP005A1.PP002 Performance DB Time: 0.03 1/s, DB CPU: 0.00 1/s, DB Non-Idle Wait: 0.03 1/s, limited performance data for PDBSEED and non CDBROOT
ORA CP005A1.PP002 Sessions 3 sessions
ORA CP005A1.PP002 Uptime Up since 2020-09-10 07:30:35, uptime: 273 days, 0:14:54
ORA CP005A1.PP005 Instance PDB Name CP005.PP005, Status READ WRITE, PDB Size 6.63 GB
ORA CP005A1.PP005 Locks No locks existing
ORA CP005A1.PP005 Long Active Sessions 1 Session (sid,serial,proc) 2848 19691 24507 active for 19 d from HOSTNAME osuser oracle program oracle@HOSTNAME (J000) sql_id 37wcwtnkcf8zm
ORA CP005A1.PP005 Performance DB Time: 0.04 1/s, DB CPU: 0.01 1/s, DB Non-Idle Wait: 0.03 1/s, limited performance data for PDBSEED and non CDBROOT
ORA CP005A1.PP005 Sessions 15 sessions
ORA CP005A1.PP005 Uptime Up since 2020-12-18 08:08:34, uptime: 173 days, 23:36:55
ORA CP005A1.PP006 Instance PDB Name CP005.PP006, Status READ WRITE, PDB Size 8.08 GB
ORA CP005A1.PP006 Locks No locks existing
ORA CP005A1.PP006 Long Active Sessions 1 Session (sid,serial,proc) 2848 19691 24507 active for 19 d from HOSTNAME osuser oracle program oracle@HOSTNAME (J000) sql_id 37wcwtnkcf8zm
ORA CP005A1.PP006 Performance DB Time: 0.23 1/s, DB CPU: 0.01 1/s, DB Non-Idle Wait: 0.22 1/s, limited performance data for PDBSEED and non CDBROOT
ORA CP005A1.PP006 Sessions 14 sessions
ORA CP005A1.PP006 Uptime Up since 2020-12-18 08:36:07, uptime: 173 days, 23:09:22
ORA CP005A1.PP007 Instance PDB Name CP005.PP007, Status READ WRITE, PDB Size 1.77 GB
ORA CP005A1.PP007 Locks No locks existing
ORA CP005A1.PP007 Long Active Sessions 1 Session (sid,serial,proc) 2848 19691 24507 active for 19 d from HOSTNAME osuser oracle program oracle@HOSTNAME (J000) sql_id 37wcwtnkcf8zm
ORA CP005A1.PP007 Performance DB Time: 0.09 1/s, DB CPU: 0.01 1/s, DB Non-Idle Wait: 0.08 1/s, limited performance data for PDBSEED and non CDBROOT
ORA CP005A1.PP007 Sessions 15 sessions
ORA CP005A1.PP007 Uptime Up since 2020-12-18 08:43:16, uptime: 173 days, 23:02:13
ORA SP009 Recovery Area 137.79 GB out of 500.00 GB used (9.2%, warn/crit at 70.0%/90.0%), 91.87 GB reclaimable
ORA SP009 Recovery Status primary database, oldest Checkpoint 5 m ago
ORA SP009.ARCHIVELOG RMAN Backup Time since last backup: 33 minutes 0 seconds
[cpu_tracking] Stop [7f227de493a0 - Snapshot(process=posix.times_result(user=0.16999999999999993, system=0.06, children_user=0.0, children_system=0.0, elapsed=0.25))]
Try aquire lock on /omd/sites/otc/var/check_mk/crashes/base/d410f536-c9bf-11eb-b5c3-0242ac110002/crash.info
Got lock on /omd/sites/otc/var/check_mk/crashes/base/d410f536-c9bf-11eb-b5c3-0242ac110002/crash.info
Releasing lock on /omd/sites/otc/var/check_mk/crashes/base/d410f536-c9bf-11eb-b5c3-0242ac110002/crash.info
Released lock on /omd/sites/otc/var/check_mk/crashes/base/d410f536-c9bf-11eb-b5c3-0242ac110002/crash.info
Traceback (most recent call last):
File “/omd/sites/otc/bin/cmk”, line 98, in
exit_status = modes.call("–check", None, opts, args)
File “/omd/sites/otc/lib/python3/cmk/base/modes/init.py”, line 69, in call
return handler(*handler_args)
File “/omd/sites/otc/lib/python3/cmk/base/modes/check_mk.py”, line 1632, in mode_check
return checking.do_check(
File “/omd/sites/otc/lib/python3/cmk/base/decorator.py”, line 37, in wrapped_check_func
status, infotexts, long_infotexts, perfdata = check_func(hostname, *args, **kwargs)
File “/omd/sites/otc/lib/python3/cmk/base/checking.py”, line 213, in do_check
num_success, plugins_missing_data = _do_all_checks_on_host(
File “/omd/sites/otc/lib/python3/cmk/base/checking.py”, line 339, in _do_all_checks_on_host
success = execute_check(
File “/omd/sites/otc/lib/python3/cmk/base/checking.py”, line 482, in execute_check
submit, data_received, result = get_aggregated_result(
File “/omd/sites/otc/lib/python3/cmk/base/checking.py”, line 577, in get_aggregated_result
result = _aggregate_results(check_function(**kwargs))
File “/omd/sites/otc/lib/python3/cmk/base/checking.py”, line 808, in _aggregate_results
perfdata, results = _consume_and_dispatch_result_types(subresults)
File “/omd/sites/otc/lib/python3/cmk/base/checking.py”, line 852, in _consume_and_dispatch_result_types
for subr in subresults:
File “/omd/sites/otc/lib/python3/cmk/base/api/agent_based/register/check_plugins.py”, line 89, in filtered_generator
for element in generator(*args, **kwargs):
File “/omd/sites/otc/lib/python3/cmk/base/api/agent_based/register/check_plugins_legacy.py”, line 171, in check_result_generator
subresults = sig_function(**kwargs)
File “/omd/sites/otc/lib/python3/cmk/base/api/agent_based/register/check_plugins_legacy.py”, line 253, in check_migration_wrapper
return original_function(item, params, section)
File “/omd/sites/otc/share/check_mk/checks/oracle_jobs”, line 81, in check_oracle_jobs
itemsid, itempdb, itemowner, itemname = item.split(’.’, 3)
ValueError: not enough values to unpack (expected 4, got 3)
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed. Contact an admin if you think this should be re-opened.
