Automatic Shared Memory Management    

  Automatic Storage Management    

  Automatic Workload Repository    

  Database Administration    

  Database Resource Manager    

  Examples    

  External Procedures    

  Flash Recovery Area    

  Flashback Database    

  Generate DDL Scripts    

  LOBs    

  Locks    

  Multi Threaded Server    

  Oracle Applications    

  Oracle Wait Interface    

  PL/SQL Examples    

  RMAN    

  RMAN Recovery Catalog    

  Real Application Clusters    

  Security    

  Session Management    

  Statspack    

  Temporary Tablespace    

  Tuning    

  UNIX Shell Scripts    

  Undo Segments    

  WINDOWS Shell Scripts    

  Workspace Manager    

  


DBA Scripts Archive for Oracle

File Name

Size

Last Updated

README.txt

6,759 bytes

Mar 18, 2012

dba_scripts_archive_Oracle.zip

592,332 bytes

Aug 26, 2014

Automatic Shared Memory Management

Output

Script Name

Last Update Date

View Output Report

asmm_components.sql

Mar 22, 2012

Automatic Storage Management

Output

Script Name

Last Update Date

View Output Report

asm_alias.sql

Mar 22, 2012

View Output Report

asm_clients.sql

Mar 22, 2012

View Output Report

asm_diskgroups.sql

Mar 22, 2012

View Output Report

asm_disks.sql

Mar 22, 2012

View Output Report

asm_disks_perf.sql

Mar 22, 2012

View Output Report

asm_drop_files.sql

Mar  8, 2012

View Output Report

asm_files.sql

Mar 22, 2012

View Output Report

asm_files2.sql

Mar 22, 2012

View Output Report

asm_files_10g.sql

Mar 22, 2012

View Output Report

asm_templates.sql

Mar 22, 2012

Automatic Workload Repository

Output

Script Name

Last Update Date

View Output Report

awr_snapshots_dbtime.sql

Mar 22, 2012

View Output Report

awr_snapshots_dbtime_xls.sql

Mar 22, 2012

Database Administration

Output

Script Name

Last Update Date

No Output Available

dba_blocks_used_by_table.sql

Mar  8, 2012

View Output Report

dba_column_constraints.sql

Mar 22, 2012

View Output Report

dba_compare_schemas.sql

Mar  8, 2012

View Output Report

dba_controlfile_records.sql

Mar 22, 2012

View Output Report

dba_controlfiles.sql

Mar 22, 2012

View Output Report

dba_cr_init.sql

Mar  8, 2012

View Output Report

dba_db_growth.sql

Mar 22, 2012

View Output Report

dba_directories.sql

Mar 22, 2012

View Output Report

dba_errors.sql

Mar 22, 2012

View Output Report

dba_file_space_usage.sql

Mar 22, 2012

View Output Report

dba_file_space_usage_7.sql

Mar 22, 2012

View Output Report

dba_file_use.sql

Mar 22, 2012

View Output Report

dba_file_use_7.sql

Mar 22, 2012

View Output Report

dba_files.sql

Jun  8, 2012

View Output Report

dba_files_all.sql

Mar 22, 2012

View Output Report

dba_free_space_frag.sql

Mar 22, 2012

No Output Available

dba_highwater_mark.sql

Mar  8, 2012

View Output Report

dba_index_fragmentation.sql

Mar  8, 2012

View Output Report

dba_index_schema_fragmentation_report.sql

Mar  8, 2012

View Output Report

dba_index_stats.sql

Mar  8, 2012

View Output Report

dba_invalid_objects.sql

Mar 22, 2012

View Output Report

dba_invalid_objects_summary.sql

Mar 22, 2012

View Output Report

dba_jobs.sql

Mar 22, 2012

View Output Report

dba_object_cache.sql

Mar 22, 2012

View Output Report

dba_object_search.sql

Mar 22, 2012

View Output Report

dba_object_summary.sql

Mar 22, 2012

View Output Report

dba_options.sql

Mar 22, 2012

View Output Report

dba_owner_to_tablespace.sql

Mar 22, 2012

View Output Report

dba_plsql_package_size.sql

Mar 22, 2012

View Output Report

