Automatic Shared Memory Management	Automatic Storage Management	Automatic Workload Repository
Create Database Scripts	Create Object Examples	Database Administration
Database Resource Manager	Demonstrations	External Procedures
Flash Recovery Area	Flashback Database	LOBs
Locks	Multi Threaded Server	Oracle Applications
Oracle Wait Interface	PL/SQL Examples	RMAN
RMAN Recovery Catalog	Real Application Clusters	Rollback Segments
Security	Session Management	Statspack
Temporary Tablespace	Tuning	UNIX Shell Scripts
WINDOWS Shell Scripts	Workspace Manager

DBA Scripts Archive for Oracle

File Name Size Last Updated README.txt 9,604 bytes Feb 26, 2011 dba_scripts_archive_Oracle.zip 9,874,829 bytes Jan 22, 2012

Automatic Shared Memory Management
Output	Script Name	Last Update Date
	asmm_components.sql	Feb 26, 2011

Automatic Storage Management
Output	Script Name	Last Update Date
	asm_alias.sql	Feb 26, 2011
	asm_clients.sql	Feb 26, 2011
	asm_diskgroups.sql	Feb 26, 2011
	asm_disks.sql	Feb 26, 2011
	asm_disks_perf.sql	Feb 26, 2011
	asm_drop_files.sql	Feb 26, 2011
	asm_files.sql	Feb 26, 2011
	asm_files2.sql	Feb 26, 2011
	asm_files_10g.sql	Feb 26, 2011
	asm_templates.sql	Feb 26, 2011

Automatic Workload Repository
Output	Script Name	Last Update Date
	awr_snapshots_dbtime.sql	Feb 26, 2011
	awr_snapshots_dbtime_xls.sql	Feb 26, 2011

Create Database Scripts
Output	Script Name	Last Update Date
	Create Database - (Linux)	Dec 17, 2006
	Create Database - (Solaris)	Dec 17, 2006
	Create Database - (Windows)	Dec 17, 2006
	SQL*Net Configuration Files	Dec 17, 2006
	cr_init.sql	Jan 10, 2008

Create Object Examples
Output	Script Name	Last Update Date
	cr_clob.sql	Feb 26, 2011
	cr_clob_8.sql	Feb 26, 2011
	cr_dimension.sql	Feb 26, 2011
	cr_index.sql	Feb 26, 2011
	cr_index_organized_table.sql	Feb 26, 2011
	cr_materialized_view.sql	Feb 26, 2011
	cr_not_null_constraints.sql	Feb 26, 2011
	cr_primary_foreign_key.sql	Feb 26, 2011
	cr_profile_password_parameters.sql	Feb 26, 2011
	cr_profile_resource_parameters.sql	Feb 26, 2011
	cr_resource_plan_multi_resource_plan_9i.sql	Feb 26, 2011
	cr_sequence.sql	Feb 26, 2011
	cr_table.sql	Feb 26, 2011
	cr_table_buffer_pools.sql	Feb 26, 2011
	cr_tablespace.sql	Feb 26, 2011
	cr_temporary_tables.sql	Feb 26, 2011
	create_emp_dept_custom.sql	Feb 26, 2011
	create_emp_dept_original.sql	Feb 26, 2011
	create_user_tables.sql	Feb 26, 2011

