Automatic Shared Memory Management	Automatic Storage Management	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	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,672,992 bytes Last Updated on: Aug  5, 2008 common.zip Size: 9,915,094 bytes Last Updated on: Aug  5, 2008

Automatic Shared Memory Management
Output	Script Name	Last Update Date
	asmm_components.sql	Jan 10, 2008

Automatic Storage Management
Output	Script Name	Last Update Date
	asm_alias.sql	Jan 10, 2008
	asm_clients.sql	Jan 10, 2008
	asm_diskgroups.sql	Jan 10, 2008
	asm_disks.sql	Jan 10, 2008
	asm_disks_perf.sql	Jan 10, 2008
	asm_drop_files.sql	Jan 10, 2008
	asm_files.sql	Jan 10, 2008
	asm_files2.sql	Jan 10, 2008
	asm_templates.sql	Jan 10, 2008

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

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

Database Resource Manager
Output	Script Name	Last Update Date
	rsrc_plan_status_detail_9i.sql	Jan 10, 2008
	rsrc_plan_status_summary_9i.sql	Jan 10, 2008

Demonstrations
Output	Script Name	Last Update Date
	example_database_resource_manager_setup.sql	Jan 10, 2008
	example_drop_unused_column.sql	Jan 10, 2008
	example_lob_demonstration.sql	Jan 10, 2008
	example_move_table.sql	Jan 10, 2008
	example_partition_range_date_oracle_8.sql	Jan 10, 2008
	example_partition_range_number_oracle_8.sql	Jan 10, 2008
	example_transport_tablespace.sql	Jan 10, 2008

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	Jan 10, 2008
	fra_files.sql	Jan 10, 2008
	fra_status.sql	Jan 10, 2008

Flashback Database
Output	Script Name	Last Update Date
	fdb_log_files.sql	Jan 10, 2008
	fdb_redo_time_matrix.sql	Jan 10, 2008
	fdb_status.sql	Jan 10, 2008

LOBs
Output	Script Name	Last Update Date
	lob_dump_blob.sql	Jan 10, 2008
	lob_dump_clob.sql	Jan 10, 2008
	lob_dump_nclob.sql	Jan 10, 2008

Locks
Output	Script Name	Last Update Date
	locks_blocking.sql	Jan 10, 2008
	locks_dml_ddl.sql	Jan 10, 2008
	locks_dml_lock_time.sql	Apr 24, 2008

Multi Threaded Server
Output	Script Name	Last Update Date
	mts_dispatcher_status.sql	Jan 10, 2008
	mts_dispatcher_utilization.sql	Jan 10, 2008
	mts_queue_information.sql	Jan 10, 2008
	mts_shared_server_statistics.sql	Jan 10, 2008
	mts_shared_server_utilization.sql	Jan 10, 2008
	mts_user_connections.sql	Jan 10, 2008

Oracle Applications
Output	Script Name	Last Update Date
	erp_conc_manager_user_query.sql	Jan 10, 2008

Oracle Wait Interface
Output	Script Name	Last Update Date
	owi_event_names.sql	Jan 10, 2008

PL/SQL Examples
Output	Script Name	Last Update Date
	plsql_random_numbers.sql	Jan 10, 2008
	plsql_webdba_utl_pkg.sql	Jan 10, 2008

RMAN
Output	Script Name	Last Update Date
	rman_backup_pieces.sql	Jan 10, 2008
	rman_backup_sets.sql	Jan 10, 2008
	rman_backup_sets_8i.sql	Jan 10, 2008
	rman_configuration.sql	Jan 10, 2008
	rman_configuration_clear_all_9i.rcv	Jan 10, 2008
	rman_configuration_setup_9i.rcv	Jan 10, 2008
	rman_controlfiles.sql	Jan 10, 2008
	rman_spfiles.sql	Jan 10, 2008

Real Application Clusters
Output	Script Name	Last Update Date
	rac_instances.sql	Jan 10, 2008
	rac_locks_blocking.sql	Jan 10, 2008
	rac_rollback_segments.sql	Jan 10, 2008
	rac_rollback_users.sql	Jan 10, 2008
	rac_sess_users.sql	Jan 10, 2008
	rac_sess_users_active.sql	Jan 10, 2008
	rac_sess_users_sql.sql	Jan 10, 2008
	rac_waiting_sessions.sql	Jan 10, 2008

Rollback Segments
Output	Script Name	Last Update Date
	rollback_contention.sql	Jan 10, 2008
	rollback_segments.sql	Jan 10, 2008
	rollback_users.sql	Jan 10, 2008

Security
Output	Script Name	Last Update Date
	sec_default_passwords.sql	Jan 10, 2008
	sec_roles.sql	Jan 10, 2008
	sec_users.sql	Jan 10, 2008

Session Management
Output	Script Name	Last Update Date
	sess_current_user_transactions.sql	Jan 10, 2008
	sess_query_sql.sql	Jan 10, 2008
	sess_uncommited_transactions.sql	Jan 10, 2008
	sess_user_sessions.sql	Jan 10, 2008
	sess_user_stats.sql	Jan 10, 2008
	sess_user_trace_file_location.sql	Jan 10, 2008
	sess_users.sql	Jan 10, 2008
	sess_users_active.sql	Jan 10, 2008
	sess_users_active_sql.sql	Jan 10, 2008
	sess_users_by_cpu.sql	Jan 10, 2008
	sess_users_by_cursors.sql	Jan 10, 2008
	sess_users_by_io.sql	Jan 10, 2008
	sess_users_by_memory.sql	Jan 10, 2008
	sess_users_by_transactions.sql	Jan 10, 2008