DBA Scripts

Here are some of the scripts I use regularly. Some of them are not necessary when using Oracle Enterprise Manager (OEM), but if like me you hate waiting around for OEM to start up you'll often get the job done more quickly with these. You can look at the individual scripts, or download the lot here. Cheers Tim...




10g...
active_session_waits.sql db_usage_hwm.sql dynamic_memory.sql
event_histogram.sql feature_usage.sql generate_multiple_awr_reports.sql
job_chain_rules.sql job_chain_steps.sql job_chains.sql
job_classes.sql job_programs.sql job_running_chains.sql
job_schedules.sql jobs.sql jobs_running.sql
lock_tree.sql segment_advisor.sql services.sql
session_waits.sql sga_buffers.sql sysaux_occupants.sql
test_calendar_string.sql window_groups.sql windows.sql

11g...
extended_stats.sql identify_trace_file.sql job_credentials.sql
memory_dynamic_components.sql memory_target_advice.sql network_acl_privileges.sql
network_acls.sql session_fix.sql system_fix.sql
system_fix_count.sql temp_free_space.sql

constraints...
disable_chk.sql disable_fk.sql disable_pk.sql
disable_ref_fk.sql enable_chk.sql enable_fk.sql
enable_pk.sql enable_ref_fk.sql

miscellaneous...
analyze_all.sql base64decode.sql base64encode.sql
column_comments.sql comments.sql compare_schemas.sql
compile_all.sql compile_all_bodies.sql compile_all_funcs.sql
compile_all_procs.sql compile_all_specs.sql compile_all_trigs.sql
compile_all_views.sql conversion_api.sql csv.sql
dict_comments.sql drop_all.sql dsp.pkb
dsp.pks err.pkb err.pks
ftp.pkb ftp.pks gen_health.sql
get_pivot.sql login.sql part_hv_to_date.sql
proc_defs.sql rebuild_index.sql soap_api.sql
string_agg.sql string_api.sql switch_schema.sql
table_comments.sql table_defs.sql table_differences.sql
trc.pkb trc.pks



monitoring...
access.sql active_sessions.sql cache_hit_ratio.sql
call_stack.sql code_dep.sql code_dep_on.sql
column_defaults.sql db_cache_advice.sql db_info.sql
db_links.sql db_properties.sql dispatchers.sql
error_stack.sql errors.sql explain.sql
file_io.sql fk_columns.sql fks.sql
free_space.sql health.sql hidden_parameters.sql
high_water_mark.sql hot_blocks.sql identify_trace_file.sql
index_extents.sql index_monitoring_status.sql index_partitions.sql
index_usage.sql invalid_objects.sql jobs.sql
jobs_running.sql latch_hit_ratios.sql latch_holders.sql
latches.sql library_cache.sql license.sql
locked_objects.sql longops.sql lru_latch_ratio.sql
max_extents.sql min_datafile_size.sql monitor.sql
monitor_memory.sql monitoring_status.sql non_indexed_fks.sql
obj_lock.sql object_status.sql open_cursors.sql
open_cursors_by_sid.sql open_cursors_full_by_sid.sql parameter_diffs.sql
parameters.sql pga_target_advice.sql pipes.sql
profiler_run_details.sql profiler_runs.sql rbs_extents.sql
rbs_stats.sql recovery_status.sql roles.sql
search_source.sql segment_stats.sql session_events.sql
session_events_by_sid.sql session_events_by_spid.sql session_io.sql
session_rollback.sql session_stats.sql session_stats_by_sid.sql
session_undo.sql session_waits.sql sessions.sql
show_indexes.sql show_space.sql show_tables.sql
source.sql spfile_parameters.sql sql_area.sql
sql_text.sql sql_text_by_sid.sql system_events.sql
system_parameters.sql system_stats.sql table_dep.sql
table_extents.sql table_indexes.sql table_partitions.sql
table_stats.sql temp_extent_map.sql temp_io.sql
temp_segments.sql temp_usage.sql tempseg_usage.sql
top_latches.sql top_sessions.sql top_sql.sql
trace_run_details.sql trace_runs.sql ts_extent_map.sql
ts_full.sql tuning.sql unusable_indexes.sql
unused_space.sql user_hit_ratio.sql user_temp_space.sql
user_undo_space.sql

rac...
locked_objects_rac.sql longops_rac.sql monitor_memory_rac.sql
session_undo_rac.sql session_waits_rac.sql sessions_rac.sql

resource manager...
active_plan.sql consumer_group_usage.sql consumer_groups.sql
plan_directives.sql resource_plans.sql

script creation...
backup.sql build_api.sql build_api2.sql
create_data.sql drop_cons_on_table.sql drop_fks_on_table.sql
drop_fks_ref_table.sql drop_indexes.sql fks_on_table.sql
fks_ref_table.sql index_monitoring_off.sql index_monitoring_on.sql
monitoring_off.sql monitoring_on.sql rbs_structure.sql
recreate_table.sql seq_structure.sql table_constraints.sql
table_indexes.sql table_structure.sql tablespace_structure.sql
view_structure.sql

security...
grant_delete.sql grant_execute.sql grant_insert.sql
grant_select.sql grant_update.sql package_synonyms.sql
schema_write_access.sql sequence_synonyms.sql table_synonyms.sql
view_synonyms.sql

external...
MOATS
Snapper