Statistics generated on: 23-AUG-2015 21:09:16
by: SYS
using: ora2html.sql v.1.0.28d
Software by
Meo Bogliolo
| Summary | |
| Item | Value |
| Database : | TST02 |
| Version : | 12.1.0.2.0 |
| Created : | 23-AUG-2015 20:21:49 |
| Started : | 23-AUG-2015 20:44:43 |
| DB Size (MB) : | 2,870 |
| Used Space (MB) : | 2,314 |
| SGA (MB) : | 3,024 |
| Log archiving : | ARCHIVELOG |
| Defined Users : | 41 |
| Defined Schemata : | 21 |
| Defined Tables : | 1433 |
| Sessions : | 46 |
| Sessions (active) : | 3 |
| Hostname : | XeniaTest02 |
| Instance : | TST02 |
| Archiver : | STARTED |
| RedoLog Writes Day (MB) : | 146 |
| Versions |
| Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production |
| PL/SQL Release 12.1.0.2.0 - Production |
| CORE 12.1.0.2.0 Production |
| TNS for Linux: Version 12.1.0.2.0 - Production |
| NLSRTL Version 12.1.0.2.0 - Production |
| Component | Description | Version |
| APEX | Oracle Application Express | 5.0.0.00.31 |
| APS | OLAP Analytic Workspace | 12.1.0.2.0 |
| CATALOG | Oracle Database Catalog Views | 12.1.0.2.0 |
| CATJAVA | Oracle Database Java Packages | 12.1.0.2.0 |
| CATPROC | Oracle Database Packages and Types | 12.1.0.2.0 |
| CONTEXT | Oracle Text | 12.1.0.2.0 |
| DV | Oracle Database Vault | 12.1.0.2.0 |
| JAVAVM | JServer JAVA Virtual Machine | 12.1.0.2.0 |
| OLS | Oracle Label Security | 12.1.0.2.0 |
| ORDIM | Oracle Multimedia | 12.1.0.2.0 |
| OWM | Oracle Workspace Manager | 12.1.0.2.0 |
| RAC | Oracle Real Application Clusters | 12.1.0.2.0 |
| SDO | Spatial | 12.1.0.2.0 |
| XDB | Oracle XML Database | 12.1.0.2.0 |
| XML | Oracle XDK | 12.1.0.2.0 |
| XOQ | Oracle OLAP API | 12.1.0.2.0 |
| Tablespaces | |||||
| Tablespace | Total | Occuped | PCT | Max_free | Max_extent |
| SYSAUX | 1,090,519,040 | 1,032,847,360 | 94% | 50,331,648 | 54 |
| SYSTEM | 912,261,120 | 905,510,912 | 99% | 5,701,632 | 110 |
| UNDOTBS1 | 1,001,390,080 | 487,849,984 | 48% | 38,797,312 | 136 |
| USERS | 5,242,880 | 393,216 | 7% | 3,801,088 | 1 |
| TOTAL | 2,870 MB | 2,314 MB | - | - | - |
| Schema/Object Matrix | |||||||||||||
| Owner | Tabs | Idxs | Trgs | Pkgs | PBod | Proc | Func | Seqs | Syns | Views | Type | LOB | Total |
| APEX_040200 | 452 | 1518 | 457 | 271 | 263 | 16 | 11 | 3 | 11 | 211 | 6 | 198 | 3421 |
| APEX_050000 | 465 | 1581 | 498 | 273 | 266 | 16 | 8 | 4 | 10 | 254 | 14 | 204 | 3602 |
| APEX_LISTENER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 0 | 0 | 0 | 22 |
| APPQOSSYS | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 5 |
| AUDSYS | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 12 |
| C##DBAAS_BACKUP | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 3 |
| C##DBAAS_MONITOR | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 2 | 0 | 0 | 15 | 1 | 37 |
| C##PDBMGR | 19 | 47 | 24 | 6 | 6 | 0 | 0 | 1 | 8 | 1 | 3 | 6 | 121 |
| CTXSYS | 53 | 68 | 0 | 77 | 66 | 2 | 2 | 3 | 0 | 81 | 36 | 4 | 409 |
| DBSNMP | 20 | 10 | 0 | 3 | 3 | 1 | 0 | 2 | 1 | 7 | 8 | 0 | 55 |
| DVF | 0 | 0 | 0 | 1 | 1 | 0 | 17 | 0 | 0 | 0 | 0 | 0 | 19 |
| DVSYS | 34 | 63 | 0 | 19 | 19 | 4 | 21 | 18 | 1 | 76 | 32 | 0 | 292 |
| FLOWS_FILES | 1 | 6 | 1 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 1 | 14 |
| GSMADMIN_INTERNAL | 21 | 21 | 4 | 7 | 7 | 0 | 0 | 4 | 0 | 4 | 30 | 1 | 108 |
| LBACSYS | 22 | 30 | 3 | 23 | 22 | 9 | 24 | 3 | 0 | 77 | 9 | 0 | 237 |
| MDSYS | 139 | 253 | 62 | 77 | 73 | 3 | 116 | 15 | 0 | 88 | 192 | 113 | 1873 |
| OJVMSYS | 6 | 7 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 1 | 16 |
| OLAPSYS | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 18 | 2 | 0 | 25 |
| ORACLE_OCM | 0 | 0 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 |
| ORDDATA | 90 | 155 | 0 | 0 | 0 | 0 | 0 | 13 | 0 | 25 | 0 | 9 | 292 |
| ORDPLUGINS | 0 | 0 | 0 | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 |
| ORDSYS | 5 | 4 | 0 | 30 | 22 | 7 | 32 | 0 | 0 | 5 | 446 | 0 | 3157 |
| OUTLN | 3 | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 10 |
| PUBLIC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37095 | 0 | 0 | 0 | 37095 |
| SI_INFORMTN_SCHEMA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 0 | 8 |
| SYS | 1265 | 1427 | 12 | 722 | 695 | 153 | 114 | 157 | 19 | 5735 | 1664 | 203 | 41950 |
| SYSTEM | 178 | 260 | 2 | 1 | 1 | 1 | 4 | 22 | 8 | 14 | 9 | 23 | 641 |
| WMSYS | 42 | 69 | 45 | 23 | 23 | 1 | 0 | 6 | 0 | 142 | 15 | 8 | 389 |
| XDB | 51 | 364 | 8 | 44 | 42 | 4 | 6 | 5 | 0 | 5 | 87 | 293 | 986 |
| TOTAL | 2876 | 5897 | 1118 | 1586 | 1518 | 219 | 356 | 262 | 37189 | 6743 | 2568 | 1067 | 94815 |
| Invalid Objects | |||||||||||
| Owner | Table | Index | Trigger | Package | P. Body | Proc. | Func. | Sequence | Synonym | View | Total |
| C##DBAAS_MONITOR | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 |
| Invalid Indexes | ||
| Owner | Indexes | Status |
| Owner | Index Partitions | Status |
| Invalid Datafiles | |
| Datafile | Status |
| Invalid Blocks | ||
| File# | Block# | Corruption Type |
| Space Usage | ||||||||
| Tablespace | Total | Tables | Table Part.s | Table SubP.s | Indexes | Index Part.s | LOBs | Clusters |
| SYSAUX | 985 | 124 | 1 | 0 | 8 | 0 | 356 | 0 |
| SYSTEM | 864 | 508 | 0 | 0 | 84 | 0 | 11 | 57 |
| UNDOTBS1 | 465 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| USERS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| TOTAL (MB) | 2,314 | 632 | 1 | 0 | 92 | 0 | 367 | 57 |
| Container | Bytes |
| Recycle Bin |
| Partitioning | |
| Owner | #Partitioned Tables |
| AUDSYS | 1 |
| Partitioning Details | ||||
| Owner | Table | Partitions | Rows | Est. Size |
| AUDSYS | CLI_SWP$2f516430$1$1 | 1 | 16 | 0 |
| Partitions Details | |||||
| Owner | Table | Tablespace | Partition | Rows | Sub.Partitions |
| AUDSYS | CLI_SWP$2f516430$1$1 | SYSAUX | HIGH_PART | 16 | 0 |
| ... |
| Parallel degree | ||
| Degree | Instances | #Tables |
| DEFAULT | DEFAULT | 2 |
| 1 | 1 | 1351 |
| 1 | 0 | 5 |
| Compression | ||
| Owner | Compression | #Tables |
| TOTAL | Compressed Tables | 0 |
| Owner | Compression | #Indexes |
| APEX_040200 | ENABLED | 25 |
| APEX_050000 | ENABLED | 62 |
| CTXSYS | ENABLED | 1 |
| TOTAL | Compressed Indexes | 88 |
| Spatial Option | |
| Owner | Spatial Tables |
| TOTAL | 0 |
|
|
|
| Datafiles | ||||
| Tablespace | Datafile | Bytes | Read # | Write # |
| SYSAUX | /u02/app/oracle/oradata/TST02/sysaux01.dbf | 1,090,519,040 | 43,946 | 1,221 |
| SYSTEM | /u02/app/oracle/oradata/TST02/system01.dbf | 912,261,120 | 23,055 | 639 |
| UNDOTBS1 | /u02/app/oracle/oradata/TST02/undotbs01.dbf | 1,001,390,080 | 1,523 | 171 |
| USERS | /u02/app/oracle/oradata/TST02/users01.dbf | 5,242,880 | 38 | 2 |
Autoextend datafiles: /u02/app/oracle/oradata/TST02/system01.dbf /u02/app/oracle/oradata/TST02/sysaux01.dbf /u02/app/oracle/oradata/TST02/undotbs01.dbf /u02/app/oracle/oradata/TST02/users01.dbf
| 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 | /u02/app/oracle/oradata/TST02/undotbs01.dbf | 1,001,390,080 | YES |
| Undo Extents | |||
| Tablespace | Status | # | Bytes |
| UNDOTBS1 | EXPIRED | 325 | 463,732,736 |
| UNDOTBS1 | UNEXPIRED | 23 | 24,117,248 |
| Tuned retention | |||
| AVG | MAX | MIN | Std DEV |
| 1299 | 1514 | 1186 | 186 |
| Log Files | ||||
| Group# | Log File | Status | Bytes | Thread |
| 1 | /u04/app/oracle/redo/redo01.log | INACTIVE | 1,073,741,824 | 1 |
| 2 | /u04/app/oracle/redo/redo02.log | CURRENT | 1,073,741,824 | 1 |
| 3 | /u04/app/oracle/redo/redo03.log | UNUSED | 1,073,741,824 | 1 |
|
|
| Archived Logs | ||||
| Creator | Registrar | Status | Archived | Count |
| ARCH | ARCH | A | YES | 1 |
| Control File Informations |
FILES ---------------------------------------------------------------------------------------------------------------------------------- /u02/app/oracle/oradata/TST02/control01.ctl, /u03/app/oracle/fast_recovery_area/TST02/control02.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 6 0 DATAFILE 520 1024 22 0 0 100 0 FILENAME 524 4146 22 0 0 0 0 TABLESPACE 68 1024 15 0 0 9 0 TEMPORARY FILENAME 56 1024 3 0 0 3 0 RMAN CONFIGURATION 1108 50 5 0 0 5 0 LOG HISTORY 56 292 1 1 1 1 0 OFFLINE RANGE 200 1063 37 1 37 37 0 ARCHIVED LOG 584 308 1 1 1 1 0 BACKUP SET 96 1022 1 1 1 1 0 BACKUP PIECE 780 1006 1 1 1 1 0 BACKUP DATAFILE 200 1063 1 1 1 1 0 BACKUP REDOLOG 76 215 0 0 0 0 0 DATAFILE COPY 736 1000 5 1 5 5 0 BACKUP CORRUPTION 44 1115 0 0 0 0 0 COPY CORRUPTION 40 1227 0 0 0 0 0 DELETED OBJECT 20 818 6 1 6 6 0 PROXY COPY 928 1004 0 0 0 0 0 BACKUP SPFILE 124 131 1 1 1 1 0 DATABASE INCARNATION 56 292 2 1 2 2 0 FLASHBACK LOG 84 2048 2 0 0 0 0 RECOVERY DESTINATION 180 1 1 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 5 1 5 5 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 31 31 0 0 0 0 GUARANTEED RESTORE POINT 212 2048 0 0 0 0 0 RESTORE POINT 212 2083 0 0 0 0 0 DATABASE BLOCK CORRUPTION 80 8384 0 0 0 0 0 ACM OPERATION 104 64 9 0 0 0 0 FOREIGN ARCHIVED LOG 604 1002 0 0 0 0 0 PDB RECORD 684 10 3 0 0 4 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
| Recovery Area Usage |
RECOVERY_DEST_SIZE ---------------------------------------------------------------------------------------------------------------------------------- db_recovery_file_dest_size: 45097156608 (42GB) FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES CON_ID ----------------------- ------------------ ------------------------- --------------- -------- CONTROL FILE 0 0 0 0 REDO LOG 0 0 0 0 ARCHIVED LOG .56 0 1 0 BACKUP PIECE .04 0 1 0 IMAGE COPY 0 0 0 0 FLASHBACK LOG 4.76 0 2 0 FOREIGN ARCHIVED LOG 0 0 0 0 AUXILIARY DATAFILE COPY 0 0 0 0 FREE_RECOVERY_PCT ----------------------------------------- 94%
| Users | |||
| Username | Default Tablespace | Temporary Tablespace | Status |
| ANONYMOUS | SYSAUX | TEMP | EXPIRED & LOCKED |
| APEX_040200 | SYSAUX | TEMP | EXPIRED & LOCKED |
| APEX_050000 | SYSAUX | TEMP | EXPIRED & LOCKED |
| APEX_LISTENER | USERS | TEMP | OPEN |
| APEX_PUBLIC_USER | USERS | TEMP | OPEN |
| APEX_REST_PUBLIC_USER | USERS | TEMP | OPEN |
| APPQOSSYS | SYSAUX | TEMP | EXPIRED & LOCKED |
| AUDSYS | USERS | TEMP | EXPIRED & LOCKED |
| C##DBAAS_BACKUP | USERS | TEMP | OPEN |
| C##DBAAS_MONITOR | USERS | TEMP | OPEN |
| C##PDBMGR | SYSAUX | TEMP | OPEN |
| CTXSYS | SYSAUX | TEMP | EXPIRED & LOCKED |
| DBSNMP | SYSAUX | TEMP | EXPIRED & LOCKED |
| DIP | USERS | TEMP | EXPIRED & LOCKED |
| DVF | SYSAUX | TEMP | EXPIRED & LOCKED |
| DVSYS | SYSAUX | TEMP | EXPIRED & LOCKED |
| FLOWS_FILES | SYSAUX | TEMP | EXPIRED & LOCKED |
| GSMADMIN_INTERNAL | SYSAUX | TEMP | EXPIRED & LOCKED |
| GSMCATUSER | USERS | TEMP | EXPIRED & LOCKED |
| GSMUSER | USERS | TEMP | EXPIRED & LOCKED |
| LBACSYS | SYSTEM | TEMP | EXPIRED & LOCKED |
| MDDATA | USERS | TEMP | EXPIRED & LOCKED |
| MDSYS | SYSAUX | TEMP | EXPIRED & LOCKED |
| OJVMSYS | USERS | TEMP | EXPIRED & LOCKED |
| OLAPSYS | SYSAUX | TEMP | EXPIRED & LOCKED |
| ORACLE_OCM | USERS | TEMP | EXPIRED & LOCKED |
| ORDDATA | SYSAUX | TEMP | EXPIRED & LOCKED |
| ORDPLUGINS | SYSAUX | TEMP | EXPIRED & LOCKED |
| ORDSYS | SYSAUX | TEMP | EXPIRED & LOCKED |
| OUTLN | SYSTEM | TEMP | EXPIRED & LOCKED |
| SI_INFORMTN_SCHEMA | SYSAUX | TEMP | EXPIRED & LOCKED |
| SPATIAL_CSW_ADMIN_USR | USERS | TEMP | EXPIRED & LOCKED |
| SPATIAL_WFS_ADMIN_USR | USERS | TEMP | EXPIRED & LOCKED |
| SYS | SYSTEM | TEMP | OPEN |
| SYSBACKUP | USERS | TEMP | EXPIRED & LOCKED |
| SYSDG | USERS | TEMP | EXPIRED & LOCKED |
| SYSKM | USERS | TEMP | EXPIRED & LOCKED |
| SYSTEM | SYSTEM | TEMP | OPEN |
| WMSYS | SYSAUX | TEMP | EXPIRED & LOCKED |
| XDB | SYSAUX | TEMP | EXPIRED & LOCKED |
| XS$NULL | USERS | TEMP | EXPIRED & LOCKED |
| TOTAL | 41 |
| Password file users |
USERNAME INST_ID SYSDB SYSOP ------------------------------ -------- ----- ----- C##PDBMGR 1 TRUE TRUE PDB_ADMIN 1 TRUE FALSE SYS 1 TRUE TRUE SYSBACKUP 1 FALSE FALSE SYSDG 1 FALSE FALSE SYSKM 1 FALSE FALSE
| Users with default passwords | |
| Username | Status |
See also 11g Encryption.
| Licensing | |
| Detected Edition: | Enterprise |
| Parameter | Value |
| USER max | 0 |
| SESSION max | 0 |
| SESSION curr./HiW. | 6 / 21 |
| CPU curr./HiW. | 2 / 2 |
| CORE curr./HiW. | 1 / 1 |
| SOCKET curr./HiW. | 1 / 1 |
| Diagnostic and tuning pack enabled | DIAGNOSTIC+TUNING |
| In-Memory enabled (12c) | ENABLE |
| 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 backup and recovery, Parallel execution, Parallel load, Point-in-time tablespace recovery, Fine-grained access control, Proxy authentication/authorization, Change Data Capture, Plan Stability, Online Index Build, Coalesce Index, Managed Standby, Materialized view rewrite, Database resource manager, 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, Enterprise User Security, Oracle Data Guard, Oracle Label Security, OLAP, Basic Compression, Join index, Trial Recovery, Advanced Analytics, Online Redefinition, Streams Capture, File Mapping, Block Change Tracking, Flashback Table, Flashback Database, Transparent Data Encryption, Backup Encryption, Unused Block Compression, Result Cache, SQL Plan Management, SecureFiles Encryption, Real Application Testing, Flashback Data Archive, DICOM, Active Data Guard, Server Flash Cache, Advanced Compression, XStream, Deferred Segment Creation, Exadata Discovery, Data Mining, Global Data Services, Adaptive Execution Plans, Table Clustering, Zone Maps, Real Application Security, Privilege Analysis, Data Redaction, Cross Transportable Backups, Cache Fusion Lock Accelerator, Snapshot time recovery, Heat Map, Automatic Data Optimization, Transparent Sensitive Data Protection, In-Memory Column Store, Advanced Index Compression, In-Memory Aggregation, | Real Application Clusters, Automatic Storage Management, Oracle Database Vault, Unified Auditing, Management Database, I/O Server, ASM Proxy Instance, |
| Features Used | ||||
| Name | Count | First | Last | Description |
| Features NOT in Use | ||
| Name | Count | Description |
| ADDM | 0 | ADDM has been used. |
| 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 |
| Adaptive Plans | 0 | Adaptive Plans have been used |
| Advanced Index Compression | 0 | Advanced Index Compression is used |
| Advanced Replication | 0 | Advanced Replication has been enabled. |
| Application Express | 0 | Application Express feature is being used. |
| Automatic Maintenance - Optimizer Statistics Gathering | 0 | Automatic initiation of Optimizer Statistics Collection |
| Automatic Maintenance - SQL Tuning Advisor | 0 | Automatic initiation of SQL Tuning Advisor |
| Automatic Maintenance - Space Advisor | 0 | Automatic initiation of Space Advisor |
| Automatic Memory Tuning | 0 | Automatic Memory Tuning is enabled. |
| Automatic Reoptimization | 0 | Automatic Reoptimization have been used |
| Automatic SGA Tuning | 0 | Automatic SGA Tuning is enabled. |
| Automatic SQL Execution Memory | 0 | Sizing of work areas for all dedicated sessions (PGA) is automatic. |
| Automatic SQL Tuning Advisor | 0 | Automatic SQL Tuning Advisor has been used. |
| Automatic Segment Space Management (system) | 0 | Extents of locally managed tablespaces are managed automatically by Oracle. |
| 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 Undo Management | 0 | Oracle automatically manages undo data using an UNDO tablespace. |
| 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 | RMAN's 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 Data Capture | 0 | Change Data Capture exit in the database |
| Change-Aware Incremental Backup | 0 | Track blocks that have changed in the database. |
| Character Semantics | 0 | Character length semantics is used in Oracle Database |
| Character Set | 0 | Character set is used in Oracle Database |
| Client Identifier | 0 | Application User Proxy Authentication: Client Identifier is used at this specific time. |
| Cloud DB with EHCC | 0 | EHCC used for Cloud Database |
| 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. |
| 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 |
| Deferred Segment Creation | 0 | Deferred Segment Creation is being used |
| 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 Express | 0 | EM Database Express has been used |
| 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. |
| 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 |
| 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 Row Level Locking | 0 | Hybrid Columnar Compression Row Level Locking is used |
| INSTANT RESTORE command | 0 | RMAN's INSTANT RESTORE command used by the database. |
| In-Memory Aggregation | 0 | In-Memory Aggregation is being used. |
| In-Memory Column Store | 0 | In-Memory Column Store is being used |
| Index Organized Tables | 0 | Index Organized Tables are being used |
| Information Lifecycle Management | 0 | Information Lifecycle Management is 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. |
| JSON | 0 | JSON feature is being used. |
| 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 |
| Locally Managed Tablespaces (system) | 0 | There exists tablespaces that are locally managed in the database. |
| Locally Managed Tablespaces (user) | 0 | There exists user tablespaces that are locally managed in the database. |
| 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. |
| Multiple Block Sizes | 0 | Multiple Block Sizes are being used with this database. |
| 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 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 (system) | 0 | OJVM default system users |
| 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 Multimedia | 0 | Oracle Multimedia has been used |
| Oracle Multimedia DICOM | 0 | Oracle Multimedia DICOM (Digital Imaging and COmmunications in Medicine) has been used |
| Oracle Pluggable Databases | 0 | Oracle Pluggable Databases is being used. |
| 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 | 0 | Oracle Utility External Table 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. |
| 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 (system) | 0 | Oracle Partitioning option is being used - there is at least one partitioned object created. |
| 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 |
| 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. |
| 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. |
| Resource Manager | 0 | Oracle Database Resource Manager is being used to manage database resources. |
| Restore Point | 0 | Restore Points are being used as targets for Flashback |
| Result Cache | 0 | The Result Cache feature has been 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 Directive | 0 | Sql plan directive 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 (system) | 0 | A SQL Tuning Set has been created in the database in the SYS schema. |
| 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. |
| 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 |
| SecureFiles (system) | 0 | SecureFiles is being used by system users |
| SecureFiles (user) | 0 | SecureFiles 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 Oracle Semantics Feature. |
| Server Flash Cache | 0 | Server Flash Cache is being used with this database. |
| Server Parameter File | 0 | The server parameter file (SPFILE) was used to startup the database. |
| Services | 0 | Oracle Services. |
| 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. |
| 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 | RMAN's TRANSPORT TABLESPACE command used by the database. |
| 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. |
| Unified Audit | 0 | Unified Audit in use. |
| 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 |
| High-Water Mark Statistics | ||
| Name | Maximum Value | Description |
| PART_TABLES | Maximum Number of Partitions belonging to an User Table | |
| PART_INDEXES | Maximum Number of Partitions belonging to an User Index | |
| USER_INDEXES | Number of User Indexes | |
| SESSIONS | Maximum Number of Concurrent Sessions seen in the database | |
| DB_SIZE | Maximum Size of the Database (Bytes) | |
| DATAFILES | Maximum Number of Datafiles | |
| TABLESPACES | Maximum Number of Tablespaces | |
| CPU_COUNT | Maximum Number of CPUs | |
| QUERY_LENGTH | Maximum Query Length | |
| SQL_NCHAR_COLUMNS | Maximum Number of SQL NCHAR Columns | |
| INSTANCES | Oracle Database instances | |
| USER_MV | Maximum Number of Materialized Views (User) | |
| ACTIVE_SESSIONS | Maximum Number of Active Sessions seen in the system | |
| HWM_DBMS_SCHEDULER | Number of job runs per day | |
| EXADATA_DISKS | Number of physical disks | |
| GLOBAL SERVICES | Number of global services | |
| USER_TABLES | Number of User Tables | |
| SEGMENT_SIZE | Size of Largest Segment (Bytes) |
| Per-User sessions | ||
| User | InstID | Count |
| APEX_PUBLIC_USER | 1 | 3 |
| TOTAL ( 1 distinct users ) | 3 |
| Current sessions | |||||||||
| SID,serial | User | OS User | Process | Type | Status | Command | Program | InstID | Logon |
| 1,18880 | SYS | oracle | 26532 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (PMON) | 1 | 2015-08-23 20:44:43 |
| 2,60954 | SYS | oracle | 26540 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (VKTM) | 1 | 2015-08-23 20:44:44 |
| 3,3844 | SYS | oracle | 26550 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (MMAN) | 1 | 2015-08-23 20:44:44 |
| 4,37880 | SYS | oracle | 26562 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (DIAG) | 1 | 2015-08-23 20:44:44 |
| 5,65261 | SYS | oracle | 26570 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (VKRM) | 1 | 2015-08-23 20:44:44 |
| 6,1963 | SYS | oracle | 26584 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (DBW0) | 1 | 2015-08-23 20:44:44 |
| 7,51824 | SYS | oracle | 26600 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (CKPT) | 1 | 2015-08-23 20:44:45 |
| 8,24244 | SYS | oracle | 26608 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (SMON) | 1 | 2015-08-23 20:44:45 |
| 9,30000 | SYS | oracle | 26616 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (RECO) | 1 | 2015-08-23 20:44:45 |
| 10,25205 | SYS | oracle | 26624 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (PXMN) | 1 | 2015-08-23 20:44:45 |
| 11,32352 | SYS | oracle | 26632 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (MMNL) | 1 | 2015-08-23 20:44:45 |
| 12,53752 | SYS | oracle | 26670 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (ARC0) | 1 | 2015-08-23 20:44:51 |
| 13,12361 | SYS | oracle | 26678 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (ARC2) | 1 | 2015-08-23 20:44:51 |
| 16,23441 | SYS | oracle | 26686 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (TT00) | 1 | 2015-08-23 20:44:51 |
| 17,7603 | SYS | oracle | 26694 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (W000) | 1 | 2015-08-23 20:44:52 |
| 19,33033 | SYS | oracle | 26706 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (AQPC) | 1 | 2015-08-23 20:44:53 |
| 21,43137 | SYS | oracle | 26893 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (CJQ0) | 1 | 2015-08-23 20:44:58 |
| 25,45366 | SYS | oracle | 27765 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (CTWR) | 1 | 2015-08-23 20:51:15 |
| 26,38953 | SYS | oracle | 1706 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (W004) | 1 | 2015-08-23 20:58:58 |
| 28,23281 | SYS | oracle | 26993 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (Q002) | 1 | 2015-08-23 20:45:03 |
| 30,19152 | SYS | oracle | 27001 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (Q004) | 1 | 2015-08-23 20:45:03 |
| 237,11485 | SYS | oracle | 1696 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (W003) | 1 | 2015-08-23 20:58:55 |
| 238,9581 | SYS | oracle | 26536 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (PSP0) | 1 | 2015-08-23 20:44:43 |
| 239,61968 | SYS | oracle | 26546 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (GEN0) | 1 | 2015-08-23 20:44:44 |
| 240,38249 | SYS | oracle | 26666 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (TMON) | 1 | 2015-08-23 20:44:51 |
| 241,50375 | SYS | oracle | 26566 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (DBRM) | 1 | 2015-08-23 20:44:44 |
| 242,22066 | SYS | oracle | 26575 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (DIA0) | 1 | 2015-08-23 20:44:44 |
| 243,13382 | SYS | oracle | 26596 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (LGWR) | 1 | 2015-08-23 20:44:44 |
| 244,44503 | SYS | oracle | 26604 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (LG00) | 1 | 2015-08-23 20:44:45 |
| 245,21975 | SYS | oracle | 26612 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (LG01) | 1 | 2015-08-23 20:44:45 |
| 246,4008 | SYS | oracle | 26620 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (LREG) | 1 | 2015-08-23 20:44:45 |
| 247,7456 | SYS | oracle | 26628 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (MMON) | 1 | 2015-08-23 20:44:45 |
| 250,58676 | SYS | oracle | 26674 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (ARC1) | 1 | 2015-08-23 20:44:51 |
| 251,19570 | SYS | oracle | 26682 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (ARC3) | 1 | 2015-08-23 20:44:51 |
| 252,23174 | SYS | oracle | 26690 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (SMCO) | 1 | 2015-08-23 20:44:52 |
| 253,3252 | SYS | oracle | 26698 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (W001) | 1 | 2015-08-23 20:44:52 |
| 256,9073 | SYS | oracle | 26945 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (RVWR) | 1 | 2015-08-23 20:44:59 |
| 258,18111 | SYS | oracle | 26985 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (QM02) | 1 | 2015-08-23 20:45:03 |
| 266,834 | SYS | oracle | 1888 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (W005) | 1 | 2015-08-23 20:59:22 |
| 272,50066 | SYS | oracle | 29773 | BACKGROUND | ACTIVE | No command | oracle@XeniaTest02 (W002) | 1 | 2015-08-23 20:54:52 |
| 32,45253 | SYS | oracle | 19166 | USER | ACTIVE | No command | oracle@XeniaTest02 (J001) | 1 | 2015-08-23 21:09:39 |
| 35,2351 | SYS | oracle | 18266 | USER | ACTIVE | Select | sqlplus@XeniaTest02 (TNS V1-V3) | 1 | 2015-08-23 21:09:05 |
| 257,32088 | SYS | oracle | 19161 | USER | ACTIVE | No command | oracle@XeniaTest02 (J000) | 1 | 2015-08-23 21:09:39 |
| 22,45442 | APEX_PUBLIC_USER | oracle | 29787 | USER | INACTIVE | No command | APEX Listener | 1 | 2015-08-23 20:54:59 |
| 263,12316 | APEX_PUBLIC_USER | oracle | 29791 | USER | INACTIVE | No command | APEX Listener | 1 | 2015-08-23 20:54:59 |
| 269,11130 | APEX_PUBLIC_USER | oracle | 29795 | USER | INACTIVE | No command | APEX Listener | 1 | 2015-08-23 20:54:59 |
| SQL | ||||||
| SID | User | Exec | Parse | Read | Get | Running SQL |
| Lock | ||||
| SID | Lock Type | Lock Mode | Request | Lock Count |
| 6 | MR | Share | HOLD | 15 |
| 6 | PW | Row Exclusive | HOLD | 1 |
| 7 | CF | Row Share | HOLD | 1 |
| 7 | RD | Null | HOLD | 1 |
| 7 | RS | Row Share | HOLD | 1 |
| 7 | XR | Null | HOLD | 1 |
| 8 | TS | Row Exclusive | HOLD | 2 |
| 22 | AE | Share | HOLD | 1 |
| 25 | CT | Exclusive | HOLD | 1 |
| 35 | AE | Share | HOLD | 1 |
| 241 | KD | Exclusive | HOLD | 1 |
| 241 | KT | Share | HOLD | 9 |
| 243 | RT | Exclusive | HOLD | 1 |
| 247 | AE | Share | HOLD | 1 |
| 247 | FD | Exclusive | HOLD | 1 |
| 256 | FL | Row Share | HOLD | 1 |
| 256 | FL | Share Row Exclusive | HOLD | 1 |
| 263 | AE | Share | HOLD | 1 |
| 269 | AE | Share | HOLD | 1 |
| Performance statistics |
A) Hit ratio buffer cache (>80%): 97.4% B1) Misses library cache (<1%): .87% B1.1) Detailed misses library cache (SQL AREA-248745): .784% B1.10) Detailed misses library cache (RULESET-3): 0% B1.11) Detailed misses library cache (SUBSCRIPTION-8): 0% B1.12) Detailed misses library cache (TEMPORARY TABLE-8): 75% B1.13) Detailed misses library cache (EDITION-544): 0% B1.14) Detailed misses library cache (DBLINK-0): 0% B1.15) Detailed misses library cache (OBJECT ID-0): 0% B1.16) Detailed misses library cache (SCHEMA-0): 0% B1.17) Detailed misses library cache (DBINSTANCE-0): 0% B1.18) Detailed misses library cache (SQL AREA STATS-8244): 0% B1.19) Detailed misses library cache (ACCOUNT_STATUS-0): 0% B1.2) Detailed misses library cache (TABLE/PROCEDURE-91046): 1.348% B1.20) Detailed misses library cache (SQL AREA BUILD-0): 0% B1.21) Detailed misses library cache (SECURITY CLASS-3): 0% B1.22) Detailed misses library cache (ACL-5): 0% B1.23) Detailed misses library cache (PDB-0): 0% B1.24) Detailed misses library cache (AUDIT POLICY-472): 0% B1.25) Detailed misses library cache (USER PRIVILEGE-14): 0% B1.26) Detailed misses library cache (PDBOPER-0): 0% B1.3) Detailed misses library cache (BODY-11945): .46% B1.4) Detailed misses library cache (TRIGGER-9902): .091% B1.5) Detailed misses library cache (INDEX-612): 1.144% B1.6) Detailed misses library cache (CLUSTER-2485): 0% B1.7) Detailed misses library cache (DIRECTORY-9): 0% B1.8) Detailed misses library cache (QUEUE-10): 0% B1.9) Detailed misses library cache (APP CONTEXT-9): 0% B2) Misses dictionary cache (<10%): 4.221% 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%): 0% E2) Hit ratio immediate redo alloc (<1%): 0% E3) Hit ratio redo copy (<1%): 0% E4) Hit ratio immediate redo copy (<1%): NA F) Free list contention (<1%): 0% G1) Sorts in memory: 39958 G2) Sorts on disk: 0 H1) Short tables full scans: 14414 H2) Long tables full scans: 0 I1 @1) Logon: 1188 I2 @1) Commit: 2909 I3 @1) Rollback: 1 |
| Stale Statistics | ||
| Owner | Table Stale Stats# | Last Analyzed |
| APEX_040200 | 14 | 2014-10-06 22:03:43 |
| APEX_050000 | 118 | 2015-06-24 14:00:53 |
| AUDSYS | 2 | 2014-10-06 22:08:22 |
| CTXSYS | 1 | 2014-07-07 06:11:31 |
| DBSNMP | 1 | 2014-10-06 22:02:14 |
| SYS | 227 | 2015-06-24 16:00:26 |
| XDB | 2 | 2014-07-07 05:55:02 |
| Owner | Index Stale Stats# | Last Analyzed |
| APEX_040200 | 48 | 2014-10-06 22:03:44 |
| APEX_050000 | 423 | 2015-06-24 14:00:53 |
| AUDSYS | 6 | 2014-10-06 22:08:23 |
| CTXSYS | 1 | 2014-07-07 06:11:31 |
| DBSNMP | 2 | 2014-10-06 22:02:15 |
| SYS | 287 | 2015-06-24 16:00:26 |
| XDB | 9 | 2014-07-07 05:55:02 |
| I/O Statistics | |
| Name | Value |
| Small Reads | 89465 |
| Small Writes | 7410 |
| Large Reads | 389 |
| Large Writes | 2589 |
| Total MB Read | 1143 |
| Total MB Written | 2504 |
| Biggest Objects | ||||
| Object | Type | Owner | Tablespace | Bytes |
| IDL_UB1$ | TABLE | SYS | SYSTEM | 327,155,712 |
| _SYSSMU5_750802473$ | TYPE2 UNDO | SYS | UNDOTBS1 | 278,724,608 |
| SOURCE$ | TABLE | SYS | SYSTEM | 83,886,080 |
| _SYSSMU4_4250244621$ | TYPE2 UNDO | SYS | UNDOTBS1 | 80,150,528 |
| SYS_LOB0000083702C00006$$ | LOBSEGMENT | MDSYS | SYSAUX | 54,722,560 |
| SYS_LOB0000093778C00007$$ | LOBSEGMENT | APEX_050000 | SYSAUX | 54,722,560 |
| _SYSSMU10_4058727488$ | TYPE2 UNDO | SYS | UNDOTBS1 | 51,511,296 |
| SYS_LOB0000006421C00005$$ | LOBSEGMENT | SYS | SYSAUX | 44,236,800 |
| IDL_UB2$ | TABLE | SYS | SYSTEM | 39,845,888 |
| C_TOID_VERSION# | CLUSTER | SYS | SYSTEM | 33,554,432 |
| SYS_LOB0000088338C00007$$ | LOBSEGMENT | APEX_040200 | SYSAUX | 24,313,856 |
| WWV_FLOW_PAGE_PLUGS | TABLE | APEX_040200 | SYSAUX | 19,922,944 |
| SYS_LOB0000085557C00004$$ | LOBSEGMENT | SYS | SYSAUX | 18,022,400 |
| SYS_LOB0000093255C00007$$ | LOBSEGMENT | APEX_050000 | SYSAUX | 16,973,824 |
| ARGUMENT$ | TABLE | SYS | SYSTEM | 16,777,216 |
| _SYSSMU6_3167659685$ | TYPE2 UNDO | SYS | UNDOTBS1 | 15,859,712 |
| C_OBJ# | CLUSTER | SYS | SYSTEM | 14,680,064 |
| _SYSSMU8_1462975257$ | TYPE2 UNDO | SYS | UNDOTBS1 | 13,762,560 |
| IDL_CHAR$ | TABLE | SYS | SYSTEM | 13,631,488 |
| WWV_FLOW_PAGE_PLUGS | TABLE | APEX_050000 | SYSAUX | 12,582,912 |
| OBJ$ | TABLE | SYS | SYSTEM | 12,582,912 |
| SYS_LOB0000010986C00001$$ | LOBSEGMENT | SYS | SYSAUX | 11,665,408 |
| _SYSSMU1_2326716099$ | TYPE2 UNDO | SYS | UNDOTBS1 | 11,665,408 |
| WWV_FLOW_STEP_ITEMS | TABLE | APEX_040200 | SYSAUX | 11,534,336 |
| C_OBJ#_INTCOL# | CLUSTER | SYS | SYSTEM | 11,534,336 |
| I_ARGUMENT1 | INDEX | SYS | SYSTEM | 11,534,336 |
| _SYSSMU2_1582804868$ | TYPE2 UNDO | SYS | UNDOTBS1 | 10,616,832 |
| SYS_LOB0000001255C00003$$ | LOBSEGMENT | SYS | SYSTEM | 10,485,760 |
| WWV_FLOW_TEMPLATES | TABLE | APEX_040200 | SYSAUX | 10,485,760 |
| _SYSSMU9_3739287458$ | TYPE2 UNDO | SYS | UNDOTBS1 | 9,568,256 |
| I_SOURCE1 | INDEX | SYS | SYSTEM | 9,437,184 |
| VIEW$ | TABLE | SYS | SYSTEM | 9,437,184 |
| ... |
| Most Fragmented Objects | |||||
| Object | Type | Owner | Tablespace | Extents | Bytes |
| _SYSSMU5_750802473$ | TYPE2 UNDO | SYS | UNDOTBS1 | 136 | 278,724,608 |
| IDL_UB1$ | TABLE | SYS | SYSTEM | 110 | 327,155,712 |
| AQ$_SUBSCRIBER_LWM | TABLE PARTITION | SYS | SYSTEM | 100 | 6,553,600 |
| SOURCE$ | TABLE | SYS | SYSTEM | 81 | 83,886,080 |
| _SYSSMU4_4250244621$ | TYPE2 UNDO | SYS | UNDOTBS1 | 74 | 80,150,528 |
| SYS_LOB0000093778C00007$$ | LOBSEGMENT | APEX_050000 | SYSAUX | 54 | 54,722,560 |
| SYS_LOB0000083702C00006$$ | LOBSEGMENT | MDSYS | SYSAUX | 54 | 54,722,560 |
| IDL_UB2$ | TABLE | SYS | SYSTEM | 53 | 39,845,888 |
| _SYSSMU10_4058727488$ | TYPE2 UNDO | SYS | UNDOTBS1 | 51 | 51,511,296 |
| C_TOID_VERSION# | CLUSTER | SYS | SYSTEM | 47 | 33,554,432 |
| SYS_LOB0000006421C00005$$ | LOBSEGMENT | SYS | SYSAUX | 44 | 44,236,800 |
| WWV_FLOW_PAGE_PLUGS | TABLE | APEX_040200 | SYSAUX | 34 | 19,922,944 |
| WRI$_OPTSTAT_SYNOPSIS$ | TABLE SUBPARTITION | SYS | SYSAUX | 32 | 2,097,152 |
| ARGUMENT$ | TABLE | SYS | SYSTEM | 31 | 16,777,216 |
| C_OBJ# | CLUSTER | SYS | SYSTEM | 29 | 14,680,064 |
| IDL_CHAR$ | TABLE | SYS | SYSTEM | 28 | 13,631,488 |
| WWV_FLOW_PAGE_PLUGS | TABLE | APEX_050000 | SYSAUX | 27 | 12,582,912 |
| OBJ$ | TABLE | SYS | SYSTEM | 27 | 12,582,912 |
| I_ARGUMENT1 | INDEX | SYS | SYSTEM | 26 | 11,534,336 |
| WWV_FLOW_STEP_ITEMS | TABLE | APEX_040200 | SYSAUX | 26 | 11,534,336 |
| SYS_LOB0000088338C00007$$ | LOBSEGMENT | APEX_040200 | SYSAUX | 25 | 24,313,856 |
| SYS_LOB0000001255C00003$$ | LOBSEGMENT | SYS | SYSTEM | 25 | 10,485,760 |
| WWV_FLOW_TEMPLATES | TABLE | APEX_040200 | SYSAUX | 25 | 10,485,760 |
| I_DEPENDENCY2 | INDEX | SYS | SYSTEM | 24 | 9,437,184 |
| I_SOURCE1 | INDEX | SYS | SYSTEM | 24 | 9,437,184 |
| SDO_CS_SRS | TABLE | MDSYS | SYSAUX | 24 | 9,437,184 |
| VIEW$ | TABLE | SYS | SYSTEM | 24 | 9,437,184 |
| I_ARGUMENT2 | INDEX | SYS | SYSTEM | 23 | 8,388,608 |
| I_OBJ2 | INDEX | SYS | SYSTEM | 23 | 8,388,608 |
| I_OBJ5 | INDEX | SYS | SYSTEM | 23 | 8,388,608 |
| WWV_FLOW_TEMPLATES | TABLE | APEX_050000 | SYSAUX | 23 | 8,388,608 |
| DEPENDENCY$ | TABLE | SYS | SYSTEM | 23 | 8,388,608 |
| ... |
| PL/SQL | |||
| User | Type | Objects | Lines |
| APEX_040200 | FUNCTION | 11 | 63 |
| APEX_040200 | PACKAGE | 271 | 53,337 |
| APEX_040200 | PACKAGE BODY | 263 | 2,211 |
| APEX_040200 | PROCEDURE | 16 | 16 |
| APEX_040200 | TRIGGER | 457 | 12,658 |
| APEX_040200 | TYPE | 6 | 20 |
| APEX_050000 | FUNCTION | 8 | 33 |
| APEX_050000 | PACKAGE | 273 | 63,039 |
| APEX_050000 | PACKAGE BODY | 266 | 2,390 |
| APEX_050000 | PROCEDURE | 16 | 16 |
| APEX_050000 | TRIGGER | 498 | 16,280 |
| APEX_050000 | TYPE | 14 | 461 |
| APEX_050000 | TYPE BODY | 5 | 5 |
| C##DBAAS_MONITOR | FUNCTION | 1 | 9 |
| C##DBAAS_MONITOR | PACKAGE | 1 | 114 |
| C##DBAAS_MONITOR | PACKAGE BODY | 1 | 984 |
| C##DBAAS_MONITOR | PROCEDURE | 1 | 19 |
| C##DBAAS_MONITOR | TRIGGER | 2 | 12 |
| C##DBAAS_MONITOR | TYPE | 15 | 118 |
| C##DBAAS_MONITOR | TYPE BODY | 9 | 713 |
| C##PDBMGR | PACKAGE | 6 | 526 |
| C##PDBMGR | PACKAGE BODY | 6 | 5,097 |
| C##PDBMGR | TRIGGER | 24 | 479 |
| C##PDBMGR | TYPE | 3 | 14 |
| CTXSYS | FUNCTION | 2 | 2 |
| CTXSYS | LIBRARY | 1 | 1 |
| CTXSYS | PACKAGE | 77 | 18,283 |
| CTXSYS | PACKAGE BODY | 66 | 117 |
| CTXSYS | PROCEDURE | 2 | 25 |
| CTXSYS | TYPE | 36 | 1,533 |
| CTXSYS | TYPE BODY | 6 | 12 |
| DBSNMP | PACKAGE | 3 | 318 |
| DBSNMP | PACKAGE BODY | 3 | 9 |
| DBSNMP | PROCEDURE | 1 | 26 |
| DBSNMP | TYPE | 8 | 47 |
| DVF | FUNCTION | 17 | 17 |
| DVF | PACKAGE | 1 | 1 |
| DVF | PACKAGE BODY | 1 | 1 |
| DVSYS | FUNCTION | 21 | 145 |
| DVSYS | LIBRARY | 5 | 5 |
| DVSYS | PACKAGE | 19 | 2,699 |
| DVSYS | PACKAGE BODY | 19 | 83 |
| DVSYS | PROCEDURE | 4 | 64 |
| DVSYS | TYPE | 32 | 165 |
| FLOWS_FILES | TRIGGER | 1 | 34 |
| GSMADMIN_INTERNAL | LIBRARY | 4 | 4 |
| GSMADMIN_INTERNAL | PACKAGE | 7 | 4,504 |
| GSMADMIN_INTERNAL | PACKAGE BODY | 7 | 21 |
| GSMADMIN_INTERNAL | TRIGGER | 4 | 11 |
| GSMADMIN_INTERNAL | TYPE | 29 | 163 |
| LBACSYS | FUNCTION | 24 | 24 |
| LBACSYS | LIBRARY | 11 | 11 |
| LBACSYS | PACKAGE | 23 | 23 |
| LBACSYS | PACKAGE BODY | 22 | 31 |
| LBACSYS | PROCEDURE | 9 | 9 |
| LBACSYS | TRIGGER | 3 | 21 |
| LBACSYS | TYPE | 9 | 123 |
| LBACSYS | TYPE BODY | 4 | 4 |
| MDSYS | FUNCTION | 116 | 744 |
| MDSYS | LIBRARY | 21 | 21 |
| MDSYS | PACKAGE | 77 | 15,202 |
| MDSYS | PACKAGE BODY | 73 | 2,704 |
| MDSYS | PROCEDURE | 3 | 5 |
| MDSYS | TRIGGER | 62 | 2,194 |
| MDSYS | TYPE | 183 | 4,058 |
| MDSYS | TYPE BODY | 45 | 441 |
| OLAPSYS | TYPE | 2 | 15 |
| ORACLE_OCM | PACKAGE | 3 | 106 |
| ORACLE_OCM | PACKAGE BODY | 3 | 3,327 |
| ORDPLUGINS | PACKAGE | 5 | 228 |
| ORDPLUGINS | PACKAGE BODY | 5 | 5 |
| ORDSYS | FUNCTION | 32 | 32 |
| ORDSYS | LIBRARY | 2 | 2 |
| ORDSYS | PACKAGE | 30 | 783 |
| ORDSYS | PACKAGE BODY | 22 | 39 |
| ORDSYS | PROCEDURE | 7 | 7 |
| ORDSYS | TYPE | 446 | 2,743 |
| ORDSYS | TYPE BODY | 15 | 19 |
| OUTLN | PROCEDURE | 1 | 9 |
| SYS | FUNCTION | 114 | 869 |
| SYS | JAVA SOURCE | 2 | 68 |
| SYS | LIBRARY | 165 | 165 |
| SYS | PACKAGE | 722 | 123,033 |
| SYS | PACKAGE BODY | 695 | 31,893 |
| SYS | PROCEDURE | 153 | 14,009 |
| SYS | TRIGGER | 12 | 194 |
| SYS | TYPE | 1,597 | 13,529 |
| SYS | TYPE BODY | 153 | 1,236 |
| SYSTEM | FUNCTION | 4 | 4 |
| SYSTEM | PACKAGE | 1 | 1 |
| SYSTEM | PACKAGE BODY | 1 | 1 |
| SYSTEM | PROCEDURE | 1 | 15 |
| SYSTEM | TRIGGER | 2 | 18 |
| SYSTEM | TYPE | 9 | 179 |
| WMSYS | PACKAGE | 23 | 29 |
| WMSYS | PACKAGE BODY | 23 | 179 |
| WMSYS | PROCEDURE | 1 | 1 |
| WMSYS | TRIGGER | 45 | 742 |
| WMSYS | TYPE | 15 | 48 |
| WMSYS | TYPE BODY | 1 | 1 |
| XDB | FUNCTION | 6 | 19 |
| XDB | LIBRARY | 19 | 19 |
| XDB | PACKAGE | 44 | 7,635 |
| XDB | PACKAGE BODY | 42 | 1,112 |
| XDB | PROCEDURE | 4 | 11 |
| XDB | TRIGGER | 8 | 54 |
| XDB | TYPE | 82 | 1,435 |
| XDB | TYPE BODY | 5 | 153 |
| TOTAL | FUNCTION | 356 | 1,961 |
| TOTAL | JAVA SOURCE | 2 | 68 |
| TOTAL | LIBRARY | 228 | 228 |
| TOTAL | PACKAGE | 1,586 | 289,861 |
| TOTAL | PACKAGE BODY | 1,518 | 50,204 |
| TOTAL | PROCEDURE | 219 | 14,232 |
| TOTAL | TRIGGER | 1,118 | 32,697 |
| TOTAL | TYPE | 2,486 | 24,651 |
| TOTAL | TYPE BODY | 243 | 2,584 |
| Libraries | ||||
| Owner | Library | File | Status | Dynamic |
| 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_GSM_ALERT_LIB | VALID | N | |
| CTXSYS | DR$LIB | VALID | N | |
| 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 |
| Jobs | ||||
| Job Id | User | Interval | Command | Total Time |
| Scheduler Jobs | |||||
| Job Name | User | Interval | Command | Count | Last Duration |
| XMLDB_NFS_CLEANUP_JOB | SYS | Freq=minutely;interval=5 | xdb.dbms_xdbutil_int.cleanup_expired_nfsclients | 0 | |
| LOAD_OPATCH_INVENTORY | SYS | BEGIN dbms_qopatch.opatch_inv_refresh_job(); END; | 0 | ||
| SM$CLEAN_AUTO_SPLIT_MERGE | SYS | freq=daily;byhour=0;byminute=0;bysecond=0 | sys.dbms_streams_auto_int.clean_auto_spli t_merge; | 5 | +000000000 00:00:01.418770 |
| RSE$CLEAN_RECOVERABLE_SCRIPT | SYS | freq=daily;byhour=0;byminute=0;bysecond=0 | sys.dbms_streams_auto_int.clean_recove rable_script; | 5 | +000000000 00:00:01.743849 |
| FGR$AUTOPURGE_JOB | SYS | freq=daily;byhour=0;byminute=0;bysecond=0 | sys.dbms_file_group.purge_file_group(NULL); | 0 | |
| BSLN_MAINTAIN_STATS_JOB | SYS | 3 | +000000000 00:00:01.820610 | ||
| DRA_REEVALUATE_OPEN_FAILURES | SYS | dbms_ir.reevaluateopenfailures | 1 | +000000000 00:00:00.250175 | |
| HM_CREATE_OFFLINE_DICTIONARY | SYS | dbms_hm.create_offline_dictionary | 0 | ||
| ORA$AUTOTASK_CLEAN | SYS | 5 | +000000000 00:00:01.580698 | ||
| FILE_SIZE_UPD | SYS | FREQ = MINUTELY; INTERVAL = 5 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(7); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 432 | +000000000 00:00:00.010239 |
| CLEANUP_ONLINE_PMO | SYS | FREQ = HOURLY; INTERVAL = 1 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(6); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 39 | +000000000 00:00:00.254375 |
| CLEANUP_TRANSIENT_PKG | SYS | FREQ = HOURLY; INTERVAL = 2 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(5); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 23 | +000000000 00:00:00.045246 |
| CLEANUP_TRANSIENT_TYPE | SYS | FREQ = HOURLY; INTERVAL = 2 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(4); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 6 | +000000000 00:00:01.779555 |
| CLEANUP_TAB_IOT_PMO | SYS | FREQ = HOURLY; INTERVAL = 1 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(3); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 39 | +000000000 00:00:00.250058 |
| CLEANUP_ONLINE_IND_BUILD | SYS | FREQ = HOURLY; INTERVAL = 1 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(2); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 39 | +000000000 00:00:00.336771 |
| CLEANUP_NON_EXIST_OBJ | SYS | FREQ = HOURLY; INTERVAL = 12 | declare myinterval number; begin myinterval := dbms_pdb.cleanup_task(1); if myinterval <> 0 then next_date := systimestamp + numtodsinterval(myinterval, 'second'); end if; end; | 6 | +000000000 00:00:01.694850 |
| PMO_DEFERRED_GIDX_MAINT_JOB | SYS | 5 | +000000000 00:00:02.681792 | ||
| FILE_WATCHER | SYS | 0 | |||
| PURGE_LOG | SYS | 5 | +000000000 00:00:02.916920 | ||
| ORACLE_APEX_DAILY_MAINTENANCE | APEX_040200 | FREQ=DAILY;BYHOUR=1;BYMINUTE=0;BYSECOND=0 | WWV_FLOW_MAINT.DAILY_MAINTENA NCE | 5 | +000000000 00:00:01.657675 |
| ORACLE_APEX_WS_NOTIFICATIONS | APEX_040200 | FREQ=MINUTELY;BYMINUTE=0,30;BYSECOND=0 | WWV_FLOW_WORKSHEET_API.DO_NOTIFY | 77 | +000000000 00:00:00.201913 |
| ORACLE_APEX_MAIL_QUEUE | APEX_040200 | FREQ=MINUTELY;BYMINUTE=0,5,10,15,20,25,30,35,40,45,50,55;BYSECOND=0 | WWV_FLOW_M AIL.PUSH_QUEUE_IMMEDIATE | 500 | +000000000 00:00:00.003878 |
| ORACLE_APEX_PURGE_SESSIONS | APEX_040200 | FREQ=HOURLY;BYMINUTE=0 | WWV_FLOW_CACHE.PURGE_SESSIONS | 40 | +000000000 00:00:00.053765 |
| ORACLE_APEX_DAILY_MAINTENANCE | APEX_050000 | FREQ=DAILY;BYHOUR=1;BYMINUTE=0;BYSECOND=0 | WWV_FLOW_MAINT.DAILY_MAINTENA NCE | 1 | +000000000 00:00:00.694878 |
| ORACLE_APEX_WS_NOTIFICATIONS | APEX_050000 | FREQ=MINUTELY;BYMINUTE=0,30;BYSECOND=0 | WWV_FLOW_WORKSHEET_API.DO_NOTIFY | 13 | +000000000 00:00:00.174366 |
| ORACLE_APEX_MAIL_QUEUE | APEX_050000 | FREQ=MINUTELY;BYMINUTE=0,5,10,15,20,25,30,35,40,45,50,55;BYSECOND=0 | WWV_FLOW_M AIL.PUSH_QUEUE_IMMEDIATE | 82 | +000000000 00:00:00.004276 |
| ORACLE_APEX_PURGE_SESSIONS | APEX_050000 | FREQ=HOURLY;BYMINUTE=0 | WWV_FLOW_CACHE.PURGE_SESSIONS | 7 | +000000000 00:00:00.075458 |
| Running Jobs | |||
| Job Id | SID | Last | Failures |
| Data Pump Jobs | ||
| Owner | Job Name | State |
| RMAN Configuration | |
| Parameter | Value |
| DEFAULT DEVICE TYPE TO | DISK |
| RETENTION POLICY | TO RECOVERY WINDOW OF 7 DAYS |
| CHANNEL | DEVICE TYPE DISK MAXPIECESIZE 2 G |
| BACKUP OPTIMIZATION | ON |
| CONTROLFILE AUTOBACKUP | ON |
| Database Links | |||
| Owner | DB Link | User | Instance |
| Directories | ||
| Owner | Directory | Path |
| SYS | DATA_PUMP_DIR | /ade/b/1281484529/oracle/admin/seeddata/dpdump/ |
| SYS | OPATCH_INST_DIR | /u01/app/oracle/product/12.1.0/dbhome_1/OPatch |
| SYS | OPATCH_LOG_DIR | /u01/app/oracle/product/12.1.0/dbhome_1/QOpatch |
| SYS | OPATCH_SCRIPT_DIR | /u01/app/oracle/product/12.1.0/dbhome_1/QOpatch |
| SYS | ORACLE_BASE | / |
| SYS | ORACLE_HOME | / |
| SYS | ORACLE_OCM_CONFIG_DIR | /u01/app/oracle/product/12.1.0/dbhome_1/ccr/hosts/XeniaTest02/state |
| SYS | ORACLE_OCM_CONFIG_DIR2 | /u01/app/oracle/product/12.1.0/dbhome_1/ccr/state |
| SYS | XMLDIR | /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/xml |
| SYS | XSDDIR | /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/xml/schema |
| Oracle Parameters | |
| Parameter | Value |
| _catalog_foreign_restore | FALSE |
| audit_file_dest | /u01/app/oracle/admin/TST02/adump |
| audit_trail | DB |
| cluster_database | FALSE |
| compatible | 12.1.0.2.0 |
| control_files | /u02/app/oracle/oradata/TST02/control01.ctl, /u03/app/oracle/fast_recovery_area/TST02/control02.ctl |
| control_management_pack_access | DIAGNOSTIC+TUNING |
| db_block_size | 8192 |
| db_create_file_dest | /u02/app/oracle/oradata |
| db_domain | xenialab.oraclecloud.internal |
| db_files | 250 |
| db_flashback_retention_target | 1440 |
| db_name | TST02 |
| db_recovery_file_dest | /u03/app/oracle/fast_recovery_area |
| db_recovery_file_dest_size | 45097156608 |
| diagnostic_dest | /u01/app/oracle |
| dispatchers | (PROTOCOL=TCP) (SERVICE=TST02XDB) |
| enable_ddl_logging | TRUE |
| enable_pluggable_database | TRUE |
| filesystemio_options | setall |
| log_archive_format | %t_%s_%r.dbf |
| memory_target | 3170893824 |
| open_cursors | 300 |
| processes | 300 |
| remote_login_passwordfile | EXCLUSIVE |
| undo_tablespace | UNDOTBS1 |
| Hidden Parameter | Value |
| _optimizer_autostats_job | TRUE |
| _optimizer_invalidation_period | 18000 |
| _optimizer_save_stats | TRUE |
| 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.8 |
| NUM_CPUS | 2.0 |
| PHYSICAL_MEMORY_BYTES | 7,895,363,584.0 |
| Timezone info | ||||
| SYSDATE | CURRENT_DATE | DB TIMEZONE | Session TIMEZONE | OS TIMEZONE |
| 2015-08-23 21:09 | 2015-08-23 21:09 | +00:00 | +00:00 | +00:00 |
| 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 |
Oracle 10g features
Tablespace Usage TABLESPACE_NAME USED_SPACE TABLESPACE_SIZE USED_PERCENT ------------------------------ ------------------ ------------------ ------------ SYSAUX 126,208 2,332,520 5.41 SYSTEM 110,664 2,310,760 4.79 TEMP 256 2,224,616 .01 UNDOTBS1 2,720 2,321,640 .12 USERS 176 2,200,040 .01 Tablespaces 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 TEMP NO YES NO 2 TEMP NO YES NO 3 USERS NO YES YES 3 TEMP NO YES NO 3 USERS NO YES YES 4 USERS NO YES YES 4 EXAMPLE NO YES YES 5 APEX_1701140435539813 NO YES YES Tablespace Usage History NAME TABLESPACE_SIZE MIN_USED MAX_USED BG ED ------------------------------ ------------------ ------------------ ------------------ ------------------ ------------------ APEX_1701140435539813 1,288 128 128 23-AUG-15 08.44.51 23-AUG-15 08.44.51 EXAMPLE 79,920 176 156,040 23-AUG-15 08.44.51 23-AUG-15 08.44.51 SYSAUX 126,720 113,656 126,208 23-AUG-15 08.44.51 23-AUG-15 08.44.51 SYSTEM 74,880 37,160 110,544 23-AUG-15 08.44.51 23-AUG-15 08.44.51 TEMP 45,909 0 5,152 23-AUG-15 08.44.51 23-AUG-15 08.44.51 UNDOTBS1 62,400 0 5,152 23-AUG-15 08.44.51 23-AUG-15 08.44.51 USERS 35,259 168 156,040 23-AUG-15 08.44.51 23-AUG-15 08.44.51 Tablespace Depletion Forecast NAME DEPLETION ------------------------------ --------- APEX_1701140435539813 EXAMPLE 0 SYSAUX 4 SYSTEM 0 TEMP 159 UNDOTBS1 159 USERS 0 Instance startup STARTUP_TIME VERSION DB_NAME INSTANCE_NAME HOST_NAME -------------------------- ----------------- --------- ---------------- ------------------------------ 23-AUG-15 08.44.51.000 PM 12.1.0.2.0 TST02 TST02 XeniaTest02 23-AUG-15 08.44.14.000 PM 12.1.0.2.0 TST02 TST02 XeniaTest02 23-AUG-15 08.43.37.000 PM 12.1.0.2.0 TST02 TST02 XeniaTest02 23-AUG-15 08.41.00.000 PM 12.1.0.2.0 TST02 TST02 XeniaTest02 23-AUG-15 08.33.56.000 PM 12.1.0.2.0 TST02 TST02 XeniaTest02 23-AUG-15 08.30.11.000 PM 12.1.0.2.0 TST02 TST02 XeniaTest02 23-AUG-15 08.29.09.000 PM 12.1.0.2.0 TST02 TST02 XeniaTest02
Oracle 11g features
Temporary Tablespace Usage TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE ------------------------------ -------------------- -------------------- -------------------- TEMP 206,569,472 11,534,336 203,423,744 TMP_FILE_NAME TS# BYTES STATUS ENABLED INST_ID ------------------------------------------------------------ -------- -------------------- ------- ---------- -------- /u02/app/oracle/oradata/TST02/PDB1/PDB1_temp012015-08-23_08- 2 20,971,520 ONLINE READ WRITE 1 37-34-PM.dbf /u02/app/oracle/oradata/TST02/pdbseed/pdbseed_temp012014-10- 2 104,857,600 ONLINE READ WRITE 1 06_07-52-18-PM.dbf /u02/app/oracle/oradata/TST02/temp01.dbf 3 206,569,472 ONLINE READ WRITE 1 TABLESPACE_NAME TOTAL_BLOCKS USED_BLOCKS FREE_BLOCKS INST_ID ------------------------------ ------------ ----------- ----------- -------- TEMP 1280 256 1024 1 TEMP 512 0 512 1 Password file Users USERNAME INST_ID SYSDB SYSOP SYSAS ------------------------------ -------- ----- ----- ----- C##PDBMGR 1 TRUE TRUE FALSE PDB_ADMIN 1 TRUE FALSE FALSE SYS 1 TRUE TRUE FALSE SYSBACKUP 1 FALSE FALSE FALSE SYSDG 1 FALSE FALSE FALSE SYSKM 1 FALSE FALSE FALSE Users with default password USERNAME ACCOUNT_STATUS ------------------------------ -------------------------------- ORACLE_OCM EXPIRED & LOCKED SYSBACKUP EXPIRED & LOCKED SYSKM EXPIRED & LOCKED APPQOSSYS EXPIRED & LOCKED DBSNMP EXPIRED & LOCKED DVF EXPIRED & LOCKED AUDSYS EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED DIP EXPIRED & LOCKED LBACSYS EXPIRED & LOCKED MDDATA EXPIRED & LOCKED DVSYS EXPIRED & LOCKED OJVMSYS EXPIRED & LOCKED OLAPSYS EXPIRED & LOCKED SPATIAL_WFS_ADMIN_USR EXPIRED & LOCKED WMSYS EXPIRED & LOCKED GSMCATUSER EXPIRED & LOCKED ORDDATA EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED GSMADMIN_INTERNAL EXPIRED & LOCKED MDSYS EXPIRED & LOCKED XDB EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED SI_INFORMTN_SCHEMA EXPIRED & LOCKED ANONYMOUS EXPIRED & LOCKED GSMUSER EXPIRED & LOCKED SYSDG EXPIRED & LOCKED OUTLN EXPIRED & LOCKED SPATIAL_CSW_ADMIN_USR EXPIRED & LOCKED Manteniance Tasks WINDOW_NAME -------------------------------------------------------------------------------------------------------------------------------- WINDOW_NEXT_TIME WINDO AUTOTASK OPTIMIZE SEGMENT_ SQL_TUNE HEALTH_M ---------------------------------------- ----- -------- -------- -------- -------- -------- MONDAY_WINDOW 24-AUG-15 10.00.00.000000 PM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED TUESDAY_WINDOW 25-AUG-15 10.00.00.000000 PM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED WEDNESDAY_WINDOW 26-AUG-15 10.00.00.000000 PM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED THURSDAY_WINDOW 27-AUG-15 10.00.00.000000 PM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED FRIDAY_WINDOW 28-AUG-15 10.00.00.000000 PM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED SATURDAY_WINDOW 29-AUG-15 06.00.00.000000 AM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED SUNDAY_WINDOW 30-AUG-15 06.00.00.000000 AM ETC/UTC FALSE ENABLED ENABLED ENABLED ENABLED DISABLED Slowest SQL Statements and cell offload SQL_ID CHILD PLAN EXECS AVG_TIME AVG_PAR OFFLOAD IO_SAVED -------------------- ------ ------------- ---------------- ----------- ------- ---------- -------- SQL1 -------------------------------------------------------------------------------------------------------------------------------- 0f3wauj9nz0zk 0 3479364841 1 6 .0 No .0 select '<tr><td>'||' Database :', '<! 10>', '<td>'||value from v$parameter where name like 'db_name' un 81539dsd2uapy 0 1972985832 1 5 .0 No .0 create table v_big_obj as select segment_name, segment_type, tablespace_name, owner, sum(bytes) bytes from sys.dba_extents 46y90rzhmghzs 0 1972985832 1 5 .0 No .0 create table v_frg_obj as select segment_name, segment_type, tablespace_name, owner, count(*) extents, sum(bytes) bytes fr bm1xn5uwvvm7k 0 106825810 1 5 .0 No .0 select '<tr><td>'|| a.tablespace_name tablespace, '<td align="right">'||to_char(sum(a.bytes),'999,999,999,999 9n1pqm8tgjahm 0 1560280317 1 5 .0 No .0 select '<tr><td>'||tablespace_name tablespace, '<td align="right">'||to_char(round(sum(bytes/1048576)), '99 6wrxp705v8d8s 0 770367912 1 5 .0 No .0 select '<td align="right">'||to_char(round(sum(b.bytes)/(1024*1024)),'999,999,999,999')||' MB' total, '<td align="rig a2rr98hku69bk 0 3298173819 1 5 .0 No .0 select '<tr><td>TOTAL (MB)', '<td align="right">'||to_char(round(sum(bytes/1048576)), '999,999'), '<td 8dyqsnz4h0g64 0 3587515571 1 1 .0 No .0 select '<tr><tr><td>'||OWNER||'<td align="right">'||count(*)||'<td>'||max(to_char(LAST_ANALYZED, ' 3gzknmkhk56s5 0 3497105509 1 1 .0 No .0 select '<tr><td>'||owner||'<td>'||type, '<td align="right">'||to_char(count(distinct name), '999,999,99 f5aup0asmmqzw 0 3497105509 1 1 .0 No .0 select '<tr><td>TOTAL<td>'||type, '<td align="right">'||to_char(count(distinct name||owner), '999,999,9 05h9rghrx50pc 0 1376585575 2 1 .0 No .0 INSERT INTO wrh$_sql_plan sp (dbid, con_dbid, snap_id, sql_id, plan_hash_value, id, operation, options, object_node, object 4crwz7bpxyfv1 0 2840156330 1 1 .0 No .0 select '<tr><tr><td>'||OWNER||'<td align="right">'||count(*)||'<td>'||max(to_char(LAST_ANALYZED, ' bckquhq9cz1wn 0 1036450760 3 0 .0 No .0 INSERT INTO wrh$_sqltext (sql_id, dbid, sql_text, command_type, snap_id, con_dbid) SELECT sqlid_kewrstx, :dbid, sqlf gxsq8pmcs6hz7 0 3675224083 1 0 .0 No .0 select '<tr><td>', owner,'<td align=right>', count(*) from all_sdo_geom_metadata group by owner 5dn4qu6k43n89 0 0 1 0 .0 No .0 begin "CTXSYS"."CTX_ADM"."DROP_USER_OBJECTS"(:myuser); end; 3jvudu1b9mpyy 0 126866737 1 0 .0 No .0 select '<tr><td>', table_owner,'<td>', table_name,'<td>', tablespace_name,'<td>', partition_name,' 2cx32gtckmm1s 0 1102472152 1 0 .0 No .0 select '<tr><tr><td>'||index_owner ||'<td>'|| count(*) ||'<td>'|| status from sys.dba_ind_partiti 622gvghxg5ur0 0 2039693794 1 0 .0 No .0 select '<tr><td>'||owner owner, '<td align="right">'||sum(decode(object_type, 'TABLE',1,0)) tabs, '<td bvk50rx1jm6bj 0 332960540 1 0 .0 No .0 select '<tr><td>'||substr(a.segment_name,1,25) rollback_segment, '<td>'||substr(a.tablespace_name,1,25) table fhf8upax5cxsz 0 0 23 0 .0 No .0 BEGIN sys.dbms_auto_report_internal.i_save_report (:rep_ref, :snap_id, :pr_class, : Most executed SQL Statements SQL_ID CHILD PLAN EXECS AVG_TIME AVG_PAR OFFLOAD IO_SAVED -------------------- ------ ------------- ---------------- ----------- ------- ---------- -------- SQL1 -------------------------------------------------------------------------------------------------------------------------------- 9tgj4g8y4rwy8 1 3755742892 52,096 0 .0 No .0 select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lists,65535),NVL(groups,65535),cachehint,hwmincr, N 96g93hntrzjtr 0 2239883476 8,337 0 .0 No .0 select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, 53saa2zkr6wc3 1 3038981986 6,399 0 .0 No .0 select intcol#,nvl(pos#,0),col#,nvl(spare1,0) from ccol$ where con#=:1 1p5grz1gs7fjq 4 813480514 3,956 0 .0 No .0 select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2, spare3, signature, spare7, spare8, spare9 fr 04kug40zbu4dm 0 4006480256 2,930 0 .0 No .0 select policy#, action# from aud_object_opt$ where object# = :1 and type = 2 87gaftwrm2h68 1 1072382624 2,898 0 .0 No .0 select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname from obj$ o where o.obj#=:1 ftj9uawt4wwzb 1 1884964958 2,746 0 .0 No .0 select condition from cdef$ where rowid=:1 5n1fs4m2n2y0r 1 452367486 2,679 0 .0 No .0 select pos#,intcol#,col#,spare1,bo#,spare2,spare3 from icol$ where obj#=:1 7sx5p1ug5ag12 2 1097271556 2,460 0 .0 No .0 SELECT SPARE4 FROM SYS.OPTSTAT_HIST_CONTROL$ WHERE SNAME = :B1 07rm5p65sc48u 1 342238424 2,429 0 .0 No .0 SELECT P.VALCHAR FROM SYS.OPTSTAT_USER_PREFS$ P, OBJ$ O, USER$ U WHERE P.OBJ#=O.OBJ# AND U.USER#=O.OWNER# AND U.NAME=:B3 AND O.N d45q8yjz3ah0u 0 1805486652 2,382 0 .0 No .0 SELECT VALUE FROM NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_COMP' 9d8cr4qsr2h11 0 1805486652 2,382 0 .0 No .0 SELECT VALUE FROM NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_SORT' 9hamx8h8qcx2d 0 2071729871 2,366 0 .0 No .0 SELECT /*+ index(u) */ COUNT(*) FROM SYS.USER$ U WHERE NAME = :B1 AND ROWNUM < 2 96g93hntrzjtr 2 2239883476 2,317 0 .0 No .0 select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, 7u49y06aqxg1s 0 3312420081 2,149 0 .0 No .0 select /*+ rule */ bucket, endpoint, col#, epvalue, epvalue_raw, ep_repeat_count from histgrm$ where obj#=:1 and intcol#=:2 and 3c1kubcdjnppq 0 477378112 1,807 0 .0 No .0 update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag,1),0,0,1), equijoin_preds = equijoi 9mcxa5qwdxbtq 0 2582313431 1,739 0 .0 No .0 select position#,sequence#,level#,argument,type#,charsetid,charsetform,properties,nvl(length, 0), nvl(precision#, 0),nvl(scale, gd28w82ct6rva 1 2970138452 1,714 0 .0 No .0 select audit$ from tab$ where obj# = :1 1p5grz1gs7fjq 6 813480514 1,557 0 .0 No .0 select obj#,type#,ctime,mtime,stime, status, dataobj#, flags, oid$, spare1, spare2, spare3, signature, spare7, spare8, spare9 fr a3771vkq58hdg 0 866645418 1,507 0 .0 No .0 select pctfree_stg, pctused_stg, size_stg,initial_stg, next_stg, minext_stg, maxext_stg, maxsiz_stg, lobret_stg,mintim_stg, pcti Offloaded SQL Statements Database patches PATCH_DATE ID ACTION VERSION COMMENTS -------------------- -------- ------------ ------------ ------------------------------ 2015-06-24 06:09:17 0 jvmpsu.sql 12.1.0.2.3OJ RAN jvmpsu.sql
Oracle 12c features
Current container CONNECTION_NAME CONNECTION_ID DATA_SCOPE -------------------- -------------------- ---------- CDB$ROOT 1 Root Database and Instance DB_NAME CREATED CDB -------------------- --------- --- TST02 23-AUG-15 YES INSTANCE_NAME HOST_NAME STATUS STARTUP_TIME EDITION -------------------- -------------------- ------------ -------------------------- ------- TST02 XeniaTest02 OPEN 23-AUG-15 EE Pluggable Databases PDB_NAME OPEN_MODE TOTAL_SIZE -------------------- ---------- -------------------- PDB$SEED READ ONLY 1,216,348,160 PDB1 READ WRITE 2,641,166,336 Pluggable Database History DB_NAME CON_ID PDB_NAME OPERATION OP_TIMEST CLONED_FROM -------------------- -------- -------------------- ---------------- --------- -------------------- SEEDDATA 3 SAMPLE_SCHEMA CREATE 07-JUL-14 PDB$SEED SEEDDATA 3 SAMPLE_SCHEMA UNPLUG 07-JUL-14 ORCL 3 PDB1 PLUG 06-OCT-14 PDB1 ORCL 3 PDB1 UNPLUG 07-OCT-14 ORCL 3 PDB1 PLUG 24-JUN-15 PDB1 ORCL 3 PDB1 UNPLUG 24-JUN-15 TST02 3 PDB1 PLUG 23-AUG-15 PDB1 Database In-Memory Option NAME VALUE -------------------------------------------- -------------------------------------------------------------------------------- inmemory_clause_default inmemory_force DEFAULT inmemory_max_populate_servers 0 inmemory_query ENABLE inmemory_size 0 inmemory_trickle_repopulate_servers_percent 1 Enterprise Manager Express Port HTTP_PORT HTTPS_PORT --------- ---------- 0 5500 Heat Map - Most accessed blocks
Oracle RAC - Performance Statistics
Cluster Interconnects Global Cache latency (should be less than 1/10th of disk access) EVENT TOTAL_WAITS TIME_WAITED_SECS AVG_MS ---------------------------------------------------------------- ---------------- ---------------- ------- db file sequential read 78,675 46 .59 Cluster overhead (should be less than 10%) TIME_CATEGORY TIME_SECS PCT ---------------------------------------------------------------- --------- ------- System I/O 542.99 56.69 Other 230.9 24.11 CPU 110.59 11.55 User I/O 66.37 6.93 Concurrency 3.71 0.39 Configuration 2 0.21 Commit .84 0.09 Application .42 0.04 Network .03 0.00 Temporary Tablespace Usage (should be paired between instances) INST_ID TABLESPACE_NAME SEGMENT_FILE TOTAL_BLOCKS USED_BLOCKS FREE_BLOCKS MAX_USED_BLOCKS MAX_SORT_BLOCKS -------- ------------------------------ ------------ ------------ ----------- ----------- --------------- --------------- 1 TEMP 0 1280 768 512 1024 128 1 TEMP 0 512 0 512 256 128 INST_ID TABLESPACE_NAME EXTENT_BLOCK_USED BLOCKS_CACHED -------- ------------------------------ ----------------- ------------- 1 TEMP 768 1280 INST_ID TABLESPACE_NAME HEADER_BLOCK_USED BLOCKS_FREE -------- ------------------------------ ----------------- ----------- 1 TEMP 1408 23808 INST_ID FREE_REQUESTS FREED_EXTENTS -------- ------------- ------------- 1 0 0 1 0 0 Parallel query statistics (exploit RAC) OPERATION VALUE ---------------------------------------------------------------- ---------------- Parallel operations not downgraded 186 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 Cluster balancing: CPU and Global Cache (should be paired between instances) INSTANCE_NAME DB_TIME_SECS DB_TIME_PCT CPU_TIME_SECS CPU_TIME_PCT -------------------- ------------ ----------- ------------- ------------ TST02 565.22 100 110.64 100 INSTANCE_NAME LOGICAL_READS GC_BLOCKS_RECIEVED PHYSICAL_READS PHYS_TO_LOGICAL_PCT GC_TO_LOGICAL_PCT -------------------- -------------------- ------------------ ---------------- ------------------- ----------------- TST02 3,555,120 0 85,946 2.42 0
Data Guard
INSTANCE_NAME INSTANCE_ROLE DATABASE_STATUS HOST_NAME -------------------- ------------------ ----------------- -------------------- TST02 PRIMARY_INSTANCE ACTIVE XeniaTest02 NAME DATABASE_ROLE OPEN_MODE CONTROL SWITCHOVER_STATUS PROTECTION_MODE -------------------------------------------- ---------------- -------------------- ------- -------------------- -------------------- FLASH LOG_MODE FORCE ----- ------------ ----- TST02 PRIMARY READ WRITE CURRENT NOT ALLOWED MAXIMUM PERFORMANCE YES ARCHIVELOG NO SYSDATE CURRENT_SCN SCN_TIME SCN_TIME_FORMATTED ---------------- ---------------- --------------------- -------------------- 2015-08-23 21:09 2787218 23-AUG-15 09.09.54.00 2015-08-23 21:09 DEST_ID CREATOR REGISTR STATUS ARC DEL APPLIED COUNT(*) MAX_SEQ ARC_FIRST ARC_LAST SCN_NEXT -------- ------- ------- ------ --- --- --------- -------- -------- -------------------- -------------------- ---------------- 1 ARCH ARCH A YES NO NO 1 1 2015-08-23 20:21 2015-08-23 20:21 2728013 EST_GAP_IN_MINUTES ------------------ LOGS GROUP# THREAD# SEQUENCE# ARC STATUS SIZE_MB -------- -------- -------- --------- --- ------ -------- RedoLog 1 1 1 YES INACTI 1024 RedoLog 2 1 2 NO CURREN 1024 RedoLog 3 1 0 YES UNUSED 1024 ARC_DEST_TYPE INST_ID DEST_ID STATUS ARCHIVED_SEQ# DEST_NAME DESTINATION ---------------- -------- -------- ------ ------------- -------------------- ------------------------------------------------------ LOCAL 1 1 VALID 1 LOG_ARCHIVE_DEST_1 /u01/app/oracle/product/12.1.0/dbhome_1/dbs/arch NAME FS_FAILOVER_STATUS FS_FAIL -------------------------------------------- ---------------------- ------- TST02 DISABLED
Buffer Cache Advice
Default pool Estd Phys Estd Phys Cache Size (MB) Buffers Read Factor Reads ---------------- ------------ ----------- ---------------- 112 13,769 1.28 110,752 224 27,538 1.02 88,470 336 41,307 1.00 86,842 448 55,076 1.00 86,842 560 68,845 1.00 86,842 672 82,614 1.00 86,842 784 96,383 1.00 86,842 896 110,152 1.00 86,842 1,008 123,921 1.00 86,842 1,120 137,690 1.00 86,842 1,232 151,459 1.00 86,842 1,264 155,393 1.00 86,842 1,344 165,228 1.00 86,842 1,456 178,997 1.00 86,842 1,568 192,766 1.00 86,842 1,680 206,535 1.00 86,842 1,792 220,304 1.00 86,842 1,904 234,073 1.00 86,842 2,016 247,842 1.00 86,842 2,128 261,611 1.00 86,842 2,240 275,380 1.00 86,842 Keep pool Library cache NAMESPACE PINS PINHITS RELOADS INVALIDATIONS ---------------------------------------------------------------- -------- -------- -------- ------------- ACCOUNT_STATUS 0 0 0 0 ACL 5 2 0 2 APP CONTEXT 9 6 0 0 AUDIT POLICY 472 458 0 0 BODY 11990 11549 58 10 CLUSTER 2558 2484 0 0 DBINSTANCE 0 0 0 0 DBLINK 0 0 0 0 DIRECTORY 9 6 0 0 EDITION 548 535 0 0 INDEX 612 98 7 0 OBJECT ID 0 0 0 0 PDB 0 0 0 0 PDBOPER 0 0 0 0 QUEUE 10 6 0 0 RULESET 3 2 0 0 SCHEMA 0 0 0 9 SECURITY CLASS 3 0 0 0 SQL AREA 269547 244735 2010 2096 SQL AREA BUILD 0 0 0 0 SQL AREA STATS 8621 374 0 0 SUBSCRIPTION 8 0 0 0 TABLE/PROCEDURE 174840 163118 1368 9 TEMPORARY TABLE 8 0 6 0 TRIGGER 9902 9507 9 0 USER PRIVILEGE 16 7 0 2 XDB CONFIG 1 0 0 0 XML SCHEMA 9 0 0 0
Oracle EMP7 Benchmark
Oracle Version and Host CPUs Version: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production CPU: 2 CORE: 1 SOCKET: 1
Benchmark results 1.05E+08 Elapsed: 00:00:06.18 1.05E+08 Elapsed: 00:00:04.93
SYSAUX Space Usage
ITEM ALLOCATED_SPACE OWNER MOVE_PROC ------------------------- -------------------- -------------------- ---------------------------------------- SDO 97,024 MDSYS MDSYS.MOVE_SDO XDB 70,144 XDB XDB.DBMS_XDB.MOVEXDB_TABLESPACE SM/OTHER 56,320 SYS SM/AWR 49,664 SYS XSOQHIST 39,680 SYS DBMS_XSOQ.OlapiMoveProc AO 39,680 SYS DBMS_AW.MOVE_AWMETA ORDIM/ORDDATA 16,448 ORDDATA ordsys.ord_admin.move_ordim_tblspc LOGMNR 14,272 SYSTEM SYS.DBMS_LOGMNR_D.SET_TABLESPACE SM/OPTSTAT 10,944 SYS SM/ADVISOR 8,704 SYS WM 7,360 WMSYS DBMS_WM.move_proc TEXT 3,904 CTXSYS DRI_MOVE_CTXSYS SQL_MANAGEMENT_BASE 2,496 SYS AUDSYS 1,664 AUDSYS PL/SCOPE 1,600 SYS LOGSTDBY 1,536 SYSTEM SYS.DBMS_LOGSTDBY.SET_TABLESPACE STREAMS 1,024 SYS JOB_SCHEDULER 896 SYS SMON_SCN_TIME 768 SYS ORDIM 448 ORDSYS ordsys.ord_admin.move_ordim_tblspc EM_MONITORING_USER 384 DBSNMP AUTO_TASK 320 SYS EM 0 SYSMAN emd_maintenance.move_em_tblspc ORDIM/ORDPLUGINS 0 ORDPLUGINS ordsys.ord_admin.move_ordim_tblspc ULTRASEARCH 0 WKSYS MOVE_WK ULTRASEARCH_DEMO_USER 0 WK_TEST MOVE_WK ORDIM/SI_INFORMTN_SCHEMA 0 SI_INFORMTN_SCHEMA ordsys.ord_admin.move_ordim_tblspc STATSPACK 0 PERFSTAT TSM 0 TSMSYS XSAMD 0 OLAPSYS DBMS_AMD.Move_OLAP_Catalog AUDIT_TABLES 0 SYS DBMS_AUDIT_MGMT.move_dbaudit_tables EXPRESSION_FILTER 0 EXFSYS Total Usage 425,280 Statistics retention RETENTION --------- 31
Statistics generated on: 23-AUG-2015 21:10:11
For more info visit this site or contact Meo Bogliolo.