Automatic Shared Memory Management    

  Automatic Storage Management    

  Automatic Workload Repository    

  Data Pump    

  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  4, 2015

dba_scripts_archive_Oracle.zip

593,928 bytes

Mar  4, 2015

Automatic Shared Memory Management

Output

Script Name

Last Update Date

View Output Report

asmm_components.sql

New! - Mar  3, 2015

Automatic Storage Management

Output

Script Name

Last Update Date

View Output Report

asm_alias.sql

New! - Mar  3, 2015

View Output Report

asm_clients.sql

New! - Mar  3, 2015

View Output Report

asm_diskgroups.sql

New! - Mar  3, 2015

View Output Report

asm_disks.sql

New! - Mar  3, 2015

View Output Report

asm_disks_perf.sql

New! - Mar  3, 2015

View Output Report

asm_drop_files.sql

New! - Mar  3, 2015

View Output Report

asm_files.sql

New! - Mar  3, 2015

View Output Report

asm_files2.sql

New! - Mar  3, 2015

View Output Report

asm_files_10g.sql

New! - Mar  3, 2015

View Output Report

asm_templates.sql

New! - Mar  3, 2015

Automatic Workload Repository

Output

Script Name

Last Update Date

View Output Report

awr_snapshots_dbtime.sql

New! - Mar  3, 2015

View Output Report

awr_snapshots_dbtime_xls.sql

New! - Mar  3, 2015

Data Pump

Output

Script Name

Last Update Date

No Output Available

dpump_jobs.sql

New! - Mar  3, 2015

Database Administration

Output

Script Name

Last Update Date

No Output Available

dba_blocks_used_by_table.sql

New! - Mar  3, 2015

View Output Report

dba_column_constraints.sql

New! - Mar  3, 2015

View Output Report

dba_compare_schemas.sql

New! - Mar  3, 2015

View Output Report

dba_controlfile_records.sql

New! - Mar  3, 2015

View Output Report

dba_controlfiles.sql

New! - Mar  3, 2015

View Output Report

dba_cr_init.sql

New! - Mar  3, 2015

View Output Report

dba_db_growth.sql

New! - Mar  3, 2015

View Output Report

dba_directories.sql

New! - Mar  3, 2015

View Output Report

dba_errors.sql

New! - Mar  3, 2015

View Output Report

dba_file_space_usage.sql

New! - Mar  3, 2015

View Output Report

dba_file_space_usage_7.sql

New! - Mar  3, 2015

View Output Report

dba_file_use.sql

New! - Mar  3, 2015

View Output Report

dba_file_use_7.sql

New! - Mar  3, 2015

View Output Report

dba_files.sql

New! - Mar  3, 2015

View Output Report

dba_files_all.sql

New! - Mar  3, 2015

View Output Report

dba_free_space_frag.sql

New! - Mar  3, 2015

No Output Available

dba_highwater_mark.sql

New! - Mar  3, 2015

View Output Report

dba_index_fragmentation.sql

New! - Mar  3, 2015

View Output Report

dba_index_schema_fragmentation_report.sql

New! - Mar  3, 2015

View Output Report

dba_index_stats.sql

New! - Mar  3, 2015

View Output Report

dba_invalid_objects.sql

New! - Mar  3, 2015

View Output Report

dba_invalid_objects_summary.sql

New! - Mar  3, 2015

View Output Report

dba_jobs.sql

New! - Mar  3, 2015

View Output Report

dba_object_cache.sql

New! - Mar  3, 2015

View Output Report

dba_object_search.sql

New! - Mar  3, 2015

View Output Report

dba_object_summary.sql

New! - Mar  3, 2015

View Output Report

dba_options.sql

New! - Mar  3, 2015

View Output Report

dba_owner_to_tablespace.sql

New! - Mar  3, 2015

View Output Report

dba_plsql_package_size.sql

New! - Mar  3, 2015

View Output Report

dba_query_hidden_parameters.sql

New! - Mar  3, 2015

View Output Report

dba_random_number.sql

New! - Mar  3, 2015

View Output Report

dba_rebuild_indexes.sql

New! - Mar  3, 2015

No Output Available

dba_recompile_invalid_objects.sql

New! - Mar  3, 2015

View Output Report

dba_registry.sql

New! - Mar  3, 2015

View Output Report

dba_related_child_tables.sql

