一些实用功能脚本

Script_Name Remark
ana_idx_reb.sql determines whether an index need rebuild
chk_tab_bak.sql check table for backup status
count_log_switches.pl extracts the log switch activity information from the alert.log file
dsp_lock_sql.sql display the SQL text of locked transactions
est_shared_pool.sql Estimate Shared Pool Utilization
fmt_plan_tab.sql format the Select of the Explain Plan Table
list_exec_sql.sql list of the SQL statement being executed in the database
list_inact_sess.sql list inactive users in the database
list_ora_pro.sql list all Oracle processes running on the system
list_run_job.sql list running jobs
list_sbm_job.sql list submitted jobs
list_sess_mem.sql list the Memory used by all sessions connected to the database
list_trans_rbs.sql list active transactions and their rollback segments and table being operated on
list_user_cursor.sql Listing User Session Cursor Usage
mon_sess_idle.sql monitoring user session idle time
mts_dis_busy.sql Show MTS Dispatcher Percent Busy.
mts_wait_time.sql calculates MTS average wait time per request
rpt_buf_info.sql provides information to assist in tuning the various buffers within the system global area (SGA)
rpt_buf_stat.sql report statistics about the buffers in the SGA
rpt_db_check.sql PROVIDE DATABASE PERFORMANCE HEALTHCHECK
rpt_db_check2.sql performance healthcheck on the system and makes suggestions on modifications that can be made if specific conditions exist
rpt_db_files.sql generate a listing of all Database Files
rpt_db_sum.sql generate a database summary report
rpt_dbf_map.sql Print Map of All Database Files
rpt_dict_cache.sql report dictionary cache effectivenes
rpt_file_io.sql report file I/O statistics
rpt_free_space.sql report free space on each tablespace
rpt_ins_stat.sql report Instance Statistics
rpt_latch_info_1.sql provides information on latch performance
rpt_latch_info_2.sql provides information on latch performance
rpt_lib_cache.sql report provides information of the shared pool’s library cache
rpt_mts_map.sql report dispatcher and process mapping using MTS
rpt_perf_sum.sql Reactive Performance Overview Report
rpt_redo_stat.sql Report Online Redo Log Statistics
rpt_sess_lock.sql report sessions waiting for locks
rpt_sess_stat.sql provided here can be used to report the current session statistics
rpt_sess_wait.sql provided here can be used to report session and system waits
rpt_sga_par.sql Reports parameters and statistics related to the SGA
rpt_sql_mem.sql report SQL Area Memory Usage by Users / statement
rpt_sum_mem.sql report SQL Area summary memory usage by user
rpt_sys_wait.sql provided here can be used to report session and system waits
rpt_tab_exts.sql report tables with many extents
rpt_tab_idx.sql report indexes and tables that exist for each user for all tablespaces
rpt_user_cur.sql report open cursors by user
rpt_user_prof.sql report User Role and Profile Information
rpt_user_space.sql Report Database Space Usage by User
show_clu_info.sql provide cluster information
show_conn_info.sql display information about connected users
show_easy_lock.sql provides low complexity locking information
show_lgs_segs.sql report largest segments in the database
show_lock_detail.sql provides a complex fully decoded locking information which is much more detailed than the other two scripts in the series
show_lock_info.sql provides medium detail locking information
show_lock_stat.sql display locks being held (or waited on) in the database
show_parse_ratio.sql Gauge the Impact of the SESSION_CACHED_CURSORS Parameter
show_rbs_info.sql generate information about Rollback Segments
show_rbs_usage.sql show rollback segments usage
show_sess_cursor.sql Tune the ‘SESSION_CACHED_CURSORS’ and ‘OPEN_CURSORS’ Parameters
show_sess_info.sql obtain detailed session information
show_shared_pool.sql show certain Shared Pool measurements
show_sort_comp.sql determine the Number of Disk Sorts vs. Memory Sorts
show_trans_rbs.sql displays active transactions (by user and terminal) in rollback segments
Trackback

no comment untill now

Add your comment now

切换到手机版