ISBN 10:  0-9797951-3-3 ISBN 13: 978-0-9797951-3-8 Library of Congress Number: 2008944147 791 pages Hardcover - 9x7 PD 1208 Shelving:  Databases/Oracle Oracle In-Focus Series #31

Advanced Oracle Utilities The Definitive Reference Bert Scalzo Donald K. Burleson Steve Callan Retail Price $59.95 /  £44.95   Order now at 30% off and get access to the code depot! Only $41.95 (30% off)         Key Features About the Author Reader Comments Table of Contents Index Topics Errata

About the Authors:
 

Bert Scalzo

Bert Scalzo is a Database Expert for Quest Software and a member of the TOAD dev team. He has worked with Oracle databases for well over two decades. Mr. Scalzo’s work history includes time at both Oracle Education and Oracle Consulting. He holds several Oracle Masters certifications and an extensive academic background - including a BS and MS in Computer Science, an MBA, plus insurance industry designations. Mr. Scalzo is also an Oracle ACE. Mr. Scalzo is accomplished speaker and has presented at numerous Oracle conferences and user groups - including OOW, ODTUG, IOUG, OAUG, RMOUG and many others. His key areas of DBA interest are Data Modeling, Database Benchmarking, Database Tuning & Optimization, "Star Schema" Data Warehouses, Linux and VMware.  Mr. Scalzo has written numerous articles, papers and blogs - including for the Oracle Technology Network (OTN), Oracle Magazine, Oracle Informant, PC Week (eWeek), Dell Power Solutions Magazine, The LINUX Journal, LINUX.com, Oracle FAQ, Ask Toad and Toad World.  Mr. Scalzo has also written six books: Oracle DBA Guide to Data Warehousing and Star Schemas, TOAD Handbook, TOAD Pocket Reference (2nd Ed),Database Benchmarking: Practical Methods for Oracle & SQL Server, Advanced Oracle Utilities: The Definitive Reference and Oracle on VMware: Expert Tips for Database Virtualization.

Donald Burleson

Donald K. Burleson is one of the world’s top Oracle Database experts with more than 25 years of full-time DBA experience.  He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems.   A former Adjunct Professor, Don Burleson has written more than 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress. Don is a popular lecturer and teacher and is a frequent speaker at Oracle OpenWorld and other international database conferences. Donald Burleson's books   Donald Burleson articles   Donald Burleson comments   Don Burleson blog   Free Oracle Tips HTML Text

Steve Callan

Steve Callan is an Oracle certified professional with over 20 years of progressive hands-on technical experience and nearly a decade managing mission-critical Oracle databases.  He is also a Microsoft Certified Professional (MCP), and is proficient in SQL Server 2005.  Steve has a Masters degree in Software and Information Systems from Regis University, and a Masters degree in Industrial Engineering from New Mexico State University.  He has also completed all Ph.D. coursework for his pending doctorate in Mathematical & Computer Sciences at the Colorado School of Mines. A former senior U.S. Military officer, Steve is a graduate of the prestigious United States Military Academy at West Point, earning his wings as an attack helicopter pilot.  He has over 1,000 hours of operational aviation unit experience with Apache and Cobra attack choppers and won an Army senior aviator award for his piloting skills. Steve lives in the Denver area and spends his spare time trying new wines, playing with computers, and writing a science fiction novel.

Table of Contents:

