首页 > 代码库 > DBA Scripts

DBA Scripts

标记一下。慢慢研究 http://www.oracle-base.com/dba/scripts.php

技术分享
Monitoring
  • category=monitoring&file=access.sql" style="color:rgb(51,51,51)">access.sql

  • category=monitoring&file=active_sessions.sql" style="color:rgb(51,51,51)">active_sessions.sql

  • cache_hit_ratio.sql
  • category=monitoring&file=call_stack.sql" style="color:rgb(51,51,51)">call_stack.sql

  • category=monitoring&file=code_dep.sql" style="color:rgb(51,51,51)">code_dep.sql

  • category=monitoring&file=code_dep_distinct.sql" style="color:rgb(51,51,51)">code_dep_distinct.sql

  • code_dep_on.sql
  • code_dep_tree.sql
  • column_defaults.sql
  • category=monitoring&file=controlfiles.sql" style="color:rgb(51,51,51)">controlfiles.sql

  • datafiles.sql
  • db_cache_advice.sql
  • db_info.sql
  • category=monitoring&file=db_links.sql" style="color:rgb(51,51,51)">db_links.sql

  • category=monitoring&file=db_links_open.sql" style="color:rgb(51,51,51)">db_links_open.sql

  • db_properties.sql
  • category=monitoring&file=df_free_space.sql" style="color:rgb(51,51,51)">df_free_space.sql

  • directories.sql
  • dispatchers.sql
  • error_stack.sql
  • category=monitoring&file=errors.sql" style="color:rgb(51,51,51)">errors.sql

  • category=monitoring&file=explain.sql" style="color:rgb(51,51,51)">explain.sql

  • category=monitoring&file=file_io.sql" style="color:rgb(51,51,51)">file_io.sql

  • fk_columns.sql
  • fks.sql
  • free_space.sql
  • health.sql
  • hidden_parameters.sql
  • high_water_mark.sql
  • category=monitoring&file=hot_blocks.sql" style="color:rgb(51,51,51)">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
  • category=monitoring&file=latch_holders.sql" style="color:rgb(51,51,51)">latch_holders.sql

  • category=monitoring&file=latches.sql" style="color:rgb(51,51,51)">latches.sql

  • library_cache.sql
  • license.sql
  • category=monitoring&file=locked_objects.sql" style="color:rgb(51,51,51)">locked_objects.sql

  • category=monitoring&file=locked_objects_internal.sql" style="color:rgb(51,51,51)">locked_objects_internal.sql

  • logfiles.sql
  • longops.sql
  • lru_latch_ratio.sql
  • max_extents.sql
 
  • min_datafile_size.sql
  • monitor.sql
  • monitor_memory.sql
  • monitoring_status.sql
  • category=monitoring&file=nls_params.sql" style="color:rgb(51,51,51)">nls_params.sql

  • non_indexed_fks.sql
  • category=monitoring&file=obj_lock.sql" style="color:rgb(51,51,51)">obj_lock.sql

  • object_privs.sql
  • object_status.sql
  • objects.sql
  • open_cursors.sql
  • open_cursors_by_sid.sql
  • category=monitoring&file=open_cursors_full_by_sid.sql" style="color:rgb(51,51,51)">open_cursors_full_by_sid.sql

  • options.sql
  • param_valid_values.sql
  • parameter_diffs.sql
  • category=monitoring&file=parameters.sql" style="color:rgb(51,51,51)">parameters.sql

  • category=monitoring&file=part_tables.sql" style="color:rgb(51,51,51)">part_tables.sql

  • pga_target_advice.sql
  • pipes.sql
  • category=monitoring&file=profiler_run_details.sql" style="color:rgb(51,51,51)">profiler_run_details.sql

  • category=monitoring&file=profiler_runs.sql" style="color:rgb(51,51,51)">profiler_runs.sql

  • category=monitoring&file=profiles.sql" style="color:rgb(51,51,51)">profiles.sql

  • rbs_extents.sql
  • rbs_stats.sql
  • category=monitoring&file=recovery_status.sql" style="color:rgb(51,51,51)">recovery_status.sql

  • category=monitoring&file=redo_by_day.sql" style="color:rgb(51,51,51)">redo_by_day.sql

  • category=monitoring&file=redo_by_hour.sql" style="color:rgb(51,51,51)">redo_by_hour.sql

  • redo_by_min.sql
  • category=monitoring&file=registry_history.sql" style="color:rgb(51,51,51)">registry_history.sql

  • role_privs.sql
  • category=monitoring&file=roles.sql" style="color:rgb(51,51,51)">roles.sql

  • search_source.sql
  • segment_stats.sql
  • session_events.sql
  • category=monitoring&file=session_events_by_sid.sql" style="color:rgb(51,51,51)">session_events_by_sid.sql

  • category=monitoring&file=session_events_by_spid.sql" style="color:rgb(51,51,51)">session_events_by_spid.sql

  • session_io.sql
  • session_rollback.sql
  • session_stats.sql
  • session_stats_by_sid.sql
  • category=monitoring&file=session_undo.sql" style="color:rgb(51,51,51)">session_undo.sql

  • session_waits.sql
  • sessions.sql
  • sessions_by_machine.sql
  • show_indexes.sql
  • category=monitoring&file=show_space.sql" style="color:rgb(51,51,51)">show_space.sql

  • category=monitoring&file=show_tables.sql" style="color:rgb(51,51,51)">show_tables.sql

  • source.sql
 
  • spfile_parameters.sql
  • category=monitoring&file=sql_area.sql" style="color:rgb(51,51,51)">sql_area.sql

  • sql_text.sql
  • category=monitoring&file=sql_text_by_sid.sql" style="color:rgb(51,51,51)">sql_text_by_sid.sql

  • statistics_prefs.sql
  • synonyms_to_missing_objects.sql
  • category=monitoring&file=system_events.sql" style="color:rgb(51,51,51)">system_events.sql

  • system_parameters.sql
  • system_privs.sql
  • system_stats.sql
  • table_dep.sql
  • table_extents.sql
  • category=monitoring&file=table_indexes.sql" style="color:rgb(51,51,51)">table_indexes.sql

  • table_partitions.sql
  • table_stats.sql
  • tables_with_locked_stats.sql
  • tables_with_zero_rows.sql
  • category=monitoring&file=tablespaces.sql" style="color:rgb(51,51,51)">tablespaces.sql

  • temp_extent_map.sql
  • temp_free_space.sql
  • category=monitoring&file=temp_io.sql" style="color:rgb(51,51,51)">temp_io.sql

  • category=monitoring&file=temp_segments.sql" style="color:rgb(51,51,51)">temp_segments.sql

  • category=monitoring&file=temp_usage.sql" style="color:rgb(51,51,51)">temp_usage.sql

  • category=monitoring&file=tempfiles.sql" style="color:rgb(51,51,51)">tempfiles.sql

  • tempseg_usage.sql
  • category=monitoring&file=top_latches.sql" style="color:rgb(51,51,51)">top_latches.sql

  • top_sessions.sql
  • top_sql.sql
  • category=monitoring&file=trace_run_details.sql" style="color:rgb(51,51,51)">trace_run_details.sql

  • trace_runs.sql
  • ts_datafiles.sql
  • ts_extent_map.sql
  • ts_free_space.sql
  • ts_full.sql
  • ts_thresholds.sql
  • ts_thresholds_reset.sql
  • ts_thresholds_set_default.sql
  • tuning.sql
  • unusable_indexes.sql
  • unused_space.sql
  • user_hit_ratio.sql
  • user_roles.sql
  • user_system_privs.sql
  • user_temp_space.sql
  • category=monitoring&file=user_undo_space.sql" style="color:rgb(51,51,51)">user_undo_space.sql

  • users.sql
  • category=monitoring&file=users_with_role.sql" style="color:rgb(51,51,51)">users_with_role.sql

  • category=monitoring&file=users_with_sys_priv.sql" style="color:rgb(51,51,51)">users_with_sys_priv.sql

 

