samples

Here you can find SQL scripts, trace-files and reports.

Count samples

• Scripts
  • select count(*) from dba_objects (sql)
  • select count(1) from dba_objects (sql)
• Trace-files
  • Oracle 9i: count(*), count(1)
  • Oracle 10xe: count(*), count(1)
  • Oracle 11xe: count(*), count(1)
• Reports
  • Resource profile
    • count(*) - Oracle 9i (zip)
    • count(1) - Oracle 9i (zip)
  • Optimization
    • for session - Oracle 9i (zip)
    • for statement - Oracle 9i (zip)