mardi 15 mars 2016

Oracle Full Dba Scripts

http://www.high-oracle.com/scripts/

Script: dba_directories.sql
Script: dba_controlfile_records.sql
Script: dba_blocks_used_by_table.sql
Script: dba_cr_init.sql
Script: dba_compare_schemas.sql
Script: dba_column_constraints.sql
Script: dba_controlfiles.sql
Script: dba_db_growth.sql
Script: awr_snapshots_dbtime.sql
Script: dba_errors.sql
Script: dba_file_space_usage.sql
Script: dba_file_space_usage_7.sql
Script: dba_file_use.sql
Script: dba_file_use_7.sql
Script: dba_files.sql
Script: dba_files_all.sql
Script: dba_free_space_frag.sql
Script: dba_highwater_mark.sql
Script: dba_index_fragmentation.sql
Script: dba_index_schema_fragmentation_report.sql
Script: dba_index_stats.sql
Script: dba_invalid_objects.sql
Script: dba_invalid_objects_summary.sql
Script: dba_jobs.sql
Script: dba_object_cache.sql
Script: dba_object_search.sql
Script: dba_object_summary.sql
Script: dba_options.sql
Script: dba_owner_to_tablespace.sql
Script: dba_plsql_package_size.sql
Script: dba_query_hidden_parameters.sql
Script: dba_random_number.sql
Script: dba_rebuild_indexes.sql
Script: dba_recompile_invalid_objects.sql
Script: dba_registry.sql
Script: dba_related_child_tables.sql
Script: dba_row_size.sql
Script: dba_segment_summary.sql
Script: dba_snapshot_database_8i.sql
Script: dba_snapshot_database_9i.sql
Script:
dba_snapshot_database_10g.sql
Script:
dba_table_info.sql
Script:
dba_tables_all.sql
Script:
dba_tables_current_user.sql
Script:
dba_tables_query_user.sql
Script:
dba_tablespace_mapper.sql
Script:
dba_tablespace_to_owner.sql
Script:
dba_tablespaces.sql
Script:
dba_tablespaces_7.sql
Script:
dba_tablespaces_8i.sql
Script:
dba_top_segments.sql
Script:
dpump_jobs.sql
Script:
dpump_progress.sql
Script:
dpump_sessions.sql
Script:
erp_conc_manager_job_status.sql
Script:
erp_conc_manager_job_status2.sql
Script:
erp_conc_manager_user_query.sql
Script:
example_create_clob.sql
Script:
example_create_dimension.sql
Script:
example_create_emp_dept_custom.sql
Script:
example_create_emp_dept_original.sql
Script:
example_create_index.sql
Script:
example_create_index_organized_table.sql
Script:
example_create_materialized_view.sql
Script:
example_create_not_null_constraints.sql
Script:
example_create_primary_foreign_key.sql
Script:
example_create_profile_password_parameters.sql
Script:
example_create_profile_resource_parameters.sql
Script:
example_create_resource_plan_multi_resource_plan_9i.sql
Script:
example_create_sequence.sql
Script:
example_create_table.sql
Script:
example_create_table_buffer_pools.sql
Script:
example_create_tablespace.sql
Script:
example_create_temporary_tables.sql
Script:
example_create_user_tables.sql
Script:
example_database_resource_manager_setup.sql
Script:
example_drop_unused_column.sql
Script:
example_lob_demonstration.sql
Script:
example_move_table.sql
Script:
example_partition_range_date_oracle_8.sql
Script:
example_partition_range_number_oracle_8.sql
Script:
example_transport_tablespace.sql
Script:
fdb_log_files.sql
Script:
fdb_redo_time_matrix.sql
Script:
fdb_status.sql
Script:
fra_alerts.sql
Script:
fra_files.sql
Script:
fra_status.sql
Script:
help.sql
Script:
lob_dump_blob.sql
Script:
lob_dump_clob.sql
Script:
lob_dump_nclob.sql
Script:
lob_fragmentation_user.sql
Script:
locks_blocking.sql
Script:
locks_blocking2.sql
Script:
locks_dml_ddl.sql
Script:
locks_dml_lock_time.sql
Script:
mts_dispatcher_status.sql
Script:
mts_dispatcher_utilization.sql
Script:
mts_queue_information.sql
Script:
mts_shared_server_statistics.sql
Script:
mts_shared_server_utilization.sql
Script:
mts_user_connections.sql
Script:
owi_event_names.sql
Script:
perf_db_block_buffer_usage.sql
Script:
perf_explain_plan.sql
Script:
perf_file_io.sql
Script:
perf_file_io_7.sql
Script:
perf_file_io_efficiency.sql
Script:
perf_file_waits.sql
Script:
perf_hit_ratio_by_session.sql
Script:
perf_hit_ratio_system.sql
Script:
perf_log_switch_history_bytes_daily_all.sql
Script:
perf_log_switch_history_count_daily.sql
Script:
perf_log_switch_history_count_daily_7.sql
Script:
perf_log_switch_history_count_daily_all.sql
Script:
perf_lru_latch_contention.sql
Script:
perf_objects_without_statistics.sql
Script:
perf_performance_snapshot.sql
Script:
perf_redo_log_contention.sql
Script:
perf_sga_free_pool.sql
Script:
perf_sga_usage.sql
Script:
perf_shared_pool_memory.sql
Script:
perf_top_10_procedures.sql
Script:
perf_top_10_tables.sql
Script:
perf_top_sql_by_buffer_gets.sql
Script:
perf_top_sql_by_disk_reads.sql
Script:
plsql_random_numbers.sql
Script:
plsql_webdba_utl_pkg.sql
Script:
rac_instances.sql
Script:
rc_databases.sql
Script:
rman_backup_pieces.sql
Script:
rman_backup_sets.sql
Script:
rman_backup_sets_8i.sql
Script:
rman_configuration.sql
Script:
rman_controlfiles.sql
Script:
rman_progress.sql
Script:
rman_spfiles.sql
Script:
rollback_segments.sql
Script:
rollback_users.sql
Script:
rsrc_plan_status_detail.sql
Script:
rsrc_plan_status_summary.sql
Script:
sec_default_passwords.sql
Script:
sec_users.sql
Script:
sess_current_user_transactions.sql
Script:
sec_roles.sql
Script:
sess_query_sql.sql
Script:
sess_uncommited_transactions.sql
Script:
sess_user_sessions.sql
Script:
sess_user_stats.sql
Script:
sess_user_trace_file_location.sql
Script:
sess_users.sql
Script:
sess_users_8i.sql
Script:
sess_users_active.sql
Script:
sess_users_active_8i.sql
Script:
sess_users_active_sql.sql
Script:
sess_users_by_cpu.sql
Script:
sess_users_by_cursors.sql
Script:
sess_users_by_io.sql
Script:
sess_users_by_memory.sql
Script:
sess_users_by_transactions.sql
Script:
sess_waiting.sql
Script:
sess_waiting_8i.sql
Script:
sp_auto.sql
Script:
sp_auto_5.sql
Script:
sp_auto_15.sql
Script:
sp_auto_30.sql
Script:
sp_list.sql
Script:
sp_parameters.sql
Script:
sp_purge.sql
Script:
sp_purge_30_days_9i.sql
Script:
sp_purge_30_days_10g.sql
Script:
sp_purge_n_days_9i.sql
Script:
sp_purge_n_days_10g.sql
Script:
sp_snap.sql
Script: sp_statspack_custom_pkg_9i.sql
Script: sp_statspack_custom_pkg_10g.sql
Script: sp_trunc.sql
Script: temp_sort_segment.sql
Script: temp_sort_users.sql
Script: temp_status.sql
Script: undo_contention.sql
Script: undo_segments.sql
Script: undo_users.sql
Script: wm_create_workspace.sql
Script: wm_disable_versioning.sql
Script: wm_enable_versioning.sql
Script: wm_freeze_workspace.sql
Script: wm_get_workspace.sql
Script:
wm_goto_workspace.sql
Script:
wm_merge_workspace.sql
Script:
wm_refresh_workspace.sql
Script:
wm_remove_workspace.sql
Script:
wm_rollback_workspace.sql
Script:
wm_workspaces.sql
Script:
asm_alias.sql
Script:
asm_clients.sql
Script:
asm_diskgroups.sql
Script:
asm_disks.sql
Script:
asm_disks_perf.sql
Script:
asm_drop_files.sql
Script:
asm_files.sql
Script:
asm_files_10g.sql
Script:
asm_files2.sql
Script:
asm_templates.sql
Script:
asmm_components.sql
Script:
awr_snapshots_dbtime_xls.sql
Script:
example_create_clob_8.sql
Script:
wm_unfreeze_workspace.sql

Oracle Database Error Messages

 

 

 

Top Oracle Database Error Messages

 

Oracle Database Error Messages

 

 

 

 

0 commentaires:

Enregistrer un commentaire

Nombre total de pages vues