Timing « SQL Plus « Oracle PL / SQL






  1. Oracle PL / SQL
  2. SQL Plus
  3. Timing
1.Time command
2.Time and autotrace a big table
3.Time query for a huge table
4.time a query with where clause
5.Time lower text function
6.Loop timing
7.timing unconditional loop
8.Statistics query Timing on index
9.Performace difference between sql and pl/sql




10.TIMING table copying
11.Timing passing table collection parameter to a procedure