GitHub - weejar/oracle-scripts: oracle sql and shell scripts

Latest commit

History

Folders and files

Name		Name	Last commit message	Last commit date
OracleLogVisualizer.7z		OracleLogVisualizer.7z
OracleLogVisualizer.jar		OracleLogVisualizer.jar
README.md		README.md
USER_ROLE_PRIVS.sql		USER_ROLE_PRIVS.sql
aas.sql		aas.sql
alert_log_clear.sh		alert_log_clear.sh
alert_log_clear_12.sh		alert_log_clear_12.sh
archivelog_clear v1.5.sh		archivelog_clear v1.5.sh
ase.sql		ase.sql
ase_cdb.sql		ase_cdb.sql
audit_trace_clear.sh		audit_trace_clear.sh
awr_redo_size_history.sql		awr_redo_size_history.sql
clear_dtx.sql		clear_dtx.sql
clear_empty_partition.sql		clear_empty_partition.sql
clear_slab_cache.sh		clear_slab_cache.sh
compress_feo.sql		compress_feo.sql
delete_archivelog.sh		delete_archivelog.sh
dg_gap.sql		dg_gap.sql
diag_ash.sql		diag_ash.sql
diffstat.sql		diffstat.sql
disable_11gR2_problem_features_topublic.txt		disable_11gR2_problem_features_topublic.txt
disable_12C_problem_features_topublic.txt		disable_12C_problem_features_topublic.txt
disable_19C_problem_features_topublic.txt		disable_19C_problem_features_topublic.txt
disable_21C_problem_features_topublic.txt		disable_21C_problem_features_topublic.txt
find_lob.sql.txt		find_lob.sql.txt
fix_control.sql		fix_control.sql
format_callstack.txt		format_callstack.txt
fsfi.sql		fsfi.sql
gen_many_awr.sql		gen_many_awr.sql
gts.sql		gts.sql
iops.sql		iops.sql
is_number.sql		is_number.sql
kill_tx_blocker_session.sh		kill_tx_blocker_session.sh
kill_tx_blocker_session.sql		kill_tx_blocker_session.sql
list all user privs.sql		list all user privs.sql
lsnr_log_clear.sh		lsnr_log_clear.sh
memory_fragment.sh		memory_fragment.sh
move_empty_partition.sql		move_empty_partition.sql
no_shared.sql		no_shared.sql
nonshared.sql		nonshared.sql
odbhc_V5.4.sql		odbhc_V5.4.sql
odbhc_V5.5.sql		odbhc_V5.5.sql
pd_test.sql		pd_test.sql
pdb_aas.sql		pdb_aas.sql
rebuild_inv_index.sql		rebuild_inv_index.sql
release_tbs.sql		release_tbs.sql
rhel_to_centos_yum.txt		rhel_to_centos_yum.txt
rman_backup_lv0.sh		rman_backup_lv0.sh
rman_backup_lv1.sh		rman_backup_lv1.sh
rman_backup_windows.bat		rman_backup_windows.bat
session_rpt.sql		session_rpt.sql
showplan.sql		showplan.sql
speed_up_create_index.sql		speed_up_create_index.sql
sql_hist.sql		sql_hist.sql
sql_monitor_rpt.sql		sql_monitor_rpt.sql
sqlhc.sql		sqlhc.sql
sqlhistory.txt		sqlhistory.txt
tablespace_del.sql		tablespace_del.sql
temp_rpt.sql		temp_rpt.sql
undo_diag.sql		undo_diag.sql
undo_stats.sql		undo_stats.sql
wait_chains.sql		wait_chains.sql
wm_concat.sql		wm_concat.sql

Repository files navigation

author: weizhao zhang

blog: www.anbob.com

desc: ORACLE database scripts

运维ORACLE数据库常用的工具

如

ase.sql 查看活动会话

diable_xxx_feature 建议禁用某版本的参数

xxx_clear 多种日志清理

About

oracle sql and shell scripts

Resources

Readme

Activity

Stars

6 stars

Watchers

1 watching

Forks

1 fork

Report repository

Navigation Menu

Latest commit

History

Folders and files

Repository files navigation

About

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors

Languages