# ## $"WL8  L8 '4AS[gv4@U_jsz*''?+g++(,g,,v/ 00m1112222H2[2m22333a44#5Y5566667"767I7^7p77777777 8808C8L8 Pr> `   Instance %sTermout %sEcho %sTiming %sCycle %uSpool %sNumwidth %uDatewidth %uLongwidth %uCharwidth %uStoponerror %sTerminal %s \~)KUbyMaxdata %uDebug %sArraysize %uAutorecovery %sCompatibility V%dRetries %sFetchrows %s.. %s %s. %s %s.Instance ORACLE .Instance ORACLE .%lu . Vx !K"[#m$%&'%lu . . . %7.2f ( ) %7.2f ()/ %7.2f ( ) %7.2f () %7.2f %7.2f %s. %s. . . SQL*DBA . . . (V)j*+,-./=0c1j2341 .1 . log %s %s %.*s log %lu log %lu log online %lu ... . . log. 5V6789:;< =*>M?}@A log: {=suggested_filename_AUTO_FROM logsource_CANCEL}1 log .%lu logs . log... log... %s . instance........ ........System Global Area %13lu bytes%24.*s %13lu bytes DVE}FGHIJRKeL{PQRS ... Monitors. ; Monitors...: %s %s .: %s %s.%s . %s %s: %s %s.%s:... Lab %d %s log %sT8UTV|WXYZJ[ log : %s %d %d: .: .: .: LICENCE_MAX_USERS , . \J]|^_`ab]defg--- --- %s Server %s %s , %s, Server %s Oracle SQL SQL92 %s Level %s SPOOL LOG ARCHIVE LOGh\iwjklmnoqr1sRtnuv RECOVER INSTANCE ECHO TERMOUT TIMING CYCLE SET SHOW PFILE SHUTDOWN tablespace wVxqyz{|}~%<dz STARTUP STOPONERROR MONITOR SET tablespace ARCHIVE VERIFY STARTUP DEBUG (1 - %u) ARCHIVE TO host/ Ps'n AUTORECOVERY Block PL/SQL ALTER DATABASE COMPATIBILITY RETRIES , DESCRIBE DESCRIBE HISTORYz8\ LINES TERM ( PAGE NOPAGE) SERVEROUTPUT FLAGGER switch Help Help Help Help SQL*DBA Help , ... >De1 Help ******** [Esc k] [Ctrl k] ********: On Line %s ****************************************************** * * * *tmw * * Help ********** ' ' **********---------- ------- Monitor Help o Drawn View V^eoyO (.. '&2&') '&1&' %s %s %s , %s, - , %s, - >-f , %s, - , ORA_RDBMS:%s<>.MSB '&N&' %s %s %s [ ] [ ] DU,V-.0112r34 , : [%d], [%s] SET INSTANCE / [%d] - buffer (%u) (1 - %d) spool %s spool 5>6d7:;<>h?@ spool %s %s buffer host %s SQL*DBA [%d] sqldba, %s sqldba, %s AJBdEGHI"J@K[PQU instance buffer pfile SHOW SGA log Buffer SQL SHOW PARAMETERS instance '%.*s' VDWkXYZ[\4]S^_ tablespaces offline tablespaces online segments rollback segments rollback offline segments rollback online `Jatbcdefg4hUij tablespaces online backup tablespaces online backup tablespaces offline offline monitor %.*s , 'DESCRIBE <>.<>'k,l_mnrGsy %.*s %.*s , %.*s , %.*s , [[a.]b.]c@dblink /, / , %st2uuvwxyKz / , %s %d toolkit %s , %s {>|a}~$T() () SERVEROUTPUT %s %s %s %s sqldba, %s sqldba, %s toolkit, %s toolkit, %s8II SQL*DBA , : toolkit %s %s %s %s %s, : %s %s SQL*DBA MONITORCycle n - 'n' secExit - Monitor,jEFile IO - / IO [pid] [pid] - / LAtch - Latches LOck [all] [pid] [pid] - Locks /Process [pid] [pid] - Rollback - segment rollback8LSPool [ ? OFF] - / logSTatistics [class] [pid] [pid] [cps] - Table [pid] [pid] - User [pid] [pid] - (C,E,F,I,LA,LO,P,R,SP,ST,T,U) (): 0 100 0 100 0 100PID Obj# n8Wq Monitor Latch ORACLE Latch%s %.2s%sMonitor Lock ORACLE = .case = waiterS= X= L=-S R=-X C=S/-X Monitor ORACLE ORACLE PID PID Monitor ORACLE ORACLE PID: #: :2xu CUR AVG MAX MIN TOT Monitor ORACLE ORACLE Latch PID PID tUamy SID IDTID:UBA:SCN:FORGROUND BACKGROUND ------------ ------ PID . :. Latch: . Lock: #: : %-6.*s : NONE NONE \p9[cwNONE NONE NONE Monitor ORACLE ... ( %u) : %-6.*sMonitor / ORACLE ------------------------------------------------PID(SNO) : %% %% %% Monitor Segments Rollback ORACLE 8FRS Rollback Extents ID Segment (bytes) Xactions (bytes/sec) Gets/sec Waits/secMonitor / ORACLE Batch . . . blks/ blks/ ms/. ms/. . . : Cur . Cur . Cur D*i . , Server ORACLE7.STARTUP [RESTRICT] [FORCE] [PFILE=filename] [NOMOUNT | MOUNT [EXCLUSIVE | {PARALLEL | SHARED} [RETRY]] | OPEN [RECOVER] [dbname] [EXCLUSIVE | {PARALLEL | SHARED} [RETRY]]] Dvv  eSHUTDOWN [NORMAL | IMMEDIATE | ABORT | dbname]MONITOR { FILE | PROCESS | IO | LATCH | LOCK | ROLLBACK | SESSION | STATISTIC | TABLE }ARCHIVE LOG {{STOP|LIST}|{START|NEXT||ALL}[TO 'destination']}RECOVER { [DATABASE [UNTIL {CANCEL | CHANGE integer | TIME date}] [USING BACKUP CONTROL FILE]] | [TABLESPACE ts-name [,tsname]] J ~ ~  R | [DATAFILE 'filename' [,'filename']]}CONNECT {[username [/password] ]|[INTERNAL]} ['@'instance-spec]DISCONNECTSET : ARRAYSIZE, AUTORECOVERY, CHARWIDTH, COMPATIBILITY CYCLE, DATEWIDTH, ECHO, FETCHROWS, HISTORY, INSTANCE, LABWIDTH, LINES, LOGSOURCE, LONGWIDTH, MAXDATA, NUMWIDTH, RETRIES, SERVEROUTPUT, SPOOL, STOPONERROR, TERM, TERMOUT, TIMINGGG W!W"f#f$%&'()*SHOW : SET ALL, ERRORS, LABEL, PARAMETERS, SGA VAREXITREMEXECUTE pl/sql_blockDESCRIBE {_ ? _ ? _}HOST [_]PRINT SPOOL [ ? OFF]VARIABLE %.*s %.*s %.*s %.*s Null; +>''''`' In/Out ; . : : instance;" ; ?" rollback ;?" rollback ;? ; 'D's''''/'Y'x'' ; ; checkpoint instances; checkpoints instances ; redo log online; ; ; ; spool ( ); SQL*DBA;$********#+$+C+D+i+j+q*+r++z,+{-+.+/+0+1+2+3+4+5+6+7+8+9+:+;+<+=+>+?+ Server Server nstance @+A+B+C+D+E+F+G+%H+&I+6J+7K+GL+HM+XN+YO+P+Q+\+]+^+_+`+a+b+c+d+e+f+g+ Checkpoint Switch Log Dispatcher Server Instance Online Offline h+i+j+k++++ +++++*+++E+F+Z+[+j+k+z+{+++++++++++ Tablespace Online Offline Segment Rollback Thread Thread ++++++++++A+B+x+y+++++++$,%,&,',(, Log Online Backup Tablespaces Online Backup Tablespaces Tablespace Backup '),*,+,,,-,.,/,!0,"1,32,43,C4,D5,S6,T7,j8,k9,x:,y;,<,=,V,W,X,Y,Z,[,\,],^,_,`,a,b,c,d,e,f,g, ServerDispatcher -Thread SQL(h,i, j, k,l,m,n,o,'p,(q,3r,4s,<t,=u,Ov,Pw,ex,fy,qz,r{,y,z,,,,,,,,,,,,,,,,,,,Cache Latch/ / Rollback Monitor Script SQLSpool Spool ,,,,,,-- -!-"-#-$-%- P- ...-.//D/E/F/v/ SQL*DBA Batch Script SQL Script SQL : Spool : :: Serverw/h/p/////// /I/R/_/// 0: :" Instance : Instance " Instance, : Instance Instance Dispatcher -Threads 0n0>0?0p0q000D0J0R0z000000 Dispatcher: Dispatchers: Server -Threads Server: # # CommitRollback : Tablespace:. .: : . Segment Online 0t111 1 1 1 18191#:19;1P<1d=1wj1k1l1m1 Offline .::. ., KM Extent: Extent: # Extents: # Extents:% : TablespaceTablespace: ., .. . 1\1x11111 1E1u11111Tablespaces OnlineTablespaces Offline Tablespaces Tablespace Online Tablespace Offline Checkpoints . . Tablespace Checkpoints Online . . Tablespace Checkpoints . . Tablespace Offline Tablespace : : 1P1111111.1]1v11 Segment Segment Rollback Tablespace: : Tablespace ( Instances) ( Instance) Segment Rollback Segment:Segments Rollback OnlineSegments Rollback Offline Segments Rollback1\1y11122 2/2?2X2g222 Segment RollbackSegment Rollback: Segment Rollback Online Segment Rollback Offline Segment Rollback Online . Redo Log Thread: : Online Redo Log: :. . Redo Log Online Online . Redo Log Redo Log Online: 2t 2 2 2 2222/2;2N2w2|222222 Log Online Redo Log .: #: Online . Redo Log Online Redo Log Online Redo Log# Log Redo Log Online:. ThreadThread: M Threads. Thread .2b2{222 2!2"2#23$2P%2b&2'2(222 .: Threads . .. . Thread: : : . :. Log: : Redo 32425262728292:2;28<2J=2L>2P?2[@2kA2rB2C2D2E2F2G2H2. Tablespace: . Tablespace Tablespace: Tablespaces:: . . .: Tablespace : : : Tablespace:I2zJ2K2L2M2N2O2 P2.Q28R2WS2zT2U2V2W2X2Y2Z2[2Tablespace Segment: : . . : . . . . . : / / / \2t]2^2_2`2a2b2c2d2e2f21g2Dh2li2~j2k2l2m2 ./ ./ SGA/ : . . : : / :: n2no2p222222 222J2e2}22222 / .:: Backup Online Tablespaces Backup Online TablespacesTablespace Online: Backup s: : Offline TablespaceTablespaces Offline: 22222222 22$2+2h2o2z223333Monitor Server Server Threads ORACLE : : Monitor Dispatcher Server Threads ORACLE/n/n/n/n /n Bytes /n /n/n/n,3z-3.3/3031323334353 ^3_3K`3^a3pb3c3333Monitor Server Threads ORACLE/n /nDispt/nServr----/n/nSeri#/n/n /n/n BytesMonitor Server Threads ORACLE /n /n /n /n /n(sec)Monitor ORACLE ID : ID :333333333 33(383@3N3\3m33333ID/nOracleID/n/n /nLatch/n/nMonitor ORACLE : ID/n/n ID/n/n/n /nLock/n Monitor ORACLE ID : ID : : : ID/n3z3&4'4(4)4*4+4,42X4CY4mZ4[4\4]4^4_4`4a4/n /n Monitor SQL ORACLE : /n SQL/n /n -- --/n /n Cache ORACLE : /n -----------------/n/n/n---------Pins--------/n/n/n/nb4t444444444"4@4Y4k44444/n tnsMonitor Latch ORACLE/n LatchPID/n ---/n /n /n --/n /n Monitor / ORACLE :/n /n /s/n/s Batch/n blks//n blks/ /n ms//n ms/4h44444444'4Y4n4 5!5"5#5 Blocks/n./n Monitor / ORACLE/n ID/n/n ID/n -------------------/n %/n /n %/n /n %/n ----------------/n %/n /n %/n /n %/n :Monitor Segment Rollback ORACLE Segment Rollback:/n IDSegment/n Rollback$5%5&5'5(5)5*5+5,5)-5J.5V/50515R5S5U5V5W5X5Y5 /n (bytes)/nExtents /nXactions/n (bytes/s)--------/n /s/n ./s----(bytes)----/n /n ---(bytes)--/n /n .----------------------/n/n /n /nMonitor ORACLE :RedoEnqueueCacheParServerZ5[5\5]5^5_5`5a555"5)5-54595B5E5S5d5j5n5v5}5555555SQL Monitor ORACLERedoEnqueueCacheParServerSQL Monitor Locks ORACLE :/n ID/n/n /n Lock/n ID 155566666666(6@6Z6r6666666/n ID 2/n /n disconnect_commandgo_to_system_commandnormal_optionimmediate_optionabort_instance_optionlocal_optionglobal_optionforce_log_switch_commandprevent_connection_commandallow_connection_commandstop_auto_archive_commandlist_archive_status_commandspool_off_commandquit_commandcut_commandcopy_commandpaste_commandclear_command66666666666"6:6L6`6g6w6666666previous_commandnext_commandsql_script_commanduse_default_pathscript_to_executespool_on_commandspool_on_file_nameconnect_commandusernamepasswordserver_output_on_commandserver_output_sizeenter_system_commandcommandstart_up_commandparameter_file_optionforce_optionrestrict_to_dbas_optionrecover_optionopen_optionretry_optiondatabase_name_optionmount_option6666666666 626Q6^6r666666retry_optiondatabase_name_optionnomout_optionexclusive_optionparallel_optionmount_database_exclusivemount_database_parallelconfigure_dispatchers_commandprotocolnumber_dispatchersconfigure_shared_server_commandnumber_sharedkill_session_commandkill_session_listrecover_in_doubt_transaction_commandcommit_transactionrollback_transactionin_doubt_transcreate_commandtablespace_name6t666666666,6>6R6f6~6666specify_data_files_optionstorage_optionbring_online_after_creationleave_offline_after_creationfile_specificationfile_specificationfile_specificationfile_specificationfile_specificationfile_specificationfile_specification_kfile_specification_mlog_member_size_option_klog_member_size_option_mfile_specification_addfile_specification_addfile_specification_addfile_specification_add6t77777777(7D 7` 7~ 7 7 7777file_specification_addfile_specification_addfile_specification_addfile_specification_addtablespace_quota_limited_ktablespace_quota_limited_mdbox_quota_limited_kdbox_quota_limited_mset_rollback_segment_storageset_rollback_segment_storageset_rollback_segment_storage_kset_rollback_segment_storage_mrbseg_alterrbseg_alterrbseg_alterrbseg_alterset_default_segment_storageset_default_segment_storage7t77777777717L7g777 7!7"7set_default_segment_storage_kset_default_segment_storage_mtablespace_storagetablespace_storagek_bytesm_bytesset_default_segment_storageset_default_segment_storageset_default_segment_storageset_default_segment_storageset_default_segment_storageset_default_segment_storageset_default_segment_storageset_default_segment_storageset_default_segment_storagetablespace_storageparam_initialparam_next#7$7%7&7'7(7)7*7+7,7-7.7/7907W17s2737475767param_minparam_minparam_maxparam_maxparam_percentparam_percentdrop_commandtablespace_to_dropinclude_contained_objectscascade_dropset_online_command_tablespacetablespace_selection_onlineset_offline_command_tablespacetablespace_selection_offlinenormal_option_droptemporary_optionimmediate_option_dropadd_data_file_commandtablespace_add_data_filesdata_files_add77z8797:7;7<7=7>7?7!@76A7@B7PC7zD7E7F7G7H7I7rename_data_file_commandtablespace_rename_data_filesold_filenamenew_filenamecurrent_datafiles_listcurrent_datafiles_listalter_default_storage_commandtablespace_storagecreate_command_rbsegsrbseg_nametablespace_rbsegoverride_default_storage_parameters_optiontable_space_listtable_space_listpublicprivateset_rollback_segment_storageset_rollback_segment_storageset_rollback_segment_storageJ7K7L7M7N7O7P7Q7'R74S7=T7FU7OV7XW7kX7uY7Z7[7\7]7^7set_rollback_segment_storageset_rollback_segment_storageset_rollback_segment_storageset_rollback_segment_storageset_rollback_segment_storagerbseg_alterrbseg_nextrbseg_optimalrbseg_minrbseg_maxrbseg_maxrbseg_maxdrop_command_rbsegsrbseg_dropset_online_command_rbsegrbseg_onlineset_offline_command_rbsegrbseg_offlinealter_storage_commandrbseg_alteradd_group_command_7t`7a7b7c7d7e7f7g7h7,i7Gj7bk7tl7m7n7o7p7thread_optiongroup_numberonline_redo_log_memberslog_member_size_optionlog_member_size_optionreuse_optiononline_redo_log_members_optiononline_redo_log_membersonline_redo_log_members_addonline_redo_log_members_addonline_redo_log_members_adddrop_group_commandlogfile_group_dropadd_member_commandmembers_to_addonline_redo_log_grouponline_redo_log_group_listonline_redo_log_group_listq7zr7s7t7u7v7w7x7y7'z74{7A|7M}7c~7q77777rename_member_commandold_log_file_namenew_log_file_namedrop_member_commandlog_file_to_droponline_redo_log_member_list_boxonline_redo_log_member_list_boxenable_thread_commandselect_threadthis_instanceany_instancedisable_thread_commanddisable_threadstart_auto_archive_commandoverride_preset_destthread_optionthread_optionthread_number_dialog_boxthread_number_dialog_box7z77777777#7?7T7i7y777777begin_manual_archive_commandspecific_threadnew_archive_destination_optionall_unarchived_groupsoldest_unarchived_groupgroup_numbergroup_numbergroup_member_list_dialog_boxgroup_member_list_dialog_boxspecific_group_numberspecific_group_numberincluding_memberincluding_memberincluding_memberincluding_memberlog_sequence_numberlog_sequence_numberspecific_sequence_numberspecific_sequence_number7z7777777777 7-7:7K7b7y777all_current_redo_informationcreate_user_commanduser_namedefault_tablespacetemporary_tablespaceusers_quotausers_profilerole_password_authrole_password_authrole_os_authuser_passworduser_passwordos_authenticationdefault_tablespace_listdefault_tablespace_listtemporary_tablespace_listtemporary_tablespace_listtablespace_quota_limited_ontablespace_quota_limited_on7t7777777747@7U7m777777tablespace_list_dialog_boxtablespace_list_dialog_boxtemp_segment_tablespace_optiontemp_segment_tablespace_optiondbox_quota_limited_ondbox_quota_limited_onusers_quotatablespace_quota_limited_onquota_optiondbox_quota_limited_ontablespace_quota_limitedtablespace_quota_limitedtablespace_quota_unlimiteddbox_quota_limiteddbox_quota_limiteddbox_quota_unlimitedusers_profileprofile_list77777777777+7?7O7e7{777777profile_optionprofile_list_dialog_boxrole_listrole_listalter_user_commandselect_userdefault_tablespace_optiontemp_segment_tablespace_optionquota_optionprofile_optiondefault_roles_optionno_change_optionchange_password_optionchange_password_optionchange_to_OS_optiondrop_user_commanduser_definition_to_dropinclude_assoc_schemacreate_role_commandrole_namerole_no_auth7777777777 7 757J7`7v77777password_authpassword_authalter_os_authenticationno_authalter_role_commandrole_to_alterdrop_role_commandrole_to_dropcreate_profile_commandcreate_profile_commandalter_profile_commandalter_profile_commandcreate_profile_commandcreate_profile_commandcreate_profile_commandcreate_profile_commandcreate_profile_commandcreate_profile_commandcreate_profile_commandcreate_profile_command7t7777777 7"777L7a7v77777create_profile_commandcreate_profile_commandcreate_profile_commandcreate_profile_commandcreate_profile_commandcreate_profile_commandalter_profile_commandalter_profile_commandalter_profile_commandalter_profile_commandalter_profile_commandalter_profile_commandalter_profile_commandalter_profile_commandalter_profile_commandalter_profile_commandalter_profile_commandalter_profile_command777777777 88*8F8b8v8888 8 8alter_profile_commandalter_profile_commanddrop_profile_commandprofile_to_dropreassign_profilealter_resource_cost_commandcpu_timeconnect_timelogical_readsprivate_sga_spacesystem_privileges_dialog_boxsystem_privileges_dialog_boxsys_priv_&_role_listsys_priv_&_role_listuser_and_role_listuser_and_role_listuser_&_role_list_dialog_boxuser_&_role_list_dialog_boxgrant_commandgrant_option 8 8 88888888,8D8W8h8{888888to_optionallow_granteerevoke_commandrevoke_optionfrom_optionbegin_online_tablespace_backup_commandtablespace_backupend_online_tablespace_backup_commandtablespace_backup_endrecover_database_commandbackup_control_filecomplete_recoveryincomplete_recoveryuntil_useruntil_changeuntil_changeuntil_timeuntil_timerecover_tablespaces_commandtablespace_to_recover8t 8!8"8#8$8%8&8'8(81)8B*8Q+8k,8-8.8/808recover_data_files_commanddata_file_to_recovermonitor_mts_sharedshared_name_filtershared_status_filtermonitor_mts_dispatcherdispatcher_name_filterdispatcher_status_filtermonitor_mts_circuitmonitor_mts_queuemonitor_processprocess_minimum_process_idprocess_maximum_process_idmonitor_sessionsession_username_filtermonitor_tabletable_minimum_process_idtable_maximum_process_id18t2838485868788898:8);8:<8J=8j>8@8A8B8C8table_schema_filtertable_table_filtermonitor_sql_areasql_area_statement_filtermonitor_library_cachelibrary_cache_namespace_filtermonitor_latchmonitor_file_iofile_io_data_file_filtermonitor_system_iomonitor_rollbackrollback_rollback_segment_filtermonitor_statistic_session_statisticsession_stat_session_idsession_stat_usersession_stat_redosession_stat_enqueuesession_stat_cache D8>E8MF8oG8|H8I8J8K8L8session_stat_iomonitor_statistic_system_statisticsys_stat_usersys_stat_redosys_stat_enqueuesys_stat_cachesys_stat_iomonitor_locklock_username_filter