Statistics generated on: 01-APR-2023 15:51:52
by: SYS
using: ora2html.sql v.1.0.35c
Software by
Meo Bogliolo
| Summary | |
| Item | Value |
| Database : | FREE |
| Version : | 23.0.0.0.0 |
| Created : | 28-MAR-2023 13:23:55 |
| Started : | 01-APR-2023 15:43:31 |
| DB Size (MB) : | 1,740 |
| Used Space (MB) : | 1,703 |
| SGA (MB) : | 1,534 |
| Log archiving : | NOARCHIVELOG |
| Defined Users / OPEN: | 34 / 4 |
| Defined Schemata : | 15 |
| Defined Tables : | 464 |
| Sessions / USER / ACTIVE: | 86 / 6 / 6 |
| Character set : | AL32UTF8 |
| Hostname : | ora23c |
| Instance : | FREE |
| Archiver : | STOPPED |
| RedoLog Writes Day (MB) : | 0 |
| Version check | |||
| Version | Supported Release | Last releases | Notes |
| Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release | NO | YES | Last Release Updates (12.2+): 23.0, 21.7, 19.16, 18.15, 12.2.0.1.220419
Last Patch Set Updates (12.1-): 12.1.0.2.220719, 11.2.0.4.201020, 10.2.0.5.19; 9.2.0.8, 8.1.7.4, 7.3.4.5 |
| Versions |
| Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release |
| Component | Description | Version |
| APS | OLAP Analytic Workspace | 23.0.0.0.0 |
| CATALOG | Oracle Database Catalog Views | 23.0.0.0.0 |
| CATJAVA | Oracle Database Java Packages | 23.0.0.0.0 |
| CATPROC | Oracle Database Packages and Types | 23.0.0.0.0 |
| CONTEXT | Oracle Text | 23.0.0.0.0 |
| DV | Oracle Database Vault | 23.0.0.0.0 |
| JAVAVM | JServer JAVA Virtual Machine | 23.0.0.0.0 |
| OLS | Oracle Label Security | 23.0.0.0.0 |
| OWM | Oracle Workspace Manager | 23.0.0.0.0 |
| RAC | Oracle Real Application Clusters | 23.0.0.0.0 |
| SDO | Spatial | 23.0.0.0.0 |
| XDB | Oracle XML Database | 23.0.0.0.0 |
| XML | Oracle XDK | 23.0.0.0.0 |
| XOQ | Oracle OLAP API | 23.0.0.0.0 |
| Tablespaces | |||||
| Tablespace | Total | Occuped | PCT | Max_free | Max_extent |
| SYSAUX | 576,716,800 | 559,611,904 | 97% | 15,728,640 | 27 |
| SYSTEM | 1,216,348,160 | 1,204,813,824 | 99% | 5,308,416 | 120 |
| UNDOTBS1 | 26,214,400 | 21,364,736 | 81% | 3,801,088 | 30 |
| USERS | 5,242,880 | 0 | 0% | 4,194,304 | 0 |
| TOTAL | 1,740 MB | 1,703 MB | - | - | - |
| Segments | |
| Segment Type | Used Space |
| TABLE | 795,541,504 |
| LOBSEGMENT | 461,570,048 |
| INDEX | 259,063,808 |
| CLUSTER | 73,728,000 |
| TABLE PARTITION | 59,244,544 |
| LOBINDEX | 42,074,112 |
| INDEX PARTITION | 37,421,056 |
| LOB PARTITION | 32,833,536 |
| TYPE2 UNDO | 21,364,736 |
| TABLE SUBPARTITION | 2,097,152 |
| ROLLBACK | 458,752 |
| NESTED TABLE | 393,216 |
| TOTAL | 1,703 MB |
| Schema/Object Matrix | ||||||||||||||||||
| Owner | Tabs | Prts | Idxs | Trgs | Pkgs | Body | Proc | Func | Seqs | Syns | Views | MVws | Jobs | Type | Oper | LOB | XML | Total |
| APPQOSSYS | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 |
| AUDSYS | 1 | 4 | 4 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 4 | 0 | 56 |
| CTXSYS | 56 | 0 | 68 | 0 | 80 | 69 | 2 | 2 | 3 | 0 | 91 | 0 | 0 | 22 | 6 | 4 | 0 | 416 |
| DBSFWUSER | 3 | 0 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 |
| DBSNMP | 15 | 0 | 4 | 0 | 1 | 1 | 5 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 29 |
| DVF | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22 |
| DVSYS | 44 | 0 | 78 | 0 | 11 | 11 | 3 | 32 | 22 | 2 | 126 | 0 | 0 | 82 | 0 | 1 | 0 | 417 |
| GGSHAREDCAP | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 |
| GSMADMIN_INTERNAL | 58 | 0 | 64 | 5 | 12 | 12 | 4 | 3 | 18 | 5 | 15 | 0 | 0 | 62 | 0 | 12 | 0 | 285 |
| LBACSYS | 22 | 0 | 30 | 3 | 25 | 24 | 8 | 25 | 3 | 2 | 77 | 0 | 0 | 5 | 0 | 0 | 0 | 239 |
| MDSYS | 152 | 1 | 215 | 84 | 145 | 137 | 6 | 150 | 18 | 0 | 101 | 0 | 0 | 297 | 31 | 87 | 0 | 4649 |
| OJVMSYS | 6 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 33 |
| OLAPSYS | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 18 | 0 | 0 | 2 | 0 | 0 | 0 | 25 |
| OUTLN | 3 | 0 | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 10 |
| PUBLIC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12782 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12785 |
| REMOTE_SCHEDULER_AGENT | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13 |
| SYS | 1958 | 655 | 2254 | 6 | 781 | 760 | 194 | 145 | 201 | 27 | 7753 | 0 | 21 | 2021 | 7 | 351 | 0 | 57033 |
| SYSTEM | 31 | 0 | 30 | 0 | 0 | 0 | 0 | 0 | 2 | 13 | 10 | 0 | 0 | 0 | 0 | 3 | 0 | 89 |
| WMSYS | 40 | 0 | 68 | 45 | 26 | 26 | 1 | 0 | 6 | 0 | 170 | 0 | 0 | 17 | 9 | 9 | 0 | 423 |
| XDB | 56 | 0 | 363 | 7 | 52 | 50 | 4 | 6 | 5 | 0 | 8 | 0 | 0 | 127 | 7 | 290 | 19 | 1021 |
| TOTAL | 2453 | 660 | 3196 | 150 | 1137 | 1094 | 240 | 384 | 283 | 12832 | 8376 | 0 | 21 | 2635 | 60 | 763 | 19 | 77561 |
| Schema/Segments Size | |||
| Owner | Tables | Indexes | Total Size |
| AUDSYS | 0 | 0 | 41,943,040 |
| CTXSYS | 1,179,648 | 1,966,080 | 3,145,728 |
| DVSYS | 1,572,864 | 3,211,264 | 4,784,128 |
| GSMADMIN_INTERNAL | 393,216 | 458,752 | 1,179,648 |
| LBACSYS | 262,144 | 65,536 | 327,680 |
| MDSYS | 32,702,464 | 4,456,448 | 131,137,536 |
| OJVMSYS | 196,608 | 196,608 | 393,216 |
| OUTLN | 196,608 | 262,144 | 589,824 |
| SYS | 750,845,952 | 238,419,968 | 1,487,273,984 |
| SYSTEM | 1,835,008 | 1,572,864 | 3,670,016 |
| WMSYS | 1,966,080 | 3,670,016 | 7,667,712 |
| XDB | 4,390,912 | 4,784,128 | 103,677,952 |
| TOTAL | 795,541,504 | 259,063,808 | 1,785,790,464 |
| Invalid Objects | |||||||||||
| Owner | Table | Index | Trigger | Package | P. Body | Proc. | Func. | Sequence | Synonym | View | Total |
| Invalid Indexes | ||
| Owner | Indexes | Status |
| Owner | Index Partitions | Status |
| Invalid Datafiles | |
| Datafile | Status |
| Invalid Blocks | ||
| File# | Block# | Corruption Type |
| Space Usage | ||||||||
| Tablespace | Total (MB) | Tables | Table Part.s | Table SubP.s | Indexes | Index Part.s | LOBs | Clusters |
| SYSAUX | 534 | 21 | 13 | 0 | 3 | 0 | 160 | 0 |
| SYSTEM | 1,149 | 590 | 0 | 0 | 77 | 0 | 179 | 66 |
| UNDOTBS1 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| TOTAL (MB) | 1,703 | 611 | 13 | 0 | 80 | 0 | 339 | 66 |
| Container | Bytes |
| Recycle Bin |
| Partitioning | |
| Owner | #Partitioned Tables |
| AUDSYS | 1 |
| MDSYS | 1 |
| Partitioning Details | ||||
| Owner | Table | Partitions | Rows | Est. Size |
| AUDSYS | AUD$UNIFIED | 4 | 422 | 0 |
| MDSYS | SDO_TXN_JOURNAL_REG | 1 | 0 | 0 |
| Partitions Details | |||||
| Owner | Table | Tablespace | Partition | Rows | Sub.Partitions |
| AUDSYS | AUD$UNIFIED | SYSAUX | AUD_UNIFIED_P0 | 0 | 0 |
| AUDSYS | AUD$UNIFIED | SYSAUX | SYS_P241 | 422 | 0 |
| AUDSYS | AUD$UNIFIED | SYSAUX | SYS_P281 | 0 | |
| AUDSYS | AUD$UNIFIED | SYSAUX | SYS_P342 | 0 | |
| MDSYS | SDO_TXN_JOURNAL_REG | SYSAUX | P1 | 0 | 0 |
| ... |
| Parallel degree | ||
| Degree | Instances | #Tables |
| DEFAULT | DEFAULT | 2 |
| 1 | 1 | 392 |
| 1 | 0 | 3 |
| Compression | ||
| Owner | Compression | #Tables |
| TOTAL | Compressed Tables | 0 |
| Owner | Compression | #Indexes |
| CTXSYS | ENABLED | 1 |
| TOTAL | Compressed Indexes | 1 |
| Owner | Compression | #Partitions |
| TOTAL | Compressed Tablespaces | 0 |
| Oracle Spatial | |
| Owner | Spatial Tables |
| TOTAL | 0 |
|
|
|
|
| Datafiles | ||||
| Tablespace | Datafile | Bytes | Read # | Write # |
| SYSAUX | /opt/oracle/oradata/FREE/sysaux01.dbf | 576,716,800 | 26,258 | 890 |
| SYSTEM | /opt/oracle/oradata/FREE/system01.dbf | 1,216,348,160 | 22,402 | 394 |
| UNDOTBS1 | /opt/oracle/oradata/FREE/undotbs01.dbf | 26,214,400 | 33 | 91 |
| USERS | /opt/oracle/oradata/FREE/users01.dbf | 5,242,880 | 3 | 0 |
Autoextend datafiles: /opt/oracle/oradata/FREE/system01.dbf /opt/oracle/oradata/FREE/sysaux01.dbf /opt/oracle/oradata/FREE/undotbs01.dbf /opt/oracle/oradata/FREE/users01.dbf
Not autoextensible datafiles:
| Rollbacks | ||||
| Rollback Segment | Tablespace | Bytes | Extents | Status |
| SYSTEM | SYSTEM | 458,752 | 7 | ONLINE |
| Undo Parameters | |
| Parameter | Value |
| undo_management | AUTO |
| undo_retention | 900 |
| undo_tablespace | UNDOTBS1 |
| Undo Datafiles | |||
| Tablespace | Datafile | Bytes | Autoextensible |
| UNDOTBS1 | /opt/oracle/oradata/FREE/undotbs01.dbf | 26,214,400 | YES |
| Undo Extents | |||
| Tablespace | Status | # | Bytes |
| UNDOTBS1 | EXPIRED | 68 | 17,235,968 |
| UNDOTBS1 | UNEXPIRED | 48 | 4,128,768 |
| Tuned retention | |||
| AVG | MAX | MIN | Std DEV |
| 1039 | 1039 | 1039 | 0 |
| Log Files | ||||
| Group# | Log File | Status | Bytes | Thread |
| 1 | /opt/oracle/oradata/FREE/redo01.log | INACTIVE | 209,715,200 | 1 |
| 2 | /opt/oracle/oradata/FREE/redo02.log | CURRENT | 209,715,200 | 1 |
| 3 | /opt/oracle/oradata/FREE/redo03.log | UNUSED | 209,715,200 | 1 |
|
|
| Archived Logs | ||||
| Creator | Registrar | Status | Archived | Count |
| Control File Informations |
FILES ---------------------------------------------------------------------------------------------------------------------------------- /opt/oracle/oradata/FREE/control01.ctl TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID CON_ID -------------------------------- ----------- ------------- ------------ ----------- ---------- ---------- -------- DATABASE 316 1 1 0 0 0 0 CKPT PROGRESS 8180 11 0 0 0 0 0 REDO THREAD 256 8 1 0 0 0 0 REDO LOG 72 16 3 0 0 3 0 DATAFILE 520 1024 15 0 0 56 0 FILENAME 524 4146 17 0 0 0 0 TABLESPACE 180 1024 14 0 0 15 0 TEMPORARY FILENAME 56 1024 4 0 0 10 0 RMAN CONFIGURATION 1108 50 0 0 0 0 0 LOG HISTORY 56 292 1 1 1 1 0 OFFLINE RANGE 200 1063 18 1 18 18 0 ARCHIVED LOG 584 28 0 0 0 0 0 BACKUP SET 96 1022 0 0 0 0 0 BACKUP PIECE 780 1006 0 0 0 0 0 BACKUP DATAFILE 200 1063 0 0 0 0 0 BACKUP REDOLOG 104 157 0 0 0 0 0 DATAFILE COPY 736 1000 0 0 0 0 0 BACKUP CORRUPTION 44 1115 0 0 0 0 0 COPY CORRUPTION 40 1227 0 0 0 0 0 DELETED OBJECT 20 818 0 0 0 0 0 PROXY COPY 928 1004 0 0 0 0 0 BACKUP SPFILE 124 131 0 0 0 0 0 DATABASE INCARNATION 56 292 2 1 2 2 0 FLASHBACK LOG 84 2048 0 0 0 0 0 RECOVERY DESTINATION 180 1 0 0 0 0 0 INSTANCE SPACE RESERVATION 28 1055 1 0 0 0 0 REMOVABLE RECOVERY FILES 32 1000 0 0 0 0 0 RMAN STATUS 116 141 0 0 0 0 0 THREAD INSTANCE NAME MAPPING 80 8 8 0 0 0 0 MTTR 100 8 1 0 0 0 0 DATAFILE HISTORY 568 57 0 0 0 0 0 STANDBY DATABASE MATRIX 400 128 128 0 0 0 0 GUARANTEED RESTORE POINT 256 2048 0 0 0 0 0 RESTORE POINT 256 2108 0 0 0 0 0 DATABASE BLOCK CORRUPTION 80 8384 0 0 0 0 0 ACM OPERATION 104 64 14 0 0 0 0 FOREIGN ARCHIVED LOG 604 1002 0 0 0 0 0 PDB RECORD 780 10 3 0 0 5 0 AUXILIARY DATAFILE COPY 584 128 0 0 0 0 0 MULTI INSTANCE REDO APPLY 556 1 0 0 0 0 0 PDBINC RECORD 144 113 0 0 0 0 0 TABLESPACE KEY HISTORY 108 151 0 0 0 0 0 SNR LOG 356 10 0 0 0 0 0
| Recovery Area Usage |
RECOVERY_DEST_SIZE -------------------------------------------------- db_recovery_file_dest_size: 0 (0GB) FREE_RECOVERY_PCT -------------------- %
| Users | |||||
| Username | Default Tablespace | Temporary Tablespace | Status | Profile | Expiry date |
| ANONYMOUS | SYSAUX | TEMP | LOCKED | DEFAULT | |
| APPQOSSYS | SYSAUX | TEMP | LOCKED | DEFAULT | |
| AUDSYS | SYSAUX | TEMP | LOCKED | DEFAULT | |
| CTXSYS | SYSAUX | TEMP | LOCKED | DEFAULT | |
| DBSFWUSER | SYSAUX | TEMP | LOCKED | DEFAULT | |
| DBSNMP | SYSAUX | TEMP | LOCKED | DEFAULT | |
| DGPDB_INT | USERS | TEMP | LOCKED | DEFAULT | |
| DIP | USERS | TEMP | LOCKED | DEFAULT | |
| DVF | SYSAUX | TEMP | LOCKED | DEFAULT | |
| DVSYS | SYSAUX | TEMP | LOCKED | DEFAULT | |
| GGSHAREDCAP | SYSAUX | TEMP | LOCKED | DEFAULT | |
| GGSYS | SYSAUX | TEMP | LOCKED | DEFAULT | |
| GSMADMIN_INTERNAL | SYSAUX | TEMP | LOCKED | DEFAULT | |
| GSMCATUSER | USERS | TEMP | LOCKED | DEFAULT | |
| GSMROOTUSER | USERS | TEMP | LOCKED | DEFAULT | |
| GSMUSER | USERS | TEMP | LOCKED | DEFAULT | |
| LBACSYS | SYSTEM | TEMP | LOCKED | DEFAULT | |
| MDDATA | USERS | TEMP | LOCKED | DEFAULT | |
| MDSYS | SYSAUX | TEMP | LOCKED | DEFAULT | |
| OJVMSYS | SYSTEM | TEMP | LOCKED | DEFAULT | |
| OLAPSYS | SYSAUX | TEMP | LOCKED | DEFAULT | |
| OPS$ORACLE | USERS | TEMP | OPEN | DEFAULT | |
| OUTLN | SYSTEM | TEMP | LOCKED | DEFAULT | |
| REMOTE_SCHEDULER_AGENT | USERS | TEMP | LOCKED | DEFAULT | |
| SYS | SYSTEM | TEMP | OPEN | DEFAULT | 24-SEP-23 |
| SYS$UMF | USERS | TEMP | LOCKED | DEFAULT | |
| SYSBACKUP | USERS | TEMP | LOCKED | DEFAULT | |
| SYSDG | USERS | TEMP | LOCKED | DEFAULT | |
| SYSKM | USERS | TEMP | LOCKED | DEFAULT | |
| SYSRAC | USERS | TEMP | OPEN | DEFAULT | |
| SYSTEM | SYSTEM | TEMP | OPEN | DEFAULT | 24-SEP-23 |
| WMSYS | SYSAUX | TEMP | LOCKED | DEFAULT | |
| XDB | SYSAUX | TEMP | LOCKED | DEFAULT | |
| XS$NULL | SYSTEM | TEMP | LOCKED | DEFAULT | |
| TOTAL | 34 | OPEN: 4 |
| DEFAULT Profile | |
| Resource | Limit |
| COMPOSITE_LIMIT | UNLIMITED |
| CONNECT_TIME | UNLIMITED |
| CPU_PER_CALL | UNLIMITED |
| CPU_PER_SESSION | UNLIMITED |
| FAILED_LOGIN_ATTEMPTS | 10 |
| IDLE_TIME | UNLIMITED |
| INACTIVE_ACCOUNT_TIME | 365 |
| LOGICAL_READS_PER_CALL | UNLIMITED |
| LOGICAL_READS_PER_SESSION | UNLIMITED |
| PASSWORD_GRACE_TIME | 7 |
| PASSWORD_LIFE_TIME | 180 |
| PASSWORD_LOCK_TIME | 1 |
| PASSWORD_REUSE_MAX | UNLIMITED |
| PASSWORD_REUSE_TIME | UNLIMITED |
| PASSWORD_ROLLOVER_TIME | 0 |
| PASSWORD_VERIFY_FUNCTION | NULL |
| PRIVATE_SGA | UNLIMITED |
| SESSIONS_PER_USER | UNLIMITED |
| Password file users |
USERNAME INST_ID SYSDB SYSOP ---------------------------------------- -------- ----- ----- SYS 1 TRUE TRUE
| Users with default passwords | |
| Username | Status |
See also 11g Users.
| Licensing | |
| Detected Edition: | Standard |
| Parameter | Value |
| USER max | 0 |
| SESSION max | 0 |
| SESSION curr./HiW. | 6 / 22 |
| CPU curr./HiW. | 2 / 2 |
| CORE curr./HiW. | 2 / 2 |
| SOCKET curr./HiW. | 1 / 1 |
| Diagnostic and tuning pack enabled | NONE |
| In-Memory enabled (12c) | ENABLE |
| Max PDBS (12cR2) | 254 |
| Options | |
| Installed | Not installed |
| Partitioning, Objects, Advanced replication, Bit-mapped indexes, Connection multiplexing, Connection pooling, Database queuing, Incremental backup and recovery, Instead-of triggers, Parallel load, Point-in-time tablespace recovery, Fine-grained access control, Proxy authentication/authorization, Plan Stability, Online Index Build, Coalesce Index, Materialized view rewrite, Spatial, Export transportable tablespaces, Transparent Application Failover, Fast-Start Fault Recovery, Sample Scan, Duplexed backups, Java, OLAP Window Functions, Block Media Recovery, Fine-grained Auditing, Application Role, OLAP, Basic Compression, Join index, Trial Recovery, Advanced Analytics, Online Redefinition, File Mapping, Block Change Tracking, Flashback Table, Flashback Database, Transparent Data Encryption, Backup Encryption, Unused Block Compression, Result Cache, SQL Plan Management, SecureFiles Encryption, Flashback Data Archive, DICOM, Advanced Compression, XStream, Deferred Segment Creation, Unified Auditing, Adaptive Execution Plans, Table Clustering, Zone Maps, Real Application Security, Privilege Analysis, Data Redaction, Cross Transportable Backups, Snapshot time recovery, Heat Map, Automatic Data Optimization, Transparent Sensitive Data Protection, In-Memory Column Store, Advanced Index Compression, In-Memory Aggregation, Centrally Managed User, | Real Application Clusters, Parallel backup and recovery, Parallel execution, Change Data Capture, Managed Standby, Database resource manager, Automatic Storage Management, Enterprise User Security, Oracle Data Guard, Oracle Label Security, Streams Capture, Oracle Database Vault, Real Application Testing, Active Data Guard, Server Flash Cache, Management Database, I/O Server, ASM Proxy Instance, Exadata Discovery, Global Data Services, Cache Fusion Lock Accelerator, Data Guard for Pluggable Databases, SQL Firewall, |
| Features Used | ||||
| Name | Count | First | Last | Description |
| Adaptive Plans | 1 | 01-APR-23 | 01-APR-23 | Adaptive Plans have been used - Total number of queries: 694 Number of queries with an adaptive plan: 47 Percentage of queries with an adaptive plan: 6.77233429 |
| Automatic Maintenance - Optimizer Statistics Gathering | 1 | 01-APR-23 | 01-APR-23 | Automatic initiation of Optimizer Statistics Collection - |
| Automatic Maintenance - SQL Tuning Advisor | 1 | 01-APR-23 | 01-APR-23 | Automatic initiation of SQL Tuning Advisor - |
| Automatic Maintenance - Space Advisor | 1 | 01-APR-23 | 01-APR-23 | Automatic initiation of Space Advisor - |
| Automatic Reoptimization | 1 | 01-APR-23 | 01-APR-23 | Automatic Reoptimization have been used - Total number of queries: 696 Number of reoptimizable queries: 19 Percentage of reoptimizable queries: 2.729885057471264367816091 |
| Automatic SGA Tuning | 1 | 01-APR-23 | 01-APR-23 | Automatic SGA Tuning is enabled. - :sga_target:1610612736:sga_max_size:1610612736:comp:shared pool:cur:402653184:min:369098752 :max:402653184:usr:0:comp:large pool: |
| Automatic SQL Execution Memory | 1 | 01-APR-23 | 01-APR-23 | Sizing of work areas for all dedicated sessions (PGA) is automatic. - |
| Automatic Segment Space Management (system) | 1 | 01-APR-23 | 01-APR-23 | Extents of locally managed tablespaces are managed automatically by Oracle. - (Segment Space Management: MANUAL, TS Count: 2, Size MB: 1185) (Segment Space Management: AUTO, TS Count: 2, Size MB: 555) |
| Automatic Undo Management | 1 | 01-APR-23 | 01-APR-23 | Oracle automatically manages undo data using an UNDO tablespace. - (Retention: NOGUARANTEE, TS Count: 1, Size MB: 25) (Undo Bl ocks: 268, Max Concurrency: 5) (Snapshot Old Info - Begin Time: 2023- |
| Character Set | 1 | 01-APR-23 | 01-APR-23 | Character set is used in Oracle Database - AL32UTF8 |
| Deferred Segment Creation | 1 | 01-APR-23 | 01-APR-23 | Deferred Segment Creation is being used - Deferred Segment Creation Parameter:1 Total Deferred Segments:634 Total Created Seg ments:6214 Table Segments:232 Index Segments |
| Information Lifecycle Management | 1 | 01-APR-23 | 01-APR-23 | Information Lifecycle Management is used - Number of ILM Policies: 1, Number of Objects Affected: 0 |
| Locally Managed Tablespaces (system) | 1 | 01-APR-23 | 01-APR-23 | There exists tablespaces that are locally managed in the database. - (Extent Management: LOCAL, TS Count: 4, Size MB: 1740) |
| Locally Managed Tablespaces (user) | 1 | 01-APR-23 | 01-APR-23 | There exists user tablespaces that are locally managed in the database. - |
| Oracle Java Virtual Machine (system) | 1 | 01-APR-23 | 01-APR-23 | OJVM default system users - System users: MDSYS with 3066 classes, 51 resources, 0 sources. SYS with 35788 classes, 1665 resou rces, 0 sources. |
| Oracle Multitenant | 1 | 01-APR-23 | 01-APR-23 | Oracle Multitenant is being used. - |
| Oracle Utility External Table (ORACLE_LOADER) | 1 | 01-APR-23 | 01-APR-23 | Oracle Utility External Table (ORACLE_LOADER) has been used. - Oracle Utility External Table (ORACLE_LOADER) invoked 35 times |
| Partitioning (system) | 1 | 01-APR-23 | 01-APR-23 | Oracle Partitioning option is being used - there is at least one partitioned object created. - 1:T:AL::1:0:2-VC(1):::::1::0:ON -0::N:N::0::0::::N|1:I:AL::1:0:2::L:N-F:U:1::0:F-0::N:N::0::0::::N|1:I:AL::1:0:2::L:N:NU:1::0:F-0 |
| Resource Manager | 1 | 01-APR-23 | 01-APR-23 | Oracle Database Resource Manager is being used to manage database resources. - CPU Management: 1, Other Management: 0 |
| SQL Plan Directive | 1 | 01-APR-23 | 01-APR-23 | Sql plan directive has been used - Number of directives with type, DYNAMIC_SAMPLING: 2 Number of Directives with reason, SINGLE TABLE CARDINALITY MISESTIMATE: 2 Nu |
| SQL Tuning Set (system) | 1 | 01-APR-23 | 01-APR-23 | A SQL Tuning Set has been created in the database in the SYS schema. - |
| SQL*Plus | 1 | 01-APR-23 | 01-APR-23 | SQL*Plus used - Client Lib Versions=(23.2.0.0.0),Charsets=(US7ASCII) |
| SecureFiles (system) | 1 | 01-APR-23 | 01-APR-23 | SecureFiles is being used by system users - |
| SecureFiles (user) | 1 | 01-APR-23 | 01-APR-23 | SecureFiles is being used - |
| Server Parameter File | 1 | 01-APR-23 | 01-APR-23 | The server parameter file (SPFILE) was used to startup the database. - |
| Services | 1 | 01-APR-23 | 01-APR-23 | Oracle Services. - num_clb_long: 2 num_clb_short: 0 num_goal_service_time: 0 num_goal_throughput: 0 num_goal_none: 2 num_aq_n otifications: 0 num_a |
| Unified Audit | 1 | 01-APR-23 | 01-APR-23 | Unified Audit in use. - Pure Unified Auditing=TRUE; Number of Unified Audit policies=14; Number of Enabled Unified Audit polic ies=3; Number of Unified A |
| Features NOT in Use | ||
| Name | Count | Description |
| ACFS | 0 | ACFS in use |
| ACFS Encryption | 0 | ACFS encryption in use |
| ACFS Snapshot | 0 | ACFS Snapshot in use |
| ADDM | 0 | ADDM has been used. |
| ASM Filter Driver | 0 | ASM Filter Driver in use |
| ASO native encryption and checksumming | 0 | ASO network native encryption and checksumming is being used. |
| AWR Baseline | 0 | At least one AWR Baseline has been created by the user |
| AWR Baseline Template | 0 | At least one AWR Baseline Template has been created by the user |
| AWR Report | 0 | At least one Workload Repository Report has been created by the user |
| Active Data Guard - Real-Time Query on Physical Standby | 0 | Active Data Guard, a set of services, is being used to enhance Data Guard |
| Advanced Index Compression | 0 | Advanced Index Compression is used |
| Advanced Replication | 0 | Advanced Replication has been enabled. |
| Analytic Views | 0 | Analytic Views are being used. |
| Application Continuity | 0 | Application Continuity has been enabled |
| Application Express | 0 | Application Express feature is being used. |
| Approx QP | 0 | Approx Query Processing has been used |
| Auto IM Advisor | 0 | Auto IM Advisor has been used. |
| Automatic Memory Tuning | 0 | Automatic Memory Tuning is enabled. |
| Automatic SQL Tuning Advisor | 0 | Automatic SQL Tuning Advisor has been used. |
| Automatic Segment Space Management (user) | 0 | Extents of locally managed user tablespaces are managed automatically by Oracle. |
| Automatic Storage Management | 0 | Automatic Storage Management has been enabled |
| Automatic Workload Repository | 0 | A manual Automatic Workload Repository (AWR) snapshot was taken in the last sample period. |
| BA Owner | 0 | BA OWNER |
| Backup BASIC Compression | 0 | BASIC compressed backups are being used. |
| Backup BZIP2 Compression | 0 | BZIP2 compressed backups are being used. |
| Backup Encryption | 0 | Encrypted backups are being used. |
| Backup HIGH Compression | 0 | HIGH compressed backups are being used. |
| Backup LOW Compression | 0 | LOW compressed backups are being used. |
| Backup MEDIUM Compression | 0 | MEDIUM compressed backups are being used. |
| Backup Rollforward | 0 | Backup Rollforward strategy is being used to backup the database. |
| Backup ZLIB Compression | 0 | ZLIB compressed backups are being used. |
| Backup and Restore of plugged database | 0 | Backup and Restore of plugged database by RMAN is used. |
| Baseline Adaptive Thresholds | 0 | Adaptive Thresholds have been configured. |
| Baseline Static Computations | 0 | Static baseline statistics have been computed. |
| Bigfile Tablespace | 0 | Bigfile tablespace is being used |
| Block Media Recovery | 0 | Block Media Recovery is being used to repair the database. |
| CONVERT command | 0 | RMANs CONVERT command used by the database. |
| CSSCAN | 0 | Oracle Database has been scanned at least once for character set:CSSCAN has been run at least once. |
| Change-Aware Incremental Backup | 0 | Track blocks that have changed in the database. |
| Character Semantics | 0 | Character length semantics is used in Oracle Database |
| Client Identifier | 0 | Application User Proxy Authentication: Client Identifier is used at this specific time. |
| Client Result Cache | 0 | Client Result Cache has been enabled |
| Cloud DB with EHCC | 0 | EHCC used for Cloud Database |
| CloudSQL | 0 | Cloudsql offload is used |
| Clustering Advisor | 0 | Clustering Advisor has been used. |
| Clusterwide Global Transactions | 0 | Clusterwide Global Transactions is being used. |
| Compression Advisor | 0 | Compression Advisor has been used. |
| Concurrent Statistics Gathering | 0 | Concurrent Statistics Gathering has been used |
| Container Usage | 0 | CONTAINER FILES used by backup appliance. |
| Cross-Platform Backups | 0 | Cross-Platform Backup and Restore used by the database. |
| Crossedition Triggers | 0 | Crossedition triggers is being used. |
| DBFS Content | 0 | Oracle Database FileSystem Content feature is being used |
| DBFS HS | 0 | Oracle Database FileSystem Hierarchical Store feature is being used |
| DBFS SFS | 0 | Oracle Database FileSystem SecureFile Store feature is being used |
| DBMS_STATS Incremental Maintenance | 0 | DBMS_STATS Incremental Maintenance has been used. |
| DCAT Integration in ADB | 0 | Data Catalog Integration is being used in ADB. |
| Data Guard | 0 | Data Guard, a set of services, is being used to create, maintain, manage, and monitor one or more standby databases. |
| Data Mining | 0 | There exist Oracle Data Mining models in the database. |
| Data Recovery Advisor | 0 | Data Recovery Advisor (DRA) is being used to repair the database. |
| Data Redaction | 0 | Data redaction is being used. There is at least one policy that is defined. |
| Database Migration Assistant for Unicode | 0 | Database Migration Assistant for Unicode has been used. |
| Database Replay: Workload Capture | 0 | Database Replay: Workload was ever captured. |
| Database Replay: Workload Replay | 0 | Database Replay: Workload was ever replayed. |
| Database Resident Connection Pooling (DRCP) | 0 | Active Database Resident Connection Pool has been detected |
| Deferred Open Read Only | 0 | Deferred open read only feature is enabled |
| Direct NFS | 0 | Direct NFS is being used to connect to an NFS server |
| Duplicate Db from Active Db using BackupSet | 0 | Duplicate from Active Database using BackupSet is used. |
| Dynamic SGA | 0 | The Oracle SGA has been dynamically resized through an ALTER SYSTEM SET statement. |
| EM Cloud Control | 0 | EM Cloud Control Database Home Page has been visited at least once. |
| EM Performance Page | 0 | EM Performance Page has been visited at least once. |
| Editioning Views | 0 | Editioning views is being used. |
| Editions | 0 | Editions is being used. |
| Encrypted Tablespaces | 0 | Encrypted Tablespaces is enabled. |
| Exadata | 0 | Exadata is being used |
| Extensibility | 0 | Extensibility feature is being used. |
| External Table Usage in ADB | 0 | External Tables are being used in ADB. |
| File Mapping | 0 | File Mapping, the mechanism that shows a complete mapping of a file to logical volumes and physical devices, is being used. |
| Fine Grained Audit | 0 | Fine Grained Audit in use. |
| Flashback Data Archive | 0 | Flashback Data Archive, a historical repository of changes to data contained in a table, is used |
| Flashback Database | 0 | Flashback Database, a rewind button for the database, is enabled |
| Flex ASM | 0 | Flex ASM in use |
| GDS Catalog | 0 | Database is a GDS catalog database. |
| Gateways | 0 | Gateways feature is being used. |
| Global Data Services | 0 | Database contains global services. |
| GoldenGate | 0 | Oracle GoldenGate Capabilities are in use. |
| HeapCompression | 0 | Heap Compression is being used |
| Heat Map | 0 | Heat Map is used |
| Hybrid Columnar Compression | 0 | Hybrid Columnar Compression is used |
| Hybrid Columnar Compression Conventional Load | 0 | Hybrid Columnar Compression with Conventional Load is used |
| Hybrid Columnar Compression Row Level Locking | 0 | Hybrid Columnar Compression Row Level Locking is used |
| INSTANT RESTORE command | 0 | RMANs INSTANT RESTORE command used by the database. |
| In-Memory ADO Policies | 0 | In-Memory ADO Policies are being used |
| In-Memory Aggregation | 0 | In-Memory Aggregation is being used. |
| In-Memory Base Level | 0 | In-Memory Base Level is being used |
| In-Memory Column Store | 0 | In-Memory Column Store is being used |
| In-Memory Distribute For Service (User Defined) | 0 | In-Memory Distribute For Service (User Defined) is being used |
| In-Memory Expressions | 0 | In-Memory Expressions or In-Memory Virtual Columns are being used |
| In-Memory FastStart | 0 | In-Memory FastStart is being used |
| In-Memory Join Groups | 0 | In-Memory Join Groups are being used |
| Index Organized Tables | 0 | Index Organized Tables are being used |
| Instance Caging | 0 | Instance Caging is being used to limit the CPU usage by the database instance. |
| Internode Parallel Execution | 0 | Internode Parallel Execution is being used. |
| JDBC OCI | 0 | JDBC OCI used |
| JDBC Thin | 0 | JDBC Thin used |
| JSON | 0 | JSON feature is being used. |
| JSON Duality Views (User) | 0 | User JSON Duality Views exist in the database |
| Job Scheduler | 0 | Job Scheduler feature is being used. |
| LOB | 0 | Persistent LOBs are being used. |
| Label Security | 0 | Oracle Label Security is being used |
| Locator | 0 | There is at least one usage of the Oracle Locator feature usage table. |
| Logfile Multiplexing | 0 | Multiple members are used in a single log file group |
| Long-term Archival Backup | 0 | Long-term archival backups are being used. |
| MTTR Advisor | 0 | Mean Time to Recover Advisor is enabled. |
| Materialized Views (User) | 0 | User Materialized Views exist in the database |
| Messaging Gateway | 0 | Messaging Gateway, that enables communication between non-Oracle messaging systems and Advanced Queuing (AQ), link configured. |
| Multi Section Backup | 0 | Multi section backups are being used. |
| Multilingual Engine (MLE) | 0 | Multilingual Engine (MLE) is being used. |
| Multiple Block Sizes | 0 | Multiple Block Sizes are being used with this database. |
| OCCI | 0 | OCCI used |
| ODA Infrastructure | 0 | Oracle Database Appliance infrastructure in use |
| ODBC | 0 | ODBC used |
| ODP.Net, Managed Driver | 0 | ODP.Net, Managed Driver used |
| ODP.Net, Unmanaged Driver | 0 | ODP.Net, Unmanaged Driver used |
| OLAP - Analytic Workspaces | 0 | OLAP - the analytic workspaces stored in the database. |
| OLAP - Cubes | 0 | OLAP - number of cubes in the OLAP catalog that are fully mapped and accessible by the OLAP API. |
| Object | 0 | Object feature is being used. |
| Online Move Datafile | 0 | Online Move Datafile is being used to move datafiles |
| Online Redefinition | 0 | Online Redefinition is being used |
| Oracle Advanced Network Compression Service | 0 | Oracle Advanced Network Compression Service Used |
| Oracle Call Interface (OCI) | 0 | Oracle Call Interface (OCI) used |
| Oracle Database Vault | 0 | Oracle Database Vault is being used |
| Oracle In-Database Hadoop | 0 | In-Database Hadoop for running MapReduce in java |
| Oracle Java Virtual Machine (user) | 0 | OJVM has been used by at least one non-system user |
| Oracle Managed Files | 0 | Database files are being managed by Oracle. |
| Oracle Secure Backup | 0 | Oracle Secure Backup is used for backups to tertiary storage. |
| Oracle Text | 0 | Oracle Text is being used - there is at least one oracle text index |
| Oracle Utility Datapump (Export) | 0 | Oracle Utility Datapump (Export) has been used. |
| Oracle Utility Datapump (Import) | 0 | Oracle Utility Datapump (Import) has been used. |
| Oracle Utility External Table (ORACLE_BIGSQL) | 0 | Oracle Utility External Table (ORACLE_BIGSQL) has been used. |
| Oracle Utility External Table (ORACLE_DATAPUMP) | 0 | Oracle Utility External Table (ORACLE_DATAPUMP) has been used. |
| Oracle Utility Metadata API | 0 | Oracle Utility (Metadata API) has been used. |
| Oracle Utility SQL Loader (Direct Path Load) | 0 | Oracle Utility SQL Loader (Direct Path Load) has been used. |
| PDB I/O Rate Limits | 0 | PDB I/O Rate Limits are being used to limit the I/O usage by Pluggable databases. |
| PERL DBD::Oracle | 0 | PERL DBD::Oracle used |
| PHP OCI8 | 0 | PHP OCI8 used |
| PL/SQL Native Compilation | 0 | PL/SQL Native Compilation is being used - there is at least one natively compiled PL/SQL library unit in the database. |
| Parallel SQL DDL Execution | 0 | Parallel SQL DDL Execution is being used. |
| Parallel SQL DML Execution | 0 | Parallel SQL DML Execution is being used. |
| Parallel SQL Query Execution | 0 | Parallel SQL Query Execution is being used. |
| Partitioning (user) | 0 | Oracle Partitioning option is being used - there is at least one user partitioned object created. |
| Pillar Storage | 0 | Tablespaces stored on Oracles Pillar Axiom Storage |
| Pillar Storage with EHCC | 0 | EHCC used on tablespaces stored on Oracles Pillar Axiom Storage |
| Privilege Capture | 0 | Privilege Capture is being used |
| Pro*C | 0 | Pro*C used |
| Pro*Cobol | 0 | Pro*Cobol used |
| Pro*Fortran | 0 | Pro*Fortran used |
| Quality of Service Management | 0 | Quality of Service Management has been used. |
| RMAN - Disk Backup | 0 | Recovery Manager (RMAN) is being used to backup the database to disk. |
| RMAN - Tape Backup | 0 | Recovery Manager (RMAN) is being used to backup the database to tape. |
| ROracle | 0 | ROracle used |
| Read Only Tablespace | 0 | Read only tablespace is being used |
| Real Application Cluster One Node | 0 | Real Application Cluster One Node is being used. |
| Real Application Clusters (RAC) | 0 | Real Application Clusters (RAC) is configured. |
| Real Application Security | 0 | Oracle Real Application Security is being used |
| Real-Time SQL Monitoring | 0 | Real-Time SQL Monitoring Usage. |
| Recover Table | 0 | Recover Table is used to recover a table in the database. |
| Recover Until Snapshot | 0 | Recover until snapshot is used to recover the database. |
| Recovery Area | 0 | The recovery area is configured. |
| Recovery Manager (RMAN) | 0 | Recovery Manager (RMAN) is being used to backup the database. |
| Restore Point | 0 | Restore Points are being used as targets for Flashback |
| Result Cache | 0 | The Result Cache feature has been used. |
| Ruby-oci8 | 0 | Ruby-oci8 used |
| Rules Manager | 0 | Rules Manager and Expression Filter |
| SPM Evolve Advisor | 0 | SPM Evolve Advisor has been used. |
| SQL Access Advisor | 0 | SQL Access Advisor has been used. |
| SQL Monitoring and Tuning pages | 0 | EM SQL Monitoring and Tuning pages has been visited at least once. |
| SQL Performance Analyzer | 0 | SQL Performance Analyzer has been used. |
| SQL Plan Management | 0 | SQL Plan Management has been used. |
| SQL Profile | 0 | SQL profiles have been used. |
| SQL Repair Advisor | 0 | SQL Repair Advisor has been used. |
| SQL Tuning Advisor | 0 | SQL Tuning Advisor has been used. |
| SQL Tuning Set (user) | 0 | A SQL Tuning Set has been created in the database in a user schema. |
| SQL Workload Manager | 0 | SQL Workload Manager has been used. |
| Scrollable Cursors | 0 | Scrollable Cursors has been used |
| SecureFile Compression (system) | 0 | SecureFile Compression is being used by system users |
| SecureFile Compression (user) | 0 | SecureFile Compression is being used |
| SecureFile Deduplication (system) | 0 | SecureFile Deduplication is being used by system users |
| SecureFile Deduplication (user) | 0 | SecureFile Deduplication is being used |
| SecureFile Encryption (system) | 0 | SecureFile Encryption is being used by system users |
| SecureFile Encryption (user) | 0 | SecureFile Encryption is being used |
| Segment Advisor (user) | 0 | Segment Advisor has been used. There is at least one user task executed. |
| Segment Maintenance Online Compress | 0 | Segment Maintenance Online Compress |
| Segment Shrink | 0 | Segment Shrink has been used. |
| Semantics/RDF | 0 | A semantic network has been created indicating usage of the RDF Semantic Graph feature of Oracle Spatial and Graph. |
| Server Flash Cache | 0 | Server Flash Cache is being used with this database. |
| Shard Database | 0 | Database is a Shard. |
| Sharding Catalog | 0 | Database is a Sharding Catalog. |
| Shared Server | 0 | The database is configured as Shared Server, where one server process can service multiple client programs. |
| Spatial | 0 | There is at least one usage of the Oracle Spatial feature usage table. |
| Standard Edition High Availability | 0 | Standard Edition High Availability is being used. |
| Statistics Advisor | 0 | Statistics Advisor has been used. |
| Streams (system) | 0 | Oracle Streams processes have been configured |
| Streams (user) | 0 | Users have configured Oracle Streams AQ |
| Sun ZFS with EHCC | 0 | EHCC used on tablespaces stored on Oracles Sun ZFS Storage |
| TRANSPORT TABLESPACE command | 0 | RMANs TRANSPORT TABLESPACE command used by the database. |
| Thin Provisioning | 0 | Thin Provisioning in use |
| Traditional Audit | 0 | Traditional Audit in use. |
| Transparent Data Encryption | 0 | Transparent Database Encryption is being used. There is atleast one column or tablespace that is encrypted. |
| Transparent Gateway | 0 | Heterogeneous Connectivity, access to a non-Oracle system, has been configured. |
| Transparent Sensitive Data Protection | 0 | Transparent Sensitive Data Protection (TSDP) |
| Transportable Tablespace | 0 | Transportable tablespace is being used |
| Tune MView | 0 | Tune MView has been used. |
| Undo Advisor | 0 | Undo Advisor has been used. |
| Very Large Memory | 0 | Very Large Memory is enabled. |
| Virtual Private Database (VPD) | 0 | Virtual Private Database (VPD) policies are being used. |
| Workspace Manager | 0 | There is at least one version enabled table. |
| XDB | 0 | XDB feature is being used. |
| XStream In | 0 | Oracle XStream Inbound servers have been configured |
| XStream Out | 0 | Oracle XStream Outbound servers have been configured |
| XStream Streams | 0 | Oracle Streams with XStream functionality has been configured |
| ZFS Storage | 0 | Tablespaces stored on Oracles Sun ZFS Storage |
| Zone maps | 0 | Zone maps |
| Zonemap Advisor | 0 | Zonemap Advisor has been used. |
| cx_Oracle | 0 | cx_Oracle used |
| node-oraceldb | 0 | node-oraceldb used |
| High-Water Mark Statistics | ||
| Name | Maximum Value | Description |
| USER_TABLES | 435 | Number of User Tables |
| SEGMENT_SIZE | 411041792 | Size of Largest Segment (Bytes) |
| PART_TABLES | 1048575 | Maximum Number of Partitions belonging to an User Table |
| PART_INDEXES | 1048575 | Maximum Number of Partitions belonging to an User Index |
| USER_INDEXES | 912 | Number of User Indexes |
| SESSIONS | 22 | Maximum Number of Concurrent Sessions seen in the database |
| DB_SIZE | 1824522240 | Maximum Size of the Database (Bytes) |
| DATAFILES | 4 | Maximum Number of Datafiles |
| TABLESPACES | 5 | Maximum Number of Tablespaces |
| CPU_COUNT | 2 | Maximum Number of CPUs |
| QUERY_LENGTH | 319 | Maximum Query Length |
| SQL_NCHAR_COLUMNS | 114 | Maximum Number of SQL NCHAR Columns |
| INSTANCES | 1 | Oracle Database instances |
| USER_MV | 0 | Maximum Number of Materialized Views (User) |
| ACTIVE_SESSIONS | 0 | Maximum Average Active Sessions - estimated |
| HWM_DBMS_SCHEDULER | 20 | Number of job runs per day |
| EXADATA_DISKS | 0 | Number of physical disks |
| GLOBAL SERVICES | 0 | Number of global services |
| SHARDS | 0 | Number of deployed shards in catalog |
| PRIMARY SHARDS | 0 | Number of deployed primary shards in catalog |
| Flex ASM | 0 | Number of completed and successful failovers |
| Per-User sessions | |||
| User | InstID | Count | Active |
| SYS | 1 | 6 | 6 |
| TOTAL ( 1 distinct users ) | 1 | 6 | 6 |
| Current sessions | ||||||||||
| SID,serial | User | OS User | Process | Type | Status | Command | Program | Module | InstID | Logon |
| 56,32418 | SYS | oracle | 487 | USER | ACTIVE | No command | oracle@8e87fa98e181 (J001) | 1 | 2023-04-14 15:49:48 | |
| 63,28724 | SYS | oracle | 1454 | USER | ACTIVE | No command | oracle@8e87fa98e181 (J004) | 1 | 2023-04-14 15:49:45 | |
| 302,16441 | SYS | oracle | 485 | USER | ACTIVE | No command | oracle@8e87fa98e181 (J000) | 1 | 2023-04-14 15:49:52 | |
| 306,34802 | SYS | oracle | 1460 | USER | ACTIVE | Select | sqlplus@8e87fa98e181 (TNS V1-V3) | sqlplus@8e87fa98e181 (TNS V1-V3) | 1 | 2023-04-14 15:50:10 |
| 314,4616 | SYS | oracle | 1450 | USER | ACTIVE | No command | oracle@8e87fa98e181 (J002) | 1 | 2023-04-14 15:49:46 | |
| 316,36591 | SYS | oracle | 1452 | USER | ACTIVE | No command | oracle@8e87fa98e181 (J003) | 1 | 2023-04-14 15:49:48 | |
| 1,41906 | SYS | oracle | 32 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (PMON) | 1 | 2023-04-14 15:43:32 | |
| 2,4342 | SYS | oracle | 40 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (PSP0) | 1 | 2023-04-14 15:43:32 | |
| 3,16045 | SYS | oracle | 50 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (GEN0) | 1 | 2023-04-14 15:43:33 | |
| 4,20251 | SYS | oracle | 169 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (M000) | MMON_SLAVE | 1 | 2023-04-14 15:43:37 |
| 5,1444 | SYS | oracle | 62 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (VOSD) | 1 | 2023-04-14 15:43:33 | |
| 6,34387 | SYS | oracle | 78 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (NMON) | 1 | 2023-04-14 15:43:33 | |
| 7,11787 | SYS | oracle | 72 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (SVCB) | 1 | 2023-04-14 15:43:34 | |
| 8,4679 | SYS | oracle | 97 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (SMCO) | 1 | 2023-04-14 15:43:34 | |
| 9,42601 | SYS | oracle | 68 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (DBRM) | 1 | 2023-04-14 15:43:34 | |
| 10,18735 | SYS | oracle | 83 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (DIA1) | 1 | 2023-04-14 15:43:34 | |
| 11,65411 | SYS | oracle | 66 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (OFSD) | 1 | 2023-04-14 15:43:34 | |
| 12,53591 | SYS | oracle | 117 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (MMNL) | 1 | 2023-04-14 15:43:34 | |
| 13,5800 | SYS | oracle | 92 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (CKPT) | 1 | 2023-04-14 15:43:34 | |
| 14,3474 | SYS | oracle | 88 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (DBW0) | 1 | 2023-04-14 15:43:34 | |
| 15,42055 | SYS | oracle | 106 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (LREG) | 1 | 2023-04-14 15:43:34 | |
| 16,11911 | SYS | oracle | 131 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (W000) | KTSJ | 1 | 2023-04-14 15:43:34 |
| 18,12194 | SYS | oracle | 129 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG00) | 1 | 2023-04-14 15:43:34 | |
| 19,5162 | SYS | oracle | 129 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG00) | 1 | 2023-04-14 15:43:35 | |
| 20,30592 | SYS | oracle | 137 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (W001) | KTSJ | 1 | 2023-04-14 15:43:35 |
| 22,5672 | SYS | oracle | 143 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (LG01) | 1 | 2023-04-14 15:43:35 | |
| 23,23523 | SYS | oracle | 141 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG01) | 1 | 2023-04-14 15:43:35 | |
| 24,33157 | SYS | oracle | 141 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG01) | 1 | 2023-04-14 15:43:35 | |
| 25,14905 | SYS | oracle | 149 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG02) | 1 | 2023-04-14 15:43:35 | |
| 26,2417 | SYS | oracle | 149 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG02) | 1 | 2023-04-14 15:43:35 | |
| 27,38163 | SYS | oracle | 149 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG02) | 1 | 2023-04-14 15:43:35 | |
| 28,45010 | SYS | oracle | 161 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (RCBG) | 1 | 2023-04-14 15:43:35 | |
| 29,35070 | SYS | oracle | 164 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (GCW0) | 1 | 2023-04-14 15:43:36 | |
| 31,53897 | SYS | oracle | 175 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (TT00) | 1 | 2023-04-14 15:43:54 | |
| 32,52014 | SYS | oracle | 179 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (TT02) | 1 | 2023-04-14 15:43:56 | |
| 34,15790 | SYS | oracle | 187 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (AQPC) | 1 | 2023-04-14 15:44:01 | |
| 36,13083 | SYS | oracle | 206 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (W004) | KTSJ | 1 | 2023-04-14 15:44:05 |
| 38,32343 | SYS | oracle | 385 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (W005) | KTSJ | 1 | 2023-04-14 15:44:09 |
| 41,55902 | SYS | oracle | 584 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (CL00) | 1 | 2023-04-14 15:44:58 | |
| 42,31833 | SYS | oracle | 404 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (Q003) | AQ | 1 | 2023-04-14 15:44:11 |
| 44,35213 | SYS | oracle | 1535 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (W007) | KTSJ | 1 | 2023-04-14 15:51:45 |
| 45,33113 | SYS | oracle | 427 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (M002) | MMON_SLAVE | 1 | 2023-04-14 15:44:15 |
| 47,9287 | SYS | oracle | 431 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (M003) | MMON_SLAVE | 1 | 2023-04-14 15:44:15 |
| 49,42884 | SYS | oracle | 435 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (M005) | MMON_SLAVE | 1 | 2023-04-14 15:44:15 |
| 52,24554 | SYS | oracle | 443 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (M007) | MMON_SLAVE | 1 | 2023-04-14 15:44:16 |
| 54,31969 | SYS | oracle | 447 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (M009) | MMON_SLAVE | 1 | 2023-04-14 15:44:16 |
| 68,37953 | SYS | oracle | 1463 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (W006) | KTSJ | 1 | 2023-04-14 15:50:17 |
| 253,27214 | SYS | oracle | 36 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (CLMN) | 1 | 2023-04-14 15:43:32 | |
| 254,11413 | SYS | oracle | 44 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (VKTM) | 1 | 2023-04-14 15:43:33 | |
| 255,51919 | SYS | oracle | 54 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (MMAN) | 1 | 2023-04-14 15:43:33 | |
| 256,1064 | SYS | oracle | 64 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (DIAG) | 1 | 2023-04-14 15:43:33 | |
| 257,41308 | SYS | oracle | 60 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (GEN2) | 1 | 2023-04-14 15:43:33 | |
| 258,14319 | SYS | oracle | 70 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (VKRM) | 1 | 2023-04-14 15:43:34 | |
| 259,16760 | SYS | oracle | 66 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (SCMN) | 1 | 2023-04-14 15:43:34 | |
| 260,31377 | SYS | oracle | 80 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (DIA0) | 1 | 2023-04-14 15:43:34 | |
| 261,54111 | SYS | oracle | 75 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (PMAN) | 1 | 2023-04-14 15:43:34 | |
| 262,50903 | SYS | oracle | 108 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (PXMN) | 1 | 2023-04-14 15:43:34 | |
| 263,14711 | SYS | oracle | 86 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (LMHB) | 1 | 2023-04-14 15:43:34 | |
| 264,20492 | SYS | oracle | 94 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (SMON) | 1 | 2023-04-14 15:43:34 | |
| 265,31412 | SYS | oracle | 102 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (RECO) | 1 | 2023-04-14 15:43:34 | |
| 266,27427 | SYS | oracle | 114 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (MMON) | 1 | 2023-04-14 15:43:34 | |
| 267,9502 | SYS | oracle | 90 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (LGWR) | 1 | 2023-04-14 15:43:34 | |
| 268,49638 | SYS | oracle | 129 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (SCMN) | 1 | 2023-04-14 15:43:34 | |
| 269,53911 | SYS | oracle | 133 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (LG00) | 1 | 2023-04-14 15:43:34 | |
| 270,60512 | SYS | oracle | 129 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG00) | 1 | 2023-04-14 15:43:34 | |
| 271,14094 | SYS | oracle | 129 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG00) | 1 | 2023-04-14 15:43:35 | |
| 272,21968 | SYS | oracle | 141 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (SCMN) | 1 | 2023-04-14 15:43:35 | |
| 273,22668 | SYS | oracle | 141 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG01) | 1 | 2023-04-14 15:43:35 | |
| 274,45866 | SYS | oracle | 141 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG01) | 1 | 2023-04-14 15:43:35 | |
| 275,57983 | SYS | oracle | 149 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (SCMN) | 1 | 2023-04-14 15:43:35 | |
| 276,14176 | SYS | oracle | 129 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (BG00) | 1 | 2023-04-14 15:43:35 | |
| 277,54604 | SYS | oracle | 159 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (TMON) | 1 | 2023-04-14 15:43:35 | |
| 279,7206 | SYS | oracle | 166 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (GCR0) | 1 | 2023-04-14 15:43:36 | |
| 280,31898 | SYS | oracle | 177 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (TT01) | 1 | 2023-04-14 15:43:54 | |
| 282,43222 | SYS | oracle | 452 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (CJQ0) | 1 | 2023-04-14 15:44:18 | |
| 283,25858 | SYS | oracle | 185 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (W002) | KTSJ | 1 | 2023-04-14 15:43:59 |
| 286,49987 | SYS | oracle | 193 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (W003) | KTSJ | 1 | 2023-04-14 15:44:02 |
| 288,44763 | SYS | oracle | 376 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (GCR1) | 1 | 2023-04-14 15:44:08 | |
| 289,15744 | SYS | oracle | 398 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (QM02) | AQ | 1 | 2023-04-14 15:44:11 |
| 291,44884 | SYS | oracle | 1467 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (GCR2) | 1 | 2023-04-14 15:50:42 | |
| 293,43360 | SYS | oracle | 406 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (Q004) | AQ | 1 | 2023-04-14 15:44:11 |
| 295,37501 | SYS | oracle | 425 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (M001) | MMON_SLAVE | 1 | 2023-04-14 15:44:14 |
| 297,61746 | SYS | oracle | 439 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (M006) | MMON_SLAVE | 1 | 2023-04-14 15:44:16 |
| 299,20743 | SYS | oracle | 433 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (M004) | MMON_SLAVE | 1 | 2023-04-14 15:44:15 |
| 301,62912 | SYS | oracle | 449 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (M00A) | MMON_SLAVE | 1 | 2023-04-14 15:44:17 |
| 303,62065 | SYS | oracle | 445 | BACKGROUND | ACTIVE | No command | oracle@8e87fa98e181 (M008) | MMON_SLAVE | 1 | 2023-04-14 15:44:16 |
| SQL | ||||||
| SID | User | Exec | Parse | Read | Get | Running SQL |
| Lock | ||||
| SID | Lock Type | Lock Mode | Request | Lock Count |
| 4 | AE | Share | HOLD | 1 |
| 4 | SS | Share | HOLD | 2 |
| 4 | TO | Row Exclusive | HOLD | 2 |
| 9 | KT | Share | HOLD | 3 |
| 13 | CF | Row Share | HOLD | 1 |
| 13 | RD | Null | HOLD | 1 |
| 13 | RS | Row Share | HOLD | 1 |
| 13 | XR | Null | HOLD | 1 |
| 14 | MR | Share | HOLD | 14 |
| 14 | PW | Row Exclusive | HOLD | 1 |
| 45 | AE | Share | HOLD | 1 |
| 47 | AE | Share | HOLD | 1 |
| 49 | AE | Share | HOLD | 1 |
| 52 | AE | Share | HOLD | 1 |
| 54 | AE | Share | HOLD | 1 |
| 266 | AE | Share | HOLD | 1 |
| 267 | RT | Exclusive | HOLD | 1 |
| 295 | AE | Share | HOLD | 1 |
| 297 | AE | Share | HOLD | 1 |
| 299 | AE | Share | HOLD | 1 |
| 301 | AE | Share | HOLD | 1 |
| 303 | AE | Share | HOLD | 1 |
| 306 | AE | Share | HOLD | 1 |
| Performance statistics |
A) Hit ratio buffer cache (>80%): 94.9% B1) Misses library cache (<1%): 1.158% B1.1) Detailed misses library cache (SQL AREA-395811): .767% B1.2) Detailed misses library cache (TABLE/PROCEDURE-59172): 3.845% B1.3) Detailed misses library cache (BODY-1115): 4.395% B1.4) Detailed misses library cache (TRIGGER-828): 4.227% B1.5) Detailed misses library cache (INDEX-1287): 1.399% B1.6) Detailed misses library cache (CLUSTER-2687): .149% B1.7) Detailed misses library cache (DIRECTORY-30): 0% B1.8) Detailed misses library cache (QUEUE-8): 0% B1.9) Detailed misses library cache (JAVA SOURCE-1): 0% B1.10) Detailed misses library cache (APP CONTEXT-6): 0% B1.11) Detailed misses library cache (RULESET-3): 0% B1.12) Detailed misses library cache (SUBSCRIPTION-6): 0% B1.13) Detailed misses library cache (JAVA DATA-1): 0% B1.14) Detailed misses library cache (EDITION-130): 1.538% B1.15) Detailed misses library cache (DBLINK-0): 0% B1.16) Detailed misses library cache (OBJECT ID-0): 0% B1.17) Detailed misses library cache (SCHEMA-0): 0% B1.18) Detailed misses library cache (DBINSTANCE-0): 0% B1.19) Detailed misses library cache (SQL AREA STATS-5728): 0% B1.20) Detailed misses library cache (ACCOUNT_STATUS-0): 0% B1.21) Detailed misses library cache (SQL AREA BUILD-0): 0% B1.22) Detailed misses library cache (PDB-0): 0% B1.23) Detailed misses library cache (AUDIT POLICY-540): .556% B1.24) Detailed misses library cache (USER PRIVILEGE-2): 0% B1.25) Detailed misses library cache (PDBOPER-0): 0% B1.26) Detailed misses library cache (FED APP-1287): .233% B1.27) Detailed misses library cache (APP STATE-0): 0% B2) Misses dictionary cache (<10%): 6.56% C1) System undo header frequence (<1%): 0% C2) System undo block frequence (<1%): 0% C3) Undo header frequence (<1%): 0% C4) Undo block frequence (<1%): 0% D) Redo log space req. (near 0): 0 E1) Hit ratio redo alloc (<1%): NA E2) Hit ratio immediate redo alloc (<1%): NA E3) Hit ratio redo copy (<1%): NA E4) Hit ratio immediate redo copy (<1%): NA F) Free list contention (<1%): 0% G1) Sorts in memory: 30682 G2) Sorts on disk: 0 H1) Short tables full scans: 14087 H2) Long tables full scans: 0 I1 @1) Logon: 166 I2 @1) Commit: 291 TPS: .54699 I3 @1) Rollback: 2 I4 @1) Exec: 298377 SQL/sec: 560.85902 L1 @1) DBcpu: 12.44759 |
| Stale Statistics | ||
| Owner | Table Stale Stats# | Last Analyzed |
| AUDSYS | 1 | 2023-03-26 02:56:06 |
| CTXSYS | 2 | 2023-03-26 03:53:34 |
| SYS | 85 | 2023-03-26 03:50:16 |
| Owner | Index Stale Stats# | Last Analyzed |
| CTXSYS | 1 | 2023-03-26 03:53:34 |
| SYS | 122 | 2023-03-26 03:50:16 |
| I/O Statistics | ||
| Name | Value | Metric |
| Small Reads | 55816 | |
| Small Writes | 8332 | |
| Large Reads | 170 | |
| Large Writes | 58 | 120.10448 IOP/s |
| Total MB Read | 893 | 1.66784 MB/s |
| Total MB Written | 368 |
| Biggest Objects | ||||
| Object | Type | Owner | Tablespace | Bytes |
| IDL_UB1$ | TABLE | SYS | SYSTEM | 411,041,792 |
| SYS_LOB0000000203C00010$$ | LOBSEGMENT | SYS | SYSTEM | 167,772,160 |
| PDB_SYNC$ | TABLE | SYS | SYSTEM | 51,380,224 |
| C_TOID_VERSION# | CLUSTER | SYS | SYSTEM | 51,380,224 |
| SOURCE$ | TABLE | SYS | SYSTEM | 44,040,192 |
| SYS_LOB0000069450C00006$$ | LOBSEGMENT | MDSYS | SYSAUX | 42,270,720 |
| SYS_LOB0000069550C00006$$ | LOBSEGMENT | MDSYS | SYSAUX | 37,027,840 |
| IDL_UB2$ | TABLE | SYS | SYSTEM | 33,554,432 |
| SYS_LOB0000021804C00030$$ | LOB PARTITION | AUDSYS | SYSAUX | 26,017,792 |
| SYS_LOB0000068579C00004$$ | LOBSEGMENT | SYS | SYSAUX | 25,493,504 |
| SYS_LOB0000001482C00003$$ | LOBSEGMENT | SYS | SYSTEM | 16,777,216 |
| C_OBJ# | CLUSTER | SYS | SYSTEM | 16,777,216 |
| _SYSSMU1_2287069710$ | TYPE2 UNDO | SYS | UNDOTBS1 | 15,728,640 |
| JAVA$MC$ | TABLE | SYS | SYSTEM | 14,680,064 |
| AUD$UNIFIED | TABLE PARTITION | AUDSYS | SYSAUX | 12,779,520 |
| ARGUMENT$ | TABLE | SYS | SYSTEM | 12,582,912 |
| OBJ$ | TABLE | SYS | SYSTEM | 11,534,336 |
| IDL_CHAR$ | TABLE | SYS | SYSTEM | 10,485,760 |
| EXT_TAB_CS_SRS | TABLE | MDSYS | SYSAUX | 10,485,760 |
| VIEW$ | TABLE | SYS | SYSTEM | 10,485,760 |
| I_OBJ5 | INDEX | SYS | SYSTEM | 9,437,184 |
| SDO_CS_SRS | TABLE | MDSYS | SYSAUX | 9,437,184 |
| I_OBJ2 | INDEX | SYS | SYSTEM | 9,437,184 |
| I_ARGUMENT1 | INDEX | SYS | SYSTEM | 8,388,608 |
| SYS_LOB0000068564C00004$$ | LOBSEGMENT | SYS | SYSAUX | 7,667,712 |
| SYS_LOB0000072265C00002$$ | LOBSEGMENT | MDSYS | SYSAUX | 7,667,712 |
| I_COL1 | INDEX | SYS | SYSTEM | 7,340,032 |
| I_SOURCE1 | INDEX | SYS | SYSTEM | 7,340,032 |
| AQ$_SUBSCRIBER_LWM | TABLE PARTITION | SYS | SYSTEM | 6,553,600 |
| DEPENDENCY$ | TABLE | SYS | SYSTEM | 6,291,456 |
| KOTAD$ | TABLE | SYS | SYSTEM | 6,291,456 |
| IDL_SB4$ | TABLE | SYS | SYSTEM | 5,242,880 |
| ... |
| Most Fragmented Objects | |||||
| Object | Type | Owner | Tablespace | Extents | Bytes |
| IDL_UB1$ | TABLE | SYS | SYSTEM | 120 | 411,041,792 |
| AQ$_SUBSCRIBER_LWM | TABLE PARTITION | SYS | SYSTEM | 100 | 6,553,600 |
| SYS_LOB0000000203C00010$$ | LOBSEGMENT | SYS | SYSTEM | 91 | 167,772,160 |
| C_TOID_VERSION# | CLUSTER | SYS | SYSTEM | 64 | 51,380,224 |
| PDB_SYNC$ | TABLE | SYS | SYSTEM | 64 | 51,380,224 |
| SOURCE$ | TABLE | SYS | SYSTEM | 57 | 44,040,192 |
| IDL_UB2$ | TABLE | SYS | SYSTEM | 47 | 33,554,432 |
| BLOCKCHAIN_TABLE_CHAIN$ | TABLE PARTITION | SYS | SYSTEM | 33 | 2,162,688 |
| WRI$_OPTSTAT_SYNOPSIS$ | TABLE SUBPARTITION | SYS | SYSAUX | 32 | 2,097,152 |
| C_OBJ# | CLUSTER | SYS | SYSTEM | 31 | 16,777,216 |
| SYS_LOB0000001482C00003$$ | LOBSEGMENT | SYS | SYSTEM | 31 | 16,777,216 |
| AUD$UNIFIED | TABLE PARTITION | AUDSYS | SYSAUX | 30 | 12,779,520 |
| _SYSSMU1_2287069710$ | TYPE2 UNDO | SYS | UNDOTBS1 | 30 | 15,728,640 |
| JAVA$MC$ | TABLE | SYS | SYSTEM | 29 | 14,680,064 |
| ARGUMENT$ | TABLE | SYS | SYSTEM | 27 | 12,582,912 |
| OBJ$ | TABLE | SYS | SYSTEM | 26 | 11,534,336 |
| EXT_TAB_CS_SRS | TABLE | MDSYS | SYSAUX | 25 | 10,485,760 |
| IDL_CHAR$ | TABLE | SYS | SYSTEM | 25 | 10,485,760 |
| VIEW$ | TABLE | SYS | SYSTEM | 25 | 10,485,760 |
| I_OBJ2 | INDEX | SYS | SYSTEM | 24 | 9,437,184 |
| I_OBJ5 | INDEX | SYS | SYSTEM | 24 | 9,437,184 |
| SDO_CS_SRS | TABLE | MDSYS | SYSAUX | 24 | 9,437,184 |
| I_ARGUMENT1 | INDEX | SYS | SYSTEM | 23 | 8,388,608 |
| I_COL1 | INDEX | SYS | SYSTEM | 22 | 7,340,032 |
| I_SOURCE1 | INDEX | SYS | SYSTEM | 22 | 7,340,032 |
| DEPENDENCY$ | TABLE | SYS | SYSTEM | 21 | 6,291,456 |
| KOTAD$ | TABLE | SYS | SYSTEM | 21 | 6,291,456 |
| I_ARGUMENT2 | INDEX | SYS | SYSTEM | 20 | 5,242,880 |
| I_DEPENDENCY1 | INDEX | SYS | SYSTEM | 20 | 5,242,880 |
| I_DEPENDENCY2 | INDEX | SYS | SYSTEM | 20 | 5,242,880 |
| IDL_SB4$ | TABLE | SYS | SYSTEM | 20 | 5,242,880 |
| ACCESS$ | TABLE | SYS | SYSTEM | 19 | 4,194,304 |
| ... |
| PL/SQL | |||
| User | Type | Objects | Lines |
| AUDSYS | LIBRARY | 1 | 1 |
| AUDSYS | PACKAGE | 2 | 607 |
| AUDSYS | PACKAGE BODY | 2 | 10 |
| CTXSYS | FUNCTION | 2 | 2 |
| CTXSYS | LIBRARY | 2 | 3 |
| CTXSYS | PACKAGE | 80 | 21,467 |
| CTXSYS | PACKAGE BODY | 69 | 164 |
| CTXSYS | PROCEDURE | 2 | 25 |
| CTXSYS | TYPE | 22 | 1,686 |
| CTXSYS | TYPE BODY | 6 | 12 |
| DBSFWUSER | PACKAGE | 1 | 538 |
| DBSFWUSER | PACKAGE BODY | 1 | 2 |
| DBSNMP | PACKAGE | 1 | 1 |
| DBSNMP | PACKAGE BODY | 1 | 1 |
| DBSNMP | PROCEDURE | 5 | 65 |
| DVF | FUNCTION | 20 | 20 |
| DVF | PACKAGE | 1 | 1 |
| DVF | PACKAGE BODY | 1 | 1 |
| DVSYS | FUNCTION | 32 | 261 |
| DVSYS | LIBRARY | 5 | 5 |
| DVSYS | PACKAGE | 11 | 3,104 |
| DVSYS | PACKAGE BODY | 11 | 79 |
| DVSYS | PROCEDURE | 3 | 63 |
| DVSYS | TYPE | 82 | 399 |
| GSMADMIN_INTERNAL | FUNCTION | 3 | 40 |
| GSMADMIN_INTERNAL | LIBRARY | 7 | 7 |
| GSMADMIN_INTERNAL | PACKAGE | 12 | 9,463 |
| GSMADMIN_INTERNAL | PACKAGE BODY | 12 | 106 |
| GSMADMIN_INTERNAL | PROCEDURE | 4 | 4 |
| GSMADMIN_INTERNAL | TRIGGER | 5 | 21 |
| GSMADMIN_INTERNAL | TYPE | 54 | 274 |
| GSMADMIN_INTERNAL | TYPE BODY | 3 | 25 |
| LBACSYS | FUNCTION | 25 | 25 |
| LBACSYS | LIBRARY | 11 | 11 |
| LBACSYS | PACKAGE | 25 | 25 |
| LBACSYS | PACKAGE BODY | 24 | 32 |
| LBACSYS | PROCEDURE | 8 | 8 |
| LBACSYS | TRIGGER | 3 | 21 |
| LBACSYS | TYPE | 5 | 119 |
| LBACSYS | TYPE BODY | 4 | 4 |
| MDSYS | FUNCTION | 150 | 846 |
| MDSYS | LIBRARY | 25 | 26 |
| MDSYS | PACKAGE | 145 | 38,342 |
| MDSYS | PACKAGE BODY | 137 | 4,733 |
| MDSYS | PROCEDURE | 6 | 40 |
| MDSYS | TRIGGER | 84 | 2,819 |
| MDSYS | TYPE | 277 | 5,576 |
| MDSYS | TYPE BODY | 79 | 666 |
| OLAPSYS | TYPE | 2 | 15 |
| OUTLN | PROCEDURE | 1 | 9 |
| REMOTE_SCHEDULER_AGENT | FUNCTION | 1 | 1 |
| REMOTE_SCHEDULER_AGENT | PROCEDURE | 12 | 12 |
| SYS | FUNCTION | 145 | 1,672 |
| SYS | JAVA SOURCE | 2 | 68 |
| SYS | LIBRARY | 201 | 201 |
| SYS | PACKAGE | 781 | 146,694 |
| SYS | PACKAGE BODY | 760 | 24,660 |
| SYS | PROCEDURE | 194 | 11,170 |
| SYS | TRIGGER | 6 | 116 |
| SYS | TYPE | 1,844 | 21,485 |
| SYS | TYPE BODY | 189 | 4,707 |
| WMSYS | PACKAGE | 26 | 35 |
| WMSYS | PACKAGE BODY | 26 | 192 |
| WMSYS | PROCEDURE | 1 | 1 |
| WMSYS | TRIGGER | 45 | 754 |
| WMSYS | TYPE | 17 | 65 |
| WMSYS | TYPE BODY | 1 | 1 |
| XDB | FUNCTION | 6 | 19 |
| XDB | LIBRARY | 20 | 20 |
| XDB | PACKAGE | 52 | 8,797 |
| XDB | PACKAGE BODY | 50 | 1,293 |
| XDB | PROCEDURE | 4 | 11 |
| XDB | TRIGGER | 7 | 53 |
| XDB | TYPE | 85 | 1,498 |
| XDB | TYPE BODY | 5 | 153 |
| TOTAL | FUNCTION | 384 | 2,886 |
| TOTAL | JAVA SOURCE | 2 | 68 |
| TOTAL | LIBRARY | 272 | 274 |
| TOTAL | PACKAGE | 1,137 | 229,074 |
| TOTAL | PACKAGE BODY | 1,094 | 31,273 |
| TOTAL | PROCEDURE | 240 | 11,408 |
| TOTAL | TRIGGER | 150 | 3,784 |
| TOTAL | TYPE | 2,388 | 31,117 |
| TOTAL | TYPE BODY | 287 | 5,568 |
| Libraries | ||||
| Owner | Library | File | Status | Dynamic |
| AUDSYS | DBMS_AUDIT_MGMT_LIB | VALID | N | |
| GSMADMIN_INTERNAL | DBMS_GSM_COMMON_LIB | VALID | N | |
| GSMADMIN_INTERNAL | DBMS_GSM_DBADMIN_LIB | VALID | N | |
| GSMADMIN_INTERNAL | DBMS_GSM_UTILITY_LIB | VALID | N | |
| GSMADMIN_INTERNAL | DBMS_DIR_SHARD_LIB | VALID | N | |
| GSMADMIN_INTERNAL | DBMS_GSM_POOLADMIN_LIB | VALID | N | |
| GSMADMIN_INTERNAL | DBMS_GSM_CLOUDADMIN_LIB | VALID | N | |
| GSMADMIN_INTERNAL | DBMS_GSM_ALERT_LIB | VALID | N | |
| CTXSYS | DR$LIB | VALID | N | |
| CTXSYS | CTXHX2LIB | $ORACLE_HOME/ctx/lib/ctxhx2.so | VALID | Y |
| LBACSYS | LBAC$TYPE_LIBT | VALID | N | |
| LBACSYS | LBAC$LABEL_LIBT | VALID | N | |
| LBACSYS | LBAC$PRIVS_LIBT | VALID | N | |
| LBACSYS | LBAC$LABLT_LIBT | VALID | N | |
| LBACSYS | LBAC$STD_LIBT | VALID | N | |
| LBACSYS | LBAC$CACHE_LIBT | VALID | N | |
| LBACSYS | LBAC$USER_LIBT | VALID | N | |
| LBACSYS | OLS$LAB_LIBT | VALID | N | |
| LBACSYS | OLS$SESSION_LIBT | VALID | N | |
| LBACSYS | LBAC$RLS_LIBT | VALID | N | |
| LBACSYS | LBAC$EVENT_LIBT | VALID | N | |
| DVSYS | KZV$UTL_LIBT | VALID | N | |
| DVSYS | KZV$FAC_LIBT | VALID | N | |
| DVSYS | KZV$RUL_LIBT | VALID | N | |
| DVSYS | KZV$ADM_LIBT | VALID | N | |
| DVSYS | KZV$RSRC_LIBT | VALID | N |
| Data Type Usage | ||||
| User | Data Type | # | Max Length | Max Precision |
| APPQOSSYS | CHAR | 1 | 1 | |
| APPQOSSYS | DATE | 3 | 7 | |
| APPQOSSYS | INTERVAL DAY(9) TO SECOND(0) | 3 | 11 | 9 |
| APPQOSSYS | NUMBER | 17 | 22 | |
| APPQOSSYS | TIMESTAMP(6) | 2 | 11 | |
| APPQOSSYS | VARCHAR2 | 7 | 4,000 | |
| AUDSYS | CLOB | 14 | 32,600 | |
| AUDSYS | NUMBER | 81 | 22 | |
| AUDSYS | RAW | 8 | 33 | |
| AUDSYS | TIMESTAMP(6) | 9 | 11 | |
| AUDSYS | VARCHAR2 | 325 | 4,000 | |
| CTXSYS | ANYDATA | 1 | 3,752 | |
| CTXSYS | CHAR | 25 | 1 | |
| CTXSYS | CLOB | 6 | 32,767 | |
| CTXSYS | DATE | 12 | 7 | |
| CTXSYS | NUMBER | 296 | 22 | 38 |
| CTXSYS | RAW | 3 | 250 | |
| CTXSYS | ROWID | 9 | 10 | |
| CTXSYS | TIMESTAMP(6) WITH TIME ZONE | 11 | 13 | |
| CTXSYS | VARCHAR2 | 472 | 4,000 | |
| DBSFWUSER | NUMBER | 1 | 22 | |
| DBSFWUSER | VARCHAR2 | 6 | 512 | |
| DBSNMP | DATE | 9 | 7 | |
| DBSNMP | NUMBER | 87 | 22 | |
| DBSNMP | RAW | 1 | 8 | |
| DBSNMP | TIMESTAMP(6) WITH TIME ZONE | 1 | 13 | |
| DBSNMP | VARCHAR2 | 12 | 1,000 | |
| DVSYS | CHAR | 84 | 25 | |
| DVSYS | CLOB | 1 | 32,600 | |
| DVSYS | DATE | 79 | 7 | |
| DVSYS | NUMBER | 282 | 22 | 10 |
| DVSYS | PLSQL_STACK_ARRAY | 1 | 3,752 | |
| DVSYS | RAW | 14 | 16 | |
| DVSYS | SIMULATION_IDS | 3 | 16 | |
| DVSYS | TIMESTAMP(6) WITH TIME ZONE | 5 | 13 | |
| DVSYS | VARCHAR2 | 784 | 4,000 | |
| GGSHAREDCAP | NUMBER | 5 | 22 | |
| GSMADMIN_INTERNAL | ANYDATA | 2 | 4,472 | |
| GSMADMIN_INTERNAL | AQ$_SIG_PROP | 2 | 1 | |
| GSMADMIN_INTERNAL | BLOB | 14 | 32,600 | |
| GSMADMIN_INTERNAL | CHAR | 20 | 10 | |
| GSMADMIN_INTERNAL | CLOB | 8 | 32,600 | |
| GSMADMIN_INTERNAL | DATE | 6 | 7 | |
| GSMADMIN_INTERNAL | DBPARAMS_LIST | 4 | 2,437 | |
| GSMADMIN_INTERNAL | GSM_CHANGE_MESSAGE | 4 | 64 | |
| GSMADMIN_INTERNAL | INSTANCE_LIST | 2 | 16 | |
| GSMADMIN_INTERNAL | NUMBER | 342 | 22 | 1 |
| GSMADMIN_INTERNAL | NUMBER_LIST | 1 | 16 | |
| GSMADMIN_INTERNAL | RAW | 25 | 2,000 | |
| GSMADMIN_INTERNAL | ROWID | 3 | 10 | |
| GSMADMIN_INTERNAL | TIMESTAMP(6) | 17 | 11 | |
| GSMADMIN_INTERNAL | TIMESTAMP(6) WITH TIME ZONE | 8 | 13 | |
| GSMADMIN_INTERNAL | TIMESTAMP(9) | 1 | 11 | |
| GSMADMIN_INTERNAL | VARCHAR2 | 255 | 4,000 | |
| LBACSYS | CHAR | 2 | 13 | |
| LBACSYS | DATE | 2 | 7 | |
| LBACSYS | NUMBER | 115 | 22 | 10 |
| LBACSYS | VARCHAR2 | 431 | 4,000 | |
| OJVMSYS | BLOB | 1 | 4,000 | |
| OJVMSYS | DATE | 3 | 7 | |
| OJVMSYS | NUMBER | 17 | 22 | 28 |
| OJVMSYS | RAW | 1 | 2,000 | |
| OJVMSYS | VARCHAR2 | 10 | 4,000 | |
| OLAPSYS | DATE | 1 | 7 | |
| OLAPSYS | NUMBER | 9 | 22 | |
| OLAPSYS | VARCHAR2 | 113 | 4,000 | |
| OUTLN | CLOB | 1 | 4,000 | |
| OUTLN | DATE | 1 | 7 | |
| OUTLN | FLOAT | 3 | 22 | 126 |
| OUTLN | LONG | 1 | 0 | |
| OUTLN | NUMBER | 22 | 22 | |
| OUTLN | RAW | 1 | 16 | |
| OUTLN | VARCHAR2 | 14 | 2,000 | |
| SYSTEM | ANYDATA | 4 | 4,472 | |
| SYSTEM | CLOB | 1 | 4,000 | |
| SYSTEM | DATE | 28 | 7 | |
| SYSTEM | FLOAT | 3 | 22 | 126 |
| SYSTEM | LONG | 11 | 0 | |
| SYSTEM | LONG RAW | 5 | 0 | |
| SYSTEM | NUMBER | 255 | 22 | 15 |
| SYSTEM | RAW | 5 | 70 | |
| SYSTEM | ROWID | 2 | 10 | |
| SYSTEM | VARCHAR2 | 133 | 4,000 | |
| WMSYS | ANYDATA | 2 | 4,472 | |
| WMSYS | AQ$_SIG_PROP | 2 | 1 | |
| WMSYS | CHAR | 3 | 10 | |
| WMSYS | CLOB | 23 | 32,767 | |
| WMSYS | DATE | 3 | 7 | |
| WMSYS | LONG | 4 | 0 | |
| WMSYS | NUMBER | 448 | 22 | |
| WMSYS | RAW | 17 | 16 | |
| WMSYS | ROWID | 3 | 10 | |
| WMSYS | TIMESTAMP(6) | 13 | 11 | |
| WMSYS | TIMESTAMP(6) WITH TIME ZONE | 51 | 13 | |
| WMSYS | TIMESTAMP(9) | 1 | 11 | |
| WMSYS | VARCHAR2 | 884 | 4,000 | |
| WMSYS | WM$ED_UNDO_CODE_TABLE_TYPE | 5 | 64 | |
| WMSYS | WM$EVENT_TYPE | 3 | 64 | |
| TOTAL | ANYDATA | 9 | 4,472 | |
| TOTAL | AQ$_SIG_PROP | 4 | 1 | |
| TOTAL | BLOB | 15 | 32,600 | |
| TOTAL | CHAR | 135 | 25 | |
| TOTAL | CLOB | 54 | 32,767 | |
| TOTAL | DATE | 147 | 7 | |
| TOTAL | DBPARAMS_LIST | 4 | 2,437 | |
| TOTAL | FLOAT | 6 | 22 | 126 |
| TOTAL | GSM_CHANGE_MESSAGE | 4 | 64 | |
| TOTAL | INSTANCE_LIST | 2 | 16 | |
| TOTAL | INTERVAL DAY(9) TO SECOND(0) | 3 | 11 | 9 |
| TOTAL | LONG | 16 | 0 | |
| TOTAL | LONG RAW | 5 | 0 | |
| TOTAL | NUMBER | 1,977 | 22 | 38 |
| TOTAL | NUMBER_LIST | 1 | 16 | |
| TOTAL | PLSQL_STACK_ARRAY | 1 | 3,752 | |
| TOTAL | RAW | 75 | 2,000 | |
| TOTAL | ROWID | 17 | 10 | |
| TOTAL | SIMULATION_IDS | 3 | 16 | |
| TOTAL | TIMESTAMP(6) | 41 | 11 | |
| TOTAL | TIMESTAMP(6) WITH TIME ZONE | 76 | 13 | |
| TOTAL | TIMESTAMP(9) | 2 | 11 | |
| TOTAL | VARCHAR2 | 3,446 | 4,000 | |
| TOTAL | WM$ED_UNDO_CODE_TABLE_TYPE | 5 | 64 | |
| TOTAL | WM$EVENT_TYPE | 3 | 64 |
| Jobs | ||||
| Job Id | User | Interval | Command | Total Time |
| Scheduler Jobs | |||||||
| Job Name | User | Interval | Start | Command | Count | Last Duration | Enabled |
| PURGE_LOG | SYS | 26-MAR-23 03.00.00.466404 AM ETC/UTC | PURGE_LOG_PROG | 1 | +000000000 00:00:08.358121 | TRUE | |
| FILE_WATCHER | SYS | FILE_WATCHER_PROGRAM | 0 | FALSE | |||
| PMO_DEFERRED_GIDX_MAINT_JOB | SYS | 27-MAR-23 02.00.00.690938 AM ETC/UTC | PMO_DEFERRED_GIDX_MAINT | 2 | +000000000 00:00:02.712250 | TRUE | |
| CLEANUP_NON_EXIST_OBJ | SYS | FREQ = HOURLY; INTERVAL = 12 | 26-MAR-23 02.52.15.940469 AM +00:00 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(1); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 2 | +000000000 00:00:02.809773 | TRUE |
| CLEANUP_ONLINE_IND_BUILD | SYS | FREQ = HOURLY; INTERVAL = 1 | 26-MAR-23 02.52.25.951942 AM +00:00 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(2); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 3 | +000000000 00:00:00.279285 | TRUE |
| CLEANUP_TAB_IOT_PMO | SYS | FREQ = HOURLY; INTERVAL = 1 | 26-MAR-23 02.52.35.966645 AM +00:00 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(3); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 2 | +000000000 00:00:03.402757 | TRUE |
| CLEANUP_TRANSIENT_TYPE | SYS | FREQ = HOURLY; INTERVAL = 2 | 26-MAR-23 02.52.45.977813 AM +00:00 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(4); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 2 | +000000000 00:00:02.887465 | TRUE |
| CLEANUP_TRANSIENT_PKG | SYS | FREQ = HOURLY; INTERVAL = 2 | 26-MAR-23 02.52.55.987439 AM +00:00 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(5); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 2 | +000000000 00:00:01.120177 | TRUE |
| CLEANUP_ONLINE_PMO | SYS | FREQ = HOURLY; INTERVAL = 1 | 26-MAR-23 02.53.05.998349 AM +00:00 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(6); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 2 | +000000000 00:00:02.308213 | TRUE |
| ORA$_ATSK_ADVPURGE | SYS | dbms_autotask_prvt.run_autotask | 1 | +000000000 00:00:03.660392 | FALSE | ||
| ORA$_ATSK_SMFLUSH | SYS | dbms_autotask_prvt.run_autotask | 2 | +000000000 00:00:01.320074 | FALSE | ||
| ORA$_ATSK_EVTPRG | SYS | dbms_autotask_prvt.run_autotask | 1 | +000000000 00:00:03.638061 | FALSE | ||
| ORA$AUTOTASK_CLEAN | SYS | 26-MAR-23 03.00.00.713777 AM ETC/UTC | ORA$AGE_AUTOTASK_DATA | 1 | +000000000 00:00:03.308706 | TRUE | |
| HM_CREATE_OFFLINE_DICTIONARY | SYS | dbms_hm.create_offline_dictionary | 0 | FALSE | |||
| DRA_REEVALUATE_OPEN_FAILURES | SYS | dbms_ir.reevaluateopenfailures | 0 | TRUE | |||
| ORA$PREPLUGIN_BACKUP_JOB | SYS | ORA$PREPLUGIN_BACKUP_PRG | 0 | FALSE | |||
| BSLN_MAINTAIN_STATS_JOB | SYS | 02-APR-23 12.00.00.000000 AM +00:00 | BSLN_MAINTAIN_STATS_PROG | 1 | +000000000 00:00:02.131880 | TRUE | |
| FGR$AUTOPURGE_JOB | SYS | freq=daily;byhour=0;byminute=0;bysecond=0 | IF sys_context('userenv','IS_DG_ROLLING_UPGRADE') = 'FALSE' THEN sys.dbms_file_group.purge_file_group(NULL); END IF; | 0 | FALSE | ||
| LOAD_OPATCH_INVENTORY | SYS | 26-MAR-23 02.55.37.603716 AM +00:00 | BEGIN dbms_qopatch.opatch_inv_refresh_job(); END; | 0 | FALSE | ||
| ORA$_ATSK_SMPURGE | SYS | dbms_autotask_prvt.run_autotask | 1 | +000000000 00:00:08.353181 | FALSE | ||
| XMLDB_NFS_CLEANUP_JOB | SYS | Freq=minutely;interval=5 | xdb.dbms_xdbutil_int.cleanup_expired_nfsclients | 0 | FALSE |
| Running Jobs | |||
| Job Id | SID | Last | Failures |
| Last executed Jobs | |||||
| Log Id | Name | Log Date | Actual Date | Status | Errors |
| 174 | ORA$_ATSK_SMPURGE | 2023/04/14 15:49:52.311845 +00:00 | 2023/04/14 15:49:43.961660 +00:00 | SUCCEEDED | |
| 180 | ORA$_ATSK_ADVPURGE | 2023/04/14 15:49:48.945323 +00:00 | 2023/04/14 15:49:45.284679 +00:00 | SUCCEEDED | |
| 176 | ORA$_ATSK_EVTPRG | 2023/04/14 15:49:48.002006 +00:00 | 2023/04/14 15:49:44.371556 +00:00 | SUCCEEDED | |
| 178 | ORA$_ATSK_SMFLUSH | 2023/04/14 15:49:46.041850 +00:00 | 2023/04/14 15:49:44.715339 +00:00 | SUCCEEDED | |
| 172 | ORA$_ATSK_SMFLUSH | 2023/04/14 15:44:47.665900 +00:00 | 2023/04/14 15:44:47.543429 +00:00 | SUCCEEDED | |
| 142 | PURGE_LOG | 2023/04/14 15:44:36.942329 +00:00 | 2023/04/14 15:44:28.591647 +00:00 | SUCCEEDED | |
| 146 | ORA$AUTOTASK_CLEAN | 2023/04/14 15:44:33.578117 +00:00 | 2023/04/14 15:44:30.247841 +00:00 | SUCCEEDED | |
| 148 | BSLN_MAINTAIN_STATS_JOB | 2023/04/14 15:44:32.459937 +00:00 | 2023/04/14 15:44:30.306880 +00:00 | SUCCEEDED |
| Data Pump Jobs | ||
| Owner | Job Name | State |
| RMAN Configuration | |
| Parameter | Value |
| Database Links | |||
| Owner | DB Link | User | Instance |
| Directories | ||
| Owner | Directory | Path |
| SYS | DATA_PUMP_DIR | /opt/oracle/admin/FREE/dpdump/ |
| SYS | DBMS_OPTIM_ADMINDIR | /opt/oracle/product/23c/dbhomeFree/rdbms/admin |
| SYS | DBMS_OPTIM_LOGDIR | /opt/oracle/product/23c/dbhomeFree/cfgtoollogs |
| SYS | JAVA$JOX$CUJS$DIRECTORY$ | /opt/oracle/product/23c/dbhomeFree/javavm/admin/ |
| SYS | OPATCH_INST_DIR | /opt/oracle/product/23c/dbhomeFree/OPatch |
| SYS | OPATCH_LOG_DIR | /opt/oracle/product/23c/dbhomeFree/rdbms/log |
| SYS | OPATCH_SCRIPT_DIR | /opt/oracle/product/23c/dbhomeFree/QOpatch |
| SYS | ORACLE_BASE | /opt/oracle |
| SYS | ORACLE_HOME | /opt/oracle/product/23c/dbhomeFree |
| SYS | SDO_DIR_ADMIN | /opt/oracle/product/23c/dbhomeFree/md/admin |
| SYS | XMLDIR | /opt/oracle/product/23c/dbhomeFree/rdbms/xml |
| SYS | XSDDIR | /opt/oracle/product/23c/dbhomeFree/rdbms/xml/schema |
| Oracle Parameters | |
| Parameter | Value |
| audit_file_dest | /opt/oracle/admin/FREE/adump |
| audit_trail | DB |
| compatible | 23.0.0 |
| control_files | /opt/oracle/oradata/FREE/control01.ctl |
| db_block_size | 8192 |
| db_name | FREE |
| diagnostic_dest | /opt/oracle |
| dispatchers | (PROTOCOL=TCP) (SERVICE=FREEXDB) |
| enable_pluggable_database | TRUE |
| local_listener | |
| nls_language | AMERICAN |
| nls_territory | AMERICA |
| open_cursors | 300 |
| pga_aggregate_target | 536870912 |
| processes | 320 |
| remote_login_passwordfile | EXCLUSIVE |
| sga_target | 1610612736 |
| undo_tablespace | UNDOTBS1 |
| Hidden Parameters | Value |
| _optimizer_ads_spd_cache_owner_limit | 64 |
| _optimizer_autostats_job | TRUE |
| _optimizer_diag_stats | TRUE |
| _optimizer_inmemory_capture_stored_stats | TRUE |
| _optimizer_invalidation_period | 18000 |
| _optimizer_save_stats | TRUE |
| All Parameters | |
| Parameter | Value |
| DBFIPS_140 | FALSE |
| active_instance_count | |
| adg_account_info_tracking | LOCAL |
| adg_redirect_dml | FALSE |
| allow_global_dblinks | FALSE |
| allow_group_access_to_sga | FALSE |
| allow_legacy_reco_protocol | TRUE |
| allow_rowid_column_type | FALSE |
| allow_weak_crypto | TRUE |
| approx_for_aggregation | FALSE |
| approx_for_count_distinct | FALSE |
| approx_for_percentile | NONE |
| aq_tm_processes | 1 |
| archive_lag_target | 0 |
| asm_diskstring | |
| asm_preferred_read_failure_groups | |
| audit_file_dest | /opt/oracle/admin/FREE/adump |
| audit_sys_operations | FALSE |
| audit_syslog_level | |
| audit_trail | DB |
| auto_start_pdb_services | FALSE |
| autotask_max_active_pdbs | 2 |
| awr_pdb_autoflush_enabled | TRUE |
| awr_pdb_max_parallel_slaves | 10 |
| awr_snapshot_time_offset | 0 |
| background_core_dump | partial |
| background_dump_dest | /opt/oracle/product/23c/dbhomeFree/rdbms/log |
| backup_tape_io_slaves | FALSE |
| bitmap_merge_area_size | 1048576 |
| blank_trimming | FALSE |
| blockchain_table_max_no_drop | |
| blockchain_table_retention_threshold | 16 |
| buffer_pool_keep | |
| buffer_pool_recycle | |
| cdb_cluster | FALSE |
| cdb_cluster_name | |
| cell_offload_compaction | ADAPTIVE |
| cell_offload_decryption | TRUE |
| cell_offload_parameters | |
| cell_offload_plan_display | AUTO |
| cell_offload_processing | TRUE |
| cell_offloadgroup_name | |
| circuits | |
| client_prefetch_rows | 0 |
| client_result_cache_lag | 3000 |
| client_result_cache_size | 0 |
| client_statistics_level | TYPICAL |
| clonedb | FALSE |
| clonedb_dir | |
| cluster_database | FALSE |
| cluster_interconnects | |
| commit_logging | |
| commit_point_strength | 1 |
| commit_wait | |
| commit_write | |
| common_user_prefix | C## |
| compatible | 23.0.0 |
| connection_brokers | ((TYPE=DEDICATED)(BROKERS=1)), ((TYPE=EMON)(BROKERS=1)) |
| container_data | ALL |
| containers_parallel_degree | 65535 |
| control_file_record_keep_time | 7 |
| control_files | /opt/oracle/oradata/FREE/control01.ctl |
| control_management_pack_access | NONE |
| core_dump_dest | /opt/oracle/diag/rdbms/free/FREE/cdump |
| cpu_count | 2 |
| cpu_min_count | 2 |
| create_bitmap_area_size | 8388608 |
| create_stored_outlines | |
| cursor_bind_capture_destination | memory+disk |
| cursor_invalidation | IMMEDIATE |
| cursor_sharing | EXACT |
| cursor_space_for_time | FALSE |
| data_guard_max_io_time | 240 |
| data_guard_max_longio_time | 240 |
| data_guard_sync_latency | 0 |
| data_transfer_cache_size | 0 |
| db_16k_cache_size | 0 |
| db_2k_cache_size | 0 |
| db_32k_cache_size | 0 |
| db_4k_cache_size | 0 |
| db_8k_cache_size | 0 |
| db_big_table_cache_percent_target | 0 |
| db_block_buffers | 0 |
| db_block_checking | FALSE |
| db_block_checksum | TYPICAL |
| db_block_size | 8192 |
| db_cache_advice | ON |
| db_cache_size | 0 |
| db_create_file_dest | |
| db_create_online_log_dest_1 | |
| db_create_online_log_dest_2 | |
| db_create_online_log_dest_3 | |
| db_create_online_log_dest_4 | |
| db_create_online_log_dest_5 | |
| db_domain | |
| db_file_multiblock_read_count | 128 |
| db_file_name_convert | |
| db_files | 200 |
| db_flash_cache_file | |
| db_flash_cache_size | 0 |
| db_flashback_log_dest | |
| db_flashback_log_dest_size | 0 |
| db_flashback_retention_target | 1440 |
| db_index_compression_inheritance | NONE |
| db_keep_cache_size | 0 |
| db_lost_write_protect | AUTO |
| db_name | FREE |
| db_performance_profile | |
| db_recovery_file_dest | |
| db_recovery_file_dest_size | 0 |
| db_recycle_cache_size | 0 |
| db_securefile | PREFERRED |
| db_ultra_safe | OFF |
| db_unique_name | FREE |
| db_unrecoverable_scn_tracking | TRUE |
| db_writer_processes | 1 |
| dbnest_enable | NONE |
| dbnest_pdb_fs_conf | |
| dbwr_io_slaves | 0 |
| ddl_lock_timeout | 0 |
| default_credential | |
| default_sharing | metadata |
| deferred_segment_creation | TRUE |
| dg_broker_config_file1 | /opt/oracle/product/23c/dbhomeFree/dbs/dr1FREE.dat |
| dg_broker_config_file2 | /opt/oracle/product/23c/dbhomeFree/dbs/dr2FREE.dat |
| dg_broker_start | FALSE |
| diagnostic_dest | /opt/oracle |
| diagnostics_control | IGNORE |
| disable_pdb_feature | 0 |
| disk_asynch_io | TRUE |
| dispatchers | (PROTOCOL=TCP) (SERVICE=FREEXDB) |
| distributed_lock_timeout | 60 |
| dml_locks | 2208 |
| dnfs_batch_size | 4096 |
| drcp_connection_limit | 0 |
| drcp_dedicated_opt | NO |
| dst_upgrade_insert_conv | TRUE |
| enable_automatic_maintenance_pdb | TRUE |
| enable_ddl_logging | FALSE |
| enable_dnfs_dispatcher | FALSE |
| enable_goldengate_replication | FALSE |
| enable_imc_with_mira | FALSE |
| enable_per_pdb_drcp | FALSE |
| enable_pluggable_database | TRUE |
| enabled_PDBs_on_standby | * |
| encrypt_new_tablespaces | CLOUD_ONLY |
| event | |
| external_keystore_credential_location | |
| fal_client | |
| fal_server | |
| fast_start_io_target | 0 |
| fast_start_mttr_target | 0 |
| fast_start_parallel_rollback | LOW |
| file_mapping | FALSE |
| fileio_network_adapters | |
| filesystemio_options | none |
| fixed_date | |
| forward_listener | |
| gcs_server_processes | 0 |
| global_names | FALSE |
| global_txn_processes | 1 |
| group_by_position_enabled | FALSE |
| hash_area_size | 131072 |
| heartbeat_batch_size | 5 |
| heat_map | OFF |
| hi_shared_memory_address | 0 |
| hs_autoregister | TRUE |
| http_proxy | |
| hybrid_read_only | FALSE |
| identity_provider_config | |
| identity_provider_type | NONE |
| ifile | |
| ignore_session_set_param_errors | |
| inmemory_adg_enabled | TRUE |
| inmemory_automatic_level | OFF |
| inmemory_clause_default | |
| inmemory_deep_vectorization | TRUE |
| inmemory_expressions_usage | ENABLE |
| inmemory_force | DEFAULT |
| inmemory_graph_algorithm_execution | DEFAULT |
| inmemory_max_populate_servers | 0 |
| inmemory_optimized_arithmetic | DISABLE |
| inmemory_prefer_xmem_memcompress | |
| inmemory_prefer_xmem_priority | |
| inmemory_query | ENABLE |
| inmemory_size | 0 |
| inmemory_trickle_repopulate_servers_percent | 1 |
| inmemory_virtual_columns | MANUAL |
| inmemory_xmem_size | 0 |
| instance_abort_delay_time | 0 |
| instance_groups | |
| instance_mode | READ-WRITE |
| instance_name | FREE |
| instance_number | 0 |
| instance_type | RDBMS |
| instant_restore | FALSE |
| iorm_limit_policy | RM_PLAN |
| ipddb_enable | FALSE |
| java_jit_enabled | TRUE |
| java_max_sessionspace_size | 0 |
| java_pool_size | 0 |
| java_restrict | none |
| java_soft_sessionspace_limit | 0 |
| job_queue_processes | 40 |
| json_behavior_flags | |
| json_expression_check | off |
| kafka_config_file | |
| large_pool_size | 0 |
| ldap_directory_access | NONE |
| ldap_directory_sysauth | no |
| license_max_sessions | 0 |
| license_max_users | 0 |
| license_sessions_warning | 0 |
| listener_networks | |
| load_without_compile | NONE |
| lob_signature_enable | FALSE |
| local_listener | |
| lock_name_space | |
| lock_sga | FALSE |
| log_archive_config | |
| log_archive_dest | |
| log_archive_dest_1 | |
| log_archive_dest_10 | |
| log_archive_dest_11 | |
| log_archive_dest_12 | |
| log_archive_dest_13 | |
| log_archive_dest_14 | |
| log_archive_dest_15 | |
| log_archive_dest_16 | |
| log_archive_dest_17 | |
| log_archive_dest_18 | |
| log_archive_dest_19 | |
| log_archive_dest_2 | |
| log_archive_dest_20 | |
| log_archive_dest_21 | |
| log_archive_dest_22 | |
| log_archive_dest_23 | |
| log_archive_dest_24 | |
| log_archive_dest_25 | |
| log_archive_dest_26 | |
| log_archive_dest_27 | |
| log_archive_dest_28 | |
| log_archive_dest_29 | |
| log_archive_dest_3 | |
| log_archive_dest_30 | |
| log_archive_dest_31 | |
| log_archive_dest_4 | |
| log_archive_dest_5 | |
| log_archive_dest_6 | |
| log_archive_dest_7 | |
| log_archive_dest_8 | |
| log_archive_dest_9 | |
| log_archive_dest_state_1 | enable |
| log_archive_dest_state_10 | enable |
| log_archive_dest_state_11 | enable |
| log_archive_dest_state_12 | enable |
| log_archive_dest_state_13 | enable |
| log_archive_dest_state_14 | enable |
| log_archive_dest_state_15 | enable |
| log_archive_dest_state_16 | enable |
| log_archive_dest_state_17 | enable |
| log_archive_dest_state_18 | enable |
| log_archive_dest_state_19 | enable |
| log_archive_dest_state_2 | enable |
| log_archive_dest_state_20 | enable |
| log_archive_dest_state_21 | enable |
| log_archive_dest_state_22 | enable |
| log_archive_dest_state_23 | enable |
| log_archive_dest_state_24 | enable |
| log_archive_dest_state_25 | enable |
| log_archive_dest_state_26 | enable |
| log_archive_dest_state_27 | enable |
| log_archive_dest_state_28 | enable |
| log_archive_dest_state_29 | enable |
| log_archive_dest_state_3 | enable |
| log_archive_dest_state_30 | enable |
| log_archive_dest_state_31 | enable |
| log_archive_dest_state_4 | enable |
| log_archive_dest_state_5 | enable |
| log_archive_dest_state_6 | enable |
| log_archive_dest_state_7 | enable |
| log_archive_dest_state_8 | enable |
| log_archive_dest_state_9 | enable |
| log_archive_duplex_dest | |
| log_archive_format | %t_%s_%r.dbf |
| log_archive_max_processes | 4 |
| log_archive_min_succeed_dest | 1 |
| log_archive_trace | 0 |
| log_buffer | 4292608 |
| log_checkpoint_interval | 0 |
| log_checkpoint_timeout | 1800 |
| log_checkpoints_to_alert | FALSE |
| log_file_name_convert | |
| long_module_action | TRUE |
| main_workload_type | OLTP |
| mandatory_user_profile | |
| max_auth_servers | 25 |
| max_columns | STANDARD |
| max_datapump_jobs_per_pdb | AUTO |
| max_datapump_parallel_per_job | AUTO |
| max_dispatchers | |
| max_dump_file_size | 32M |
| max_idle_blocker_time | 0 |
| max_idle_time | 0 |
| max_iops | 0 |
| max_mbps | 0 |
| max_pdbs | 254 |
| max_saga_duration | 86400 |
| max_shared_servers | |
| max_string_size | STANDARD |
| memoptimize_pool_size | 0 |
| memoptimize_write_area_size | 0 |
| memoptimize_writes | HINT |
| memory_max_size | 0 |
| memory_max_target | 0 |
| memory_size | 0 |
| memory_target | 0 |
| min_auth_servers | 1 |
| multilingual_engine | enable |
| multishard_query_data_consistency | strong |
| multishard_query_partial_results | not allowed |
| native_blockchain_features | |
| nls_calendar | |
| nls_comp | BINARY |
| nls_currency | |
| nls_date_format | |
| nls_date_language | |
| nls_dual_currency | |
| nls_iso_currency | |
| nls_language | AMERICAN |
| nls_length_semantics | BYTE |
| nls_nchar_conv_excp | FALSE |
| nls_numeric_characters | |
| nls_sort | |
| nls_territory | AMERICA |
| nls_time_format | |
| nls_time_tz_format | |
| nls_timestamp_format | |
| nls_timestamp_tz_format | |
| noncdb_compatible | FALSE |
| object_cache_max_size_percent | 10 |
| object_cache_optimal_size | 51200000 |
| ofs_threads | 4 |
| olap_page_pool_size | 0 |
| one_step_plugin_for_pdb_with_tde | FALSE |
| open_cursors | 300 |
| open_links | 4 |
| open_links_per_instance | 4 |
| optimizer_adaptive_plans | TRUE |
| optimizer_adaptive_reporting_only | FALSE |
| optimizer_adaptive_statistics | FALSE |
| optimizer_capture_sql_plan_baselines | FALSE |
| optimizer_capture_sql_quarantine | FALSE |
| optimizer_cross_shard_resiliency | FALSE |
| optimizer_dynamic_sampling | 2 |
| optimizer_features_enable | 23.1.0 |
| optimizer_ignore_hints | FALSE |
| optimizer_ignore_parallel_hints | FALSE |
| optimizer_index_caching | 0 |
| optimizer_index_cost_adj | 100 |
| optimizer_inmemory_aware | TRUE |
| optimizer_mode | ALL_ROWS |
| optimizer_real_time_statistics | FALSE |
| optimizer_secure_view_merging | TRUE |
| optimizer_session_type | NORMAL |
| optimizer_use_invisible_indexes | FALSE |
| optimizer_use_pending_statistics | FALSE |
| optimizer_use_sql_plan_baselines | TRUE |
| optimizer_use_sql_quarantine | TRUE |
| os_authent_prefix | ops$ |
| os_roles | FALSE |
| outbound_dblink_protocols | ALL |
| parallel_adaptive_multi_user | FALSE |
| parallel_degree_limit | CPU |
| parallel_degree_policy | MANUAL |
| parallel_execution_message_size | 16384 |
| parallel_force_local | FALSE |
| parallel_instance_group | |
| parallel_max_servers | 1 |
| parallel_min_degree | 1 |
| parallel_min_percent | 0 |
| parallel_min_servers | 1 |
| parallel_min_time_threshold | AUTO |
| parallel_servers_target | 1 |
| parallel_threads_per_cpu | 1 |
| pdb_file_name_convert | |
| pdb_lockdown | |
| pdb_os_credential | |
| pdb_template | |
| pdc_file_size | 2101248 |
| permit_92_wrap_format | FALSE |
| pga_aggregate_limit | 2147483648 |
| pga_aggregate_target | 536870912 |
| pkcs11_library_location | |
| plscope_settings | IDENTIFIERS:NONE |
| plsql_ccflags | |
| plsql_code_type | INTERPRETED |
| plsql_debug | FALSE |
| plsql_implicit_conversion_bool | FALSE |
| plsql_optimize_level | 2 |
| plsql_v2_compatibility | FALSE |
| plsql_warnings | DISABLE:ALL |
| pmem_filestore | |
| pre_page_sga | TRUE |
| private_temp_table_prefix | ORA$PTT_ |
| processes | 320 |
| processor_group_name | |
| query_rewrite_enabled | TRUE |
| query_rewrite_integrity | enforced |
| rdbms_server_dn | |
| read_only | FALSE |
| read_only_open_delayed | FALSE |
| recovery_parallelism | 0 |
| recyclebin | on |
| redo_transport_user | |
| remote_dependencies_mode | TIMESTAMP |
| remote_listener | |
| remote_login_passwordfile | EXCLUSIVE |
| remote_os_roles | FALSE |
| remote_recovery_file_dest | |
| replication_dependency_tracking | TRUE |
| resource_limit | TRUE |
| resource_manage_goldengate | FALSE |
| resource_manager_cpu_allocation | 0 |
| resource_manager_cpu_scope | INSTANCE_ONLY |
| resource_manager_plan | |
| result_cache_auto_blocklist | ON |
| result_cache_execution_threshold | 2 |
| result_cache_integrity | TRUSTED |
| result_cache_max_result | 5 |
| result_cache_max_size | 8126464 |
| result_cache_max_temp_result | 5 |
| result_cache_max_temp_size | 81264640 |
| result_cache_mode | MANUAL |
| result_cache_remote_expiration | 0 |
| resumable_timeout | 0 |
| rollback_segments | |
| saga_hist_retention | 43200 |
| scheduler_follow_pdbtz | FALSE |
| sec_max_failed_login_attempts | 3 |
| sec_protocol_error_further_action | (DROP,3) |
| sec_protocol_error_trace_action | TRACE |
| sec_return_server_release_banner | FALSE |
| serial_reuse | disable |
| service_names | FREE |
| session_cached_cursors | 50 |
| session_exit_on_package_state_error | FALSE |
| session_max_open_files | 10 |
| sessions | 502 |
| sga_max_size | 1610612736 |
| sga_min_size | 0 |
| sga_target | 1610612736 |
| shadow_core_dump | partial |
| shard_enable_raft_follower_read | TRUE |
| shard_queries_restricted_by_key | FALSE |
| shared_memory_address | 0 |
| shared_pool_reserved_size | 25836912 |
| shared_pool_size | 0 |
| shared_server_sessions | |
| shared_servers | 1 |
| shrd_dupl_table_refresh_rate | 60 |
| skip_unusable_indexes | TRUE |
| smtp_out_server | |
| soda_behavior_flags | |
| sort_area_retained_size | 0 |
| sort_area_size | 65536 |
| spatial_vector_acceleration | TRUE |
| spfile | /opt/oracle/product/23c/dbhomeFree/dbs/spfileFREE.ora |
| sql92_security | TRUE |
| sql_error_mitigation | off |
| sql_history_enabled | FALSE |
| sql_trace | FALSE |
| sql_transpiler | OFF |
| sqltune_category | DEFAULT |
| ssl_wallet | |
| standby_db_preserve_states | NONE |
| standby_file_management | MANUAL |
| standby_pdb_source_file_dblink | |
| standby_pdb_source_file_directory | |
| star_transformation_enabled | FALSE |
| statement_redirect_service | |
| statistics_level | TYPICAL |
| streams_pool_size | 0 |
| sysdate_at_dbtimezone | FALSE |
| tablespace_encryption | MANUAL_ENABLE |
| tablespace_encryption_default_algorithm | AES256 |
| tape_asynch_io | TRUE |
| target_pdbs | 3 |
| tde_configuration | |
| tde_key_cache | FALSE |
| temp_undo_enabled | FALSE |
| thread | 0 |
| threaded_execution | FALSE |
| time_at_dbtimezone | off |
| timed_os_statistics | 0 |
| timed_statistics | TRUE |
| timezone_version_upgrade_integrity | enforced |
| timezone_version_upgrade_online | FALSE |
| trace_enabled | TRUE |
| tracefile_content_classification | DISABLE |
| tracefile_identifier | |
| transactions | 552 |
| transactions_per_rollback_segment | 5 |
| true_cache | FALSE |
| txn_auto_rollback_high_priority_wait_target | 2147483647 |
| txn_auto_rollback_medium_priority_wait_target | 2147483647 |
| txn_auto_rollback_mode | ROLLBACK |
| txn_priority | HIGH |
| undo_management | AUTO |
| undo_retention | 900 |
| undo_tablespace | UNDOTBS1 |
| unified_audit_common_systemlog | |
| unified_audit_systemlog | |
| uniform_log_timestamp_format | TRUE |
| use_dedicated_broker | NONE |
| use_large_pages | TRUE |
| user_dump_dest | /opt/oracle/product/23c/dbhomeFree/rdbms/log |
| wallet_root | |
| workarea_size_policy | AUTO |
| xml_client_side_decoding | true |
| xml_db_events | enable |
| xml_handling_of_invalid_chars | raise_error |
| NLS Settings | |
| Parameter | Value |
| NLS_CHARACTERSET | AL32UTF8 |
| NLS_NCHAR_CHARACTERSET | AL16UTF16 |
| NLS_NUMERIC_CHARACTERS | ., |
| Operating System Infos | |
| Parameter | Value |
| Platform | Linux x86 64-bit |
| LOAD | 2.4 |
| NUM_CPUS | 2.0 |
| PHYSICAL_MEMORY_BYTES | 6,232,616,960.0 |
| Timezone info | ||||
| SYSDATE | CURRENT_DATE | DB TIMEZONE | Session TIMEZONE | OS TIMEZONE |
| 2023-04-14 15:52 | 2023-04-14 15:52 | +00:00 | +00:00 | +00:00 |
TABLESPACE_NAME USED_SPACE TABLESPACE_SIZE USED_PERCENT -------------------------------- ------------------ ------------------ ------------ SYSAUX 68,440 3,903,876 1.75 SYSTEM 147,200 3,981,956 3.70 TEMP 0 3,902,943 .00 UNDOTBS1 2,736 4,194,302 .07 USERS 128 3,834,116 .00 TSPACE TOT_TS_SIZE USED_MB FREE_TS_SIZE FREE_PCT USED_PCT USED_PCT_OF_MAX ------------------------------ ----------- -------- ------------ -------- -------- --------------- SYSAUX 550 535 15 3 97 2 SYSTEM 1160 1150 10 1 99 4 USERS 5 1 4 80 20 0
TS# NAME BIG FSH BCK ENC
-------- -------------------------------- --- --- --- ---
0 SYSTEM NO YES YES
0 SYSTEM NO YES YES
0 SYSTEM NO YES YES
1 SYSAUX NO YES YES
1 SYSAUX NO YES YES
1 SYSAUX NO YES YES
2 UNDOTBS1 NO YES YES
2 UNDOTBS1 NO YES YES
2 UNDOTBS1 NO YES YES
3 TEMP NO YES NO
3 TEMP NO YES NO
3 TEMP NO YES NO
4 USERS NO YES YES
6 USERS NO YES YES
STARTUP_TIME VERSION DB_NAME INSTANCE_NAME HOST_NAME ------------------------------ ----------------- --------- ---------------- ------------------------------------ 01-APR-23 03.44.00.000 PM 23.0.0.0.0 FREE FREE 8e87fa98e181 28-MAR-23 01.27.55.000 PM 23.0.0.0.0 FREE FREE c060a90c6edf 28-MAR-23 01.24.31.000 PM 23.0.0.0.0 FREE FREE c060a90c6edf 28-MAR-23 01.23.59.000 PM 23.0.0.0.0 FREE FREE c060a90c6edf
TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE -------------------------------- -------------------- -------------------- -------------------- TEMP 356,515,840 346,030,080 353,370,112 TMP_FILE_NAME TS# BYTES STATUS ENABLED INST_ID ---------------------------------------------------------------------- -------- -------------------- ------- ---------- -------- /opt/oracle/oradata/FREE/FREEPDB1/temp01.dbf 3 20,971,520 ONLINE READ WRITE 1 /opt/oracle/oradata/FREE/pdbseed/temp01.dbf 3 20,971,520 ONLINE READ WRITE 1 /opt/oracle/oradata/FREE/temp01.dbf 3 356,515,840 ONLINE READ WRITE 1 TABLESPACE_NAME TOTAL_BLOCKS USED_BLOCKS FREE_BLOCKS INST_ID -------------------------------- ------------ ----------- ----------- -------- TEMP 42112 256 41856 1 TEMP 384 0 384 1 TEMP 256 256 0 1
USERNAME INST_ID SYSDB SYSOP SYSAS ------------------------------ -------- ----- ----- ----- SYS 1 TRUE TRUE FALSE
WINDOW_NAME WINDOW_NEXT_TIME WINDO AUTOTASK OPTIMIZE SEGMENT_ SQL_TUNE -------------------- ---------------------------------------- ----- -------- -------- -------- -------- SATURDAY_WINDOW 15-APR-23 06.00.00.000000 AM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED MONDAY_WINDOW 17-APR-23 10.00.00.000000 PM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED TUESDAY_WINDOW 18-APR-23 10.00.00.000000 PM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED WEDNESDAY_WINDOW 19-APR-23 10.00.00.000000 PM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED SUNDAY_WINDOW 16-APR-23 06.00.00.000000 AM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED THURSDAY_WINDOW 20-APR-23 10.00.00.000000 PM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED FRIDAY_WINDOW 01-APR-23 10.00.00.000000 PM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED
SQL_ID CHILD PLAN EXECS AVG_TIME AVG_PAR OFFLOAD IO_SAVED
-------------------- ------ ------------- ---------------- ----------- ------- ---------- --------
SQL1
--------------------------------------------------------------------------------------------------------------------------------
8dyqsnz4h0g64 0 1258687637 1 2 .0 No .0
select '<tr><tr><td>'||OWNER||'<td align="right">'||count(*)||'<td>'||max(to_char(LAST_ANALYZED, '
3j65syxxhmmz3 1 0 1 2 .0 No .0
insert into UMF$_ATSK_HIST(dbid,epoch_time, event_time,TASK_ID,CON_ID,INST_ID,SCHEDULED_TIME,SCHEDULED_TIME_TZ,START_TIME,START
cnq31548hb8un 1 0 1 2 .0 No .0
BEGIN :c := dbms_spm_internal.auto_purge_sql_plan_baseline; END;
01uy9sb7w8a9g 1 0 1 1 .0 No .0
begin dbms_aqadm_sys.remove_all_nondurablesub(:1, :2); end;
4crwz7bpxyfv1 0 2374470273 1 1 .0 No .0
select '<tr><tr><td>'||OWNER||'<td align="right">'||count(*)||'<td>'||max(to_char(LAST_ANALYZED, '
cqf7m0y17q4gh 0 1301944989 1 1 .0 No .0
select '<tr><td>'||owner||'<td>'||type, '<td align="right">'||to_char(count(distinct name), '999,999,99
43fkz4bw76gdj 0 1301944989 1 1 .0 No .0
select '<tr><td>TOTAL<td>'||type, '<td align="right">'||to_char(count(distinct name||owner), '999,999,9
05gbgtc2arhtg 0 3227934528 1 1 .0 No .0
select 'A) Hit ratio buffer cache (>80%): '|| to_char(round(1-( sum(decode(name,'physical reads',1,0)*value) /(sum(d
3v6x6h8uk596j 0 3347134668 1 0 .0 No .0
select '<tr><td>'||owner||'<td>'|| data_type, '<td align="right">'||to_char(count(*), '999,999,999')||
01uy9sb7w8a9g 0 0 1 0 .0 No .0
begin dbms_aqadm_sys.remove_all_nondurablesub(:1, :2); end;
bj1mt6pa09d3p 0 0 4 0 .0 No .0
BEGIN DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE ( job_name => :job_name, argument_position => 2, argume
6ajyr40qfxwfb 0 3347134668 1 0 .0 No .0
select '<tr><td>TOTAL<td>'|| data_type, '<td align="right">'||to_char(count(*), '999,999,999')|| '<
c3hftja47uhcn 0 2408407531 1 0 .0 No .0
select '<tr><td>'||job_name||'<td>'||owner||'<td>'||repeat_interval||'<td>'||start_date, '&
ac8wzzswuaxq6 1 3220912584 1 0 .0 No .0
select min(next_date) from "SYS"."AQ$_AQ_PROP_TABLE_T"
7726p6dfnygh7 0 829386060 2 0 .0 No .0
select o.obj#,o.type#,u.name,o.name,o.flags from obj$ o,user$ u where u.user#=o.owner# and (o.type#=28 or ((o.type#=29 or o.t
g46qxpvaxz8px 0 846273774 1 0 .0 No .0
select '<tr><td>'||l.sid, '<td>'||l.type, '<td>'||decode(l.lmode, 0, 'WAITING', 1,'Null', 2, 'Row Share'
9djgpkwnfw7r0 0 368750712 0 0 .0 No .0
SELECT /*CROSSCON*/ /*SYS."CDB_SUPPLEMENTAL_LOGGING"*/ /*"K"*/ /* ID */ * FROM "SYS"."DBA_SUPPLEMENTAL_LOGGING"
dfk4vps483sqh 0 3802468062 1 0 .0 No .0
select TABLESPACE_NAME, USED_SPACE, TABLESPACE_SIZE, USED_PERCENT from dba_tablespace_usage_metrics order by TABLESPACE_NAME
4qftj2g9hq6ut 0 2798709625 1 0 .0 No .0
select * from DBA_AUTOTASK_WINDOW_CLIENTS
9xnwcv885gta0 0 4254711693 1 0 .0 No .0
select /*+ no_monitor no_statement_queuing current_instance */ alljobs.CON_ID, OBJOID, RETRYCNT, alljobs.FLAGS, STATUS
SQL_ID CHILD PLAN EXECS AVG_TIME AVG_PAR OFFLOAD IO_SAVED
-------------------- ------ ------------- ---------------- ----------- ------- ---------- --------
SQL1
--------------------------------------------------------------------------------------------------------------------------------
a63yan528cvy2 0 3684871272 50,244 0 .0 No .0
SELECT TEXT FROM SYS.VIEW$ WHERE ROWID = :1
9tgj4g8y4rwy8 0 3755742892 45,986 0 .0 No .0
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, N
gftq4wv1kaaz2 0 1523033141 24,672 0 .0 No .0
SELECT STATUS FROM REGISTRY$ WHERE CID=:B1 AND NAMESPACE = SYS.DBMS_REGISTRY.SESSION_NAMESPACE
6r819rmzn7pdz 0 1388734953 24,672 0 .0 No .0
SELECT DECODE( :B1 , 0, 'INVALID', 1, 'VALID', 2, 'LOADING', 3, 'LOADED', 4, 'UPGRADING', 5, 'UPGRADED', 6, 'DOWNGRADING', 7, 'D
0sbbcuruzd66f 0 2239883476 13,732 0 .0 No .0
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
0sbbcuruzd66f 2 2239883476 10,229 0 .0 No .0
select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival,
87gaftwrm2h68 0 1072382624 9,909 0 .0 No .0
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=:1
d7rfcjyhcsnaf 0 660002331 8,224 0 .0 No .0
SELECT NULL FROM SYS.REGISTRY$ WHERE CID = :B1 AND NAMESPACE = SYS.DBMS_REGISTRY.SESSION_NAMESPACE
53saa2zkr6wc3 0 3038981986 3,358 0 .0 No .0
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1
acmvv4fhdc9zh 1 813480514 3,016 0 .0 No .0
select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2, spare3, signature, spare7, spare8, spare9, n
04kug40zbu4dm 0 4006480256 2,931 0 .0 No .0
select policy#, action# from aud_object_opt$ where object# = :1 and type = 2
dkpbcdcp1bwpb 0 2013599597 2,931 0 .0 No .0
select policy#, action#, intcol# from sys.aud_objcol_opt$ where object# = :1
5c4sr912n136n 0 1097271556 2,743 0 .0 No .0
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ SPARE4, SVAL1 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1
9fcnmy8r0xhnv 0 324713838 2,743 0 .0 No .0
SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'false') */ P.VALCHAR, P.VALNUM FROM SYS.OPTSTAT_USER_PREFS$ P WHERE P.OBJ#=:
0gwaa0289rasu 0 299250003 2,206 0 .0 No .0
select /*+ rule */ pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1
87gaftwrm2h68 5 1072382624 1,946 0 .0 No .0
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=:1
53saa2zkr6wc3 5 3038981986 1,740 0 .0 No .0
select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1
0gwaa0289rasu 2 299250003 1,513 0 .0 No .0
select /*+ rule */ pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1
gd28w82ct6rva 0 2970138452 1,509 0 .0 No .0
select audit$ from tab$ where obj# = :1
5pnxt7ap1kvc0 0 2582313431 1,352 0 .0 No .0
select position#,sequence#,level#,argument,type#,charsetid,charsetform,properties,nvl(length, 0), nvl(precision#, 0),nvl(scale,
PATCH_DATE ID ACTION VERSION COMMENTS
-------------------- -------- ------------ ---------------- ------------------------------
BOOTSTRAP 23 RDBMS_23.2.0.0.0_LINUX.X64_230
BOOTSTRAP 23 ca1d019aff30b2db3fdfd55985a596
BOOTSTRAP 23 bbb2f23fd9daadd3bd5ae8004db503
BOOTSTRAP 23 cc33d7b58f7f4efa82f56bcd4e4cc6
BOOTSTRAP 23 d2fe47aaebec6dc08dbc7f7caad78a
Alert and Trace Files
------------------------------------------------------------------------------------------------------------------------------------
plsql
ios
crs
asm
diagtool
em
acfs
gsm
netcman
afdboot
orapwd
asmtool
dps
plsqlapp
rdbms
free
i_1.mif
free
trace
free_ora_903.trm
free_pmon_1502.trm
free_dbw0_653.trc
free_lg01_884.trc
free_vktm_785.trm
free_pman_822.trm
free_ora_2360.trc
free_dia0_1555_lws_1.trm
free_gcw0_731.trc
free_dia0_826.trc
free_mman_1524.trm
PARAMETER VALUE -------------------------------------------- -------------------------------------------------------------------------------- max_pdbs 254 CONNECTION_NAME CONNECTION_ID DATA_SCOPE -------------------- -------------------- ---------- CDB$ROOT 1 Root
DB_NAME CREATED CDB -------------------- --------- --- FREE 28-MAR-23 YES INSTANCE_NAME HOST_NAME STATUS STARTUP_TIME EDITION -------------------- -------------------------------------------------- ------------ ------------------------------ ------- FREE 8e87fa98e181 OPEN 2023-04-14 15:43:31 FREE
CON_ID PDB_NAME OPEN_MODE TOTAL_SIZE
-------- -------------------- ---------- --------------------
2 PDB$SEED READ ONLY 744,488,960
3 FREEPDB1 READ WRITE 749,731,840
CON_ID CON_NAME INSTANCE_NAME SAVED_STATE
-------- -------------------- -------------------- --------------
3 FREEPDB1 FREE OPEN
DB_NAME CON_ID PDB_NAME OPERATION OP_TIMEST CLONED_FROM -------------------- -------- -------------------- ---------------- --------- -------------------- FREE 3 FREEPDB1 CREATE 28-MAR-23 PDB$SEED
PROPERTY_NAME PROPERTY_VALUE ---------------------------------------- -------------------- LOCAL_UNDO_ENABLED TRUE
adg_account_info_tracking allow_rowid_column_type allow_weak_crypto approx_for_aggregation approx_for_count_distinct approx_for_percentile aq_tm_processes asm_diskstring auto_start_pdb_services awr_pdb_autoflush_enabled bitmap_merge_area_size blank_trimming blockchain_table_max_no_drop blockchain_table_retention_threshold cell_offload_compaction cell_offload_decryption cell_offload_parameters cell_offload_plan_display cell_offload_processing cell_offloadgroup_name client_prefetch_rows client_result_cache_lag client_result_cache_size client_statistics_level commit_logging commit_point_strength commit_wait commit_write common_user_prefix container_data containers_parallel_degree cpu_count cpu_min_count create_bitmap_area_size create_stored_outlines cursor_bind_capture_destination cursor_invalidation cursor_sharing db_block_checking db_cache_size db_create_file_dest db_create_online_log_dest_1 db_create_online_log_dest_2 db_create_online_log_dest_3 db_create_online_log_dest_4 db_create_online_log_dest_5 db_domain db_file_multiblock_read_count db_file_name_convert db_files db_index_compression_inheritance db_performance_profile db_securefile db_unrecoverable_scn_tracking ddl_lock_timeout default_sharing deferred_segment_creation distributed_lock_timeout drcp_connection_limit drcp_dedicated_opt dst_upgrade_insert_conv enable_automatic_maintenance_pdb enable_ddl_logging encrypt_new_tablespaces fast_start_parallel_rollback fixed_date forward_listener global_names group_by_position_enabled heartbeat_batch_size heat_map hybrid_read_only identity_provider_config identity_provider_type ignore_session_set_param_errors inmemory_automatic_level inmemory_clause_default inmemory_deep_vectorization inmemory_expressions_usage inmemory_force inmemory_graph_algorithm_execution inmemory_optimized_arithmetic inmemory_prefer_xmem_memcompress inmemory_prefer_xmem_priority inmemory_query inmemory_size inmemory_virtual_columns inmemory_xmem_size java_jit_enabled job_queue_processes json_behavior_flags json_expression_check ldap_directory_access ldap_directory_sysauth listener_networks load_without_compile lob_signature_enable local_listener log_archive_min_succeed_dest long_module_action main_workload_type mandatory_user_profile max_auth_servers max_columns max_datapump_jobs_per_pdb max_datapump_parallel_per_job max_dump_file_size max_idle_blocker_time max_idle_time max_iops max_mbps max_pdbs max_string_size min_auth_servers multilingual_engine multishard_query_data_consistency multishard_query_partial_results native_blockchain_features nls_calendar nls_comp nls_currency nls_date_format nls_date_language nls_dual_currency nls_iso_currency nls_language nls_length_semantics nls_nchar_conv_excp nls_numeric_characters nls_sort nls_territory nls_time_format nls_time_tz_format nls_timestamp_format nls_timestamp_tz_format object_cache_max_size_percent object_cache_optimal_size olap_page_pool_size open_cursors open_links optimizer_adaptive_plans optimizer_adaptive_reporting_only optimizer_adaptive_statistics optimizer_capture_sql_plan_baselines optimizer_capture_sql_quarantine optimizer_cross_shard_resiliency optimizer_dynamic_sampling optimizer_features_enable optimizer_ignore_hints optimizer_ignore_parallel_hints optimizer_index_caching optimizer_index_cost_adj optimizer_inmemory_aware optimizer_mode optimizer_real_time_statistics optimizer_secure_view_merging optimizer_use_invisible_indexes optimizer_use_pending_statistics optimizer_use_sql_plan_baselines optimizer_use_sql_quarantine parallel_degree_limit parallel_degree_policy parallel_force_local parallel_instance_group parallel_max_servers parallel_min_degree parallel_min_time_threshold parallel_servers_target pdb_file_name_convert pdb_lockdown pdb_os_credential pdb_template pga_aggregate_limit pga_aggregate_target pkcs11_library_location plscope_settings plsql_ccflags plsql_code_type plsql_debug plsql_implicit_conversion_bool plsql_optimize_level plsql_v2_compatibility plsql_warnings private_temp_table_prefix query_rewrite_enabled query_rewrite_integrity recyclebin remote_dependencies_mode remote_listener remote_recovery_file_dest resource_limit resource_manager_plan result_cache_auto_blocklist result_cache_execution_threshold result_cache_max_result result_cache_max_size result_cache_max_temp_result result_cache_max_temp_size result_cache_mode result_cache_remote_expiration resumable_timeout rollback_segments scheduler_follow_pdbtz session_cached_cursors session_exit_on_package_state_error sessions sga_min_size sga_target shadow_core_dump shard_enable_raft_follower_read shard_queries_restricted_by_key shared_pool_size shared_servers shrd_dupl_table_refresh_rate skip_unusable_indexes smtp_out_server soda_behavior_flags sort_area_retained_size sort_area_size spatial_vector_acceleration sql92_security sql_error_mitigation sql_history_enabled sql_trace sql_transpiler sqltune_category star_transformation_enabled statement_redirect_service statistics_level sysdate_at_dbtimezone tablespace_encryption_default_algorithm tde_configuration tde_key_cache temp_undo_enabled time_at_dbtimezone timed_os_statistics timed_statistics timezone_version_upgrade_integrity timezone_version_upgrade_online txn_auto_rollback_high_priority_wait_target txn_auto_rollback_medium_priority_wait_targe t txn_auto_rollback_mode undo_management undo_retention undo_tablespace unified_audit_systemlog workarea_size_policy xml_client_side_decoding xml_db_events xml_handling_of_invalid_chars
NAME VALUE -------------------------------------------- -------------------------------------------------------------------------------- inmemory_adg_enabled TRUE inmemory_automatic_level OFF inmemory_clause_default inmemory_deep_vectorization TRUE inmemory_expressions_usage ENABLE inmemory_force DEFAULT inmemory_graph_algorithm_execution DEFAULT inmemory_max_populate_servers 0 inmemory_optimized_arithmetic DISABLE inmemory_prefer_xmem_memcompress inmemory_prefer_xmem_priority inmemory_query ENABLE inmemory_size 0 inmemory_trickle_repopulate_servers_percent 1 inmemory_virtual_columns MANUAL inmemory_xmem_size 0
HTTP_PORT HTTPS_PORT
--------- ----------
0 0
Home and Inventory
------------------------------------------------------------------------------------------------------------------------------------
Oracle Home : /opt/oracle/product/23c/dbhomeFree
Inventory : /opt/oracle/oraInventory
bundle_series
*
ERROR at line 7:
ORA-00904: "BUNDLE_SERIES": invalid identifier
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE_SER
-------------------- ---------- -------------------- ---------- -------- ------------------------------ ----------
BOOTSTRAP DATAPATCH 23 RDBMS_23.2.0.0.0_LINUX.X64_230
BOOTSTRAP DATAPATCH_DBMSSQLPAT 23 ca1d019aff30b2db3fdfd55985a596
CH
BOOTSTRAP DATAPATCH_PRVTQOPI 23 bbb2f23fd9daadd3bd5ae8004db503
BOOTSTRAP DATAPATCH_DBMSQOPI 23 cc33d7b58f7f4efa82f56bcd4e4cc6
BOOTSTRAP DATAPATCH_PRVTSQLPAT 23 d2fe47aaebec6dc08dbc7f7caad78a
CH
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE_SER
-------------------- ---------- -------------------- ---------- -------- ------------------------------ ----------
BOOTSTRAP DATAPATCH 23 RDBMS_23.2.0.0.0_LINUX.X64_230
BOOTSTRAP DATAPATCH_DBMSSQLPAT 23 ca1d019aff30b2db3fdfd55985a596
CH
BOOTSTRAP DATAPATCH_PRVTQOPI 23 bbb2f23fd9daadd3bd5ae8004db503
BOOTSTRAP DATAPATCH_DBMSQOPI 23 cc33d7b58f7f4efa82f56bcd4e4cc6
BOOTSTRAP DATAPATCH_PRVTSQLPAT 23 d2fe47aaebec6dc08dbc7f7caad78a
CH
P CONNECTION_TEST_T SQL_CONNECTION_TEST SERVICE_NAME E - ----------------- ---------------------------------------------------------------- -------------------- - Y SQL_TEST SELECT 1 FROM DUAL Y Y SQL_TEST SELECT COUNT(*) FROM DUAL Y Y SQL_TEST SELECT 1 Y Y SQL_TEST BEGIN NULL;END Y Y PING_TEST NA N Y ENDREQUEST_TEST NA N Y BEGINREQUEST_TEST NA Y
| Disk Groups | |||||||||
| Disk Group | Disk Group# | Type | Total GB | Free GB | Used GB | Free% | Allocation Unit Size | State | Offline Disks |
| Usage | |||
| Type | Group# | GB | Bytes |
| Clients | |||
| Disk Group | Instance | DB Name | Status |
HOST_NAME DB_NAME DB_UNIQUE_NAME INSTANCE_NAME -------------------------------------------------- -------------------- ------------------------------ -------------------- 8e87fa98e181 FREE FREE FREE
EVENT TOTAL_WAITS TIME_WAITED_SECS AVG_MS ---------------------------------------------------------------- ---------------- ---------------- ------- db file sequential read 51,593 28 .55
TIME_CATEGORY TIME_SECS PCT ---------------------------------------------------------------- --------- ------- CPU 208.97 42.92 User I/O 85.33 17.52 Concurrency 81.23 16.68 Other 60.14 12.35 Scheduler 39.55 8.12 System I/O 11.36 2.33 Commit .13 0.03 Configuration .1 0.02 Application .06 0.01 Network .03 0.01 Administrative .02 0.00
INST_ID TABLESPACE_NAME SEGMENT_FILE TOTAL_BLOCKS USED_BLOCKS FREE_BLOCKS MAX_USED_BLOCKS MAX_SORT_BLOCKS
-------- -------------------------------- ------------ ------------ ----------- ----------- --------------- ---------------
1 TEMP 0 42112 256 41856 42112 41856
1 TEMP 0 384 0 384 0 0
1 TEMP 0 256 256 0 256 128
INST_ID TABLESPACE_NAME EXTENT_BLOCK_USED BLOCKS_CACHED
-------- -------------------------------- ----------------- -------------
1 TEMP 256 42112
1 TEMP 0 384
1 TEMP 256 256
INST_ID TABLESPACE_NAME HEADER_BLOCK_USED BLOCKS_FREE
-------- -------------------------------- ----------------- -----------
1 TEMP 42240 1280
1 TEMP 512 2048
1 TEMP 384 2176
INST_ID FREE_REQUESTS FREED_EXTENTS
-------- ------------- -------------
1 0 0
1 0 0
1 0 0
OPERATION VALUE ---------------------------------------------------------------- ---------------- Parallel operations not downgraded 0 Parallel operations downgraded to serial 0 Parallel operations downgraded 75 to 99 pct 0 Parallel operations downgraded 50 to 75 pct 0 Parallel operations downgraded 25 to 50 pct 0 Parallel operations downgraded 1 to 25 pct 0
INSTANCE_NAME DB_TIME_SECS DB_TIME_PCT CPU_TIME_SECS CPU_TIME_PCT -------------------- ------------ ----------- ------------- ------------ FREE 301.21 100 209.14 100 INSTANCE_NAME LOGICAL_READS GC_BLOCKS_RECIEVED PHYSICAL_READS PHYS_TO_LOGICAL_PCT GC_TO_LOGICAL_PCT -------------------- -------------------- ------------------ ---------------- ------------------- ----------------- FREE 2,315,500 0 105,107 4.54 0
INSTANCE_NAME INSTANCE_ROLE DATABASE_STATUS HOST_NAME
-------------------- ------------------ ----------------- --------------------------------------------------
FREE PRIMARY_INSTANCE ACTIVE 8e87fa98e181
NAME DATABASE_ROLE OPEN_MODE CONTROLFIL SWITCHOVER_STATUS PROTECTION_MODE FLASH LOG_MODE FORCE
---------------- ---------------- -------------------- ---------- -------------------- -------------------- ----- ------------ -----
FREE PRIMARY READ WRITE CURRENT NOT ALLOWED MAXIMUM PERFORMANCE NO NOARCHIVELOG NO
SYSDATE CURRENT_SCN SCN_TIME SCN_TIME_FORMATTED
-------------------- ---------------- --------------------- --------------------
2023-04-14 15:52 3117843 01-APR-23 03.52.50.00 2023-04-14 15:52
EST_GAP_IN_MINUTES
------------------
LOGS GROUP# THREAD# SEQUENCE# ARC STATUS SIZE_MB
-------- -------- -------- --------- --- ------ --------
RedoLog 1 1 1 NO INACTI 200
RedoLog 2 1 2 NO CURREN 200
RedoLog 3 1 0 YES UNUSED 200
ARC_DEST_TYPE INST_ID DEST_ID STATUS ARCHIVED_SEQ# DEST_NAME DESTINATION
---------------- -------- -------- ------ ------------- -------------------- ------------------------------------------------------
LOCAL 1 1 VALID 0 LOG_ARCHIVE_DEST_1 /opt/oracle/product/23c/dbhomeFree/dbs/arch
NAME FS_FAILOVER_STATUS FS_FAIL
---------------- ---------------------- -------
FREE DISABLED
Estd Phys Estd Phys
Cache Size (MB) Buffers Read Factor Reads
---------------- ------------ ----------- ----------------
96 11,748 1.27 81,663
192 23,496 1.02 65,600
288 35,244 1.00 64,556
384 46,992 1.00 64,556
480 58,740 1.00 64,556
576 70,488 1.00 64,556
672 82,236 1.00 64,556
768 93,984 1.00 64,556
864 105,732 1.00 64,556
960 117,480 1.00 64,556
1,024 125,312 1.00 64,556
1,056 129,228 1.00 64,556
1,152 140,976 1.00 64,556
1,248 152,724 1.00 64,556
1,344 164,472 1.00 64,556
1,440 176,220 1.00 64,556
1,536 187,968 1.00 64,556
1,632 199,716 1.00 64,556
1,728 211,464 1.00 64,556
1,824 223,212 1.00 64,556
1,920 234,960 1.00 64,556
NAMESPACE PINS PINHITS RELOADS INVALIDATIONS -------------------------------- -------- -------- -------- ------------- ACCOUNT_STATUS 0 0 0 0 APP CONTEXT 6 3 0 0 APP STATE 0 0 0 0 AUDIT POLICY 576 541 3 0 BODY 1396 1152 65 0 CLUSTER 2807 2748 4 0 DBINSTANCE 0 0 0 0 DBLINK 0 0 0 0 DIRECTORY 62 51 0 0 EDITION 138 110 4 0 FED APP 1300 1292 3 0 INDEX 1287 846 18 0 JAVA DATA 3 0 0 0 JAVA SOURCE 1 0 0 0 OBJECT ID 0 0 0 0 PDB 0 0 0 0 PDBOPER 0 0 0 0 QUEUE 8 4 0 0 RULESET 3 2 0 0 SCHEMA 0 0 0 0 SQL AREA 416194 395531 3170 1320 SQL AREA BUILD 0 0 0 0 SQL AREA STATS 6207 275 0 0 SUBSCRIPTION 6 0 0 0 TABLE/PROCEDURE 157136 145619 2467 0 TRIGGER 832 763 35 0 USER PRIVILEGE 4 2 1 0 XDB CONFIG 1 0 0 0 XML SCHEMA 9 0 0 0
IS_OMF COUNT(*)
-------- --------
0 5
NAME VALUE ------------------------------------------------------- -------------------------------------------------- db_create_file_dest db_create_online_log_dest_1 db_create_online_log_dest_2 db_create_online_log_dest_3 db_create_online_log_dest_4 db_create_online_log_dest_5 db_recovery_file_dest db_recovery_file_dest_size 0
NAME FNAME TS_NUM IS_OMF ------------------------------------------------------- ------------------------------------------------------- -------- -------- /opt/oracle/oradata/FREE/system01.dbf /opt/oracle/oradata/FREE/system01.dbf 0 0 /opt/oracle/oradata/FREE/sysaux01.dbf /opt/oracle/oradata/FREE/sysaux01.dbf 1 0 /opt/oracle/oradata/FREE/undotbs01.dbf /opt/oracle/oradata/FREE/undotbs01.dbf 2 0 /opt/oracle/oradata/FREE/temp01.dbf /opt/oracle/oradata/FREE/temp01.dbf 3 0 /opt/oracle/oradata/FREE/users01.dbf /opt/oracle/oradata/FREE/users01.dbf 4 0
ITEM ALLOCATED_SPACE OWNER MOVE_PROC
------------------------- -------------------- -------------------- ----------------------------------------
SDO 128,064 MDSYS MDSYS.MOVE_SDO
XDB 101,248 XDB XDB.DBMS_XDB_ADMIN.MOVEXDB_TABLESPACE
SM/AWR 73,216 SYS
AO 48,576 SYS DBMS_AW.MOVE_AWMETA
AUDSYS 40,960 AUDSYS DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION
SM/OTHER 14,848 SYS
SM/OPTSTAT 14,464 SYS
SM/ADVISOR 13,888 SYS
LOGMNR 11,392 SYSTEM SYS.DBMS_LOGMNR_D.SET_TABLESPACE
SQL_MANAGEMENT_BASE 8,064 SYS
WM 7,488 WMSYS DBMS_WM.move_proc
PL/SCOPE 3,136 SYS
TEXT 3,072 CTXSYS DRI_MOVE_CTXSYS
JOB_SCHEDULER 2,496 SYS
STREAMS 2,048 SYS
AUTO_TASK 704 SYS
SMON_SCN_TIME 256 SYS
SM/SQLMON/REPORTS 192 SYS
TSM 0 TSMSYS
EM_MONITORING_USER 0 DBSNMP
EXPRESSION_FILTER 0 EXFSYS
ULTRASEARCH_DEMO_USER 0 WK_TEST MOVE_WK
ULTRASEARCH 0 WKSYS MOVE_WK
EM 0 SYSMAN emd_maintenance.move_em_tblspc
ORDIM/SI_INFORMTN_SCHEMA 0 SI_INFORMTN_SCHEMA ordsys.ord_admin.move_ordim_tblspc
ORDIM/ORDPLUGINS 0 ORDPLUGINS ordsys.ord_admin.move_ordim_tblspc
ORDIM/ORDDATA 0 ORDDATA ordsys.ord_admin.move_ordim_tblspc
ORDIM 0 ORDSYS ordsys.ord_admin.move_ordim_tblspc
STATSPACK 0 PERFSTAT
XSOQHIST 0 SYS DBMS_XSOQ.OlapiMoveProc
XSAMD 0 OLAPSYS DBMS_AMD.Move_OLAP_Catalog
AUDIT_TABLES 0 SYS DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION
LOGSTDBY 0 SYSTEM SYS.DBMS_LOGSTDBY.SET_TABLESPACE
Total Usage 474,112
Statistics retention
RETENTION
---------
31
RMAN Configuration Backup Job Details Backup Set Details RMAN Output
Customer scripts
Version: Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release CPU: 2 CORE: 2 SOCKET: 1
1.05E+08 Elapsed: 00:00:08.21 1.05E+08 Elapsed: 00:00:08.08
Generating migration scripts in log directory...
Statistics generated on: 01-APR-2023 15:53:11
For more info contact Meo Bogliolo.