GitHub - oracle-suburb/Oracle-Database-Scripts: My Oracle DB Scripts

Branches Tags

Name	Name	Last commit message	Last commit date
Latest commit History 296 Commits 296 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 */;