ot;Ed"
.com>cc:
Sent by: Subject: Bug, tuning issue or bad sql?
Bug.
Ed wrote:
> Oracle 8.1.6.0 NT 4.0
>
> I'm having a problem with a query which is basically just a bunch of UNION
> ALL's that I want sorted in a certain way. The query runs flawlessly when I
> limit the result set with a where clause, but when I remove it, the query
> crashes when sorting
Wow. Are you using CURSOR_SHARING=FORCE in your init.ora by any chance?
We've had sporadic problems with that while CBO is on. Also, what does the
explain plan look like?
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, S
Oracle 8.1.6.0 NT 4.0
I'm having a problem with a query which is basically just a bunch of UNION
ALL's that I want sorted in a certain way. The query runs flawlessly when I
limit the result set with a where clause, but when I remove it, the query
crashes when sorting (in the order by at the far
