Home » RDBMS Server » Server Administration » Urgent :ORA-03113 End of Communication on Query
Urgent :ORA-03113 End of Communication on Query [message #56254] Fri, 14 March 2003 06:24 Go to next message
Shiju
Messages: 12
Registered: October 2002
Junior Member
Hi,

On Oracle 9i, on excution of a query...
select...where rownum <= 100000
MINUS
select...where rownum <= 99995

there is End Of Communication

This happens on an inconsistent basis.

Kindly suggest some way to overcome this...

Thanks for the help

Shiju

Report message to a moderator

Re: Urgent :ORA-03113 End of Communication on Query [message #56258 is a reply to message #56254] Fri, 14 March 2003 09:55 Go to previous message
JUAN
Messages: 23
Registered: November 2000
Junior Member
Did you try to run an "analyze table xxx compute statistics" on the tables?

Report message to a moderator

Previous Topic: Oracle Database Copying
Next Topic: QUERY TUNE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:49:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.