RE: What this is?

Hi Stephen,
to be sure what it is, try tracing the inserting process. also look = into the parsing counts on the insert. i think oracle should only need = to find constraints via recursive sql at parse time. are there lots of = parses involved in the insert process? trace it to be sure...

bruce

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Stephen Lee Sent: Friday, November 12, 2004 1:46 PM
To: oracle-l_at_freelists.org
Subject: What this is?

select c.name, u.name
from con$ c, cdef$ cd, user$ u=3D20
where c.con# =3D3D cd.con# and cd.enabled =3D3D :1 and c.owner# =3D3D = u.user#;

After some concern about a database running slower than desired and slower than normal, the statement that shows up as being the biggest for the number executions and buffer gets (but NOT buffer gets per execution) is above. I know that a large table is getting data inserted, and there are two unique constraints, one primary key, three foreign keys, and a few not null constraints on the table. The table has 321 million rows, and sum(bytes) from dba_segments comes back with 44,669,337,600.

I can understand how constraint validation could certainly incur some overhead on stuffing rows into this table. I can't see how the above select ties in since it appears to be a query of: gimme all the constraints where cd.enabled =3D3D some value. It is being executed by = =3D
SYS.
Would anyone care to speculate if the query is part of the system doing constraint validation, or might it be the result of something else ... like maybe that Embarcadero Performance Center installation that just got installed around here.

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 12 2004 - 15:05:25 CST