技术分享
10g
  • active_session_waits.sql
  • category=10g&file=ash.sql" style="color:rgb(51,51,51)">ash.sql

  • db_usage_hwm.sql
  • dynamic_memory.sql
  • category=10g&file=event_histogram.sql" style="color:rgb(51,51,51)">event_histogram.sql

  • feature_usage.sql
  • flashback_db_info.sql
  • generate_multiple_awr_reports.sql
  • category=10g&file=job_chain_rules.sql" style="color:rgb(51,51,51)">job_chain_rules.sql

  • category=10g&file=job_chain_steps.sql" style="color:rgb(51,51,51)">job_chain_steps.sql

 
  • category=10g&file=job_chains.sql" style="color:rgb(51,51,51)">job_chains.sql

  • job_classes.sql
  • job_programs.sql
  • job_running_chains.sql
  • job_schedules.sql
  • category=10g&file=jobs.sql" style="color:rgb(51,51,51)">jobs.sql

  • jobs_running.sql
  • lock_tree.sql
  • category=10g&file=segment_advisor.sql" style="color:rgb(51,51,51)">segment_advisor.sql

  • services.sql
 
  • session_waits.sql
  • category=10g&file=sga_buffers.sql" style="color:rgb(51,51,51)">sga_buffers.sql

  • category=10g&file=sga_dynamic_components.sql" style="color:rgb(51,51,51)">sga_dynamic_components.sql

  • sga_dynamic_free_memory.sql
  • category=10g&file=sga_resize_ops.sql" style="color:rgb(51,51,51)">sga_resize_ops.sql

  • category=10g&file=sysaux_occupants.sql" style="color:rgb(51,51,51)">sysaux_occupants.sql

  • category=10g&file=test_calendar_string.sql" style="color:rgb(51,51,51)">test_calendar_string.sql

  • window_groups.sql
  • windows.sql
 