dba_query_hidden_parameters.sql

Mar 22, 2012

View Output Report

dba_random_number.sql

Mar  8, 2012

View Output Report

dba_rebuild_indexes.sql

Mar 22, 2012

No Output Available

dba_recompile_invalid_objects.sql

Mar  8, 2012

View Output Report

dba_registry.sql

Mar 22, 2012

View Output Report

dba_related_child_tables.sql

Mar  8, 2012

View Output Report

dba_row_size.sql

Mar 22, 2012

View Output Report

dba_segment_summary.sql

Mar 22, 2012

View Output Report

dba_snapshot_database_10g.sql

Mar  8, 2012

View Output Report

dba_snapshot_database_8i.sql

Mar  8, 2012

View Output Report

dba_snapshot_database_9i.sql

Mar  8, 2012

View Output Report

dba_table_info.sql

Mar 22, 2012

View Output Report

dba_tables_all.sql

Mar 22, 2012

View Output Report

dba_tables_current_user.sql

Mar 22, 2012

View Output Report

dba_tables_query_user.sql

Mar 22, 2012

View Output Report

dba_tablespace_mapper.sql

Mar 22, 2012

View Output Report

dba_tablespace_to_owner.sql

Mar 22, 2012

View Output Report

dba_tablespaces.sql

Mar 22, 2012

View Output Report

dba_tablespaces_7.sql

Mar 22, 2012

View Output Report

dba_tablespaces_8i.sql

Mar 22, 2012

View Output Report

dba_top_segments.sql

Mar 22, 2012

View Output Report

help.sql

Aug 26, 2014

Database Resource Manager

Output

Script Name

Last Update Date

View Output Report

rsrc_plan_status_detail.sql

Mar 22, 2012

View Output Report

rsrc_plan_status_summary.sql

Mar 22, 2012

Examples

Output

Script Name

Last Update Date

No Output Available

example_create_clob.sql

Mar  8, 2012

No Output Available

example_create_clob_8.sql

Mar  8, 2012

No Output Available

example_create_dimension.sql

Mar  8, 2012

No Output Available

example_create_emp_dept_custom.sql

Mar  8, 2012

No Output Available

example_create_emp_dept_original.sql

Mar  8, 2012

No Output Available

example_create_index.sql

Mar  8, 2012

No Output Available

example_create_index_organized_table.sql

Mar  8, 2012

No Output Available

example_create_materialized_view.sql

Mar  8, 2012

No Output Available

example_create_not_null_constraints.sql

Mar  8, 2012

No Output Available

example_create_primary_foreign_key.sql

Mar  8, 2012

No Output Available

example_create_profile_password_parameters.sql

Mar  8, 2012

No Output Available

example_create_profile_resource_parameters.sql

Mar  8, 2012

No Output Available

example_create_resource_plan_multi_resource_plan_9i.sql

Mar  8, 2012

No Output Available

example_create_sequence.sql

Mar  8, 2012

No Output Available

example_create_table.sql

Mar  8, 2012

No Output Available

example_create_table_buffer_pools.sql

Mar  8, 2012

No Output Available

example_create_tablespace.sql

Mar  8, 2012

No Output Available

example_create_temporary_tables.sql

Mar  8, 2012

No Output Available

example_create_user_tables.sql

Mar  8, 2012

No Output Available

example_database_resource_manager_setup.sql

Mar  8, 2012

No Output Available

example_drop_unused_column.sql

Mar  8, 2012

View Output Report

example_lob_demonstration.sql

Mar  8, 2012

No Output Available

example_move_table.sql

Mar  8, 2012

No Output Available

example_partition_range_date_oracle_8.sql

Mar  8, 2012

No Output Available

example_partition_range_number_oracle_8.sql

Mar  8, 2012

No Output Available

example_transport_tablespace.sql

Mar  8, 2012

External Procedures

Output

Script Name

Last Update Date

No Output Available

compile_shell.sh

Mar  8, 2012

No Output Available

shell.c

Mar  8, 2012

Flash Recovery Area

Output

Script Name

Last Update Date

View Output Report

fra_alerts.sql

Mar  8, 2012

No Output Available

fra_files.sql

Mar  8, 2012

