Re: Query occasionally returning empty results in 8i

BoukeB <bbruinsma_at_ortec.nl> wrote:
> We have a simple query (SELECT * FROM..,no WHERE clause) in 8i that
> sometimes returns empty results and ORA-01403: no data found. We have
> clues that it might be caused by settings in the init.ora, particularly
> for the sort area or the optimizer. The result of the query should be
> some 800 rows.

Run an SQL trace on the server and examine the results.

Yours,
Laurenz Albe Received on Thu Jun 08 2006 - 07:51:57 CDT