|

| DBA Scripts Archives | |||||||||||||||
|
|||||||||||||||
| Automatic Shared Memory Management | ||
| Output | Script Name | Last Update Date |
![]() |
asmm_components.sql | Jan 10, 2008 |
![]() |
| Automatic Storage Management | ||
| Output | Script Name | Last Update Date |
![]() |
asm_alias.sql | Jan 10, 2008 |
![]() |
asm_clients.sql | Jan 10, 2008 |
![]() |
asm_diskgroups.sql | Jan 10, 2008 |
![]() |
asm_disks.sql | Jan 10, 2008 |
![]() |
asm_disks_perf.sql | Jan 10, 2008 |
![]() |
asm_drop_files.sql | Jan 10, 2008 |
![]() |
asm_files.sql | Jan 10, 2008 |
![]() |
asm_files2.sql | Jan 10, 2008 |
![]() |
asm_templates.sql | Jan 10, 2008 |
![]() |
| Create Database Scripts | ||
| Output | Script Name | Last Update Date |
![]() |
Create Database - (Linux) | Dec 17, 2006 |
![]() |
Create Database - (Solaris) | Dec 17, 2006 |
![]() |
Create Database - (Windows) | Dec 17, 2006 |
![]() |
SQL*Net Configuration Files | Dec 17, 2006 |
![]() |
cr_init.sql | Jan 10, 2008 |
![]() |
| Create Object Examples | ||
| Output | Script Name | Last Update Date |
![]() |
cr_clob.sql | Jan 10, 2008 |
![]() |
cr_clob_8.sql | Jan 10, 2008 |
![]() |
cr_dimension.sql | Jan 10, 2008 |
![]() |
cr_index.sql | Jan 10, 2008 |
![]() |
cr_index_organized_table.sql | Jan 10, 2008 |
![]() |
cr_materialized_view.sql | Jan 10, 2008 |
![]() |
cr_not_null_constraints.sql | Jan 10, 2008 |
![]() |
cr_primary_foreign_key.sql | Jan 10, 2008 |
![]() |
cr_profile_password_parameters.sql | Jan 10, 2008 |
![]() |
cr_profile_resource_parameters.sql | Jan 10, 2008 |
![]() |
cr_resource_plan_multi_resource_plan_9i.sql | Jan 10, 2008 |
![]() |
cr_sequence.sql | Jan 10, 2008 |
![]() |
cr_table.sql | Jan 10, 2008 |
![]() |
cr_table_buffer_pools.sql | Jan 10, 2008 |
![]() |
cr_tablespace.sql | Jan 10, 2008 |
![]() |
cr_temporary_tables.sql | Jan 10, 2008 |
![]() |
create_emp_dept_custom.sql | Jan 10, 2008 |
![]() |
create_emp_dept_original.sql | Jan 10, 2008 |
![]() |
create_user_tables.sql | Jan 10, 2008 |
![]() |
![]() |
| Database Resource Manager | ||
| Output | Script Name | Last Update Date |
![]() |
rsrc_plan_status_detail_9i.sql | Jan 10, 2008 |
![]() |
rsrc_plan_status_summary_9i.sql | Jan 10, 2008 |
![]() |
| Demonstrations | ||
| Output | Script Name | Last Update Date |
![]() |
example_database_resource_manager_setup.sql | Jan 10, 2008 |
![]() |
example_drop_unused_column.sql | Jan 10, 2008 |
![]() |
example_lob_demonstration.sql | Jan 10, 2008 |
![]() |
example_move_table.sql | Jan 10, 2008 |
![]() |
example_partition_range_date_oracle_8.sql | Jan 10, 2008 |
![]() |
example_partition_range_number_oracle_8.sql | Jan 10, 2008 |
![]() |
example_transport_tablespace.sql | Jan 10, 2008 |
![]() |
| External Procedures | ||
| Output | Script Name | Last Update Date |
![]() |
compile_test_extproc.sh | Sep 19, 2004 |
![]() |
test_extproc.c | Sep 19, 2004 |
![]() |
| Flash Recovery Area | ||
| Output | Script Name | Last Update Date |
![]() |
fra_alerts.sql | Jan 10, 2008 |
![]() |
fra_files.sql | Jan 10, 2008 |
![]() |
fra_status.sql | Jan 10, 2008 |
![]() |
| Flashback Database | ||
| Output | Script Name | Last Update Date |
![]() |
fdb_log_files.sql | Jan 10, 2008 |
![]() |
fdb_redo_time_matrix.sql | Jan 10, 2008 |
![]() |
fdb_status.sql | Jan 10, 2008 |
![]() |
| LOBs | ||
| Output | Script Name | Last Update Date |
![]() |
lob_dump_blob.sql | Jan 10, 2008 |
![]() |
lob_dump_clob.sql | Jan 10, 2008 |
![]() |
lob_dump_nclob.sql | Jan 10, 2008 |
![]() |
| Locks | ||
| Output | Script Name | Last Update Date |
![]() |
locks_blocking.sql | Jan 10, 2008 |
![]() |
locks_dml_ddl.sql | Jan 10, 2008 |
![]() |
locks_dml_lock_time.sql | Apr 24, 2008 |
![]() |
| Multi Threaded Server | ||
| Output | Script Name | Last Update Date |
![]() |
mts_dispatcher_status.sql | Jan 10, 2008 |
![]() |
mts_dispatcher_utilization.sql | Jan 10, 2008 |
![]() |
mts_queue_information.sql | Jan 10, 2008 |
![]() |
mts_shared_server_statistics.sql | Jan 10, 2008 |
![]() |
mts_shared_server_utilization.sql | Jan 10, 2008 |
![]() |
mts_user_connections.sql | Jan 10, 2008 |
![]() |
| Oracle Applications | ||
| Output | Script Name | Last Update Date |
![]() |
erp_conc_manager_user_query.sql | Jan 10, 2008 |
![]() |
| Oracle Wait Interface | ||
| Output | Script Name | Last Update Date |
![]() |
owi_event_names.sql | Jan 10, 2008 |
![]() |
| PL/SQL Examples | ||
| Output | Script Name | Last Update Date |
![]() |
plsql_random_numbers.sql | Jan 10, 2008 |
![]() |
plsql_webdba_utl_pkg.sql | Jan 10, 2008 |
![]() |
| RMAN | ||
| Output | Script Name | Last Update Date |
![]() |
rman_backup_pieces.sql | Jan 10, 2008 |
![]() |
rman_backup_sets.sql | Jan 10, 2008 |
![]() |
rman_backup_sets_8i.sql | Jan 10, 2008 |
![]() |
rman_configuration.sql | Jan 10, 2008 |
![]() |
rman_configuration_clear_all_9i.rcv | Jan 10, 2008 |
![]() |
rman_configuration_setup_9i.rcv | Jan 10, 2008 |
![]() |
rman_controlfiles.sql | Jan 10, 2008 |
![]() |
rman_spfiles.sql | Jan 10, 2008 |
![]() |
| Real Application Clusters | ||
| Output | Script Name | Last Update Date |
![]() |
rac_instances.sql | Jan 10, 2008 |
![]() |
rac_locks_blocking.sql | Jan 10, 2008 |
![]() |
rac_rollback_segments.sql | Jan 10, 2008 |
![]() |
rac_rollback_users.sql | Jan 10, 2008 |
![]() |
rac_sess_users.sql | Jan 10, 2008 |
![]() |
rac_sess_users_active.sql | Jan 10, 2008 |
![]() |
rac_sess_users_sql.sql | Jan 10, 2008 |
![]() |
rac_waiting_sessions.sql | Jan 10, 2008 |
![]() |
| Rollback Segments | ||
| Output | Script Name | Last Update Date |
![]() |
rollback_contention.sql | Jan 10, 2008 |
![]() |
rollback_segments.sql | Jan 10, 2008 |
![]() |
rollback_users.sql | Jan 10, 2008 |
![]() |
| Security | ||
| Output | Script Name | Last Update Date |
![]() |
sec_default_passwords.sql | Jan 10, 2008 |
![]() |
sec_roles.sql | Jan 10, 2008 |
![]() |
sec_users.sql | Jan 10, 2008 |
![]() |
| Session Management | ||
| Output | Script Name | Last Update Date |
![]() |
sess_current_user_transactions.sql | Jan 10, 2008 |
![]() |
sess_query_sql.sql | Jan 10, 2008 |
![]() |
sess_uncommited_transactions.sql | Jan 10, 2008 |
![]() |
sess_user_sessions.sql | Jan 10, 2008 |
![]() |
sess_user_stats.sql | Jan 10, 2008 |
![]() |
sess_user_trace_file_location.sql | Jan 10, 2008 |
![]() |
sess_users.sql | Jan 10, 2008 |
![]() |
sess_users_active.sql | Jan 10, 2008 |
![]() |
sess_users_active_sql.sql | Jan 10, 2008 |
![]() |
sess_users_by_cpu.sql | Jan 10, 2008 |
![]() |
sess_users_by_cursors.sql | Jan 10, 2008 |
![]() |
sess_users_by_io.sql | Jan 10, 2008 |
![]() |
sess_users_by_memory.sql | Jan 10, 2008 |
![]() |
sess_users_by_transactions.sql | Jan 10, 2008 |
![]() |
||