View Output Report

fra_status.sql

Mar  8, 2012

Flashback Database

Output

Script Name

Last Update Date

View Output Report

fdb_log_files.sql

Mar  8, 2012

View Output Report

fdb_redo_time_matrix.sql

Mar  8, 2012

View Output Report

fdb_status.sql

Mar  8, 2012

Generate DDL Scripts

Output

Script Name

Last Update Date

LOBs

Output

Script Name

Last Update Date

View Output Report

lob_dump_blob.sql

Mar 22, 2012

View Output Report

lob_dump_clob.sql

Mar 22, 2012

No Output Available

lob_dump_nclob.sql

Mar 22, 2012

View Output Report

lob_fragmentation_user.sql

Mar 22, 2012

Locks

Output

Script Name

Last Update Date

View Output Report

locks_blocking.sql

Mar 22, 2012

View Output Report

locks_blocking2.sql

Mar 22, 2012

View Output Report

locks_dml_ddl.sql

Mar 22, 2012

View Output Report

locks_dml_lock_time.sql

Mar 22, 2012

Multi Threaded Server

Output

Script Name

Last Update Date

View Output Report

mts_dispatcher_status.sql

Mar 22, 2012

View Output Report

mts_dispatcher_utilization.sql

Mar 22, 2012

View Output Report

mts_queue_information.sql

Mar 22, 2012

View Output Report

mts_shared_server_statistics.sql

Mar 22, 2012

View Output Report

mts_shared_server_utilization.sql

Mar 22, 2012

View Output Report

mts_user_connections.sql

Mar 22, 2012

Oracle Applications

Output

Script Name

Last Update Date

No Output Available

erp_conc_manager_job_status.sql

Mar 22, 2012

No Output Available

erp_conc_manager_job_status2.sql

Mar 22, 2012

View Output Report

erp_conc_manager_user_query.sql

Mar 22, 2012

Oracle Wait Interface

Output

Script Name

Last Update Date

View Output Report

owi_event_names.sql

Mar 22, 2012

PL/SQL Examples

Output

Script Name

Last Update Date

No Output Available

plsql_random_numbers.sql

Mar  8, 2012

No Output Available

plsql_webdba_utl_pkg.sql

Mar  8, 2012

RMAN

Output

Script Name

Last Update Date

View Output Report

rman_backup_pieces.sql

Mar 22, 2012

View Output Report

rman_backup_sets.sql

Mar 22, 2012

View Output Report

rman_backup_sets_8i.sql

Mar 22, 2012

View Output Report

rman_configuration.sql

Mar 22, 2012

View Output Report

rman_configuration_clear_all_9i.rcv

Mar 15, 2012

View Output Report

rman_configuration_setup_9i.rcv

Mar 15, 2012

View Output Report

rman_controlfiles.sql

Mar 22, 2012

View Output Report

rman_progress.sql

Mar 22, 2012

View Output Report

rman_spfiles.sql

Mar 22, 2012

RMAN Recovery Catalog

Output

Script Name

Last Update Date

View Output Report

rc_databases.sql

Mar 22, 2012

Real Application Clusters

Output

Script Name

Last Update Date

View Output Report

rac_instances.sql

Mar 15, 2012

Security

Output

Script Name

Last Update Date

View Output Report

sec_default_passwords.sql

Mar 22, 2012

View Output Report

sec_roles.sql

Mar 22, 2012

View Output Report

sec_users.sql

Mar 22, 2012

Session Management

Output

Script Name

Last Update Date

View Output Report

sess_current_user_transactions.sql

Mar 22, 2012

View Output Report

sess_query_sql.sql

Mar 22, 2012

View Output Report

sess_uncommited_transactions.sql

Mar 22, 2012

View Output Report

sess_user_sessions.sql

Mar 22, 2012

View Output Report

sess_user_stats.sql

Mar 22, 2012

View Output Report

sess_user_trace_file_location.sql

Mar 22, 2012

View Output Report

sess_users.sql

Mar 22, 2012

View Output Report

sess_users_8i.sql

Mar 22, 2012

View Output Report

sess_users_active.sql

Mar 22, 2012

No Output Available

sess_users_active_8i.sql