Using the Online Code Depot Conventions Used in this Book Acknowledgements Chapter 1: Introduction to Oracle Utilities Introduction Definition of a Utility What is a Hidden Utility? Utility Locations Methods of Discovery Package Discovery Package Utilities UNIX Utilities and Shell Scripts Windows Executables Conclusion Chapter 2: UNIX/Linux Oracle OS Utilities Finding the OS Utilities in Linux/UNIX Binary Discovery UNIX/Linux Utilities for the Oracle Professional Introduction to the UNIX Architecture Dialects of UNIX UNIX Access Control Management UNIX and DOS Commands Introduction to UNIX Utilities Appending Data to UNIX Files Redirecting Output to a NULL Device Common Oracle UNIX Commands File Management in UNIX Directory Management in UNIX The Oracle environment in UNIX Dissecting Complex UNIX commands Deciphering a Complex UNIX Command Conclusion Chapter 3: Windows Oracle OS Utilities Reasons for Using Oracle on Windows Windows Utilities for Monitoring Oracle Checking Windows Services for Oracle Test the Windows Oracle Service Oracle Scripts for Windows Sample Invocation of Oracle from Windows Running a Data Pump Export from Windows Sending Oracle Output via Windows Email Monitoring Trace and Dump Files in Windows Starting and Stopping Oracle on Windows Conclusion Chapter 4: Oracle Utilities for Server-Side Functions Server Management Database Creation and the DBCA SQL*NET Configuration Files:  NETCA External Functions Auto Start and Auto Stop lsnrctl emca emctl relink External job scheduling Using the OPatch Utility Utilities for Analyzing Oracle Trace Files Using the Trace Analyzer Utility Remote Connection Management Using orapwd Server Monitoring Utilities Using vmstat Server RAM and Oracle Tracking External Server Metrics with AWR Enterprise Manager for Server & Environment Using AWR and STATSPACK for Server Monitoring Vmstat to the Rescue Using the ltom utility File analysis Using the BBED Block Editor Utility Using and Linking BBED File Analysis The DBV Utility (Database Verify) dbv The dbms_repair Utility Configuring the Environment Finding Corrupt Blocks Repairing Corrupt Blocks Rebuilding Freelists Process Management kill orakill renice trcsess TKPROF Using the Orastack Utility RAC Management VIPCA crsctl crs_start crs_stop crs_stat srvctl Storage Management ocfs2console mkfs.ocfs2 tunefs.ocfs2 fsck.ocfs2 mounted.ocfs2 asmtool asmtoolg asmcmd Conclusion Chapter 5: Oracle SQL Management Utilities Introduction SQL Utilities SQL*Plus SQL Developer Toad for Oracle® Advanced SQL Techniques Login Scripts Dynamic SQL Scripting SET TIMING ON TIMING START & STOP Obtaining Explain Plans SQL*Plus AUTOTRACE Interpreting Explain Plans Conclusion Chapter 6: Oracle DBA Utilities Introduction Reorganization Utilities Data Pump (EXPDP) Export Transportable Tablespaces IMPDP Import Transportable Tablespaces Import Partition Options Import Remapping Options DBMS_REDEFINITION DBMS_METADATA Recovery Utilities DBMS_FLASHBACK DBMS_LOGMNR Job Scheduling DBMS_JOBS DBMS_SCHEDULER Access Security DBMS_RLS File Security DBMS_CRYPTO DBMS_OBFUSCATION_TOOLKIT UTL_COMPRESS UTL_ENCODE Replication DBMS_AQADM DBMS_AQ DBMS_REPUTIL Space Management DBMS_SPACE_ADMIN DBMS_SPACE Data Corruption Utilities DBVERIFY DBMS_REPAIR Database Session Management DBMS_SESSION File Management DBMS_FILE_TRANSFER UTL_SMTP UTL_TCP ASMCMD Instance Management DBMS_SHARED_POOL Conclusion

Chapter 7: Oracle Tuning and Monitoring Utilities Introduction Tuning Utilities DBMS_WORKLOAD_REPOSITORY DBMS_WORKLOAD_CAPTURE DBMS_WORKLOAD_REPLAY DBMS_ADVISOR SQL Tuning DBMS_ADVANCED_REWRITE DBMS_STATS DBMS_SQLTUNE Monitoring DBMS_ALERT DBMS_SERVER_ALERT DBMS_WARNING DBMS_MONITOR Conclusion Chapter 8: Oracle Advisory and Diagnostic Utilities Introduction ADRCI: ADR Command Interpreter Changes in Oracle 11g ADRCI Command Line Interface SQL Performance Analyzer Defining a Workflow Other Utilities Advisor Central Traditional Tracing Methods Conclusion Chapter 9: Oracle Developer Utilities Introduction UTL Utilities UTL_COLL UTL_COMPRESS UTL_DBWS UTL_ENCODE UTL_FILE UTL_HTTP UTL_I18N UTL_INADDR UTL_LMS UTL_MAIL UTL_NLA UTL_RAW UTL_RECOMP UTL_REF UTL_SMTP UTL_SPADV UTL_TCP UTL_URL XML Utilities DBMS_XMLGEN DBMS_XMLSAVE DBMS_XMLSTORE Other Useful Utilities Oerr DBMS_PROFILER DBMS_DEBUG Conclusion Chapter 10: BBED: The Block Browser and Editor Tool Introduction ROWID_INFO Procedure Starting a Session Altering Data Undeleting a Row Corrupted Blocks Restoring Data Restoring a File Conclusion Additional information Chapter 11: Oracle  Job Scheduling Introduction to Job Scheduling Fundamentals of Job Scheduling UNIX Job Scheduling (cron) vs dbms_scheduler Job Scheduling Components Using cron and crontab to Schedule Oracle Jobs The crontab Options The Format of the crontab File Using the Windows Job Scheduler at.exe utility Internal Oracle Job Scheduling Oracle Scheduler Overview Configuring Oracle Job Scheduling Setting up a Test Environment Overview of the dbms_scheduler Functions Programs Schedules Creating Oracle Jobs Job Classes Oracle Job Scheduling Windows Job Scheduling Window Groups Enabling, Disabling and Setting Attributes of Scheduler Objects Time-based Job Scheduling Setting Job Execution Dates Intervals and Interval Literals Calendar Syntax in Oracle Job Scheduling Complex Date Rules for Job Execution Creating an Oracle Job Chain Conditional Job Creation Conditional Job Enabling Conditional Job Runs Using Oracle Advanced Queuing Conditional Job Runs Using a Custom Table Solution Implementing Error Checking Routines Sending Email Notifications of Job Errors Using UTL_SMTP Using UTL_MAIL in Oracle Monitoring Oracle Job Execution Killing Oracle Job Sessions Setting Job Scheduler Attributes Job Priorities Scheduler Logging Job Logs Displaying Job Run Details Window Logs Purging Logs Using the Job Resource Manager Export/Import and the Scheduler Job Services and Instance Stickiness Conclusion Index About Bert Scalzo About Donald K. Burleson About Steve Callan About Mike Reed About Jeff Smith

