DBA Scripts

access.sql

active_sessions.sql

active_user_sessions.sql

cache_hit_ratio.sql

call_stack.sql

code_dep.sql

code_dep_distinct.sql

code_dep_on.sql

code_dep_tree.sql

column_defaults.sql

controlfiles.sql

datafiles.sql

db_cache_advice.sql

db_info.sql

db_links.sql

db_links_open.sql

db_properties.sql

default_tablespaces.sql

df_free_space.sql

directories.sql

directory_permissions.sql

directory_permissions_all.sql

dispatchers.sql

error_stack.sql

errors.sql

explain.sql

file_io.sql

find_packaged_proc.sql

fk_columns.sql

fks.sql

free_space.sql

health.sql

hidden_parameters.sql

high_water_mark.sql

hot_blocks.sql

identify_trace_file.sql

index_extents.sql

index_monitoring_status.sql

index_partitions.sql

index_usage.sql

invalid_objects.sql

jobs.sql

jobs_running.sql

large_lob_segments.sql

large_segments.sql

latch_hit_ratios.sql

latch_holders.sql

latches.sql

library_cache.sql

license.sql

locked_objects.sql

locked_objects_internal.sql

logfiles.sql

longops.sql

lru_latch_ratio.sql

max_extents.sql

min_datafile_size.sql

monitor.sql

monitor_memory.sql

monitoring_status.sql

my_roles.sql

nls_params.sql

non_indexed_fks.sql

obj_lock.sql

object_privs.sql

object_status.sql

objects.sql

open_cursors.sql

open_cursors_by_sid.sql

open_cursors_full_by_sid.sql

options.sql

packaged_procs.sql

param_valid_values.sql

parameter_diffs.sql

parameters.sql

parameters_non_default.sql

part_tables.sql

patch_registry.sql

pga_target_advice.sql

pipes.sql

profiler_run_details.sql

profiler_runs.sql

profiles.sql

proxy_sessions.sql

proxy_users.sql

rbs_extents.sql

rbs_stats.sql

recovery_status.sql

recyclebin.sql

redo_by_day.sql

redo_by_hour.sql

redo_by_min.sql

registry_history.sql

role_privs.sql

roles.sql

search_source.sql

segment_size.sql

segment_stats.sql

segments_in_ts.sql

session_events.sql

session_events_by_sid.sql

session_events_by_spid.sql

session_io.sql

session_pga.sql

session_rollback.sql

session_stats.sql

session_stats_by_sid.sql

session_undo.sql

session_waits.sql

sessions.sql

sessions_by_machine.sql

sessions_by_osuser.sql

sessions_by_sid.sql

show_indexes.sql

show_space.sql

show_tables.sql

source.sql

spfile_parameters.sql

sql_area.sql

sql_text.sql

sql_text_by_sid.sql

statistics_prefs.sql

synonyms_to_missing_objects.sql

system_events.sql

system_parameters.sql

system_privs.sql

system_stats.sql

table_dep.sql

table_extents.sql

table_growth.sql

table_indexes.sql

table_partitions.sql

table_stats.sql

table_triggers.sql

tables_with_locked_stats.sql

tables_with_zero_rows.sql

tablespaces.sql

temp_extent_map.sql

temp_free_space.sql

temp_io.sql

temp_segments.sql

temp_usage.sql

tempfiles.sql

tempseg_usage.sql

top_latches.sql

top_sessions.sql

top_sql.sql

trace_run_details.sql

trace_runs.sql

ts_datafiles.sql

ts_extent_map.sql

ts_free_space.sql

ts_full.sql

ts_thresholds.sql

ts_thresholds_reset.sql

ts_thresholds_set_default.sql

tuning.sql

undo_segments.sql

unusable_indexes.sql

unused_space.sql

user_hit_ratio.sql

user_objects.sql

user_roles.sql

user_sessions.sql

user_system_privs.sql

user_temp_space.sql

user_ts_quotas.sql

user_undo_space.sql

users.sql

users_with_role.sql

users_with_sys_priv.sql

active_session_waits.sql

ash.sql

datapump_jobs.sql

db_usage_hwm.sql

dynamic_memory.sql

event_histogram.sql

feature_usage.sql

flashback_db_info.sql

generate_multiple_awr_reports.sql

job_chain_rules.sql

job_chain_steps.sql

job_chains.sql

job_classes.sql

job_programs.sql

job_running_chains.sql

job_schedules.sql

jobs.sql

jobs_running.sql

lock_tree.sql

scheduler_attributes.sql

segment_advisor.sql

services.sql

session_waits.sql

sga_buffers.sql

sga_dynamic_components.sql

sga_dynamic_free_memory.sql

sga_resize_ops.sql

sysaux_occupants.sql

test_calendar_string.sql

window_groups.sql

windows.sql

admin_privs.sql

autotask_change_window_schedules.sql

autotask_job_history.sql

autotask_schedule.sql

database_block_corruption.sql

default_passwords.sql

diag_info.sql

extended_stats.sql

fda.sql

fda_tables.sql

fda_ts.sql

identify_trace_file.sql

job_credentials.sql

job_output_file.sql

job_run_details.sql

