Hello All,
We are running oracle 9.2 on a sun box in a DW env.
Data loads are thorugh informatica.
During one such load of fact table, the load time per sec is about 300
rows per sec.
The table is suppose to load about 5 mil rows.
During the load i happen to do
Title: RE: Insert too slow...
How may indexes are on DM_TRANS_PYMT_HIST? If there are a lot, you might want to drop the indexes, except for the primary key or unique constraints, insert the records, rebuild the dropped indexes, and analyze those indexes.
Jerry Whittle
ACIFICS DBA
NCI
Except for primay key constraint we dont have any other constraints or
indexes present during the load.
What does the sql * net wait events signify. Is there cause for concern
when we see those events. ??
Thanks,
Sathish.
On Wed, 23 Oct 2002 09:02:21 -0800, Whittle Jerome Contr NCI
[EMAIL
Sathish
Given that your high wait times relate not to the actual Oracle insert
process but to communication with the client, the first place I would look
is the connection between Oracle and Informatica. Are you going through
ODBC? There are options in SQL*Net and in the ODBC driver. I would
