Let's follow the transaction and see what happens. I am sure there are
some errors and omissions, so please take with a grain of salt and add
other steps/clarifications.
1) Object resolution. If the object definition does not already exist in
the dictionary cache, it must be read from the data
Partial List
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
How
about foreign key constraints? - going to the parent table to see if the value
exists.
Tom Mercadante Oracle Certified Professional
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, March 17, 2003 12:22
PMTo: Multiple recipients of list ORACLE-LSubject:
Constraint validations?
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 3/17/2003 11:22 AM
In sqlarea I am finding some insert statements with high disk reads .
why would an insert statement will generate disk reads ? Any idea .
-ak
--
Please see the official
Do you have many indexes on your system ?
A table insert often results in index updates;
and for large tables with many indexes you
usually find that some of the index leaf blocks
have to be read from disk.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now available One-day tutorials:
insert
into ... select * from ..
-Original Message-From: AK
[mailto:[EMAIL PROTECTED]Sent: Monday, March 17, 2003 12:22
PMTo: Multiple recipients of list ORACLE-LSubject:
insert stmt disk reads
In sqlarea I am finding some insert statements
with high disk reads . why
I dont have any foreign key const on the table . Yes but there are two
indexes on this table . Would that cause this high disk reads ?
-ak
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, March 17, 2003 10:14 AM
Constraint validations?