toolbox

collection of sql and shell scripts that I use as an Oracle DBA Some of these scripts are written by me, others come (as is or modified) from other DBA's

Name		Name	Last commit message	Last commit date
Latest commit History 192 Commits
.gitattributes		.gitattributes
Edit.000		Edit.000
Edit.001		Edit.001
Edit.002		Edit.002
Edit.003		Edit.003
Edit.004		Edit.004
Edit.005		Edit.005
README.md		README.md
RecreateUsers.sql		RecreateUsers.sql
SimpleHTTPServerWithUpload.py		SimpleHTTPServerWithUpload.py
activity_monitor.sql		activity_monitor.sql
add_exadata_vmdisk.sh		add_exadata_vmdisk.sh
add_job_statistics.sql		add_job_statistics.sql
add_lun_online.sh		add_lun_online.sh
adrci_cleanup.sh		adrci_cleanup.sh
after_servererror_trigger.sql		after_servererror_trigger.sql
all_db_links.sql		all_db_links.sql
all_granted_roles.sql		all_granted_roles.sql
arch_redo_size_on_disk.sql		arch_redo_size_on_disk.sql
archived_redo_stats.sql		archived_redo_stats.sql
as.sql		as.sql
ash_queries_wip.sql		ash_queries_wip.sql
ash_query_freq.sql		ash_query_freq.sql
asm_diskgroup_info.sql		asm_diskgroup_info.sql
asm_operations.sql		asm_operations.sql
asm_queries.sql		asm_queries.sql
asmiostat.scriptje		asmiostat.scriptje
asmiostat.zip		asmiostat.zip
avg_archived_size.sql		avg_archived_size.sql
avgskew.sql		avgskew.sql
awr_io_load_history.sql		awr_io_load_history.sql
awr_load_history.sql		awr_load_history.sql
awr_long_queries.sql		awr_long_queries.sql
base_backup_sizes_per_pool1.sql		base_backup_sizes_per_pool1.sql
base_backup_sizes_per_pool2.sql		base_backup_sizes_per_pool2.sql
base_crea_db_role_privs_diff.sql		base_crea_db_role_privs_diff.sql
base_no_db_link_priv.sql		base_no_db_link_priv.sql
batch_start_dbconsole.sh		batch_start_dbconsole.sh
big_table_read_perf.sql		big_table_read_perf.sql
blocked_sessions.sql		blocked_sessions.sql
blocked_sessions2.sql		blocked_sessions2.sql
bloom_join2.sql		bloom_join2.sql
calculate_total_size.sql		calculate_total_size.sql
calibrate_io.sql		calibrate_io.sql
cbo_last_analyzed_stats.sql		cbo_last_analyzed_stats.sql
cdc_healthcheck.sql		cdc_healthcheck.sql
change_pctincrease.sql		change_pctincrease.sql
check_nd_constraints.sql		check_nd_constraints.sql
check_px.sql		check_px.sql
client_tracing_parameters		client_tracing_parameters
client_tracing_parameters.txt		client_tracing_parameters.txt
cnt_proc_per_user.sh		cnt_proc_per_user.sh
cols_as_rows.sql		cols_as_rows.sql
comp_ratio.sql		comp_ratio.sql
compare_schema.sql		compare_schema.sql
constraint_info.sql		constraint_info.sql
cpu_table.sh		cpu_table.sh
create_display_raw.sql		create_display_raw.sql
create_sql_profile.sql		create_sql_profile.sql
create_tablespaces.sql		create_tablespaces.sql
create_user.sql		create_user.sql
db_cache_advice.sql		db_cache_advice.sql
db_info.sql		db_info.sql
db_info2.sql		db_info2.sql
db_report.sql		db_report.sql
db_size.sql		db_size.sql
db_size2.sql		db_size2.sql
dba_tables.sql		dba_tables.sql
df_details.sql		df_details.sql
df_details2.sql		df_details2.sql
df_details_pre_9.sql		df_details_pre_9.sql
df_high_water_mark.sql		df_high_water_mark.sql
dg_archivelog_status.sql		dg_archivelog_status.sql
dg_archives.sql		dg_archives.sql
dg_attributes.sql		dg_attributes.sql
dg_lsby_diag.sql		dg_lsby_diag.sql
dg_phy_stby_diag.sql		dg_phy_stby_diag.sql
dg_prim_diag.sql		dg_prim_diag.sql
display_raw.sql		display_raw.sql
dnfs_mounts.sql		dnfs_mounts.sql
dp_disable_tracing.sql		dp_disable_tracing.sql
dp_enable_tracing.sql		dp_enable_tracing.sql
dp_list_sessions.sql		dp_list_sessions.sql
dplan.sql		dplan.sql
dump_block.sql		dump_block.sql
dynamic_plan_query.sql		dynamic_plan_query.sql
dynamic_plan_table.sql		dynamic_plan_table.sql
enable_trace_in_other_session.sql		enable_trace_in_other_session.sql
enqwaits.sql		enqwaits.sql
esfc_hit_ratio.sql		esfc_hit_ratio.sql
esfc_keep_tables.sql		esfc_keep_tables.sql
estimate_compression_ratio.sql		estimate_compression_ratio.sql
expiring_accounts.sql		expiring_accounts.sql
expiring_passwords.sql		expiring_passwords.sql
extmap.sql		extmap.sql
filestat.sql		filestat.sql
find_trace.sql		find_trace.sql
findilos.sh		findilos.sh
flashback_space_usage.sql		flashback_space_usage.sql
flashback_space_usage2.sql		flashback_space_usage2.sql

dhoogfr/toolbox

Folders and files

Latest commit

History