Database Administration
Output	Script Name	Last Update Date
	dba_blocks_used_by_table.sql	Feb 26, 2011
	dba_column_constraints.sql	Feb 26, 2011
	dba_compare_schemas.sql	Feb 26, 2011
	dba_controlfile_records.sql	Feb 26, 2011
	dba_controlfiles.sql	Feb 26, 2011
	dba_cr_init.sql	Feb 26, 2011
	dba_db_growth.sql	Feb 26, 2011
	dba_directories.sql	Mar 27, 2011
	dba_errors.sql	Feb 26, 2011
	dba_file_space_usage.sql	Feb 26, 2011
	dba_file_space_usage_7.sql	Feb 26, 2011
	dba_file_use.sql	Feb 26, 2011
	dba_file_use_7.sql	Feb 26, 2011
	dba_files.sql	Feb 26, 2011
	dba_files_all.sql	Feb 26, 2011
	dba_free_space_frag.sql	Feb 26, 2011
	dba_highwater_mark.sql	Feb 26, 2011
	dba_index_fragmentation.sql	Feb 26, 2011
	dba_index_schema_fragmentation_report.sql	Feb 26, 2011
	dba_index_stats.sql	Feb 26, 2011
	dba_invalid_objects.sql	Feb 26, 2011
	dba_invalid_objects_summary.sql	Feb 26, 2011
	dba_jobs.sql	Feb 26, 2011
	dba_object_cache.sql	Feb 26, 2011
	dba_object_search.sql	Feb 26, 2011
	dba_object_summary.sql	Feb 26, 2011
	dba_options.sql	Feb 26, 2011
	dba_owner_to_tablespace.sql	Feb 26, 2011
	dba_plsql_package_size.sql	Feb 26, 2011
	dba_query_hidden_parameters.sql	Feb 26, 2011
	dba_random_number.sql	Feb 26, 2011
	dba_rebuild_indexes.sql	Feb 26, 2011
	dba_recompile_invalid_objects.sql	Feb 26, 2011
	dba_registry.sql	Feb 26, 2011
	dba_related_child_tables.sql	Feb 26, 2011
	dba_row_size.sql	Feb 26, 2011
	dba_segment_summary.sql	Feb 26, 2011
	dba_snapshot_database_10g.sql	Feb 26, 2011
	dba_snapshot_database_8i.sql	Feb 26, 2011
	dba_snapshot_database_9i.sql	Feb 26, 2011
	dba_table_info.sql	Feb 26, 2011
	dba_tables.sql	Feb 26, 2011
	dba_tables_all.sql	Feb 26, 2011
	dba_tables_user.sql	Feb 26, 2011
	dba_tablespace_mapper.sql	Feb 26, 2011
	dba_tablespace_to_owner.sql	Feb 26, 2011
	dba_tablespaces.sql	Sep  2, 2011
	dba_tablespaces_7.sql	Feb 26, 2011
	dba_tablespaces_8i.sql	Feb 26, 2011
	dba_top_segments.sql	Feb 26, 2011
	help.sql	Jan 22, 2012

Database Resource Manager
Output	Script Name	Last Update Date
	rsrc_plan_status_detail_9i.sql	Feb 26, 2011
	rsrc_plan_status_summary_9i.sql	Feb 26, 2011

Demonstrations
Output	Script Name	Last Update Date
	example_database_resource_manager_setup.sql	Feb 26, 2011
	example_drop_unused_column.sql	Feb 26, 2011
	example_lob_demonstration.sql	Feb 26, 2011
	example_move_table.sql	Feb 26, 2011
	example_partition_range_date_oracle_8.sql	Feb 26, 2011
	example_partition_range_number_oracle_8.sql	Feb 26, 2011
	example_transport_tablespace.sql	Feb 26, 2011

External Procedures
Output	Script Name	Last Update Date
	compile_test_extproc.sh	Sep 19, 2004
	test_extproc.c	Sep 19, 2004

Flash Recovery Area
Output	Script Name	Last Update Date
	fra_alerts.sql	Feb 26, 2011
	fra_files.sql	Feb 26, 2011
	fra_status.sql	Feb 26, 2011

Flashback Database
Output	Script Name	Last Update Date
	fdb_log_files.sql	Feb 26, 2011
	fdb_redo_time_matrix.sql	Feb 26, 2011
	fdb_status.sql	Feb 26, 2011

LOBs
Output	Script Name	Last Update Date
	lob_dump_blob.sql	Feb 26, 2011
	lob_dump_clob.sql	Feb 26, 2011
	lob_dump_nclob.sql	Feb 26, 2011
	lob_fragmentation_user.sql	Feb 26, 2011

Locks
Output	Script Name	Last Update Date
	locks_blocking.sql	Feb 26, 2011
	locks_dml_ddl.sql	Feb 26, 2011
	locks_dml_lock_time.sql	Feb 26, 2011

Multi Threaded Server
Output	Script Name	Last Update Date
	mts_dispatcher_status.sql	Feb 26, 2011
	mts_dispatcher_utilization.sql	Feb 26, 2011
	mts_queue_information.sql	Feb 26, 2011
	mts_shared_server_statistics.sql	Feb 26, 2011
	mts_shared_server_utilization.sql	Feb 26, 2011
	mts_user_connections.sql	Feb 26, 2011

Oracle Applications
Output	Script Name	Last Update Date
	erp_conc_manager_user_query.sql	Feb 26, 2011

Oracle Wait Interface
Output	Script Name	Last Update Date
	owi_event_names.sql	Feb 26, 2011

PL/SQL Examples
Output	Script Name	Last Update Date
	plsql_random_numbers.sql	Feb 26, 2011
	plsql_webdba_utl_pkg.sql	Feb 26, 2011