技术分享
11g
  • diag_info.sql
  • extended_stats.sql
  • category=11g&file=identify_trace_file.sql" style="color:rgb(51,51,51)">identify_trace_file.sql

  • job_credentials.sql
  • job_output_file.sql
  • job_run_details.sql
  • memory_dynamic_components.sql
 
  • category=11g&file=memory_resize_ops.sql" style="color:rgb(51,51,51)">memory_resize_ops.sql

  • category=11g&file=memory_target_advice.sql" style="color:rgb(51,51,51)">memory_target_advice.sql

  • category=11g&file=network_acl_privileges.sql" style="color:rgb(51,51,51)">network_acl_privileges.sql

  • network_acls.sql
  • category=11g&file=result_cache_objects.sql" style="color:rgb(51,51,51)">result_cache_objects.sql

  • result_cache_report.sql
  • result_cache_statistics.sql
 
  • result_cache_status.sql
  • category=11g&file=session_fix.sql" style="color:rgb(51,51,51)">session_fix.sql

  • category=11g&file=system_fix.sql" style="color:rgb(51,51,51)">system_fix.sql

  • system_fix_count.sql
  • temp_free_space.sql
 

技术分享
12c
  • cdb_resource_plan_directives.sql
  • cdb_resource_plans.sql
  • category=12c&file=credentials.sql" style="color:rgb(51,51,51)">credentials.sql

 
  • login.sql
  • pdbs.sql
  • category=12c&file=priv_captures.sql" style="color:rgb(51,51,51)">priv_captures.sql

 
  • services.sql
 



技术分享
Constraints
  • category=constraints&file=disable_chk.sql" style="color:rgb(51,51,51)">disable_chk.sql

  • category=constraints&file=disable_fk.sql" style="color:rgb(51,51,51)">disable_fk.sql

  • disable_pk.sql
 
  • disable_ref_fk.sql
  • enable_chk.sql
  • category=constraints&file=enable_fk.sql" style="color:rgb(51,51,51)">enable_fk.sql

 
  • category=constraints&file=enable_pk.sql" style="color:rgb(51,51,51)">enable_pk.sql

  • category=constraints&file=enable_ref_fk.sql" style="color:rgb(51,51,51)">enable_ref_fk.sql

 

技术分享
Miscellaneous
  • category=miscellaneous&file=analyze_all.sql" style="color:rgb(51,51,51)">analyze_all.sql

  • category=miscellaneous&file=base64decode.sql" style="color:rgb(51,51,51)">base64decode.sql

  • base64encode.sql
  • column_comments.sql
  • category=miscellaneous&file=comments.sql" style="color:rgb(51,51,51)">comments.sql

  • category=miscellaneous&file=compile_all.sql" style="color:rgb(51,51,51)">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
  • category=miscellaneous&file=conversion_api.sql" style="color:rgb(51,51,51)">conversion_api.sql

 
  • category=miscellaneous&file=csv.sql" style="color:rgb(51,51,51)">csv.sql

  • dict_comments.sql
  • drop_all.sql
  • category=miscellaneous&file=dsp.pkb" style="color:rgb(51,51,51)">dsp.pkb

  • category=miscellaneous&file=dsp.pks" style="color:rgb(51,51,51)">dsp.pks

  • err.pkb
  • category=miscellaneous&file=err.pks" style="color:rgb(51,51,51)">err.pks

  • category=miscellaneous&file=ftp.pkb" style="color:rgb(51,51,51)">ftp.pkb

  • ftp.pks
  • category=miscellaneous&file=gen_health.sql" style="color:rgb(51,51,51)">gen_health.sql

  • category=miscellaneous&file=get_pivot.sql" style="color:rgb(51,51,51)">get_pivot.sql

  • login.sql
  • part_hv_to_date.sql
 
  • category=miscellaneous&file=proc_defs.sql" style="color:rgb(51,51,51)">proc_defs.sql

  • category=miscellaneous&file=rebuild_index.sql" style="color:rgb(51,51,51)">rebuild_index.sql

  • soap_api.sql
  • string_agg.sql
  • category=miscellaneous&file=string_api.sql" style="color:rgb(51,51,51)">string_api.sql

  • switch_schema.sql
  • table_comments.sql
  • table_defs.sql
  • table_differences.sql
  • trc.pkb
  • category=miscellaneous&file=trc.pks" style="color:rgb(51,51,51)">trc.pks

 

