| Report Name | dba_snapshot_database_8i_ORA817_20041202.html |
|---|---|
| Date / Time | 12/02/2004 14:57:48 |
| Database Name | ORA817 |
| Global Database Name | ORA817.IDEVELOPMENT.INFO |
| Database Startup Time | 12/02/2004 12:27:49 |
| Database Block Size | 8192 |
| Report Run User | SYSTEM |
| Banner |
|---|
| Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production |
| PL/SQL Release 8.1.7.4.0 - Production |
| CORE 8.1.7.0.0 Production |
| TNS for Solaris: Version 8.1.7.4.0 - Production |
| NLSRTL Version 3.4.1.0.0 - Production |
| Option Name | Installed? |
|---|---|
| Partitioning |
TRUE
|
| Objects |
TRUE
|
| Parallel Server |
FALSE
|
| Advanced replication |
TRUE
|
| Bit-mapped indexes |
TRUE
|
| Connection multiplexing |
TRUE
|
| Connection pooling |
TRUE
|
| Database queuing |
TRUE
|
| Incremental backup and recovery |
TRUE
|
| Instead-of triggers |
TRUE
|
| Parallel backup and recovery |
TRUE
|
| Parallel execution |
TRUE
|
| Parallel load |
TRUE
|
| Point-in-time tablespace recovery |
TRUE
|
| Fine-grained access control |
TRUE
|
| N-Tier authentication/authorization |
TRUE
|
| Function-based indexes |
TRUE
|
| Plan Stability |
TRUE
|
| Online Index Build |
TRUE
|
| Coalesce Index |
TRUE
|
| Managed Standby |
TRUE
|
| Materialized view rewrite |
TRUE
|
| Materialized view warehouse refresh |
TRUE
|
| Database resource manager |
TRUE
|
| Spatial |
TRUE
|
| Visual Information Retrieval |
TRUE
|
| Export transportable tablespaces |
TRUE
|
| Transparent Application Failover |
TRUE
|
| Fast-Start Fault Recovery |
TRUE
|
| Sample Scan |
TRUE
|
| Duplexed backups |
TRUE
|
| Java |
FALSE
|
| OLAP Window Functions |
TRUE
|
| Parameter Name | Value | Is Default? | Is Dynamic? |
|---|---|---|---|
| O7_DICTIONARY_ACCESSIBILITY | TRUE |
FALSE
|
FALSE
|
| _complex_view_merging | TRUE |
FALSE
|
FALSE
|
| _push_join_predicate | TRUE |
FALSE
|
FALSE
|
| _trace_files_public | TRUE |
FALSE
|
FALSE
|
| active_instance_count |
TRUE
|
FALSE
|
|
| always_anti_join | NESTED_LOOPS |
TRUE
|
FALSE
|
| always_semi_join | STANDARD |
TRUE
|
FALSE
|
| aq_tm_processes | 1 |
FALSE
|
IMMEDIATE
|
| audit_file_dest | /u01/app/oracle/admin/ORA817/adump |
FALSE
|
FALSE
|
| audit_trail | NONE |
FALSE
|
FALSE
|
| background_core_dump | partial |
TRUE
|
FALSE
|
| background_dump_dest | /u01/app/oracle/admin/ORA817/bdump |
FALSE
|
IMMEDIATE
|
| backup_tape_io_slaves | FALSE |
TRUE
|
DEFERRED
|
| bitmap_merge_area_size | 1048576 |
TRUE
|
FALSE
|
| blank_trimming | FALSE |
TRUE
|
FALSE
|
| buffer_pool_keep |
TRUE
|
FALSE
|
|
| buffer_pool_recycle |
TRUE
|
FALSE
|
|
| commit_point_strength | 1 |
TRUE
|
FALSE
|
| compatible | 8.1.7 |
FALSE
|
FALSE
|
| control_file_record_keep_time | 7 |
FALSE
|
IMMEDIATE
|
| control_files | /u03/app/oradata/ORA817/control01.ctl, /u04/app/or adata/ORA817/control02.ctl, /u05/app/oradata/ORA817/control03.ctl |
FALSE
|
FALSE
|
| core_dump_dest | /u01/app/oracle/admin/ORA817/cdump |
FALSE
|
IMMEDIATE
|
| cpu_count | 1 |
TRUE
|
FALSE
|
| create_bitmap_area_size | 8388608 |
TRUE
|
FALSE
|
| cursor_sharing | EXACT |
FALSE
|
IMMEDIATE
|
| cursor_space_for_time | FALSE |
TRUE
|
FALSE
|
| db_block_buffers | 10240 |
FALSE
|
FALSE
|
| db_block_checking | FALSE |
FALSE
|
DEFERRED
|
| db_block_checksum | FALSE |
FALSE
|
IMMEDIATE
|
| db_block_lru_latches | 1 |
TRUE
|
FALSE
|
| db_block_max_dirty_target | 10240 |
TRUE
|
IMMEDIATE
|
| db_block_size | 8192 |
FALSE
|
FALSE
|
| db_domain | IDEVELOPMENT.INFO |
FALSE
|
FALSE
|
| db_file_direct_io_count | 64 |
TRUE
|
DEFERRED
|
| db_file_multiblock_read_count | 32 |
FALSE
|
IMMEDIATE
|
| db_file_name_convert |
TRUE
|
FALSE
|
|
| db_files | 600 |
FALSE
|
FALSE
|
| db_name | ORA817 |
FALSE
|
FALSE
|
| db_writer_processes | 1 |
FALSE
|
FALSE
|
| dblink_encrypt_login | FALSE |
TRUE
|
FALSE
|
| dbwr_io_slaves | 0 |
TRUE
|
FALSE
|
| disk_asynch_io | TRUE |
TRUE
|
FALSE
|
| distributed_transactions | 61 |
TRUE
|
FALSE
|
| dml_locks | 988 |
TRUE
|
FALSE
|
| enqueue_resources | 1608 |
TRUE
|
FALSE
|
| event |
TRUE
|
FALSE
|
|
| fast_start_io_target | 10240 |
TRUE
|
IMMEDIATE
|
| fast_start_parallel_rollback | LOW |
TRUE
|
IMMEDIATE
|
| fixed_date |
TRUE
|
IMMEDIATE
|
|
| gc_defer_time | 10 |
TRUE
|
IMMEDIATE
|
| gc_files_to_locks |
TRUE
|
FALSE
|
|
| gc_releasable_locks | 0 |
TRUE
|
FALSE
|
| gc_rollback_locks | 0-1024=32!8REACH |
TRUE
|
FALSE
|
| global_names | FALSE |
FALSE
|
IMMEDIATE
|
| hash_area_size | 1024000 |
TRUE
|
FALSE
|
| hash_join_enabled | TRUE |
TRUE
|
FALSE
|
| hash_multiblock_io_count | 0 |
TRUE
|
IMMEDIATE
|
| hi_shared_memory_address | 0 |
TRUE
|
FALSE
|
| hpux_sched_noage |
TRUE
|
IMMEDIATE
|
|
| hs_autoregister | TRUE |
TRUE
|
IMMEDIATE
|
| ifile |
TRUE
|
FALSE
|
|
| instance_groups |
TRUE
|
FALSE
|
|
| instance_name | ORA817 |
FALSE
|
FALSE
|
| instance_number | 0 |
TRUE
|
FALSE
|
| java_max_sessionspace_size | 0 |
TRUE
|
FALSE
|
| java_pool_size | 30000000 |
FALSE
|
FALSE
|
| java_soft_sessionspace_limit | 0 |
TRUE
|
FALSE
|
| job_queue_interval | 60 |
FALSE
|
FALSE
|
| job_queue_processes | 2 |
FALSE
|
IMMEDIATE
|
| large_pool_size | 20000000 |
FALSE
|
FALSE
|
| license_max_sessions | 0 |
TRUE
|
IMMEDIATE
|
| license_max_users | 0 |
TRUE
|
IMMEDIATE
|
| license_sessions_warning | 0 |
TRUE
|
IMMEDIATE
|
| lm_locks | 12000 |
TRUE
|
FALSE
|
| lm_ress | 6000 |
TRUE
|
FALSE
|
| local_listener |
TRUE
|
FALSE
|
|
| lock_name_space |
TRUE
|
FALSE
|
|
| lock_sga | FALSE |
TRUE
|
FALSE
|
| log_archive_dest |
TRUE
|
IMMEDIATE
|
|
| log_archive_dest_1 | location=/u06/app/oradata/ORA817/archive MANDATORY |
FALSE
|
IMMEDIATE
|
| log_archive_dest_2 | service=ORA817_STBY OPTIONAL REOPEN=30 |
FALSE
|
IMMEDIATE
|
| log_archive_dest_3 |
TRUE
|
IMMEDIATE
|
|
| log_archive_dest_4 |
TRUE
|
IMMEDIATE
|
|
| log_archive_dest_5 |
TRUE
|
IMMEDIATE
|
|
| log_archive_dest_state_1 | enable |
FALSE
|
IMMEDIATE
|
| log_archive_dest_state_2 | defer |
FALSE
|
IMMEDIATE
|
| log_archive_dest_state_3 | enable |
TRUE
|
IMMEDIATE
|
| log_archive_dest_state_4 | enable |
TRUE
|
IMMEDIATE
|
| log_archive_dest_state_5 | enable |
TRUE
|
IMMEDIATE
|
| log_archive_duplex_dest |
TRUE
|
IMMEDIATE
|
|
| log_archive_format | arch_t%t_s%s.dbf |
FALSE
|
FALSE
|
| log_archive_max_processes | 1 |
TRUE
|
IMMEDIATE
|
| log_archive_min_succeed_dest | 1 |
TRUE
|
IMMEDIATE
|
| log_archive_start | TRUE |
FALSE
|
FALSE
|
| log_archive_trace | 0 |
TRUE
|
IMMEDIATE
|
| log_buffer | 32768 |
FALSE
|
FALSE
|
| log_checkpoint_interval | 0 |
TRUE
|
IMMEDIATE
|
| log_checkpoint_timeout | 21600 |
FALSE
|
IMMEDIATE
|
| log_checkpoints_to_alert | TRUE |
FALSE
|
FALSE
|
| log_file_name_convert |
TRUE
|
FALSE
|
|
| max_commit_propagation_delay | 700 |
TRUE
|
FALSE
|
| max_dump_file_size | unlimited |
FALSE
|
IMMEDIATE
|
| max_enabled_roles | 145 |
FALSE
|
FALSE
|
| max_rollback_segments | 49 |
TRUE
|
FALSE
|
| mts_circuits | 0 |
TRUE
|
FALSE
|
| mts_dispatchers |
TRUE
|
IMMEDIATE
|
|
| mts_listener_address |
TRUE
|
FALSE
|
|
| mts_max_dispatchers | 5 |
TRUE
|
FALSE
|
| mts_max_servers | 20 |
TRUE
|
FALSE
|
| mts_multiple_listeners | FALSE |
TRUE
|
FALSE
|
| mts_servers | 0 |
TRUE
|
IMMEDIATE
|
| mts_service | ORA817 |
TRUE
|
FALSE
|
| mts_sessions | 0 |
TRUE
|
FALSE
|
| nls_calendar |
TRUE
|
FALSE
|
|
| nls_comp |
TRUE
|
FALSE
|
|
| nls_currency |
TRUE
|
FALSE
|
|
| nls_date_format |
TRUE
|
FALSE
|
|
| nls_date_language |
TRUE
|
FALSE
|
|
| nls_dual_currency |
TRUE
|
FALSE
|
|
| nls_iso_currency |
TRUE
|
FALSE
|
|
| nls_language | AMERICAN |
TRUE
|
FALSE
|
| nls_numeric_characters |
TRUE
|
FALSE
|
|
| nls_sort |
TRUE
|
FALSE
|
|
| nls_territory | AMERICA |
TRUE
|
FALSE
|
| nls_time_format |
TRUE
|
FALSE
|
|
| nls_time_tz_format |
TRUE
|
FALSE
|
|
| nls_timestamp_format |
TRUE
|
FALSE
|
|
| nls_timestamp_tz_format |
TRUE
|
FALSE
|
|
| object_cache_max_size_percent | 10 |
TRUE
|
DEFERRED
|
| object_cache_optimal_size | 102400 |
TRUE
|
DEFERRED
|
| open_cursors | 1000 |
FALSE
|
FALSE
|
| open_links | 10 |
FALSE
|
FALSE
|
| open_links_per_instance | 4 |
TRUE
|
FALSE
|
| ops_interconnects |
TRUE
|
FALSE
|
|
| optimizer_features_enable | 8.1.7 |
TRUE
|
FALSE
|
| optimizer_index_caching | 0 |
TRUE
|
FALSE
|
| optimizer_index_cost_adj | 100 |
TRUE
|
FALSE
|
| optimizer_max_permutations | 80000 |
TRUE
|
FALSE
|
| optimizer_mode | CHOOSE |
FALSE
|
FALSE
|
| optimizer_percent_parallel | 0 |
TRUE
|
FALSE
|
| oracle_trace_collection_name |
TRUE
|
FALSE
|
|
| oracle_trace_collection_path | ?/otrace/admin/cdf |
TRUE
|
FALSE
|
| oracle_trace_collection_size | 5242880 |
TRUE
|
FALSE
|
| oracle_trace_enable | FALSE |
TRUE
|
IMMEDIATE
|
| oracle_trace_facility_name | oracled |
TRUE
|
FALSE
|
| oracle_trace_facility_path | ?/otrace/admin/fdf |
TRUE
|
FALSE
|
| os_authent_prefix | ops$ |
TRUE
|
FALSE
|
| os_roles | FALSE |
TRUE
|
FALSE
|
| parallel_adaptive_multi_user | FALSE |
TRUE
|
IMMEDIATE
|
| parallel_automatic_tuning | FALSE |
FALSE
|
FALSE
|
| parallel_broadcast_enabled | FALSE |
TRUE
|
FALSE
|
| parallel_execution_message_size | 2148 |
TRUE
|
FALSE
|
| parallel_instance_group |
TRUE
|
IMMEDIATE
|
|
| parallel_max_servers | 5 |
FALSE
|
FALSE
|
| parallel_min_percent | 0 |
TRUE
|
FALSE
|
| parallel_min_servers | 0 |
TRUE
|
FALSE
|
| parallel_server | FALSE |
TRUE
|
FALSE
|
| parallel_server_instances | 1 |
TRUE
|
FALSE
|
| parallel_threads_per_cpu | 2 |
TRUE
|
IMMEDIATE
|
| partition_view_enabled | FALSE |
TRUE
|
FALSE
|
| plsql_v2_compatibility | FALSE |
TRUE
|
IMMEDIATE
|
| pre_page_sga | TRUE |
FALSE
|
FALSE
|
| processes | 200 |
FALSE
|
FALSE
|
| query_rewrite_enabled | TRUE |
FALSE
|
IMMEDIATE
|
| query_rewrite_integrity | enforced |
FALSE
|
IMMEDIATE
|
| rdbms_server_dn |
TRUE
|
FALSE
|
|
| read_only_open_delayed | FALSE |
TRUE
|
FALSE
|
| recovery_parallelism | 0 |
TRUE
|
FALSE
|
| remote_dependencies_mode | TIMESTAMP |
TRUE
|
IMMEDIATE
|
| remote_login_passwordfile | EXCLUSIVE |
FALSE
|
FALSE
|
| remote_os_authent | FALSE |
TRUE
|
FALSE
|
| remote_os_roles | FALSE |
TRUE
|
FALSE
|
| replication_dependency_tracking | TRUE |
TRUE
|
FALSE
|
| resource_limit | FALSE |
TRUE
|
IMMEDIATE
|
| resource_manager_plan |
TRUE
|
IMMEDIATE
|
|
| rollback_segments | rbs1, rbs2, rbs3, rbs4, rbs5, rbs6, rbs7, rbs8 |
FALSE
|
FALSE
|
| row_locking | always |
TRUE
|
FALSE
|
| serial_reuse | DISABLE |
TRUE
|
FALSE
|
| serializable | FALSE |
TRUE
|
FALSE
|
| service_names | ORA817_ALEX.IDEVELOPMENT.INFO |
FALSE
|
FALSE
|
| session_cached_cursors | 0 |
TRUE
|
FALSE
|
| session_max_open_files | 10 |
TRUE
|
FALSE
|
| sessions | 225 |
TRUE
|
FALSE
|
| shadow_core_dump | partial |
TRUE
|
FALSE
|
| shared_memory_address | 0 |
TRUE
|
FALSE
|
| shared_pool_reserved_size | 3750000 |
TRUE
|
FALSE
|
| shared_pool_size | 75000000 |
FALSE
|
FALSE
|
| sort_area_retained_size | 512000 |
FALSE
|
DEFERRED
|
| sort_area_size | 512000 |
FALSE
|
DEFERRED
|
| sort_multiblock_read_count | 2 |
TRUE
|
DEFERRED
|
| sql92_security | FALSE |
TRUE
|
FALSE
|
| sql_trace | FALSE |
TRUE
|
FALSE
|
| sql_version | NATIVE |
TRUE
|
FALSE
|
| standby_archive_dest | ?/dbs/arch |
TRUE
|
IMMEDIATE
|
| star_transformation_enabled | FALSE |
TRUE
|
FALSE
|
| tape_asynch_io | TRUE |
TRUE
|
FALSE
|
| text_enable | FALSE |
TRUE
|
IMMEDIATE
|
| thread | 0 |
TRUE
|
FALSE
|
| timed_os_statistics | 0 |
TRUE
|
IMMEDIATE
|
| timed_statistics | TRUE |
FALSE
|
IMMEDIATE
|
| tracefile_identifier |
TRUE
|
FALSE
|
|
| transaction_auditing | TRUE |
TRUE
|
DEFERRED
|
| transactions | 247 |
TRUE
|
FALSE
|
| transactions_per_rollback_segment | 5 |
TRUE
|
FALSE
|
| use_indirect_data_buffers | FALSE |
TRUE
|
FALSE
|
| user_dump_dest | /u01/app/oracle/admin/ORA817/udump |
FALSE
|
IMMEDIATE
|
| utl_file_dir | /u01/app/oracle/common/out, /u01/app/oracle/common /extproc |
FALSE
|
FALSE
|
|
Instance
Num |
Instance
Name |
Host
Name |
Oracle
Version |
Parallel |
Instance
Status |
Start
Time |
Current
Time |
Uptime
(in days) |
Logins | Archiver |
|---|---|---|---|---|---|---|---|---|---|---|
|
1
|
ORA817
|
alex
|
8.1.7.4.0
|
NO
|
OPEN
|
12/02/2004 12:27:49
|
12/02/2004 14:57:48
|
.1 |
ALLOWED
|
STARTED
|
| DB Name | DB ID | Log Mode | Version Time | Open Mode |
|---|---|---|---|---|
|
ORA817
|
1701256249
|
ARCHIVELOG
|
08/28/2004 14:15:21
|
READ WRITE
|
| Job ID | User | What | Next Run Date | Interval | Last Run Date | Failures | Broken? |
|---|---|---|---|---|---|---|---|
|
1
|
SCOTT | test_proc; | 12/03/2004 13:43:54 | sysdate + 1 | 12/02/2004 13:43:54 |
0
|
N
|
|
2
|
SCOTT | test_proc; | 01/01/4000 00:00:00 | sysdate + 1 | 12/02/2004 14:27:07 |
0
|
Y
|
| Current No. of Processes | Max No. of Processes | % Usage |
|---|---|---|
|
19
|
200
|
9.5%
|
| Controlfile Name | Status |
|---|---|
| /u03/app/oradata/ORA817/control01.ctl |
VALID
|
| /u04/app/oradata/ORA817/control02.ctl |
VALID
|
| /u05/app/oradata/ORA817/control03.ctl |
VALID
|
| Record Section Type |
Record Size
(in bytes) |
Records Allocated | Bytes Allocated | Records Used | Bytes Used | % Used | First Index | Last Index | Last RecID |
|---|---|---|---|---|---|---|---|---|---|
|
ARCHIVED LOG
|
584 | 1,007 | 588,088 | 10 | 5,840 | 1 | 1 | 10 | 10 |
|
BACKUP CORRUPTION
|
44 | 742 | 32,648 | 0 | 0 | 0 | 0 | 0 | |
|
BACKUP DATAFILE
|
116 | 1,056 | 122,496 | 27 | 3,132 | 3 | 1 | 27 | 27 |
|
BACKUP PIECE
|
736 | 1,009 | 742,624 | 9 | 6,624 | 1 | 1 | 9 | 9 |
|
BACKUP REDOLOG
|
76 | 107 | 8,132 | 5 | 380 | 5 | 1 | 5 | 5 |
|
BACKUP SET
|
40 | 612 | 24,480 | 9 | 360 | 1 | 1 | 9 | 9 |
|
CKPT PROGRESS
|
4,084 | 10 | 40,840 | 0 | 0 | 0 | 0 | 0 | |
|
COPY CORRUPTION
|
40 | 612 | 24,480 | 0 | 0 | 0 | 0 | 0 | |
|
DATABASE
|
192 | 1 | 192 | 1 | 192 | 100 | 0 | 0 | 0 |
|
DATAFILE COPY
|
660 | 1,002 | 661,320 | 6 | 3,960 | 1 | 1 | 6 | 6 |
|
DATAFILE
|
180 | 600 | 108,000 | 9 | 1,620 | 2 | 0 | 0 | 32 |
|
DELETED OBJECT
|
20 | 1,225 | 24,500 | 16 | 320 | 1 | 1 | 16 | 16 |
|
FILENAME
|
524 | 761 | 398,764 | 19 | 9,956 | 2 | 0 | 0 | 0 |
|
LOG HISTORY
|
36 | 1,134 | 40,824 | 43 | 1,548 | 4 | 1 | 43 | 43 |
|
OFFLINE RANGE
|
56 | 729 | 40,824 | 0 | 0 | 0 | 0 | 0 | |
|
PROXY COPY
|
852 | 1,006 | 857,112 | 0 | 0 | 0 | 0 | 0 | |
|
REDO LOG
|
72 | 32 | 2,304 | 3 | 216 | 9 | 0 | 0 | 3 |
|
REDO THREAD
|
104 | 10 | 1,040 | 1 | 104 | 10 | 0 | 0 | 0 |
|
RESERVED1
|
56 | 600 | 33,600 | 1 | 56 | 0 | 0 | 1 | |
|
RESERVED2
|
1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | |
|
RESERVED4
|
1 | 8,168 | 8,168 | 0 | 0 | 0 | 0 | 0 | |
|
TABLESPACE
|
68 | 600 | 40,800 | 9 | 612 | 2 | 0 | 0 | 9 |
| ----------- | ----------------- | --------------- | ------------ | ------------ | ------ | ||||
| Average: | 6 | ||||||||
| Total: | 8,542 | 21,024 | 3,801,237 | 168 | 34,920 |
| Member | Group Number | Bytes |
|---|---|---|
| /u03/app/oradata/ORA817/redo_g01a.log | 1 | 52,428,800 |
| /u04/app/oradata/ORA817/redo_g01b.log | 1 | 52,428,800 |
| /u05/app/oradata/ORA817/redo_g01c.log | 1 | 52,428,800 |
| /u03/app/oradata/ORA817/redo_g02a.log | 2 | 52,428,800 |
| /u04/app/oradata/ORA817/redo_g02b.log | 2 | 52,428,800 |
| /u05/app/oradata/ORA817/redo_g02c.log | 2 | 52,428,800 |
| /u03/app/oradata/ORA817/redo_g03a.log | 3 | 52,428,800 |
| /u04/app/oradata/ORA817/redo_g03b.log | 3 | 52,428,800 |
| /u05/app/oradata/ORA817/redo_g03c.log | 3 | 52,428,800 |
| Day / Time | 00 | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
08/28
|
14 | 5 | 19 | ||||||||||||||||||||||
|
09/02
|
1 | 1 | |||||||||||||||||||||||
|
09/10
|
1 | 1 | |||||||||||||||||||||||
|
09/17
|
1 | 1 | |||||||||||||||||||||||
|
09/23
|
1 | 1 | |||||||||||||||||||||||
|
09/24
|
1 | 1 | |||||||||||||||||||||||
|
09/30
|
1 | 1 | |||||||||||||||||||||||
|
10/07
|
1 | 1 | |||||||||||||||||||||||
|
10/13
|
1 | 1 | |||||||||||||||||||||||
|
10/19
|
1 | 1 | |||||||||||||||||||||||
|
10/25
|
1 | 1 | |||||||||||||||||||||||
|
10/31
|
1 | 1 | |||||||||||||||||||||||
|
11/10
|
1 | 1 | |||||||||||||||||||||||
|
11/16
|
1 | 1 | |||||||||||||||||||||||
|
11/22
|
1 | 1 | |||||||||||||||||||||||
|
11/28
|
1 | 1 | |||||||||||||||||||||||
|
12/02
|
3 | 2 | 4 | 9 | |||||||||||||||||||||
| ------------ | |||||||||||||||||||||||||
| Average: | 3 | ||||||||||||||||||||||||
| Total: | 43 |
| Latch Name | Gets | Misses | Sleeps | Immediate Gets | Immediate Misses |
|---|---|---|---|---|---|
|
Redo Allocation
|
290,596 | 3 | 3 | 0 | 0 |
|
Redo Copy
|
18 | 0 | 0 | 266,803 | 48 |
|
Redo Writing
|
37,758 | 2 | 4 | 0 | 0 |
| ------------------------ | ---------------- | ---------------- | ------------------------ | ---------------- | |
| Total: | 328,372 | 5 | 7 | 266,803 | 48 |
System Statistics Like redo%
| Statistics Name | Value |
|---|---|
|
Redo Synch Writes
|
72 |
|
Redo Synch Time
|
25 |
|
Redo Entries
|
261,134 |
|
Redo Size
|
292,347,180 |
|
Redo Buffer Allocation Retries
|
5,674 |
|
Redo Wastage
|
2,262,988 |
|
Redo Writer Latching Time
|
70 |
|
Redo Writes
|
8,903 |
|
Redo Blocks Written
|
593,972 |
|
Redo Write Time
|
42,643 |
|
Redo Log Space Requests
|
5 |
|
Redo Log Space Wait Time
|
50 |
|
Redo Log Switch Interrupts
|
0 |
|
Redo Ordering Marks
|
0 |
| Month | Growth (Bytes) |
|---|---|
|
2004-08
|
3,822,059,520 |
|
2004-11
|
5,242,880 |
|
2004-12
|
1,048,576 |
| ---------------- | |
| Total: | 3,828,350,976 |
| Status | Tablespace Name | TS Type | Ext. Mgt. | Tablespace Size | Free (in bytes) | Used (in bytes) | Pct. Used |
|---|---|---|---|---|---|---|---|
|
ONLINE
|
DRSYS | PERMANENT | LOCAL | 104,857,600 | 100,466,688 | 4,390,912 |
4 %
|
|
ONLINE
|
PERFSTAT | PERMANENT | LOCAL | 524,288,000 | 524,222,464 | 65,536 |
0 %
|
|
ONLINE
|
RBS1 | PERMANENT | LOCAL | 1,048,576,000 | 954,204,160 | 94,371,840 |
9 %
|
|
ONLINE
|
RBS2 | PERMANENT | LOCAL | 1,048,576,000 | 943,718,400 | 104,857,600 |
10 %
|
|
ONLINE
|
SYSTEM | PERMANENT | DICTIONARY | 838,860,800 | 585,416,704 | 253,444,096 |
30 %
|
|
ONLINE
|
USERS | PERMANENT | LOCAL | 257,949,696 | 5,701,632 | 252,248,064 |
97 %
|
|
OFFLINE
|
USERS2 | PERMANENT | DICTIONARY | 1,048,576 | 1,040,384 | 8,192 |
0 %
|
|
ONLINE
|
USERS_DICT | PERMANENT | DICTIONARY | 5,242,880 | 1,597,440 | 3,645,440 |
69 %
|
|
ONLINE
|
TEMP | TEMPORARY | LOCAL | 524,288,000 | 510,656,512 | 13,631,488 |
2 %
|
| -------------------- | -------------------- | -------------------- | |||||
| Total: | 4,353,687,552 | 3,627,024,384 | 726,663,168 |
|
Tablespace
Name |
Largest
Extent |
Smallest
Extent |
Total
Free |
Number of
Free Extents |
|---|---|---|---|---|
| DRSYS | 100,466,688 | 100,466,688 | 100,466,688 | 1 |
| PERFSTAT | 524,222,464 | 524,222,464 | 524,222,464 | 1 |
| RBS1 | 954,204,160 | 954,204,160 | 954,204,160 | 1 |
| RBS2 | 943,718,400 | 943,718,400 | 943,718,400 | 1 |
| SYSTEM | 585,416,704 | 585,416,704 | 585,416,704 | 1 |
| USERS2 | 1,040,384 | 1,040,384 | 1,040,384 | 1 |
| USERS | 5,177,344 | 524,288 | 5,701,632 | 2 |
| USERS_DICT | 1,597,440 | 1,597,440 | 1,597,440 | 1 |
| -------------------- | -------------------- | -------------------- | -------------------- | |
| Total: | 3,115,843,584 | 3,111,190,528 | 3,116,367,872 | 9 |
| Tablespace Name | Owner | Segment Type | Size (in Bytes) | Segment Count |
|---|---|---|---|---|
| DRSYS |
CTXSYS
|
INDEX
|
2,686,976 | 41 |
|
CTXSYS
|
LOBINDEX
|
65,536 | 1 | |
|
CTXSYS
|
LOBSEGMENT
|
65,536 | 1 | |
|
CTXSYS
|
TABLE
|
1,507,328 | 23 | |
| RBS1 |
SYS
|
ROLLBACK
|
83,886,080 | 4 |
| RBS2 |
SYS
|
ROLLBACK
|
94,371,840 | 4 |
| SYSTEM |
AURORA$JIS$UTILITY$
|
INDEX
|
851,968 | 13 |
|
AURORA$JIS$UTILITY$
|
LOBINDEX
|
65,536 | 1 | |
|
AURORA$JIS$UTILITY$
|
LOBSEGMENT
|
65,536 | 1 | |
|
AURORA$JIS$UTILITY$
|
TABLE
|
917,504 | 14 | |
|
MDSYS
|
INDEX
|
983,040 | 15 | |
|
MDSYS
|
LOBINDEX
|
262,144 | 4 | |
|
MDSYS
|
LOBSEGMENT
|
262,144 | 4 | |
|
MDSYS
|
TABLE
|
1,507,328 | 15 | |
|
ORDSYS
|
INDEX
|
851,968 | 13 | |
|
ORDSYS
|
LOBINDEX
|
65,536 | 1 | |
|
ORDSYS
|
LOBSEGMENT
|
65,536 | 1 | |
|
ORDSYS
|
TABLE
|
589,824 | 9 | |
|
OSE$HTTP$ADMIN
|
TABLE
|
196,608 | 3 | |
|
OUTLN
|
INDEX
|
49,152 | 3 | |
|
OUTLN
|
TABLE
|
32,768 | 2 | |
|
SYS
|
CACHE
|
8,192 | 1 | |
|
SYS
|
CLUSTER
|
3,661,824 | 9 | |
|
SYS
|
DEFERRED ROLLBACK
|
65,536 | 1 | |
|
SYS
|
INDEX
|
34,119,680 | 220 | |
|
SYS
|
LOBINDEX
|
131,072 | 5 | |
|
SYS
|
LOBSEGMENT
|
229,376 | 5 | |
|
SYS
|
ROLLBACK
|
2,539,520 | 2 | |
|
SYS
|
TABLE
|
195,297,280 | 169 | |
|
SYSTEM
|
INDEX
|
5,701,632 | 87 | |
|
SYSTEM
|
LOBINDEX
|
851,968 | 13 | |
|
SYSTEM
|
LOBSEGMENT
|
851,968 | 13 | |
|
SYSTEM
|
TABLE
|
3,211,264 | 49 | |
| USERS |
SCOTT
|
INDEX
|
131,072 | 2 |
|
SCOTT
|
LOBINDEX
|
65,536 | 1 | |
|
SCOTT
|
LOBSEGMENT
|
65,536 | 1 | |
|
SCOTT
|
TABLE
|
251,854,848 | 4 | |
| USERS_DICT |
SCOTT
|
TABLE
|
3,637,248 | 1 |
| ****************************************************************** | -------------------- | ---------------- | ||
| Total: | 691,773,440 | 756 |
| Owner | Tablespace Name | Segment Type | Size (in Bytes) | Segment Count |
|---|---|---|---|---|
| AURORA$JIS$UTILITY$ |
SYSTEM
|
INDEX
|
851,968 | 13 |
|
SYSTEM
|
LOBINDEX
|
65,536 | 1 | |
|
SYSTEM
|
LOBSEGMENT
|
65,536 | 1 | |
|
SYSTEM
|
TABLE
|
917,504 | 14 | |
| CTXSYS |
DRSYS
|
INDEX
|
2,686,976 | 41 |
|
DRSYS
|
LOBINDEX
|
65,536 | 1 | |
|
DRSYS
|
LOBSEGMENT
|
65,536 | 1 | |
|
DRSYS
|
TABLE
|
1,507,328 | 23 | |
| MDSYS |
SYSTEM
|
INDEX
|
983,040 | 15 |
|
SYSTEM
|
LOBINDEX
|
262,144 | 4 | |
|
SYSTEM
|
LOBSEGMENT
|
262,144 | 4 | |
|
SYSTEM
|
TABLE
|
1,507,328 | 15 | |
| ORDSYS |
SYSTEM
|
INDEX
|
851,968 | 13 |
|
SYSTEM
|
LOBINDEX
|
65,536 | 1 | |
|
SYSTEM
|
LOBSEGMENT
|
65,536 | 1 | |
|
SYSTEM
|
TABLE
|
589,824 | 9 | |
| OSE$HTTP$ADMIN |
SYSTEM
|
TABLE
|
196,608 | 3 |
| OUTLN |
SYSTEM
|
INDEX
|
49,152 | 3 |
|
SYSTEM
|
TABLE
|
32,768 | 2 | |
| SCOTT |
USERS
|
INDEX
|
131,072 | 2 |
|
USERS
|
LOBINDEX
|
65,536 | 1 | |
|
USERS
|
LOBSEGMENT
|
65,536 | 1 | |
|
USERS
|
TABLE
|
251,854,848 | 4 | |
|
USERS_DICT
|
TABLE
|
3,637,248 | 1 | |
| SYS |
RBS1
|
ROLLBACK
|
83,886,080 | 4 |
|
RBS2
|
ROLLBACK
|
94,371,840 | 4 | |
|
SYSTEM
|
CACHE
|
8,192 | 1 | |
|
SYSTEM
|
CLUSTER
|
3,661,824 | 9 | |
|
SYSTEM
|
DEFERRED ROLLBACK
|
65,536 | 1 | |
|
SYSTEM
|
INDEX
|
34,119,680 | 220 | |
|
SYSTEM
|
LOBINDEX
|
131,072 | 5 | |
|
SYSTEM
|
LOBSEGMENT
|
229,376 | 5 | |
|
SYSTEM
|
ROLLBACK
|
2,539,520 | 2 | |
|
SYSTEM
|
TABLE
|
195,297,280 | 169 | |
| SYSTEM |
SYSTEM
|
INDEX
|
5,701,632 | 87 |
|
SYSTEM
|
LOBINDEX
|
851,968 | 13 | |
|
SYSTEM
|
LOBSEGMENT
|