RMAN
Output	Script Name	Last Update Date
	rman_backup_pieces.sql	Feb 26, 2011
	rman_backup_sets.sql	Feb 26, 2011
	rman_backup_sets_8i.sql	Feb 26, 2011
	rman_configuration.sql	Feb 26, 2011
	rman_configuration_clear_all_9i.rcv	Feb 26, 2011
	rman_configuration_setup_9i.rcv	Feb 26, 2011
	rman_controlfiles.sql	Feb 26, 2011
	rman_progress.sql	Feb 26, 2011
	rman_spfiles.sql	Feb 26, 2011

RMAN Recovery Catalog
Output	Script Name	Last Update Date
	rc_databases.sql	Feb 26, 2011

Real Application Clusters
Output	Script Name	Last Update Date
	rac_instances.sql	Feb 26, 2011
	rac_locks_blocking.sql	Feb 26, 2011
	rac_rollback_segments.sql	Feb 26, 2011
	rac_rollback_users.sql	Feb 26, 2011
	rac_sess_users.sql	Feb 26, 2011
	rac_sess_users_active.sql	Feb 26, 2011
	rac_sess_users_sql.sql	Feb 26, 2011
	rac_waiting_sessions.sql	Feb 26, 2011

Rollback Segments
Output	Script Name	Last Update Date
	rollback_contention.sql	Feb 26, 2011
	rollback_segments.sql	Feb 26, 2011
	rollback_users.sql	Feb 26, 2011

Security
Output	Script Name	Last Update Date
	sec_default_passwords.sql	Feb 26, 2011
	sec_roles.sql	Feb 26, 2011
	sec_users.sql	Feb 26, 2011

Session Management
Output	Script Name	Last Update Date
	sess_current_user_transactions.sql	Feb 26, 2011
	sess_query_sql.sql	Feb 26, 2011
	sess_uncommited_transactions.sql	Feb 26, 2011
	sess_user_sessions.sql	Feb 26, 2011
	sess_user_stats.sql	Feb 26, 2011
	sess_user_trace_file_location.sql	Feb 26, 2011
	sess_users.sql	Feb 26, 2011
	sess_users_active.sql	Feb 26, 2011
	sess_users_active_sql.sql	Feb 26, 2011
	sess_users_by_cpu.sql	Feb 26, 2011
	sess_users_by_cursors.sql	Feb 26, 2011
	sess_users_by_io.sql	Feb 26, 2011
	sess_users_by_memory.sql	Feb 26, 2011
	sess_users_by_transactions.sql	Feb 26, 2011
	sess_users_sql.sql	Feb 26, 2011

Statspack
Output	Script Name	Last Update Date
	sp_auto.sql	Feb 26, 2011
	sp_auto_15.sql	Feb 26, 2011
	sp_auto_30.sql	Feb 26, 2011
	sp_auto_5.sql	Feb 26, 2011
	sp_last_report.sql	Nov 30, 2004
	sp_list.sql	Feb 26, 2011
	sp_parameters.sql	Feb 26, 2011
	sp_purge.sql	Feb 26, 2011
	sp_purge_30_days_10g.sql	Feb 26, 2011
	sp_purge_30_days_9i.sql	Feb 26, 2011
	sp_purge_n_days_10g.sql	Feb 26, 2011
	sp_purge_n_days_9i.sql	Feb 26, 2011
	sp_snap.sql	Feb 26, 2011
	sp_statspack_custom_pkg_10g.sql	Feb 26, 2011
	sp_statspack_custom_pkg_9i.sql	Feb 26, 2011
	sp_trunc.sql	Feb 26, 2011

Temporary Tablespace
Output	Script Name	Last Update Date
	temp_sort_segment.sql	Feb 26, 2011
	temp_sort_users.sql	Feb 26, 2011
	temp_status.sql	Feb 26, 2011