Index:

$ $ORACLE_HOME . .bash_history .bshrc .cshrc .ksh_history .kshrc .profile .sh_history @ @PRIOR_VERSION _ _optimizer_cost_model A accept_sql_profile active_plan.sql Add Scheduled Task add_alias_to_ldap add_filter add_grouped_policy add_policy add_policy_context add_sqlset_reference add_sqlwkld_ref add_sts_ref add_subscriber add_warning_setting_cat add_warning_setting_num add_window_group_member Advanced Queuing after_index all_directories all_objects alter_aq_agent alter_propagation_schedule alter_queue alter_queue_table alter_rewrite_equivalence alter_sql_profile alter_stats_history_retention alter_subscriber analyze analyze table analyze_table APEX Application Express AQ aq_administrator_role aq_user_role argument_name argument_position argument_type argument_value ash_report_html ash_report_text asmcmd ASMCMD asmtool asmtoolg assm_segment_verify assm_tablespace_verify AT –attach ATTR5 attrib auto_commit auto_drop auto_restrict Automated Storage Management automated_email_alert.sql automated_email_alert_10g.sql automatic data recording Automatic Database Diagnostic Monitor Automatic Diagnostic Repository Automatic Session Tracing Automatic Storage Management Automatic Workload Repository autostart AUTOTRACE awk awr_diff_report_html awr_diff_report_text awr_sql_report_html awr_sql_report_text B base64_decode base64_encode BATCH BBED utility before_index Block Browser and Editor block_end block_size block_start Bourne shell build_safe_rewrite_equivalence C calendar_string calibrate cancel_replay cancel_task cancel_tuning_task capture_cursor_cache_sqlset cd check_object chmod chown cjq0 clear_all_context clear_context clear_identifier clear_set_identifier client_id_stat_disable client_id_stat_enable client_id_trace_disable client_id_trace_enable close_all_connections close_connection close_data close_window Cluster Ready Services Clusterware Control command command_replies comments Conditional job creation Conditional job enabling Conditional job runs connect connect internal consumer_group_usage.sql consumer_groups.sql control_management_pack_access convert_raw_value convert_raw_value_nvarchar convert_raw_value_rowid copy_file copy_job copy_sqlwkld_tosts copy_table_stats coraenv corrupt_count corrupt_option CPU-bound create_10g_job_failure.sql create_10g_job_max_runs.sql create_action create_aq_agent create_baseline create_baseline_template create_consumer_groups.sql create_extended_stats create_file create_index_cost create_job create_job_class create_job_classes.sql create_job_failure.sql create_np_queue create_object create_plan_directive create_policy_group create_program create_queue create_queue_table create_schedule create_snapshot create_sqlset create_stat_table create_stgtab_sqlprof create_stgtab_sqlset_sqlprof create_table_cost create_table_cost_columns create_task create_tuning_task create_window create_window_group Critical Patch Update CRON cron daemon crontab CRS crs_start crs_stat crs_stop crsctl c-Shell current_open_window D data Data Definition Language Data Encryption Standard Data Pump Export Data pump import Data Recovery Advisor Database Configuration Assistant Database Control Database Creation Assistant Database Manager Database Replay Database Verify utility database_trace_disable database_trace_enable datapump DATE DAY TO SECOND day_plan.sql day_precision db_file_multiblock_read_count db_writers dba_advisor_actions dba_advisor_findings dba_advisor_objects dba_advisor_recommendations dba_advisor_tasks dba_jobs dba_jobs_running dba_objects dba_rsrc_% dba_rsrc_consumer_groups dba_rsrc_plan_directives dba_scheduler_% dba_scheduler_job_args dba_scheduler_job_classes dba_scheduler_job_log dba_scheduler_job_run_details dba_scheduler_jobs dba_scheduler_program_args dba_scheduler_programs dba_scheduler_running_jobs dba_scheduler_schedules dba_scheduler_window_details dba_scheduler_window_groups dba_scheduler_window_log dba_scheduler_windows dba_scheduler_wingroup_members DBA_SQLSET_STATEMENTS dba_tab_columns DBA_WORKLOAD_REPLAYS dbca DBCA DBMS_ALERT dbms_application_info dbms_aqdbms_aqadm dbms_crypto dbms_datapump DBMS_DEBUG dbms_file_transfer dbms_flashback dbms_job dbms_jobs dbms_metadata DBMS_MONITOR dbms_obfuscation_toolkit dbms_pipe DBMS_PROFILER dbms_redefinition dbms_repair dbms_reputil dbms_resource_manager dbms_resource_manager_privs dbms_rls dbms_scheduler DBMS_SERVER_ALERT dbms_service dbms_session dbms_shared_pool dbms_space dbms_space_admin dbms_sqadm DBMS_SQLPA DBMS_SQLTUNE dbms_system dbms_system.ksdwrt DBMS_WARNING DBMS_WORKLOAD_REPLAY DBMS_WORKLOAD_ REPOSITORY DBMS_XPLAN DBMS-TTS dbshut dbstart dbv dbv.cmd dbv.ksh DBVerify DDL declare_rewrite_equivalence decrypt default_action DEFAULT_JOB_CLASS default_timezone DEFAULT_TIMEZONE default_value define_metadata_argument define_program_argument del_alias_from_ldap delete_capture_info delete_column_stats delete_consumer_group delete_database_prefs delete_database_stats delete_dictionary_stats delete_filter delete_fixed_object_stats delete_index_stats delete_pending_stats delete_plan delete_plans.sql delete_policy_group delete_replay_info delete_schema_prefs delete_schema_stats delete_sqlset delete_sts_ref delete_system_stats delete_table_prefs delete_table_stats delete_task dequeue dequeue_array Des3decrypt Des3getkey Desdecrypt diagnostic_dest diff_table_stats_in_history diff_table_stats_in_pending diff_table_stats_in_stattab