Mar 22, 2012

View Output Report

sess_users_active_sql.sql

Mar 22, 2012

View Output Report

sess_users_by_cpu.sql

Mar 22, 2012

View Output Report

sess_users_by_cursors.sql

Mar 22, 2012

View Output Report

sess_users_by_io.sql

Mar 22, 2012

View Output Report

sess_users_by_memory.sql

Mar 22, 2012

View Output Report

sess_users_by_transactions.sql

Mar 22, 2012

View Output Report

sess_waiting.sql

Mar 22, 2012

No Output Available

sess_waiting_8i.sql

Mar 22, 2012

Statspack

Output

Script Name

Last Update Date

View Output Report

sp_auto.sql

Mar  8, 2012

View Output Report

sp_auto_15.sql

Mar  8, 2012

View Output Report

sp_auto_30.sql

Mar  8, 2012

View Output Report

sp_auto_5.sql

Mar  8, 2012

View Output Report

sp_list.sql

Mar  8, 2012

View Output Report

sp_parameters.sql

Mar  8, 2012

View Output Report

sp_purge.sql

Mar  8, 2012

View Output Report

sp_purge_30_days_10g.sql

Mar  8, 2012

View Output Report

sp_purge_30_days_9i.sql

Mar  8, 2012

View Output Report

sp_purge_n_days_10g.sql

Mar  8, 2012

View Output Report

sp_purge_n_days_9i.sql

Mar  8, 2012

View Output Report

sp_snap.sql

Mar  8, 2012

View Output Report

sp_statspack_custom_pkg_10g.sql

Mar  8, 2012

View Output Report

sp_statspack_custom_pkg_9i.sql

Mar  8, 2012

View Output Report

sp_trunc.sql

Mar  8, 2012

Temporary Tablespace

Output

Script Name

Last Update Date

View Output Report

temp_sort_segment.sql

Mar 22, 2012

View Output Report

temp_sort_users.sql

Mar 22, 2012

View Output Report

temp_status.sql

Mar 22, 2012

Tuning

Output

Script Name

Last Update Date

View Output Report

perf_db_block_buffer_usage.sql

Feb 26, 2011

View Output Report

perf_explain_plan.sql

Feb 26, 2011

View Output Report

perf_file_io.sql

Feb 26, 2011

View Output Report

perf_file_io_7.sql

Feb 26, 2011

View Output Report

perf_file_io_efficiency.sql

Feb 26, 2011

View Output Report

perf_file_waits.sql

Feb 26, 2011

View Output Report

perf_hit_ratio_by_session.sql

Feb 26, 2011

View Output Report

perf_hit_ratio_system.sql

Feb 26, 2011

View Output Report

perf_log_switch_history_bytes_daily_all.sql

Feb 26, 2011

View Output Report

perf_log_switch_history_count_daily.sql

Feb 26, 2011

View Output Report

perf_log_switch_history_count_daily_7.sql

Feb 26, 2011

View Output Report

perf_log_switch_history_count_daily_all.sql

Feb 26, 2011

View Output Report

perf_lru_latch_contention.sql

Feb 26, 2011

View Output Report

perf_objects_without_statistics.sql

Feb 26, 2011

View Output Report

perf_performance_snapshot.sql

Feb 26, 2011

View Output Report

perf_redo_log_contention.sql

Feb 26, 2011

View Output Report

perf_sga_free_pool.sql

Feb 26, 2011

View Output Report

perf_sga_usage.sql

Feb 26, 2011

View Output Report

perf_shared_pool_memory.sql

Feb 26, 2011

View Output Report

perf_top_10_procedures.sql

Feb 26, 2011

View Output Report

perf_top_10_tables.sql

Feb 26, 2011

View Output Report

perf_top_sql_by_buffer_gets.sql

Feb 26, 2011

View Output Report

perf_top_sql_by_disk_reads.sql

Feb 26, 2011

UNIX Shell Scripts

Output

Script Name

Last Update Date

View Output Report

archive_oracle_log_files.ksh

Mar 18, 2012

View Output Report

asm

Jan 22, 2012

View Output Report

asm_disk_mappings.ksh

Mar 18, 2012

No Output Available