技术分享
Real Application Clusters (RAC)
  • locked_objects_rac.sql
  • longops_rac.sql
 
  • category=rac&file=monitor_memory_rac.sql" style="color:rgb(51,51,51)">monitor_memory_rac.sql

  • session_undo_rac.sql
 
  • session_waits_rac.sql
  • sessions_rac.sql
 

技术分享
Resource Manager
  • category=resource_manager&file=active_plan.sql" style="color:rgb(51,51,51)">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
  • category=script_creation&file=create_data.sql" style="color:rgb(51,51,51)">create_data.sql

  • db_link_ddl.sql
  • category=script_creation&file=directory_ddl.sql" style="color:rgb(51,51,51)">directory_ddl.sql

  • drop_cons_on_table.sql
  • drop_fks_on_table.sql
  • category=script_creation&file=drop_fks_ref_table.sql" style="color:rgb(51,51,51)">drop_fks_ref_table.sql

  • drop_indexes.sql
  • category=script_creation&file=fks_on_table_ddl.sql" style="color:rgb(51,51,51)">fks_on_table_ddl.sql

  • fks_ref_table_ddl.sql
  • index_monitoring_off.sql
 
  • index_monitoring_on.sql
  • category=script_creation&file=logon_as_user.sql" style="color:rgb(51,51,51)">logon_as_user.sql

  • logon_as_user_orig.sql
  • category=script_creation&file=monitoring_off.sql" style="color:rgb(51,51,51)">monitoring_off.sql

  • category=script_creation&file=monitoring_on.sql" style="color:rgb(51,51,51)">monitoring_on.sql

  • object_grants.sql
  • category=script_creation&file=profile_ddl.sql" style="color:rgb(51,51,51)">profile_ddl.sql

  • rbs_structure.sql
  • recreate_table.sql
  • category=script_creation&file=role_ddl.sql" style="color:rgb(51,51,51)">role_ddl.sql

  • sequence_ddl.sql
  • synonym_by_object_owner_ddl.sql
  • synonym_ddl.sql
 
  • category=script_creation&file=synonym_public_remote_ddl.sql" style="color:rgb(51,51,51)">synonym_public_remote_ddl.sql

  • table_constraints_ddl.sql
  • category=script_creation&file=table_ddl.sql" style="color:rgb(51,51,51)">table_ddl.sql

  • table_grants_ddl.sql
  • category=script_creation&file=table_indexes_ddl.sql" style="color:rgb(51,51,51)">table_indexes_ddl.sql

  • category=script_creation&file=table_triggers_ddl.sql" style="color:rgb(51,51,51)">table_triggers_ddl.sql

  • tablespace_ddl.sql
  • tablespace_structure.sql
  • trigger_ddl.sql
  • user_ddl.sql
  • view_ddl.sql
 

技术分享
Security
  • grant_delete.sql
  • category=security&file=grant_execute.sql" style="color:rgb(51,51,51)">grant_execute.sql

  • grant_insert.sql
  • grant_select.sql
 
  • category=security&file=grant_update.sql" style="color:rgb(51,51,51)">grant_update.sql

  • package_synonyms.sql
  • schema_write_access.sql
  • category=security&file=sequence_synonyms.sql" style="color:rgb(51,51,51)">sequence_synonyms.sql

 
  • table_synonyms.sql
  • view_synonyms.sql
 

技术分享
External Scripts

  • MOATS
  • Snapper
  • OraLatencyMap
  • SQL Fiddle

技术分享
WebLogic
  • category=weblogic&file=deploy_app.py.txt" style="color:rgb(51,51,51)">deploy_app.py.txt

  • deploy_app.sh
  • start-domain.sh
 
  • category=weblogic&file=start-forms-reports.sh" style="color:rgb(51,51,51)">start-forms-reports.sh

  • start-node-manager.sh
  • stop-domain.sh
 
  • stop-forms-reports.sh
  • stop-node-manager.sh

DBA Scripts