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 Archives

README.txt       common.tar.gz Size: 8,584,723 bytes Last Updated on: Oct 27, 2009 common.zip Size: 9,829,921 bytes Last Updated on: Oct 27, 2009

Automatic Shared Memory Management
Output	Script Name	Last Update Date
	asmm_components.sql	Feb  1, 2009

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

Automatic Workload Repository
Output	Script Name	Last Update Date
	awr_snapshots_dbtime.sql	Mar  5, 2009
	awr_snapshots_dbtime_xls.sql	Apr  2, 2009

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  1, 2009
	cr_clob_8.sql	Feb  1, 2009
	cr_dimension.sql	Feb  1, 2009
	cr_index.sql	Feb  1, 2009
	cr_index_organized_table.sql	Feb  1, 2009
	cr_materialized_view.sql	Feb  1, 2009
	cr_not_null_constraints.sql	Feb  1, 2009
	cr_primary_foreign_key.sql	Feb  1, 2009
	cr_profile_password_parameters.sql	Feb  1, 2009
	cr_profile_resource_parameters.sql	Feb  1, 2009
	cr_resource_plan_multi_resource_plan_9i.sql	Feb  1, 2009
	cr_sequence.sql	Feb  1, 2009
	cr_table.sql	Feb  1, 2009
	cr_table_buffer_pools.sql	Feb  1, 2009
	cr_tablespace.sql	Feb  1, 2009
	cr_temporary_tables.sql	Feb  1, 2009
	create_emp_dept_custom.sql	Feb  1, 2009
	create_emp_dept_original.sql	Feb  1, 2009
	create_user_tables.sql	Feb  1, 2009

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

Database Resource Manager
Output	Script Name	Last Update Date
	rsrc_plan_status_detail_9i.sql	Feb  1, 2009
	rsrc_plan_status_summary_9i.sql	Feb  1, 2009

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

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  1, 2009
	fra_files.sql	Feb  1, 2009
	fra_status.sql	Feb  1, 2009

Flashback Database
Output	Script Name	Last Update Date
	fdb_log_files.sql	Feb  1, 2009
	fdb_redo_time_matrix.sql	Feb  1, 2009
	fdb_status.sql	Feb  1, 2009

LOBs
Output	Script Name	Last Update Date
	lob_dump_blob.sql	Feb  1, 2009
	lob_dump_clob.sql	Feb  1, 2009
	lob_dump_nclob.sql	Feb  1, 2009

Locks
Output	Script Name	Last Update Date
	locks_blocking.sql	Feb  1, 2009
	locks_dml_ddl.sql	Feb  1, 2009
	locks_dml_lock_time.sql	Feb  1, 2009

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

Oracle Applications
Output	Script Name	Last Update Date
	erp_conc_manager_user_query.sql	Feb  1, 2009

Oracle Wait Interface
Output	Script Name	Last Update Date
	owi_event_names.sql	Feb  1, 2009

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

RMAN
Output	Script Name	Last Update Date
	rman_backup_pieces.sql	Feb  1, 2009
	rman_backup_sets.sql	Feb  1, 2009
	rman_backup_sets_8i.sql	Feb  1, 2009
	rman_configuration.sql	Feb  1, 2009
	rman_configuration_clear_all_9i.rcv	Feb  1, 2009
	rman_configuration_setup_9i.rcv	Feb  1, 2009
	rman_controlfiles.sql	Feb  1, 2009
	rman_progress.sql	Apr 21, 2009
	rman_spfiles.sql	Feb  1, 2009

RMAN Recovery Catalog
Output	Script Name	Last Update Date
	rc_databases.sql	Apr  2, 2009

Real Application Clusters
Output	Script Name	Last Update Date
	rac_instances.sql	Feb  1, 2009
	rac_locks_blocking.sql	Feb  1, 2009
	rac_rollback_segments.sql	Feb  1, 2009
	rac_rollback_users.sql	Feb  1, 2009
	rac_sess_users.sql	Sep 18, 2009
	rac_sess_users_active.sql	Sep 18, 2009
	rac_sess_users_sql.sql	Sep 18, 2009
	rac_waiting_sessions.sql	Feb  1, 2009

Rollback Segments
Output	Script Name	Last Update Date
	rollback_contention.sql	Feb  1, 2009
	rollback_segments.sql	Feb  1, 2009
	rollback_users.sql	Feb  1, 2009