New! - Mar  3, 2015

View Output Report

dba_row_size.sql

New! - Mar  3, 2015

View Output Report

dba_segment_summary.sql

New! - Mar  3, 2015

View Output Report

dba_snapshot_database_10g.sql

New! - Mar  3, 2015

View Output Report

dba_snapshot_database_8i.sql

New! - Mar  3, 2015

View Output Report

dba_snapshot_database_9i.sql

New! - Mar  3, 2015

View Output Report

dba_table_info.sql

New! - Mar  3, 2015

View Output Report

dba_tables_all.sql

New! - Mar  3, 2015

View Output Report

dba_tables_current_user.sql

New! - Mar  3, 2015

View Output Report

dba_tables_query_user.sql

New! - Mar  3, 2015

View Output Report

dba_tablespace_mapper.sql

New! - Mar  3, 2015

View Output Report

dba_tablespace_to_owner.sql

New! - Mar  3, 2015

View Output Report

dba_tablespaces.sql

New! - Mar  3, 2015

View Output Report

dba_tablespaces_7.sql

New! - Mar  3, 2015

View Output Report

dba_tablespaces_8i.sql

New! - Mar  3, 2015

View Output Report

dba_top_segments.sql

New! - Mar  3, 2015

View Output Report

help.sql

New! - Mar  4, 2015

Database Resource Manager

Output

Script Name

Last Update Date

View Output Report

rsrc_plan_status_detail.sql

New! - Mar  4, 2015

View Output Report

rsrc_plan_status_summary.sql

New! - Mar  4, 2015

Examples

Output

Script Name

Last Update Date

No Output Available

example_create_clob.sql

New! - Mar  3, 2015

No Output Available

example_create_clob_8.sql

New! - Mar  3, 2015

No Output Available

example_create_dimension.sql

New! - Mar  3, 2015

No Output Available

example_create_emp_dept_custom.sql

New! - Mar  3, 2015

No Output Available

example_create_emp_dept_original.sql

New! - Mar  3, 2015

No Output Available

example_create_index.sql

New! - Mar  3, 2015

No Output Available

example_create_index_organized_table.sql

New! - Mar  3, 2015

No Output Available

example_create_materialized_view.sql

New! - Mar  3, 2015

No Output Available

example_create_not_null_constraints.sql

New! - Mar  3, 2015

No Output Available

example_create_primary_foreign_key.sql

New! - Mar  3, 2015

No Output Available

example_create_profile_password_parameters.sql

New! - Mar  3, 2015

No Output Available

example_create_profile_resource_parameters.sql

New! - Mar  3, 2015

No Output Available

example_create_resource_plan_multi_resource_plan_9i.sql

New! - Mar  3, 2015

No Output Available

example_create_sequence.sql

New! - Mar  3, 2015

No Output Available

example_create_table.sql

New! - Mar  3, 2015

No Output Available

example_create_table_buffer_pools.sql

New! - Mar  3, 2015

No Output Available

example_create_tablespace.sql

New! - Mar  3, 2015

No Output Available

example_create_temporary_tables.sql

New! - Mar  3, 2015

No Output Available

example_create_user_tables.sql

New! - Mar  3, 2015

No Output Available

example_database_resource_manager_setup.sql

New! - Mar  3, 2015

No Output Available

example_drop_unused_column.sql

New! - Mar  3, 2015

View Output Report

example_lob_demonstration.sql

New! - Mar  3, 2015

No Output Available

example_move_table.sql

New! - Mar  3, 2015

No Output Available

example_partition_range_date_oracle_8.sql

New! - Mar  3, 2015

No Output Available

example_partition_range_number_oracle_8.sql

New! - Mar  3, 2015

No Output Available

example_transport_tablespace.sql

New! - Mar  3, 2015

External Procedures

Output

Script Name

Last Update Date

No Output Available

compile_shell.sh

New! - Mar  4, 2015

No Output Available

shell.c

New! - Mar  4, 2015

Flash Recovery Area

Output

Script Name

Last Update Date

View Output Report

fra_alerts.sql

New! - Mar  3, 2015

No Output Available

fra_files.sql

New! - Mar  3, 2015

View Output Report

fra_status.sql

New! - Mar  3, 2015

Flashback Database

Output

Script Name

Last Update Date

View Output Report

fdb_log_files.sql

New! - Mar  3, 2015

View Output Report

