GitHub - sonnguyen-dba/Oracle-Database-Scripts: My Oracle DB Scripts

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 316 Commits
ASM		ASM
Admin_General		Admin_General
BackupAndRecovery		BackupAndRecovery
DataPump		DataPump
Exadata		Exadata
GoldenGate		GoldenGate
PerformanceTuning_Mgmt		PerformanceTuning_Mgmt
RAC		RAC
Standby		Standby
Tools_And_Monitoring		Tools_And_Monitoring
+plusenv.sql		+plusenv.sql
+simplecool.sql		+simplecool.sql
Bigtable_fortest.sql		Bigtable_fortest.sql
Fat200objects.sql		Fat200objects.sql
Nonindexedfkconstraints.sql		Nonindexedfkconstraints.sql
OFE_12.1.0.2_in_12.2.0.1.sql		OFE_12.1.0.2_in_12.2.0.1.sql
Oracle_Test1.sql		Oracle_Test1.sql
PXHCDR.sql		PXHCDR.sql
STA_SQLID_Cursor.sql		STA_SQLID_Cursor.sql
activesessions_ash.sql		activesessions_ash.sql
all_stalestats.sql		all_stalestats.sql
archive.sql		archive.sql
archive_new.sql		archive_new.sql
ash_cachebufferchain.sql		ash_cachebufferchain.sql
ash_event_trend.sql		ash_event_trend.sql
ash_last_x_mins.sql		ash_last_x_mins.sql
ash_last_x_secs.sql		ash_last_x_secs.sql
ash_latch.sql		ash_latch.sql
ash_object_enq_contention.sql		ash_object_enq_contention.sql
ash_pio_events.sql		ash_pio_events.sql
ash_sid.sql		ash_sid.sql
ash_sqlid_mins.sql		ash_sqlid_mins.sql
ash_top_events.sql		ash_top_events.sql
ash_toppga_2mb.sql		ash_toppga_2mb.sql
asm_diskdrop.sql		asm_diskdrop.sql
asmdiskgroup.sql		asmdiskgroup.sql
asmfilevolinfo.sql		asmfilevolinfo.sql
asmspaceused.sql		asmspaceused.sql
autostatsgatherdet.sql		autostatsgatherdet.sql
awr_manualsnap.sql		awr_manualsnap.sql
awr_modify_topnsql.sql		awr_modify_topnsql.sql
awretention.sql		awretention.sql
bindvariables_fromawr.sql		bindvariables_fromawr.sql
blocking_local.com		blocking_local.com
check_dataguard_config.sql		check_dataguard_config.sql
check_modify_awrretention.sql		check_modify_awrretention.sql
coe_xfr_sql_profile.sql		coe_xfr_sql_profile.sql
columns_usage.sql		columns_usage.sql
cpu_stats.sql		cpu_stats.sql
cpubusytime_db.sql		cpubusytime_db.sql
cpuusage.sql		cpuusage.sql
create_schedule_job.sql		create_schedule_job.sql
create_sql_patch.sql		create_sql_patch.sql
current_redologfile_usage.sql		current_redologfile_usage.sql
cursor_notsharing_reason.sql		cursor_notsharing_reason.sql
datampump_monitoring.sql		datampump_monitoring.sql
datapump_10046trace_process.sql		datapump_10046trace_process.sql
datapump_cleanup_orphanedjobs.sql		datapump_cleanup_orphanedjobs.sql
datapump_samplescript.sh		datapump_samplescript.sh
db_hang.sql		db_hang.sql
dba_hist_snapshot.sql		dba_hist_snapshot.sql
dba_hist_sqlbind.sql		dba_hist_sqlbind.sql
dba_schedulerjobs.sql		dba_schedulerjobs.sql
dbgrowth_permonth.sql		dbgrowth_permonth.sql
dblink_details.sql		dblink_details.sql
dbms_jobs_broken.sql		dbms_jobs_broken.sql
dbserverdetails.sql		dbserverdetails.sql
dbtime.sql		dbtime.sql
dbupgdiag.sql		dbupgdiag.sql
ddl-objects.sql		ddl-objects.sql
ddl_schema.sql		ddl_schema.sql
disable_resourcemanager.sql		disable_resourcemanager.sql
dop_tablesindexes.sql		dop_tablesindexes.sql
drop_phv_baseline.sql		drop_phv_baseline.sql
drop_sql_baseline.sql		drop_sql_baseline.sql
drop_sql_profile.sql		drop_sql_profile.sql
drop_sqlplan_baselines.sql		drop_sqlplan_baselines.sql
dynamic_sampling_objects.sql		dynamic_sampling_objects.sql
enq_tx_indexcontention_split.sql		enq_tx_indexcontention_split.sql
exadata_cellperf.sql		exadata_cellperf.sql
failover_stats.sql		failover_stats.sql
file_block.sql		file_block.sql
file_border.sql		file_border.sql
find_objects.sql		find_objects.sql
find_objects_1.sql		find_objects_1.sql
find_objects_2.sql		find_objects_2.sql
find_sql.sql		find_sql.sql
find_sql_2.sql		find_sql_2.sql
find_sql_pio.sql		find_sql_pio.sql
find_sql_pio_1.sql		find_sql_pio_1.sql
find_x$_basetables.sql		find_x$_basetables.sql
fklocking.sql		fklocking.sql
flashback_main.sql		flashback_main.sql
flushsql_cursor.sql		flushsql_cursor.sql
gather_stats.sql		gather_stats.sql
generate_set_tablestats.sql		generate_set_tablestats.sql
get_dependent_ddl.sql		get_dependent_ddl.sql
get_optimizer_trace.sql		get_optimizer_trace.sql
getbinds-sqlid.sql		getbinds-sqlid.sql
goldengate_healthcheck.sql		goldengate_healthcheck.sql

Repository files navigation

select
samp.dbid,
fu.name,
samp.version,
detected_usages,
total_samples,
decode(to_char(last_usage_date, 'MM/DD/YYYY, HH:MI:SS'),
NULL, 'FALSE',
to_char(last_sample_date, 'MM/DD/YYYY, HH:MI:SS'), 'TRUE',
'FALSE')
currently_used,
first_usage_date,
last_usage_date,
aux_count,
feature_info,
last_sample_date,
last_sample_period,
sample_interval,
mt.description
from
wri$_dbu_usage_sample samp,
wri$_dbu_feature_usage fu,
wri$_dbu_feature_metadata mt
where
samp.dbid = fu.dbid and
samp.version = fu.version and
fu.name = mt.name and
fu.name not like '_DBFUS_TEST%' and /* filter out test features */
bitand(mt.usg_det_method, 4) != 4 /* filter out disabled features */;