crontab_header_oracle_packmule.txt

Mar 18, 2012

No Output Available

crontab_header_oracle_racnode1.txt

Mar 18, 2012

No Output Available

crontab_header_oracle_racnode2.txt

Mar 18, 2012

No Output Available

crontab_header_root_thing1.txt

Mar 19, 2012

No Output Available

crontab_header_root_thing2.txt

Mar 19, 2012

View Output Report

crs_components_backup_10g.ksh

Mar 19, 2012

No Output Available

dbora_10g

Mar 18, 2012

No Output Available

dbora_10g_solaris

Mar 18, 2012

No Output Available

dbora_grid_10g

Mar 18, 2012

No Output Available

dbora_rac_10g

Mar 18, 2012

No Output Available

dg_activate_standby_failover.ksh

Jan 22, 2012

View Output Report

dg_activate_standby_failover_9i.ksh

Jan 22, 2012

No Output Available

dg_rebuild_standby.ksh

Mar 18, 2012

No Output Available

dg_refresh_standby_database.ksh

Mar 18, 2012

View Output Report

dos2unix.pl

Jan 22, 2012

View Output Report

dpump_backup_full.ksh

Apr  9, 2012

View Output Report

export_backup_full.ksh

Mar 18, 2012

No Output Available

get_public_ip_address

Jan 22, 2012

No Output Available

hugepages_settings.sh

Jan 22, 2012

View Output Report

ias10gr1_ctl

Jan 22, 2012

View Output Report

iscsi-ls-map.ksh

Jan 22, 2012

No Output Available

iscsi_client_services_solaris.ksh

Jan 22, 2012

No Output Available

metalink_download_patch.sh

Feb 21, 2012

View Output Report

ocfs2_check_orphaned_files.ksh

Mar 19, 2012

View Output Report

oem10g_ctl.ksh

Mar 18, 2012

View Output Report

purge_archived_logs.ksh

Mar 19, 2012

View Output Report

rac_crs_stat

Jan 22, 2012

View Output Report

rman_backup_online_full.ksh

Mar 19, 2012

View Output Report

switch_log_file.ksh

Mar 19, 2012

View Output Report

top15

Mar 23, 2012

Undo Segments

Output

Script Name

Last Update Date

View Output Report

rollback_segments.sql

Mar 22, 2012

No Output Available

rollback_users.sql

Mar 22, 2012

View Output Report

undo_contention.sql

Mar 22, 2012

View Output Report

undo_segments.sql

Mar 22, 2012

View Output Report

undo_users.sql

Mar 22, 2012

WINDOWS Shell Scripts

Output

Script Name

Last Update Date

View Output Report

Template.js

Mar 18, 2012

View Output Report

Template.vbs

Mar 18, 2012

View Output Report

dpump_backup_full.bat

Apr  9, 2012

View Output Report

export_backup_full.bat

Mar 23, 2012

View Output Report

oracle_ADO_example.vbs

Apr  1, 2011

View Output Report

rman_backup_online_full.bat

Mar 23, 2012

View Output Report

rman_copy_purge_backupset.bat

Jan 10, 2012

View Output Report

sp_purge_n_days.vbs

Feb 26, 2011

No Output Available

standby_database_admin.bat

Mar 23, 2012

Workspace Manager

Output

Script Name

Last Update Date

View Output Report

wm_create_workspace.sql

Mar  8, 2012

View Output Report

wm_disable_versioning.sql

Mar  8, 2012

View Output Report

wm_enable_versioning.sql

Mar  8, 2012

View Output Report

wm_freeze_workspace.sql

Mar  8, 2012

View Output Report

wm_get_workspace.sql

Mar  8, 2012

View Output Report

wm_goto_workspace.sql

Mar  8, 2012

View Output Report

wm_merge_workspace.sql

Mar  8, 2012

View Output Report

wm_refresh_workspace.sql

Mar  8, 2012

View Output Report

wm_remove_workspace.sql

Mar  8, 2012

View Output Report

wm_rollback_workspace.sql

Mar  8, 2012

View Output Report

wm_unfreeze_workspace.sql

Mar  8, 2012

View Output Report

wm_workspaces.sql

Mar  8, 2012