fdb_redo_time_matrix.sql

New! - Mar  3, 2015

View Output Report

fdb_status.sql

New! - Mar  3, 2015

Generate DDL Scripts

Output

Script Name

Last Update Date

LOBs

Output

Script Name

Last Update Date

View Output Report

lob_dump_blob.sql

New! - Mar  3, 2015

View Output Report

lob_dump_clob.sql

New! - Mar  3, 2015

No Output Available

lob_dump_nclob.sql

New! - Mar  3, 2015

View Output Report

lob_fragmentation_user.sql

New! - Mar  3, 2015

Locks

Output

Script Name

Last Update Date

View Output Report

locks_blocking.sql

New! - Mar  3, 2015

View Output Report

locks_blocking2.sql

New! - Mar  3, 2015

View Output Report

locks_dml_ddl.sql

New! - Mar  3, 2015

View Output Report

locks_dml_lock_time.sql

New! - Mar  3, 2015

Multi Threaded Server

Output

Script Name

Last Update Date

View Output Report

mts_dispatcher_status.sql

New! - Mar  3, 2015

View Output Report

mts_dispatcher_utilization.sql

New! - Mar  3, 2015

View Output Report

mts_queue_information.sql

New! - Mar  3, 2015

View Output Report

mts_shared_server_statistics.sql

New! - Mar  3, 2015

View Output Report

mts_shared_server_utilization.sql

New! - Mar  3, 2015

View Output Report

mts_user_connections.sql

New! - Mar  3, 2015

Oracle Applications

Output

Script Name

Last Update Date

No Output Available

erp_conc_manager_job_status.sql

New! - Mar  3, 2015

No Output Available

erp_conc_manager_job_status2.sql

New! - Mar  3, 2015

View Output Report

erp_conc_manager_user_query.sql

New! - Mar  3, 2015

Oracle Wait Interface

Output

Script Name

Last Update Date

View Output Report

owi_event_names.sql

New! - Mar  3, 2015

PL/SQL Examples

Output

Script Name

Last Update Date

No Output Available

plsql_random_numbers.sql

New! - Mar  4, 2015

No Output Available

plsql_webdba_utl_pkg.sql

New! - Mar  4, 2015

RMAN

Output

Script Name

Last Update Date

View Output Report

rman_backup_pieces.sql

New! - Mar  4, 2015

View Output Report

rman_backup_sets.sql

New! - Mar  4, 2015

View Output Report

rman_backup_sets_8i.sql

New! - Mar  4, 2015

View Output Report

rman_configuration.sql

New! - Mar  4, 2015

View Output Report

rman_configuration_clear_all_9i.rcv

New! - Mar  4, 2015

View Output Report

rman_configuration_setup_9i.rcv

New! - Mar  4, 2015

View Output Report

rman_controlfiles.sql

New! - Mar  4, 2015

View Output Report

rman_progress.sql

New! - Mar  4, 2015

View Output Report

rman_spfiles.sql

New! - Mar  4, 2015

RMAN Recovery Catalog

Output

Script Name

Last Update Date

View Output Report

rc_databases.sql

New! - Mar  4, 2015

Real Application Clusters

Output

Script Name

Last Update Date

View Output Report

rac_instances.sql

New! - Mar  4, 2015

Security

Output

Script Name

Last Update Date

View Output Report

sec_default_passwords.sql

New! - Mar  4, 2015

View Output Report

sec_roles.sql

New! - Mar  4, 2015

View Output Report

sec_users.sql

New! - Mar  4, 2015

Session Management

Output

Script Name

Last Update Date

View Output Report

sess_current_user_transactions.sql

New! - Mar  4, 2015

View Output Report

sess_query_sql.sql

New! - Mar  4, 2015

View Output Report

sess_uncommited_transactions.sql

New! - Mar  4, 2015

View Output Report

sess_user_sessions.sql

New! - Mar  4, 2015

View Output Report

sess_user_stats.sql

New! - Mar  4, 2015

View Output Report

sess_user_trace_file_location.sql

New! - Mar  4, 2015

View Output Report

sess_users.sql

New! - Mar  4, 2015

View Output Report

sess_users_8i.sql

New! - Mar  4, 2015

View Output Report

sess_users_active.sql

New! - Mar  4, 2015

No Output Available

sess_users_active_8i.sql

New! - Mar  4, 2015

