Rob, also check your explain plan on the insert also. You may be
performing a cartesian join because the optimiser thinks it a cheaper
option... insert the hint /*+ ordered use_hash() */ immediately after
the SELECT . It may, help.
"rob" <rob_at_dsdelft.nl> wrote in message news:<bfqkm4$dn7$1_at_news.tudelft.nl>...
> Check your alert log.
> Is disk where your archives are written full?
> Rob
> "Jackie" <jackie_ol_at_hotmail.com> schreef in bericht
> news:2c196db8.0307242256.339ffe06_at_posting.google.com...
> > Hi!
> > Insert queries don't work on our Oracle Server. Everything was fine
> > yesterday but today when I give an insert query sqlplus waits forever.
> > I don't receive an error message or something else, it just waits.
> > What may be the problem, this is so urgent, I need help.
> >
> > Thanks.
Received on Fri Jul 25 2003 - 15:25:21 CDT
