Skip to content

Latest commit

 

History

History

aot

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
06_libcache_deadlock.sql
06_libcache_deadlock.sql
 
 
06_self_deadlock.sql
06_self_deadlock.sql
 
 
README.txt
README.txt
 
 
bh_private.sql
bh_private.sql
 
 
bigcomment.sql
bigcomment.sql
 
 
bigp.sql
bigp.sql
 
 
bigsql.sql
bigsql.sql
 
 
cbchammer.sh
cbchammer.sh
 
 
cbchammer2.sh
cbchammer2.sh
 
 
demo1.sql
demo1.sql
 
 
demo11.sql
demo11.sql
 
 
demo1a.sql
demo1a.sql
 
 
demo2.sql
demo2.sql
 
 
demo2a.sql
demo2a.sql
 
 
demo3.sql
demo3.sql
 
 
demo4.sql
demo4.sql
 
 
demo4_ora600.sql
demo4_ora600.sql
 
 
demo5.sql
demo5.sql
 
 
demo6.sql
demo6.sql
 
 
demo7.sql
demo7.sql
 
 
demo8.sql
demo8.sql
 
 
demo9.sql
demo9.sql
 
 
disable_throttle.sh
disable_throttle.sh
 
 
enable_throttle.sh
enable_throttle.sh
 
 
failed_parse_loop.sql
failed_parse_loop.sql
 
 
fatal_bg_proc.sql
fatal_bg_proc.sql
 
 
fulltrace.sql
fulltrace.sql
 
 
hang.sh
hang.sh
 
 
hang_1.sql
hang_1.sql
 
 
hang_2.sql
hang_2.sql
 
 
hang_3.sql
hang_3.sql
 
 
hang_4.sql
hang_4.sql
 
 
hang_run.sql
hang_run.sql
 
 
hang_setup.sql
hang_setup.sql
 
 
hash.sql
hash.sql
 
 
hash_demo.sql
hash_demo.sql
 
 
insert_loop.sql
insert_loop.sql
 
 
kill_cpu.sql
kill_cpu.sql
 
 
lookup_cbc.sql
lookup_cbc.sql
 
 
matching_lock_type_wait.sql
matching_lock_type_wait.sql
 
 
nonsharing_child.sql
nonsharing_child.sql
 
 
optimizer_bug.sql
optimizer_bug.sql
 
 
ora4031.sql
ora4031.sql
 
 
pga_dbms_output.sql
pga_dbms_output.sql
 
 
pga_memleak.sql
pga_memleak.sql
 
 
report_sp_chunk_durations.sql
report_sp_chunk_durations.sql
 
 
shared_pool_leak_bug.sql
shared_pool_leak_bug.sql
 
 
short_stack.sql
short_stack.sql
 
 
soe_indexes.sql
soe_indexes.sql
 
 
sqlidconv.sql
sqlidconv.sql
 
 
system_ts_writes.sql
system_ts_writes.sql
 
 
temp_io.sql
temp_io.sql
 
 
tx_lock_diag.txt
tx_lock_diag.txt
 
 
wrong_results.sql
wrong_results.sql
 
 

README.txt

Advanced Oracle Troubleshooting course scripts by Tanel Poder

DON'T JUST RUN THE SCRIPTS HERE WITHOUT CHECKING WHAT THEY DO!
DON'T TEST THESE SCRIPTS IN PRODUCTION!

These scripts are designed to cause trouble, so that they could be troubleshooted.