View Output Report

sess_users_active_sql.sql

New! - Mar  4, 2015

View Output Report

sess_users_by_cpu.sql

New! - Mar  4, 2015

View Output Report

sess_users_by_cursors.sql

New! - Mar  4, 2015

View Output Report

sess_users_by_io.sql

New! - Mar  4, 2015

View Output Report

sess_users_by_memory.sql

New! - Mar  4, 2015

View Output Report

sess_users_by_transactions.sql

New! - Mar  4, 2015

View Output Report

sess_waiting.sql

New! - Mar  4, 2015

No Output Available

sess_waiting_8i.sql

New! - Mar  4, 2015

Statspack

Output

Script Name

Last Update Date

View Output Report

sp_auto.sql

New! - Mar  4, 2015

View Output Report

sp_auto_15.sql

New! - Mar  4, 2015

View Output Report

sp_auto_30.sql

New! - Mar  4, 2015

View Output Report

sp_auto_5.sql

New! - Mar  4, 2015

View Output Report

sp_list.sql

New! - Mar  4, 2015

View Output Report

sp_parameters.sql

New! - Mar  4, 2015

View Output Report

sp_purge.sql

New! - Mar  4, 2015

View Output Report

sp_purge_30_days_10g.sql

New! - Mar  4, 2015

View Output Report

sp_purge_30_days_9i.sql

New! - Mar  4, 2015

View Output Report

sp_purge_n_days_10g.sql

New! - Mar  4, 2015

View Output Report

sp_purge_n_days_9i.sql

New! - Mar  4, 2015

View Output Report

sp_snap.sql

New! - Mar  4, 2015

View Output Report

sp_statspack_custom_pkg_10g.sql

New! - Mar  4, 2015

View Output Report

sp_statspack_custom_pkg_9i.sql

New! - Mar  4, 2015

View Output Report

sp_trunc.sql

New! - Mar  4, 2015

Temporary Tablespace

Output

Script Name

Last Update Date

View Output Report

temp_sort_segment.sql

New! - Mar  4, 2015

View Output Report

temp_sort_users.sql

New! - Mar  4, 2015

View Output Report

temp_status.sql

New! - Mar  4, 2015

Tuning

Output

Script Name

Last Update Date

View Output Report

perf_db_block_buffer_usage.sql

New! - Mar  3, 2015

View Output Report

perf_explain_plan.sql

New! - Mar  3, 2015

View Output Report

perf_file_io.sql

New! - Mar  3, 2015

View Output Report

perf_file_io_7.sql

New! - Mar  3, 2015

View Output Report

perf_file_io_efficiency.sql

New! - Mar  3, 2015

View Output Report

perf_file_waits.sql

New! - Mar  3, 2015

View Output Report

perf_hit_ratio_by_session.sql

New! - Mar  3, 2015

View Output Report

perf_hit_ratio_system.sql

New! - Mar  3, 2015

View Output Report

perf_log_switch_history_bytes_daily_all.sql

New! - Mar  3, 2015

View Output Report

perf_log_switch_history_count_daily.sql

New! - Mar  3, 2015

View Output Report

perf_log_switch_history_count_daily_7.sql

New! - Mar  3, 2015

View Output Report

perf_log_switch_history_count_daily_all.sql

New! - Mar  3, 2015

View Output Report

perf_lru_latch_contention.sql

New! - Mar  3, 2015

View Output Report

perf_objects_without_statistics.sql

New! - Mar  3, 2015

View Output Report

perf_performance_snapshot.sql

New! - Mar  3, 2015

View Output Report

perf_redo_log_contention.sql

New! - Mar  3, 2015

View Output Report

perf_sga_free_pool.sql

New! - Mar  3, 2015

View Output Report

perf_sga_usage.sql

New! - Mar  3, 2015

View Output Report

perf_shared_pool_memory.sql

New! - Mar  3, 2015

View Output Report

perf_top_10_procedures.sql

New! - Mar  3, 2015

View Output Report

perf_top_10_tables.sql

New! - Mar  3, 2015

View Output Report

perf_top_sql_by_buffer_gets.sql

New! - Mar  3, 2015

View Output Report

perf_top_sql_by_disk_reads.sql

New! - Mar  3, 2015

UNIX Shell Scripts

Output

Script Name

Last Update Date

View Output Report

archive_oracle_log_files.ksh