dircmp disable_db_access disable_grouped_policy disable_propagation_schedule disabled_jobs.sql drop_action drop_aq_agent drop_baseline drop_baseline_template drop_extended_stats drop_grouped_policy drop_job drop_job_class drop_job_classes.sql drop_policy drop_policy_context drop_program drop_program_argument drop_queue drop_queue_table drop_rewrite_equivalence drop_schedule drop_snapshot_range drop_sql_profile drop_sqlset DROP_SQLSET drop_stat_table drop_tuning_task drop_window drop_window_group dump dump_option dump_orphan_keys duration E EHLO EM emacs enable enable_db_access enable_grouped_policy enable_jms_types enable_policy enable_propagation_schedule enabled encrypt end_date enqueue enqueue_array Enterprise Manager Enterprise Manager Command Line Utility Enterprise Manager Configuration Assistant errnum evaluate_calendar_string exception_job_proc_1.sql EXECUTABLE EXECUTE_ANALYSIS_TASK execute_task execute_tuning_task execution plan exp exp_full_data expand_message expdp EXPDP explain Explain Plan export_awr export_column_stats export_database_prefs export_database_stats export_dictionary_stats export_fixed_object_stats export_index_stats export_pending_stats export_schema_prefs export_schema_stats export_system_stats export_table_prefs export_table_stats extension F facility fast_start_io_target fast_start_mttr_target find finish_capture fix_corrupt_blocks fix_count flags flashback query FLASHBACK TABLE flashback_transaction_query flush flush_database_monitoring_info force fraction_second_precision free_blocks from_remote fsck.ocfs2 G gather_database_stats gather_dictionary_stats gather_fixed_object_stats gather_index_stats gather_schema_stats gather_system_stats gather_table_stats generate_job_name generate_stats get_capture_info get_category get_column_stats get_file get_index_stats get_line get_line_nchar get_prefs get_raw get_replay_info get_rowinfo get_scheduler_attribute get_stats_history_availability get_stats_history_retention get_system_stats get_table_stats get_task_report get_task_script get_text get_text_nchar get_threshold get_warning_setting_cat get_warning_setting_num get_warning_setting_string get_watermark glance Global Services Daemon global_name grant_queue_privilege grant_switch_consumer_group grant_system_privilege graves grep group_name GSD H hanganalyze hash HELO help high water mark Hotsos I ifconfig ignorecase imp imp_full_database impdp IMPDP implement_task implement_tuning_task import_awr import_database_prefs import_database_stats import_dictionary_stats import_fixed_object_stats import_index_stats import_schema_prefs import_schema_stats import_system_stats import_table_prefs import_table_stats Index Organized Tables index_object init.ora initialize_replay inittab instance_stickiness interrupt_task interrupt_tuning_task interval Intervals isopen J job coordinator job run history job slave job table job_and_window_log job_chain job_chain_aq.sql job_chain_aq_jobs.sql job_chain_aq_query.sql job_chain_aq_setup.sql job_chain_create.sql job_chain_create_job.sql job_chain_custom_jobs.sql job_chain_enable_jobs.sql job_chain_locks job_chain_locks_query.sql job_chain_query.sql job_chain_queue_tab job_chain_table.sql job_class job_class_name job_class_resource_privileges.sql job_classes.sql job_log job_log_lifecycle.sql job_name job_priority job_queue_processes job_queue_query.sql job_run_failures_10g.sql job_run_history.sql job_user jobs_10g.sql jobs_running.sql jobs_running_10g.sql John the Ripper JServer Julian dates K kcvcptim kcvfhccc kcvfhcpc kill Korn shell kscnbas L language Lempel-Ziv listen listener.ora load_sqlset lock_partition_stats lock_schema_stats lock_table_stats log_checkpoint_interval log_checkpoint_timeout log_history logging_full logging_level logging_off logging_runs ls.. ls –al lsattr lsinventory lsnrctl lsnsctl ltom lz_compress lz_compress_add lz_compress_close lz_compress_open lz_uncompress lz_uncompress_close lz_uncompress_extract lz_uncompress_open M MAC mail mailto make_internal_package MANAGE SCHEDULER mark_recommendation max_failures max_job_slave_processes max_runs max_users maxmem message –messagefile metadata migrate_queue_table mimeheader_decode mimeheader_encode mkfs.ocfs2 modify_baseline_window_size modify_snapshot_settings mounted.ocfs2 MOVIERENTAL mv my_schedule_function.sql N name Network Configuration Assistant new_job next_date next_run_date night_plan.sql nls_date_format NOOP number_of_arguments numuse O object_dependent_segments object_growth_trend object_name object_type ocfs2console oemctl utility oerr utility old_job OLTP oltp_job_class OLTP_SERVICE Opatch open_connection open_data open_window optimizer_index_cost_adj Oracle Cluster File System Oracle Counters Oracle Database Listener Oracle Enterprise Manager Oracle Forensics Oracle Lite Onboard Monitor Oracle Managed File Oracle Parallel Server Oracle Stream Advanced Queuing oradebug oradim oraenv orakill orapwd orastack orcl orphan_table out_argument

