RSS start | index | login or register | find | edit
Online for 3202 days.




sticky snips:

2004-02-23-bug
2004-08-02-misc


no backlinks


1 active user:

unknown (1)

Recent edits:

Java
tsr
2008-01-22
Swing Explorer
SAP XI
UISpec4J
JIDE-OSS
bean-properties
DocBook
Visual Library
 Oracle Performance Tuning stick
by tsr, 3152 days ago

Oracle
Cost-Based Optimizer

  • autotrace: set autotrace on
  • trace logging(for tkprof): alter session set sql_trace=true
  • flush !buffer cache! (10g feature): alter session flush buffer_cache;

    Runstats
    This is the test harness I use to try out different ideas. It shows two vital sets of statistics for me:
  • The elapsed time difference between two approaches. It very simply shows me which approach is faster by the wall clock
  • How many resources each approach takes. This can be more meaningful then even the wall clock timings. For example, if one approach is faster then the other but it takes thousands of latches (locks), I might avoid it simply because it will not scale as well.


    No attachments for this snip.
    Upload / manage attachments!
    •   c'est un vanilla site