New! - Mar  4, 2015

View Output Report

asm

New! - Mar  4, 2015

View Output Report

asm_disk_mappings.ksh

New! - Mar  4, 2015

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

New! - Mar  4, 2015

No Output Available

dbora_10g

New! - Mar  4, 2015

No Output Available

dbora_10g_solaris

New! - Mar  4, 2015

No Output Available

dbora_grid_10g

New! - Mar  4, 2015

No Output Available

dbora_rac_10g

Mar 18, 2012

No Output Available

dg_activate_standby_failover.ksh

New! - Mar  4, 2015

View Output Report

dg_activate_standby_failover_9i.ksh

New! - Mar  4, 2015

No Output Available

dg_rebuild_standby.ksh

New! - Mar  4, 2015

No Output Available

dg_refresh_standby_database.ksh

New! - Mar  4, 2015

View Output Report

dos2unix.pl

New! - Mar  4, 2015

View Output Report

dpump_backup_full.ksh

New! - Mar  4, 2015

View Output Report

export_backup_full.ksh

New! - Mar  4, 2015

No Output Available

get_public_ip_address

New! - Mar  4, 2015

No Output Available

hugepages_settings.sh

New! - Mar  4, 2015

View Output Report

ias10gr1_ctl

New! - Mar  4, 2015

View Output Report

iscsi-ls-map.ksh

New! - Mar  4, 2015

No Output Available

iscsi_client_services_solaris.ksh

New! - Mar  4, 2015

No Output Available

metalink_download_patch.sh

New! - Mar  4, 2015

View Output Report

ocfs2_check_orphaned_files.ksh

New! - Mar  4, 2015

View Output Report

oem10g_ctl.ksh

New! - Mar  4, 2015

No Output Available

oemctrl

Nov 25, 2014

View Output Report

purge_archived_logs.ksh

New! - Mar  4, 2015

View Output Report

rac_crs_stat

New! - Mar  4, 2015

View Output Report

rman_backup_online_full.ksh

New! - Mar  4, 2015

View Output Report

switch_log_file.ksh

New! - Mar  4, 2015

View Output Report

top15

New! - Mar  4, 2015

Undo Segments

Output

Script Name

Last Update Date

View Output Report

rollback_segments.sql

New! - Mar  4, 2015

No Output Available

rollback_users.sql

New! - Mar  4, 2015

View Output Report

undo_contention.sql

New! - Mar  4, 2015

View Output Report

undo_segments.sql

New! - Mar  4, 2015

View Output Report

undo_users.sql

New! - Mar  4, 2015

WINDOWS Shell Scripts

Output

Script Name

Last Update Date

View Output Report

Template.js

New! - Mar  4, 2015

View Output Report

Template.vbs

New! - Mar  4, 2015

View Output Report

dpump_backup_full.bat

New! - Mar  4, 2015

View Output Report

export_backup_full.bat

New! - Mar  4, 2015

View Output Report

oracle_ADO_example.vbs

New! - Mar  4, 2015

View Output Report

rman_backup_online_full.bat

New! - Mar  4, 2015

View Output Report

rman_copy_purge_backupset.bat

New! - Mar  4, 2015

View Output Report

sp_purge_n_days.vbs

New! - Mar  4, 2015

No Output Available

standby_database_admin.bat

New! - Mar  4, 2015

Workspace Manager

Output

Script Name

Last Update Date

View Output Report

wm_create_workspace.sql

New! - Mar  4, 2015

View Output Report

wm_disable_versioning.sql

New! - Mar  4, 2015

View Output Report

wm_enable_versioning.sql

New! - Mar  4, 2015

View Output Report

wm_freeze_workspace.sql

New! - Mar  4, 2015

View Output Report

wm_get_workspace.sql

New! - Mar  4, 2015

View Output Report

wm_goto_workspace.sql

New! - Mar  4, 2015

View Output Report

wm_merge_workspace.sql

New! - Mar  4, 2015

View Output Report

wm_refresh_workspace.sql

New! - Mar  4, 2015

View Output Report

wm_remove_workspace.sql

New! - Mar  4, 2015

View Output Report

wm_rollback_workspace.sql

New! - Mar  4, 2015

View Output Report

wm_unfreeze_workspace.sql

New! - Mar  4, 2015

View Output Report

wm_workspaces.sql

New! - Mar  4, 2015