OracleDailySQL

DBA handy SQL for checking Oracle Database Status

Name	Name	Last commit message	Last commit date
Latest commit History 17 Commits 17 Commits
RealTimeDiagnose	RealTimeDiagnose
2pc_clean.txt	2pc_clean.txt
DailySQLCollection	DailySQLCollection
HistIndexAccessUsage.sql	HistIndexAccessUsage.sql
LogFileSyncDiagnose	LogFileSyncDiagnose
LongSQLsFromSQLMonitor.txt	LongSQLsFromSQLMonitor.txt
OSWatcherReportAnalysis	OSWatcherReportAnalysis
README.md	README.md
ash_sql_line_id.txt	ash_sql_line_id.txt
ash_top_sql_event.txt	ash_top_sql_event.txt
ash_used.txt	ash_used.txt
awr_db_time.txt	awr_db_time.txt
awr_event_histogram.txt	awr_event_histogram.txt
awr_metric_name.txt	awr_metric_name.txt
bind_noused.txt	bind_noused.txt
cursor_purge.txt	cursor_purge.txt
ddl_metadata.txt	ddl_metadata.txt
dml_modification_count_get.txt	dml_modification_count_get.txt
fra_usage_get.txt	fra_usage_get.txt
param_get.txt	param_get.txt
real_time_sql_monitor	real_time_sql_monitor
redo_hist_switch_info.txt	redo_hist_switch_info.txt
segment_size.txt	segment_size.txt
session_for_sid.txt	session_for_sid.txt
session_for_spid.txt	session_for_spid.txt
session_kill.txt	session_kill.txt
shared_pool_free.txt	shared_pool_free.txt
sql_monitor.txt	sql_monitor.txt
sql_profile.txt	sql_profile.txt
sqlhis_awr.txt	sqlhis_awr.txt
sqlinfo_total.txt	sqlinfo_total.txt
tablespace_used.txt	tablespace_used.txt
tabstat.txt	tabstat.txt
temp_used.txt	temp_used.txt
transaction_get.txt	transaction_get.txt
undo_used.txt	undo_used.txt
wait_event.txt	wait_event.txt
wait_event_block.txt	wait_event_block.txt
wait_event_hash.txt	wait_event_hash.txt
wait_event_sqlid.txt	wait_event_sqlid.txt
wait_session_order_by_hash.txt	wait_session_order_by_hash.txt
wait_session_orderby_by_sqlid.txt	wait_session_orderby_by_sqlid.txt

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Repository files navigation

OracleDailySQL

About

Uh oh!

Releases

Packages

Search code, repositories, users, issues, pull requests...

duqiangatom/OracleDailySQL

Folders and files

Latest commit

History

Repository files navigation

OracleDailySQL

About

Resources

Uh oh!

Stars

Watchers

Forks

Releases

Packages 0

Packages