Foreign Key Validation
Primary Key Validation
Reading blocks on the freelist for insert
Before Insert/After Insert Triggers
-- Daniel W. Fink http://www.optimaldba.com
IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo InternalsAK wrote:
In sqlarea I am finding some insert statements with high disk reads . why would an insert statement will generate disk reads ? Any idea .-ak