Project Title

This is a repository of commonly used Oracle scripts.

Prerequisites

In order to run the SQL files, you need to have an Oracle database.

SQL> @<sql_file>

SQL> @tab_desc.sql
SQL> @rebuild_indexes.sql

Name		Name	Last commit message	Last commit date
Latest commit History 48 Commits
README.md		README.md
active_rollback.sql		active_rollback.sql
ascii.sql		ascii.sql
client_info.sql		client_info.sql
db_buffer_hr.sql		db_buffer_hr.sql
db_cache_advice.sql		db_cache_advice.sql
db_report.sql		db_report.sql
dbfile_seqread.sql		dbfile_seqread.sql
dbfile_seqread_object.sql		dbfile_seqread_object.sql
dbv_list.sql		dbv_list.sql
ddl_extract.sql		ddl_extract.sql
dump_env.sql		dump_env.sql
kill_oracle.sh		kill_oracle.sh
last5.sql		last5.sql
litersql.sql		litersql.sql
log_switches.sql		log_switches.sql
maxshrink.sql		maxshrink.sql
monitor_cursors.sql		monitor_cursors.sql
need_to_pin.sql		need_to_pin.sql
oracle_connection.sh		oracle_connection.sh
pga_cache_advice.sql		pga_cache_advice.sql
proc_datafiles.sql		proc_datafiles.sql
proc_extents.sql		proc_extents.sql
proc_free_bytes.sql		proc_free_bytes.sql
proc_last_change.sql		proc_last_change.sql
proc_open_cursors.sql		proc_open_cursors.sql
proc_sessions.sql		proc_sessions.sql
proc_show_events.sql		proc_show_events.sql
proc_table_pk.sql		proc_table_pk.sql
proc_update_mail.sql		proc_update_mail.sql
rebuild_indexes.sql		rebuild_indexes.sql
redo_log_switches.sql		redo_log_switches.sql
rollback_extensions.sql		rollback_extensions.sql
search_long.sql		search_long.sql
show_events.sql		show_events.sql
tab_desc.sql		tab_desc.sql
tableinfo.sql		tableinfo.sql
test_table.sql		test_table.sql
tp_stats.sql		tp_stats.sql
unix_process.sql		unix_process.sql
user_privs.sql		user_privs.sql