XE
This document contains detailed information on the
oracle instance XE.
Table of contents:
Statistics generated on: 11-DIC-2007 19:16
General Oracle RDBMS Schema: detHTML.sql v.1.0.15
Software by
Meo
Oracle Instance: XE
| Versions |
| Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product |
| PL/SQL Release 10.2.0.1.0 - Production |
| CORE 10.2.0.1.0 Production |
| TNS for 32-bit Windows: Version 10.2.0.1.0 - Production |
| NLSRTL Version 10.2.0.1.0 - Production |
| Tablespaces |
| tablespace | total | occuped | pct
| max_free | max_extent
|
| SYSAUX | 230,686,720
| 226,033,664 | 97%
| 3,342,336 | 42
|
| USERS | 104,857,600
| 1,638,400 | 1%
| 103,153,664 | 1
|
| UNDO | 110,100,480
| 101,449,728 | 92%
| 2,097,152 | 289
|
| SYSTEM | 356,515,840
| 346,750,976 | 97%
| 9,699,328 | 81
|
| TOTAL | 765 MB | -
| - | - | -
|
| Schema/Object Matrix |
| owner | tabs | idxs | trgs
| pkgs | seqs | syns | vies
| alls
|
| MDSYS
| 37
| 39
| 19
| 26
| 5
| 0
| 49
| 473
|
| TSMSYS
| 1
| 1
| 0
| 0
| 0
| 0
| 0
| 3
|
| FLOWS_020100
| 164
| 364
| 178
| 156
| 3
| 12
| 27
| 1143
|
| PUBLIC
| 0
| 0
| 0
| 0
| 0
| 2766
| 0
| 2767
|
| OUTLN
| 3
| 3
| 0
| 0
| 0
| 0
| 0
| 8
|
| CTXSYS
| 37
| 46
| 0
| 71
| 3
| 0
| 54
| 339
|
| HR
| 7
| 19
| 2
| 0
| 3
| 0
| 1
| 34
|
| FLOWS_FILES
| 1
| 4
| 1
| 0
| 0
| 5
| 0
| 12
|
| SYSTEM
| 140
| 180
| 2
| 1
| 20
| 8
| 12
| 452
|
| DBSNMP
| 21
| 10
| 0
| 3
| 2
| 0
| 1
| 46
|
| XDB
| 36
| 51
| 12
| 20
| 2
| 0
| 2
| 668
|
| SYS
| 680
| 695
| 1
| 441
| 71
| 9
| 2832
| 6630
|
| Space Usage |
| Tablespace | Tables # | Tables bytes
| Indexes # | Indexes bytes | Cluster #
| Cluster bytes | Rollback # | Rollback bytes
|
| SYSAUX | 706
| 59,047,936 | 917
| 69,926,912 | 0
| 0 | 0
| 0
|
| USERS | 6
| 393,216 | 19
| 1,245,184 | 0
| 0 | 0
| 0
|
| SYSTEM | 925
| 195,231,744 | 945
| 115,015,680 | 77
| 20,774,912 | 6
| 393,216
|
| UNDO | 0
| 0 | 0
| 0 | 0
| 0 | 0
| 0
|
| SGA |
| SGA element | bytes
|
| Database Buffers | 427,819,008
|
| Variable Size | 167,773,580
|
| Redo Buffers | 2,904,064
|
| Fixed Size | 1,288,820
|
| Datafiles |
| Tablespace | Datafile | Bytes | Read #
| Write #
|
| SYSAUX
| C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF
| 230,686,720 | 11,333
| 1,376
|
| SYSTEM
| C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF
| 356,515,840 | 10,332
| 271
|
| UNDO
| C:\ORACLEXE\ORADATA\XE\UNDO.DBF
| 110,100,480 | 27
| 331
|
| USERS
| C:\ORACLEXE\ORADATA\XE\USERS.DBF
| 104,857,600 | 127
| 1
|
| Rollbacks |
| rollback segment | tablespace | bytes
| extents | status
|
| SYSTEM | SYSTEM | 393,216
| 6 | ONLINE
|
| Log Files |
| Log File | Bytes
|
| C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_3OWQ5H36
_.LOG
| 52,428,800
|
| C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_3OWQ5FKO
_.LOG
| 52,428,800
|
| Invalid Objects |
| Owner | Table | Index | Trigger
| Package | Package body | Procedure
| Sequence | Synonym | View | All
|
| Indexes Status |
| Owner | Indexes | Status
|
| SYS | 25 | N/A
|
| SYSTEM | 32 | N/A
|
| Datafiles Status |
| Datafile | Status
|
| Users |
| Username | Default Tablespace
| Temporary Tablespace
|
| SYS | SYSTEM | TEMP
|
| SYSTEM | SYSTEM | TEMP
|
| ANONYMOUS | SYSAUX | TEMP
|
| HR | USERS | TEMP
|
| MDSYS | SYSTEM | TEMP
|
| OUTLN | SYSTEM | TEMP
|
| DIP | SYSTEM | TEMP
|
| TSMSYS | SYSTEM | TEMP
|
| FLOWS_FILES | SYSAUX | TEMP
|
| CTXSYS | SYSAUX | TEMP
|
| DBSNMP | SYSAUX | TEMP
|
| FLOWS_020100 | SYSAUX | TEMP
|
| XDB | SYSAUX | TEMP
|
| Biggest Objects |
| Object | Type | Owner | Tablespace
| Bytes
|
| SOURCE$
| TABLE | SYS
| SYSTEM | 83,886,080
|
| _SYSSMU8$
| TYPE2 UNDO | SYS
| UNDO | 77,398,016
|
| IDL_UB1$
| TABLE | SYS
| SYSTEM | 31,457,280
|
| SYS_LOB0000010794C00025$$
| LOBSEGMENT | XDB
| SYSAUX | 28,311,552
|
| IDL_UB2$
| TABLE | SYS
| SYSTEM | 13,631,488
|
| PK_CT
| INDEX | SYS
| SYSTEM | 10,485,760
|
| PK_C0
| INDEX | SYS
| SYSTEM | 10,485,760
|
| PK_CS
| INDEX | SYS
| SYSTEM | 10,485,760
|
| C_TOID_VERSION#
| CLUSTER | SYS
| SYSTEM | 10,485,760
|
| PK_O
| INDEX | SYS
| SYSTEM | 10,485,760
|
| Most Fragmented Objects |
| Object | Type | Owner | Tablespace
| Extents | Bytes
|
| _SYSSMU8$
| TYPE2 UNDO | SYS
| UNDO | 289
| 77,398,016
|
| SOURCE$
| TABLE | SYS
| SYSTEM | 81
| 83,886,080
|
| IDL_UB1$
| TABLE | SYS
| SYSTEM | 45
| 31,457,280
|
| SYS_LOB0000010794C00025$$
| LOBSEGMENT | XDB
| SYSAUX | 42
| 28,311,552
|
| IDL_UB2$
| TABLE | SYS
| SYSTEM | 28
| 13,631,488
|
| C_TOID_VERSION#
| CLUSTER | SYS
| SYSTEM | 25
| 10,485,760
|
| C_OBJ#
| CLUSTER | SYS
| SYSTEM | 21
| 6,291,456
|
| ARGUMENT$
| TABLE | SYS
| SYSTEM | 21
| 6,291,456
|
| WWV_FLOW_DICTIONARY$CAPED
| INDEX | FLOWS_020100
| SYSAUX | 20
| 5,242,880
|
| XDB$RESOURCE
| TABLE | XDB
| SYSAUX | 20
| 5,242,880
|
| PL/SQL |
| User | Type | Objects | Lines
|
| DBSNMP | PACKAGE
| 3 | 376
|
| DBSNMP | PACKAGE BODY
| 3 | 14
|
| DBSNMP | TYPE
| 6 | 38
|
| FLOWS_FILES | TRIGGER
| 1 | 33
|
| FLOWS_020100 | FUNCTION
| 11 | 204
|
| FLOWS_020100 | PACKAGE
| 156 | 21,134
|
| FLOWS_020100 | PACKAGE BODY
| 149 | 7,113
|
| FLOWS_020100 | PROCEDURE
| 16 | 777
|
| FLOWS_020100 | TRIGGER
| 178 | 4,033
|
| FLOWS_020100 | TYPE
| 5 | 16
|
| HR | PROCEDURE
| 2 | 22
|
| HR | TRIGGER
| 2 | 12
|
| OUTLN | PROCEDURE
| 1 | 6
|
| Scheduled Jobs |
| Job Id | User | Interval | Command
|
| Database Links |
| DB Link | User | Instance
|
| DBMS_CLRDBLINK | | ORACLR_CONNECTION_DATA
|
| Oracle Parameters |
| Parameter | Value
|
| audit_file_dest | C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
|
| background_dump_dest | C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
|
| compatible | 10.2.0.1.0
|
| control_files | C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
|
| core_dump_dest | C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
|
| db_name | XE
|
| db_recovery_file_dest | C:\oraclexe\app\oracle\flash_recovery_area
|
| db_recovery_file_dest_size | 10737418240
|
| dispatchers | (PROTOCOL=TCP) (SERVICE=XEXDB)
|
| job_queue_processes | 4
|
| open_cursors | 300
|
| os_authent_prefix |
|
| pga_aggregate_target | 199229440
|
| remote_login_passwordfile | EXCLUSIVE
|
| sessions | 49
|
| sga_target | 599785472
|
| shared_servers | 4
|
| spfile | C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
|
| undo_management | AUTO
|
| undo_tablespace | UNDO
|
| user_dump_dest | C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
|
| NLS Settings |
| Parameter | Value
|
| NLS_CHARACTERSET | WE8MSWIN1252
|
| NLS_NCHAR_CHARACTERSET | AL16UTF16
|
| NLS_NUMERIC_CHARACTERS | .,
|
For more info on this statistics
refer to the
online documentation.
For more info on detHTML contact
Meo.