Security
Output	Script Name	Last Update Date
	sec_default_passwords.sql	Feb  1, 2009
	sec_roles.sql	Feb  1, 2009
	sec_users.sql	Feb  1, 2009

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

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

Temporary Tablespace
Output	Script Name	Last Update Date
	temp_sort_segment.sql	Feb  1, 2009
	temp_sort_users.sql	Sep 18, 2009
	temp_status.sql	Feb  1, 2009

Tuning
Output	Script Name	Last Update Date
	perf_db_block_buffer_usage.sql	Feb  1, 2009
	perf_explain_plan.sql	Feb  1, 2009
	perf_file_io.sql	Feb  1, 2009
	perf_file_io_7.sql	Feb  1, 2009
	perf_file_io_efficiency.sql	Feb  1, 2009
	perf_file_waits.sql	Feb  1, 2009
	perf_hit_ratio_by_session.sql	Sep 18, 2009
	perf_hit_ratio_system.sql	Feb  1, 2009
	perf_log_switch_history_daily.sql	Feb  1, 2009
	perf_log_switch_history_daily_7.sql	Feb  1, 2009
	perf_log_switch_history_daily_all.sql	Feb  1, 2009
	perf_lru_latch_contention.sql	Feb  1, 2009
	perf_objects_without_statistics.sql	Feb  1, 2009
	perf_performance_snapshot.sql	Feb  1, 2009
	perf_redo_log_contention.sql	Feb  1, 2009
	perf_sga_free_pool.sql	Feb  1, 2009
	perf_sga_usage.sql	Feb  1, 2009
	perf_shared_pool_memory.sql	Feb  1, 2009
	perf_top_10_procedures.sql	Feb  1, 2009
	perf_top_10_tables.sql	Feb  1, 2009
	perf_top_sql_by_buffer_gets.sql	Feb  1, 2009
	perf_top_sql_by_disk_reads.sql	Feb  1, 2009

UNIX Shell Scripts
Output	Script Name	Last Update Date
	archive_oracle_log_files.ksh	Sep 23, 2009
	asm	Feb  1, 2009
	asm_disk_mappings.ksh	Apr 13, 2009
	backup_tape_vmwindows.ksh	Mar 26, 2009
	check_locks	Feb  1, 2009
	check_sessions	Feb  1, 2009
	crontab_header.txt	Sep 18, 2009
	crs_components_backup_10g.ksh	Oct  9, 2009
	dbora	Feb  9, 2009
	dbora_rac_10g	Feb  9, 2009
	dg_activate_standby_failover.ksh	Feb  1, 2009
	dg_activate_standby_failover_9i.ksh	Feb  1, 2009
	dg_rebuild_standby.ksh	Feb  1, 2009
	dg_refresh_standby_database.ksh	Feb  6, 2009
	dos2unix.pl	Feb  1, 2009
	dpump_backup_online_full.ksh	Feb  1, 2009
	export_backup_online_full.ksh	Feb  1, 2009
	get_public_ip_address	Feb  1, 2009
	ias10gr1_ctl	Feb  1, 2009
	invalid_objects	Feb  1, 2009
	iscsi-ls-map.ksh	Feb  1, 2009
	iscsi_client_services_solaris.ksh	Apr 14, 2009
	oem10g_ctl.ksh	Feb  1, 2009
	oraproducts	Feb  1, 2009
	purge_admin_files	Feb  1, 2009
	purge_archived_logs.ksh	Feb 24, 2009
	rac_crs_stat	Sep 18, 2009
	rman_backup_online_full.ksh	Jul 11, 2009
	switch_log_file.ksh	Feb  1, 2009
	top15	Feb  1, 2009
	vmware_vm_tape_backup.ksh	Mar 26, 2009

WINDOWS Shell Scripts
Output	Script Name	Last Update Date
	Template.js	Feb  1, 2009
	Template.vbs	Feb  1, 2009
	dpump_backup_online_full.bat	Feb  1, 2009
	export_backup_online_full.bat	Feb  1, 2009
	oracle_ADO_example.vbs	Feb  1, 2009
	rman_backup_hot_full_9i.bat	Feb  1, 2009
	rman_copy_purge_backupset_9i.bat	Feb  1, 2009
	sp_purge_n_days.vbs	Feb  1, 2009

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