Herod's Home Page

Oracle DBA

My Blog

http://yaodba.blogspot.com

Welcome 

 

A quick example of the difference in sqlnet bytes returned

ed_test.txt

My top speed dialup capability proof

dialup.jpg

 An introduction to DBMS_RANDOM

RandomData.htm

A script using DBMS_RANDOM to generate a few million rows of test data

gen_random_data.sql

Create and generate random invoice data for testing.

create_random_invoice_data.sql

Some instructions on using 3 of the oracle SQL analytics functions.

OracleSQLAnalyticsPart1.htm . You can see it in PDF too

 

I tested if when you drop and recreate an index if the statistics are gathered at create.  I assumed they were not.  I was correct for v8 but was wrong on v9 and v10.  You learn something every day.

The test scripts

for V8

for V9 and V10

The output

V8, V9, V102

 Playing with indexing dates

SKINNY_TABLE_DATES.LOG

WIDE_TABLE_DATES.LOG