memory_dynamic_components.sql

memory_resize_ops.sql

memory_target_advice.sql

network_acl_privileges.sql

network_acl_privileges_by_host.sql

network_acls.sql

result_cache_objects.sql

result_cache_report.sql

result_cache_statistics.sql

result_cache_status.sql

session_fix.sql

statistics_global_prefs.sql

system_fix.sql

system_fix_count.sql

temp_free_space.sql

cdb_resource_plan_directives.sql

cdb_resource_plans.sql

cdb_resource_profile_directives.sql

clustering_dimensions.sql

clustering_joins.sql

clustering_keys.sql

clustering_tables.sql

credentials.sql

host_aces.sql

host_acls.sql

lockdown_profiles.sql

login.sql

pdb_spfiles.sql

pdbs.sql

plugin_violations.sql

priv_captures.sql

redaction_columns.sql

redaction_policies.sql

redaction_value_defaults.sql

services.sql

lockdown_rules.sql

max_pdb_snapshots.sql

pdb_snapshot_mode.sql

pdb_snapshots.sql

auto_index_config.sql

auto_indexes.sql

blockchain_tables.sql

certificates.sql

sql_macros.sql

disable_chk.sql

disable_fk.sql

disable_pk.sql

disable_ref_fk.sql

enable_chk.sql

enable_fk.sql

enable_pk.sql

enable_ref_fk.sql

analyze_all.sql

base64decode.sql

base64encode.sql

blob_to_clob.sql

blob_to_file.sql

clob_to_blob.sql

clob_to_file.sql

column_comments.sql

comments.sql

compile_all.sql

compile_all_bodies.sql

compile_all_funcs.sql

compile_all_procs.sql

compile_all_specs.sql

compile_all_trigs.sql

compile_all_views.sql

conversion_api.sql

csv.sql

date_api.sql

dict_comments.sql

digest_auth_api.sql

drop_all.sql

dsp.pkb

dsp.pks

err.pkb

err.pks

file_to_blob.sql

file_to_clob.sql

find_object.sql

ftp.pkb

ftp.pks

gen_health.sql

get_pivot.sql

get_stat.sql

login.sql

part_hv_to_date.sql

print_table.sql

proc_defs.sql

rebuild_index.sql

smart_quotes_api.sql

soap_api.sql

string_agg.sql

string_api.sql

switch_schema.sql

table_comments.sql

table_defs.sql

table_differences.sql

trc.pkb

trc.pks

ts_move_api.sql

locked_objects_rac.sql

longops_rac.sql

monitor_memory_rac.sql

session_undo_rac.sql

session_waits_rac.sql

sessions_rac.sql

active_plan.sql

consumer_group_usage.sql

consumer_groups.sql

plan_directives.sql

resource_plans.sql

backup.sql

build_api.sql

build_api2.sql

create_data.sql

db_link_ddl.sql

directory_ddl.sql

drop_cons_on_table.sql

drop_fks_on_table.sql

drop_fks_ref_table.sql

drop_indexes.sql

fks_on_table_ddl.sql

fks_ref_table_ddl.sql

index_monitoring_off.sql

index_monitoring_on.sql

job_ddl.sql

logon_as_user.sql

logon_as_user_orig.sql

monitoring_off.sql

monitoring_on.sql

network_acls_ddl.sql

object_grants.sql

profile_ddl.sql

rbs_structure.sql

recreate_table.sql

role_ddl.sql

sequence_ddl.sql

synonym_by_object_owner_ddl.sql

synonym_ddl.sql

synonym_public_remote_ddl.sql

table_constraints_ddl.sql

table_ddl.sql

table_grants_ddl.sql

table_indexes_ddl.sql

table_triggers_ddl.sql

tablespace_ddl.sql

tablespace_structure.sql

trigger_ddl.sql

user_ddl.sql

view_ddl.sql

grant_delete.sql

grant_execute.sql

grant_insert.sql

grant_select.sql

grant_update.sql

package_synonyms.sql

schema_write_access.sql

sequence_synonyms.sql

table_synonyms.sql

view_synonyms.sql

dba_ords_client_roles.sql

dba_ords_clients.sql

dba_ords_handler_content.sql

dba_ords_handlers.sql

dba_ords_modules.sql

dba_ords_objects.sql

dba_ords_privilege_mappings.sql

dba_ords_privilege_modules.sql

dba_ords_privilege_roles.sql

dba_ords_privileges.sql

dba_ords_roles.sql

dba_ords_schemas.sql

dba_ords_templates.sql

dba_ords_views.sql

user_ords_client_roles.sql

user_ords_clients.sql

user_ords_handler_content.sql

user_ords_handlers.sql

user_ords_modules.sql

user_ords_objects.sql

user_ords_privilege_mappings.sql

user_ords_privilege_modules.sql

user_ords_privilege_roles.sql

user_ords_privileges.sql

user_ords_roles.sql

user_ords_schemas.sql

user_ords_templates.sql

user_ords_views.sql

deploy_app.py.txt

deploy_app.sh

start-domain.sh

start-forms-reports.sh

start-node-manager.sh

stop-domain.sh

stop-forms-reports.sh

stop-node-manager.sh