RE: What this is?
- From: "McCartney, Bruce" <BMcCartney@xxxxxxxxxxxxxxxxxxx>
- To: <Stephen.Lee@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Nov 2004 13:59:08 -0700
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stephen Lee
Sent: Friday, November 12, 2004 1:46 PM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