Tuning
Output	Script Name	Last Update Date
	perf_db_block_buffer_usage.sql	Feb 26, 2011
	perf_explain_plan.sql	Feb 26, 2011
	perf_file_io.sql	Feb 26, 2011
	perf_file_io_7.sql	Feb 26, 2011
	perf_file_io_efficiency.sql	Feb 26, 2011
	perf_file_waits.sql	Feb 26, 2011
	perf_hit_ratio_by_session.sql	Feb 26, 2011
	perf_hit_ratio_system.sql	Feb 26, 2011
	perf_log_switch_history_bytes_daily_all.sql	Feb 26, 2011
	perf_log_switch_history_count_daily.sql	Feb 26, 2011
	perf_log_switch_history_count_daily_7.sql	Feb 26, 2011
	perf_log_switch_history_count_daily_all.sql	Feb 26, 2011
	perf_lru_latch_contention.sql	Feb 26, 2011
	perf_objects_without_statistics.sql	Feb 26, 2011
	perf_performance_snapshot.sql	Feb 26, 2011
	perf_redo_log_contention.sql	Feb 26, 2011
	perf_sga_free_pool.sql	Feb 26, 2011
	perf_sga_usage.sql	Feb 26, 2011
	perf_shared_pool_memory.sql	Feb 26, 2011
	perf_top_10_procedures.sql	Feb 26, 2011
	perf_top_10_tables.sql	Feb 26, 2011
	perf_top_sql_by_buffer_gets.sql	Feb 26, 2011
	perf_top_sql_by_disk_reads.sql	Feb 26, 2011

UNIX Shell Scripts
Output	Script Name	Last Update Date
	archive_oracle_log_files.ksh	Jan 22, 2012
	asm	Jan 22, 2012
	asm_disk_mappings.ksh	Jan 22, 2012
	backup_tape_vmwindows.ksh	Aug 17, 2010
	check_locks	Jan 22, 2012
	check_sessions	Jan 22, 2012
	crontab_header_oracle_packmule.txt	Sep 13, 2010
	crontab_header_oracle_racnode1.txt	Sep 11, 2010
	crontab_header_oracle_racnode2.txt	Sep 11, 2010
	crontab_header_root_racnode1.txt	Sep 11, 2010
	crontab_header_root_racnode2.txt	Sep 11, 2010
	crs_components_backup_10g.ksh	Jan 22, 2012
	dbora_10g	Apr  1, 2011
	dbora_10g_solaris	Sep  9, 2010
	dbora_grid_10g	Sep  9, 2010
	dbora_rac_10g	Sep  9, 2010
	dg_activate_standby_failover.ksh	Jan 22, 2012
	dg_activate_standby_failover_9i.ksh	Jan 22, 2012
	dg_rebuild_standby.ksh	Jan 22, 2012
	dg_refresh_standby_database.ksh	Jan 22, 2012
	dos2unix.pl	Jan 22, 2012
	dpump_backup_full.ksh	Jan 22, 2012
	export_backup_full.ksh	Jan 22, 2012
	get_public_ip_address	Jan 22, 2012
	hugepages_settings.sh	Jan 22, 2012
	ias10gr1_ctl	Jan 22, 2012
	invalid_objects	Jan 22, 2012
	iscsi-ls-map.ksh	Jan 22, 2012
	iscsi_client_services_solaris.ksh	Jan 22, 2012
	ocfs2_check_orphaned_files.ksh	Jan 22, 2012
	oem10g_ctl.ksh	Jan 22, 2012
	oraproducts	Jan 22, 2012
	purge_admin_files	Jan 22, 2012
	purge_archived_logs.ksh	Jan 22, 2012
	rac_crs_stat	Jan 22, 2012
	rman_backup_online_full.ksh	Jan 22, 2012
	switch_log_file.ksh	Feb 26, 2011
	top15	Jan 22, 2012
	vmware_vm_tape_backup.ksh	Jan 22, 2012

WINDOWS Shell Scripts
Output	Script Name	Last Update Date
	Template.js	Mar  7, 2011
	Template.vbs	Mar  7, 2011
	dpump_backup_full.bat	Jan 10, 2012
	export_backup_full.bat	Apr  1, 2011
	oracle_ADO_example.vbs	Apr  1, 2011
	rman_backup_online_full.bat	Jan 10, 2012
	rman_copy_purge_backupset.bat	Jan 10, 2012
	sp_purge_n_days.vbs	Feb 26, 2011
	standby_database_admin.bat	Jan 10, 2012

Workspace Manager
Output	Script Name	Last Update Date
	wm_create_workspace.sql	Feb 26, 2011
	wm_disable_versioning.sql	Feb 26, 2011
	wm_enable_versioning.sql	Feb 26, 2011
	wm_freeze_workspace.sql	Feb 26, 2011
	wm_get_workspace.sql	Feb 26, 2011
	wm_goto_workspace.sql	Feb 26, 2011
	wm_merge_workspace.sql	Feb 26, 2011
	wm_refresh_workspace.sql	Feb 26, 2011
	wm_remove_workspace.sql	Feb 26, 2011
	wm_unfreeze_workspace.sql	Feb 26, 2011
	wm_workspaces.sql	Feb 26, 2011