P p_mail_host pack_stgtab_sqlprof pack_stgtab_sqlset page-in page-out page-stealing daemon parfile partition_name patch_storage peek perfmon pfile PGA Advisor pipe plan_stat PLSQL_BLOCK PLUSTRACE PLUSTRC pname post prepare_column_value prepare_replay Print Working Directory Privilege Procedure Builder Process Explorer process_capture product program_action program_args.sql program_name program_type programs.sql prtconf ps ps –ef PStat publis_pending_stats purge_action purge_options purge_queue_table purge_stats put_file pwd Q query_rewrite_enabled query_rewrite_integrity Queue Tables quick_tune QuickSlice quit quoted_printable_decode quoted_printable_encode R RAC raise_application_error RCPT read_line read_raw read_text Real Application Clusters Real Application Testing rebuild_freelists recyclebin refresh_grouped_policy refresh_policy Regedit register relative_fno relink remap_connection remap_data remap_stgtab_sqlprof remap_stgtab_sqlset remap_table remote_login_passwordfile remove remove_sqlset_reference remove_subscriber remove_window_group_member removeall rename_baseline repair_table repair_table_name repeat_interval REPLAY_CONNECTION replication_is_on replication_off replication_on report report_auto_tuning_task report_sql_monitor report_tuning_task reset_global_prefs_defaults reset_param_defaults reset_task reset_tuning_task resource_consumer_group resource_manager_plan resource_plan resource_plan_directives.sql restore_database_stats restore_dictionary_stats restore_fixed_object_stats restore_schema_stats restore_system_stats restore_table_stats resume_tuning_task RETENTION GUARANTEE return_after_date revoke_queue_privilege revoke_system_privilege rm rmdir round row level security ROWID RSET run_job running_job_consumer_groups.sql S sar SAVEPOINT scan_limit schedule_name schedule_propagation Scheduled Tasks Wizard scheduled_job_details.sql scheduled_jobs.sql scheduled_jobs_running.sql schema_export schema_name SCHTASKS script_tuning_task sed Segment Advisor segment_corrupt segment_drop_corrupt segment_dump segment_dump_bitmap_summary segment_dump_extent_map segment_id segment_mark_corrupt segment_mark_valid segment_option segment_verify segment_verify_basic segment_verify_deep segment_verify_extents segment_verify_extents_global select_cursor_cache select_sqlset select_workload_repository send_mail.sql Sendmail serv_mod_act_stat_disable serv_mod_act_stat_enable serv_mod_act_trace_disable serv_mod_act_trace_enable Server Control service session_trace_disable session_trace_enable SET TIMING set_attribute set_attribute_null set_column_stats set_context set_database_prefs set_default_task_parameter set_defaults set_global_prefs set_identifier set_index_stats set_scheduler_attribute set_schema_prefs set_system_stats set_table_prefs set_table_stats set_task_parameter set_threshold set_tuning_task_parameter set_warning_setting_string set_watermark SGA Advisor show_extended_stats_name show_scheduler_attribute.sql shutmode shuttype signal smtp_out_server snap-in sort_area_size space_usage SQL Access Advisor SQL Developer SQL Performance Advisor SQL Performance Analyzer SQL Repair Advisor SQL Tuning Advisor SQL Tuning Sets SQL*Loader SQL*Plus SQL*Trace sqlfile sqlnet.ora sqltext_to_signature srcvtl srvctl start_capture start_date start_queue start_replay statistics_level Statspack StatsPack stop_job stop_queue storage_clause STORED_PROCEDURE sts_name switch_group switch_time sync_up_rep sysdate systimestamp T table_comments.sql table_object table_type tablespace_fix_bitmaps tablespace_fix_segment_states tablespace_migrate_from_local tablespace_migrate_to_local tablespace_rebuild_bitmaps tablespace_rebuild_quotas tablespace_relocate_bitmaps tablespace_verify taskkill test_calendar_string.sql test_date_string test_resource_manager_job_1.sql test_stored_procedure_prog test_timestamp_string text_decode text_encode timeout TIMESTAMP TIMING START TIMING STOP TKPROF tnslsnr.exe tnsnames.ora Toad top Trace Analyzer transaction_backout transport_full_check transportable tablespace trcasst trcsess Triple DES trunc ts_option ts_segments tune_mview tunefs.ocfs2 U umask uname unbind Undo Advisor unlock_partition_stats unlock_schema_stats unlock_table_stats unpack_stgtab_sqlprof unpack_stgtab_sqlset unregister unschedule_propagation unused_space update_object update_rec_attributes update_sqlset update_task_attributes upgrade_stat_table use_current_session user_dump_dest Utility Utility Locations UTL_COMPRESS UTL_ENCODE UTL_FILE utl_file_dir UTL_MAIL UTL_SMTP UTL_TCP UUDECODE UUENCODE V v$active_session_history v$datafile v$datafile.db_block_size v$instance_recovery v$logmnr_contents v$mttr_target_advice v$process v$rsrc_consumer_group v$rsrc_plan v$session v$session_longops v$sql_monitor v$sql_plan v$sql_plan_monitor v$sql_plan_statistics_all validate_rewrite_equivalence verify_option vi VIPCA Virtual IP Configuration Assistant Virtual Private Database virtual private databases vmstat VRFY W waitany wc which which_log who window_groups.sql window_list window_log window_logs.sql window_name window_priority Windows Performance Monitor windows.sql wordcount write_data write_line write_raw write_raw_data write_text Y year_precision

Reviews:

From the series Editor: