Database Name (SID): cis Version/SGA Information: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE 9.2.0.1.0 Production TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production Total System Global Area as of March 18th, 2008: 135,338,868 bytes (129 MB) Tablespaces and Datafiles: SP2-0734: unknown command beginning "word_wrapp..." - rest of line ignored. File Size Tablespace ID Datafile in MB. --------------- ----- ------------------------------------------------------------ ----------- CWMLITE 3 D:\ORACLE\ORA_92\ORADATA\cis\CWMLITE01.DBF 20.00 *************** ----------- TS SIZE: 20.00 DRSYS 4 D:\ORACLE\ORA_92\ORADATA\cis\DRSYS01.DBF 20.00 *************** ----------- TS SIZE: 20.00 EXAMPLE 5 D:\ORACLE\ORA_92\ORADATA\cis\EXAMPLE01.DBF 148.75 *************** ----------- TS SIZE: 148.75 cis_INF_USER 19 D:\ORACLE\ORA_92\TABLESPACE\cis_INF_USER.ORA 10.00 *************** ----------- TS SIZE: 10.00 cis_JNK_USER 26 C:\INSTALLED_APPS\ORACLE\ORA92\DATABASE\cis_JNK_USER.ORA 10.00 *************** ----------- TS SIZE: 10.00 cis_KTK 23 C:\INSTALLED_APPS\ORACLE\ORA92\DATABASE\cis_KTK.ORA 10.00 *************** ----------- TS SIZE: 10.00 cis_KTK_DEV_U 27 D:\ORACLE\ORA_92\TABLESPACE\cis_KTK_DEV_USER.ORA 3350.00 SER *************** ----------- TS SIZE: 3350.00 cis_KTK_TEMP 24 C:\INSTALLED_APPS\ORACLE\ORA92\DATABASE\cis_KTK_TEMP.ORA 5.00 *************** ----------- TS SIZE: 5.00 cis_KTK_USER 20 D:\ORACLE\ORA_92\TABLESPACE\cis_KTK_USER.ORA 3720.00 *************** ----------- TS SIZE: 3720.00 cis_YBL_UAT_U 30 D:\ORACLE\ORA_92\TABLESPACE\cis_YBL_UAT_USER.ORA 55.00 SER *************** ----------- TS SIZE: 55.00 INDX 6 D:\ORACLE\ORA_92\ORADATA\cis\INDX01.DBF 25.00 *************** ----------- TS SIZE: 25.00 INTCDR_UBI_USER 14 D:\ORACLE\ORA_92\TABLESPACE\INTCDR_UBI_USER.ORA 10.00 *************** ----------- TS SIZE: 10.00 File Size Tablespace ID Datafile in MB. --------------- ----- ------------------------------------------------------------ ----------- INTCDR_UNB_USER 17 D:\ORACLE\ORA_92\TABLESPACE\INTCDR_UNB_USER.ORA 195.00 *************** ----------- TS SIZE: 195.00 INTCDR_USER 15 D:\ORACLE\ORA_92\TABLESPACE\INTCDR_USER.ORA 375.00 *************** ----------- TS SIZE: 375.00 INTCDR_YBL_USER 12 D:\ORACLE\ORA_92\TABLESPACE\INTCDR_YBL_USER.ORA 10.00 *************** ----------- TS SIZE: 10.00 IRS2007_BOR_USE 21 D:\ORACLE\ORA_92\TABLESPACE\IRS2007_BOR_USER.ORA 10.00 R *************** ----------- TS SIZE: 10.00 IRS2007_JNK_USE 18 D:\ORACLE\ORA_92\TABLESPACE\IRS2007_JNK_USER.ORA 510.00 R *************** ----------- TS SIZE: 510.00 IRS2007_UBI_USE 13 D:\ORACLE\ORA_92\TABLESPACE\IRS2007_UBI_USER.ORA 25.00 R *************** ----------- TS SIZE: 25.00 IRS2007_UNB_DEM 22 D:\ORACLE\ORA_92\TABLESPACE\IRS2007_UNB_DEMO_USER.ORA 10.00 O_USER *************** ----------- TS SIZE: 10.00 IRS2007_UNB_USE 16 D:\ORACLE\ORA_92\TABLESPACE\IRS2007_UNB_USER.ORA 855.00 R *************** ----------- TS SIZE: 855.00 IRS2007_YBL_PRO 29 D:\ORACLE\ORA_92\TABLESPACE\IRS2007_YBL_PROD_USER.ORA 280.00 D_USER *************** ----------- TS SIZE: 280.00 IRS2007_YBL_USE 11 D:\ORACLE\ORA_92\TABLESPACE\IRS2007_YBL_USER.ORA 325.00 R *************** ----------- File Size Tablespace ID Datafile in MB. --------------- ----- ------------------------------------------------------------ ----------- TS SIZE: 325.00 IRSOUT_MST_JNK_ 25 D:\ORACLE\ORA_92\TABLESPACE\IRSOUT_MST_JNK_USER.ORA 10.00 USER *************** ----------- TS SIZE: 10.00 ODM 7 D:\ORACLE\ORA_92\ORADATA\cis\ODM01.DBF 20.00 *************** ----------- TS SIZE: 20.00 SYSTEM 1 D:\ORACLE\ORA_92\ORADATA\cis\SYSTEM01.DBF 470.00 *************** ----------- TS SIZE: 470.00 TOOLS 8 D:\ORACLE\ORA_92\ORADATA\cis\TOOLS01.DBF 10.00 *************** ----------- TS SIZE: 10.00 UNDOTBS1 2 D:\ORACLE\ORA_92\ORADATA\cis\UNDOTBS01.DBF 390.00 *************** ----------- TS SIZE: 390.00 USERS 9 D:\ORACLE\ORA_92\ORADATA\cis\USERS01.DBF 25.00 *************** ----------- TS SIZE: 25.00 XDB 10 D:\ORACLE\ORA_92\ORADATA\cis\XDB01.DBF 38.13 *************** ----------- TS SIZE: 38.13 ----------- DB SIZE: 10941.88 Space usage (as of March 18th, 2008): SP2-0311: string expected but not found SP2-0734: unknown command beginning "9,99999999..." - rest of line ignored. SP2-0311: string expected but not found SP2-0734: unknown command beginning "9,99999999..." - rest of line ignored. Tablespace Size (Mb) Free (Mb) % Free % Used ------------------------- --------------- --------------- ------ ------ ODM 20 11 53 47 XDB 38 0 0 100 INDX 25 25 99 1 DRSYS 20 10 52 48 TOOLS 10 4 39 61 USERS 25 24 97 3 SYSTEM 470 10 2 98 CWMLITE 20 11 53 47 EXAMPLE 149 0 0 100 UNDOTBS1 390 366 94 6 cis_KTK 10 10 99 1 INTCDR_USER 375 8 2 98 cis_INF_USER 10 9 91 9 cis_JNK_USER 10 10 99 1 cis_KTK_TEMP 5 5 99 1 cis_KTK_USER 3720 1 0 100 INTCDR_UBI_USER 10 9 94 6 INTCDR_UNB_USER 195 3 1 99 INTCDR_YBL_USER 10 9 92 8 IRS2007_BOR_USER 10 5 51 49 IRS2007_JNK_USER 510 5 1 99 IRS2007_UBI_USER 25 3 14 86 IRS2007_UNB_USER 855 4 1 99 IRS2007_YBL_USER 325 33 10 90 cis_KTK_DEV_USER 3350 778 23 77 cis_YBL_UAT_USER 55 3 5 95 IRSOUT_MST_JNK_USER 10 10 99 1 IRS2007_UNB_DEMO_USER 10 10 99 1 IRS2007_YBL_PROD_USER 280 280 100 0 --------------- --------------- Totals: 10942 1656 Online Redo Logfiles: Group Size Logfile Number in MB. ------------------------------------------------------------ ------ ---------- D:\ORACLE\ORA_92\ORADATA\cis\REDO01.LOG 1 100.00 D:\ORACLE\ORA_92\ORADATA\cis\REDO02.LOG 2 100.00 D:\ORACLE\ORA_92\ORADATA\cis\REDO03.LOG 3 100.00 Control files: File Name ------------------------------------------------------------ D:\ORACLE\ORA_92\ORADATA\cis\CONTROL01.CTL D:\ORACLE\ORA_92\ORADATA\cis\CONTROL02.CTL D:\ORACLE\ORA_92\ORADATA\cis\CONTROL03.CTL Rollback Segments (sizes as of March 18th, 2008): SP2-0042: unknown command "truncated" - rest of line ignored. SP2-0311: string expected but not found SP2-0042: unknown command "99990.9" - rest of line ignored. Seg Next Min Max Pct Curr Size Tablespace Name Status initial_extent (in M) Ext Ext Inc (in M) --------------- ------- -------- -------------- -------- ------ ------------- ------ --------- SYSTEM SYSTEM ONLINE .109375 1 32765 0 UNDOTBS1 _SYSSMU ONLINE .125 2 32765 2 1$ _SYSSMU ONLINE .125 2 32765 2 2$ _SYSSMU ONLINE .125 2 32765 3 3$ _SYSSMU ONLINE .125 2 32765 2 4$ _SYSSMU ONLINE .125 2 32765 2 5$ _SYSSMU ONLINE .125 2 32765 2 6$ _SYSSMU ONLINE .125 2 32765 3 7$ _SYSSMU ONLINE .125 2 32765 2 8$ _SYSSMU ONLINE .125 2 32765 3 9$ _SYSSMU ONLINE .125 2 32765 2 10$ Parameters (non-defaults): Name Value ----------------------------------- -------------------------------------------------- O7_DICTIONARY_ACCESSIBILITY FALSE active_instance_count aq_tm_processes 1 archive_lag_target 0 audit_sys_operations FALSE audit_trail NONE background_core_dump partial background_dump_dest C:\Installed_Apps\oracle\admin\cis\bdump backup_tape_io_slaves FALSE bitmap_merge_area_size 1048576 blank_trimming FALSE buffer_pool_keep buffer_pool_recycle circuits 170 cluster_database FALSE cluster_database_instances 1 cluster_interconnects commit_point_strength 1 compatible 9.2.0.0.0 control_file_record_keep_time 7 control_files D:\oracle\ora_92\oradata\cis\CONTROL01.CTL, D:\oracle\ora_92\oradata\cis\CONTROL02.CTL, D:\oracle\ora_92\oradata\cis\CONTROL03.CTL core_dump_dest C:\Installed_Apps\oracle\admin\cis\cdump cpu_count 4 create_bitmap_area_size 8388608 cursor_sharing EXACT cursor_space_for_time FALSE db_16k_cache_size 0 db_2k_cache_size 0 db_32k_cache_size 0 db_4k_cache_size 0 db_8k_cache_size 0 db_block_buffers 0 db_block_checking FALSE db_block_checksum TRUE db_block_size 8192 db_cache_advice ON db_cache_size 25165824 db_create_file_dest db_create_online_log_dest_1 db_create_online_log_dest_2 db_create_online_log_dest_3 db_create_online_log_dest_4 db_create_online_log_dest_5 db_domain db_file_multiblock_read_count 16 db_file_name_convert db_files 200 db_keep_cache_size 0 db_name cis db_recycle_cache_size 0 Name Value ----------------------------------- -------------------------------------------------- db_writer_processes 1 dblink_encrypt_login FALSE dbwr_io_slaves 0 dg_broker_config_file1 %ORACLE_HOME%\DATABASE\DR1%ORACLE_SID%.DAT dg_broker_config_file2 %ORACLE_HOME%\DATABASE\DR2%ORACLE_SID%.DAT dg_broker_start FALSE disk_asynch_io TRUE dispatchers (PROTOCOL=TCP) (SERVICE=cisXDB) distributed_lock_timeout 60 dml_locks 748 drs_start FALSE enqueue_resources 968 event fal_client fal_server fast_start_io_target 0 fast_start_mttr_target 300 fast_start_parallel_rollback LOW file_mapping FALSE filesystemio_options fixed_date gc_files_to_locks global_context_pool_size global_names FALSE hash_area_size 1048576 hash_join_enabled TRUE hi_shared_memory_address 0 hs_autoregister TRUE ifile instance_groups instance_name cis instance_number 0 java_max_sessionspace_size 0 java_pool_size 33554432 java_soft_sessionspace_limit 0 job_queue_processes 10 large_pool_size 8388608 license_max_sessions 0 license_max_users 0 license_sessions_warning 0 local_listener lock_name_space lock_sga FALSE log_archive_dest log_archive_dest_1 log_archive_dest_10 log_archive_dest_2 log_archive_dest_3 log_archive_dest_4 log_archive_dest_5 log_archive_dest_6 log_archive_dest_7 log_archive_dest_8 Name Value ----------------------------------- -------------------------------------------------- log_archive_dest_9 log_archive_dest_state_1 enable log_archive_dest_state_10 enable log_archive_dest_state_2 enable log_archive_dest_state_3 enable log_archive_dest_state_4 enable log_archive_dest_state_5 enable log_archive_dest_state_6 enable log_archive_dest_state_7 enable log_archive_dest_state_8 enable log_archive_dest_state_9 enable log_archive_duplex_dest log_archive_format ARC%S.%T log_archive_max_processes 2 log_archive_min_succeed_dest 1 log_archive_start FALSE log_archive_trace 0 log_buffer 524288 log_checkpoint_interval 0 log_checkpoint_timeout 1800 log_checkpoints_to_alert FALSE log_file_name_convert log_parallelism 1 logmnr_max_persistent_sessions 1 max_commit_propagation_delay 700 max_dispatchers 5 max_dump_file_size UNLIMITED max_enabled_roles 30 max_rollback_segments 37 max_shared_servers 20 mts_circuits 170 mts_dispatchers (PROTOCOL=TCP) (SERVICE=cisXDB) mts_listener_address mts_max_dispatchers 5 mts_max_servers 20 mts_multiple_listeners FALSE mts_servers 1 mts_service cis mts_sessions 165 nls_calendar nls_comp nls_currency nls_date_format nls_date_language nls_dual_currency nls_iso_currency nls_language AMERICAN nls_length_semantics BYTE nls_nchar_conv_excp FALSE nls_numeric_characters nls_sort nls_territory AMERICA nls_time_format Name Value ----------------------------------- -------------------------------------------------- nls_time_tz_format nls_timestamp_format nls_timestamp_tz_format object_cache_max_size_percent 10 object_cache_optimal_size 102400 olap_page_pool_size 33554432 open_cursors 300 open_links 4 open_links_per_instance 4 optimizer_dynamic_sampling 1 optimizer_features_enable 9.2.0 optimizer_index_caching 0 optimizer_index_cost_adj 100 optimizer_max_permutations 2000 optimizer_mode CHOOSE oracle_trace_collection_name oracle_trace_collection_path %ORACLE_HOME%\OTRACE\ADMIN\CDF\ oracle_trace_collection_size 5242880 oracle_trace_enable FALSE oracle_trace_facility_name oracled oracle_trace_facility_path %ORACLE_HOME%\OTRACE\ADMIN\FDF\ os_authent_prefix OPS$ os_roles FALSE parallel_adaptive_multi_user FALSE parallel_automatic_tuning FALSE parallel_execution_message_size 2148 parallel_instance_group parallel_max_servers 5 parallel_min_percent 0 parallel_min_servers 0 parallel_server FALSE parallel_server_instances 1 parallel_threads_per_cpu 2 partition_view_enabled FALSE pga_aggregate_target 25165824 plsql_compiler_flags INTERPRETED plsql_native_c_compiler plsql_native_library_dir plsql_native_library_subdir_count 0 plsql_native_linker plsql_native_make_file_name plsql_native_make_utility plsql_v2_compatibility FALSE pre_page_sga FALSE processes 150 query_rewrite_enabled FALSE query_rewrite_integrity enforced rdbms_server_dn read_only_open_delayed FALSE recovery_parallelism 0 remote_archive_enable true remote_dependencies_mode TIMESTAMP remote_listener Name Value ----------------------------------- -------------------------------------------------- remote_login_passwordfile EXCLUSIVE remote_os_authent FALSE remote_os_roles FALSE replication_dependency_tracking TRUE resource_limit FALSE resource_manager_plan rollback_segments row_locking always serial_reuse DISABLE serializable FALSE service_names cis session_cached_cursors 0 session_max_open_files 10 sessions 170 sga_max_size 135338868 shadow_core_dump partial shared_memory_address 0 shared_pool_reserved_size 2516582 shared_pool_size 50331648 shared_server_sessions 165 shared_servers 1 sort_area_retained_size 0 sort_area_size 524288 spfile %ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA sql92_security FALSE sql_trace FALSE sql_version NATIVE standby_archive_dest %ORACLE_HOME%\RDBMS standby_file_management MANUAL star_transformation_enabled FALSE statistics_level TYPICAL tape_asynch_io TRUE thread 0 timed_os_statistics 0 timed_statistics TRUE trace_enabled TRUE tracefile_identifier transaction_auditing TRUE transactions 187 transactions_per_rollback_segment 5 undo_management AUTO undo_retention 10800 undo_suppress_errors FALSE undo_tablespace UNDOTBS1 use_indirect_data_buffers FALSE user_dump_dest C:\Installed_Apps\oracle\admin\cis\udump utl_file_dir workarea_size_policy AUTO user details : USERNAME PROFILE DEFAULT_TABLESPACE TEMPORARY_TABLESPACE ------------------------------ ------------------------------ ------------------------------ ------------------------------ SYS DEFAULT SYSTEM TEMP SYSTEM DEFAULT SYSTEM TEMP DBSNMP DEFAULT SYSTEM TEMP IRS2007_YBL DEFAULT IRS2007_YBL_USER TEMP INTCDR_YBL DEFAULT INTCDR_YBL_USER TEMP SCOTT DEFAULT SYSTEM TEMP IRS2007_UBI DEFAULT IRS2007_UBI_USER TEMP INTCDR DEFAULT INTCDR_USER TEMP INTCDR_UNB DEFAULT INTCDR_UNB_USER TEMP IRS2007_YBL_PROD DEFAULT IRS2007_YBL_PROD_USER TEMP cis_KTK_DEV DEFAULT cis_KTK_DEV_USER TEMP cis_JNK DEFAULT cis_JNK_USER TEMP IRSOUT_MST_JNK DEFAULT IRSOUT_MST_JNK_USER TEMP IRS2007_UNB_DEMO DEFAULT IRS2007_UNB_DEMO_USER TEMP IRS2007_BOR DEFAULT IRS2007_BOR_USER TEMP cis_KTK DEFAULT cis_KTK_USER TEMP cis_INF DEFAULT cis_INF_USER TEMP IRS2007_JNK DEFAULT IRS2007_JNK_USER TEMP cis_YBL_UAT DEFAULT cis_YBL_UAT_USER TEMP IRS2007_UNB DEFAULT IRS2007_UNB_USER TEMP INTCDR_UBI DEFAULT INTCDR_UBI_USER TEMP OUTLN DEFAULT SYSTEM TEMP WMSYS DEFAULT SYSTEM TEMP ORDSYS DEFAULT SYSTEM TEMP ORDPLUGINS DEFAULT SYSTEM TEMP MDSYS DEFAULT SYSTEM TEMP CTXSYS DEFAULT DRSYS TEMP XDB DEFAULT XDB TEMP ANONYMOUS DEFAULT XDB TEMP WKSYS DEFAULT DRSYS TEMP WKPROXY DEFAULT DRSYS TEMP ODM DEFAULT ODM TEMP ODM_MTR DEFAULT ODM TEMP OLAPSYS DEFAULT CWMLITE TEMP RMAN DEFAULT TOOLS TEMP HR DEFAULT EXAMPLE TEMP OE DEFAULT EXAMPLE TEMP PM DEFAULT EXAMPLE TEMP SH DEFAULT EXAMPLE TEMP QS_ADM DEFAULT EXAMPLE TEMP QS DEFAULT EXAMPLE TEMP QS_WS DEFAULT EXAMPLE TEMP QS_ES DEFAULT EXAMPLE TEMP QS_OS DEFAULT EXAMPLE TEMP QS_CBADM DEFAULT EXAMPLE TEMP QS_CB DEFAULT EXAMPLE TEMP QS_CS DEFAULT EXAMPLE TEMP user details : user details : user details : PARAMETER VALUE ------------------------------ ---------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8MSWIN1252 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_RDBMS_VERSION 9.2.0.1.0 TABLESPACE_NAME BLOCK_SIZE EXTENT_MAN SEGMEN ------------------------------ ---------- ---------- ------ SYSTEM 8192 LOCAL MANUAL UNDOTBS1 8192 LOCAL MANUAL TEMP 8192 LOCAL MANUAL CWMLITE 8192 LOCAL AUTO DRSYS 8192 LOCAL AUTO EXAMPLE 8192 LOCAL AUTO INDX 8192 LOCAL AUTO ODM 8192 LOCAL AUTO TOOLS 8192 LOCAL AUTO USERS 8192 LOCAL AUTO XDB 8192 LOCAL AUTO IRS2007_YBL_USER 8192 LOCAL MANUAL INTCDR_YBL_USER 8192 LOCAL MANUAL IRS2007_UBI_USER 8192 LOCAL MANUAL INTCDR_UBI_USER 8192 LOCAL MANUAL IRS2007_UNB_USER 8192 LOCAL MANUAL INTCDR_UNB_USER 8192 LOCAL MANUAL IRS2007_JNK_USER 8192 LOCAL MANUAL cis_INF_USER 8192 LOCAL MANUAL cis_KTK_USER 8192 LOCAL MANUAL cis_KTK 8192 LOCAL MANUAL cis_KTK_TEMP 8192 LOCAL MANUAL IRSOUT_MST_JNK_USER 8192 LOCAL MANUAL cis_JNK_USER 8192 LOCAL MANUAL cis_KTK_DEV_USER 8192 LOCAL MANUAL IRS2007_YBL_PROD_USER 8192 LOCAL MANUAL cis_YBL_UAT_USER 8192 LOCAL MANUAL INTCDR_USER 8192 LOCAL MANUAL IRS2007_BOR_USER 8192 LOCAL MANUAL IRS2007_UNB_DEMO_USER 8192 LOCAL MANUAL