OraFAQ Forum: Server Administration » ORA-600 [17182] when using DESC in a simple query

Home » RDBMS Server » Server Administration » ORA-600 [17182] when using DESC in a simple query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-600 [17182] when using DESC in a simple query [message #51435]

Thu, 23 May 2002 00:27

Sylvain Fauvel
Messages: 4
Registered: May 2002

Junior Member

Hello.

I need help please, can't understand....
I'm working on a server 8.1.5 on NT 4 SP6.
Via SQLPLUS, i launch this query :

select
agt_ref,
agt_nom,
agt_pwd,
agt_tel,
ppragt.prf_cod,
prf_lib
from ppragt, pprprf
where pprprf.prf_cod=ppragt.prf_cod
order by prf_lib desc;

It may work one, two or three times, but it finally returns an ORA-600 error as follows :
(This is a part of SQL trace file)
*** SESSION ID:(10.26630) 2002.05.22.15.41.21.811
XCTEND rlbk=0, rd_only=1
=====================
PARSING IN CURSOR #1 len=34 dep=0 uid=97 oct=42 lid=97 tim=8826602 hv=2195525345 ad='441eca8'
alter session set sql_trace=true
END OF STMT
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=8826602
=====================
PARSING IN CURSOR #1 len=157 dep=0 uid=97 oct=3 lid=97 tim=8826602 hv=1945775368 ad='4150814'
select
agt_ref,
agt_nom,
agt_pwd,
agt_tel,
ppragt.prf_cod,
prf_lib
from ppragt, pprprf
where pprprf.prf_cod=ppragt.prf_cod
order by prf_lib desc
END OF STMT
PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=8826602
XCTEND rlbk=0, rd_only=1
EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=8826603
FETCH #1:c=0,e=0,p=0,cr=4,cu=8,mis=0,r=15,dep=0,og=4,tim=8826617
********** Internal heap ERROR 17182 addr=0xa1c7948 *********
***** Dump of memory around addr 0xa1c7948:
A1C7740 00000004 00000003 00000000 00000019 0A1C76E0 00CCE884
A1C7760 0000000C 00000000 00000000 00000029 0A1C7754 00E12EB4 00000004 00000000
A1C7780 00000000 00000000 0A1C76EC 0A1C7760 00000000 000001B5 0A1C776C 00CCE884

(This is a part of the INSTANCE_NAME_ALRT.LOG)
Wed May 22 19:13:40 2002
Errors in file D:OracleOra81rdbmstraceORA00235.TRC:
ORA-00600: code erreur interne, arguments : [[17182]], [[3253044]], [[]], [[]], [[]], [[]], [[]], [[]]
ORA-00600: code erreur interne, arguments : [[17182]], [[3253044]], [[]], [[]], [[]], [[]], [[]], [[]]

If i don't use the final "DESC" in the ORDER clause, there is no error...if i delete the WHERE... the problem disappears also.
I already have dropped all the indexes on the fields...

Can anybody help me ??

Report message to a moderator

Re: ORA-600 [17182] when using DESC in a simple query [message #51439 is a reply to message #51435]

Thu, 23 May 2002 02:21

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You probably ran into bug #907332. It is fixed in 8.1.6 so if you have the chance: Upgrade asap. It upgrading is not an option, you can bypass this bug by doing the sort binary:

SQL> alter session set nls_sort=binary;

At metalink you'll find a more lengthy explanation.

MHE

Report message to a moderator

Re: ORA-600 [17182] when using DESC in a simple query [message #51445 is a reply to message #51439]

Thu, 23 May 2002 04:21

Sylvain Fauvel
Messages: 4
Registered: May 2002

Junior Member

Great Thanks,

My problem was exactly that i couldn't connect to metalink cause i use the Oracle license of my client, and i can't join him to have his ident :o(

You saved me,
Sylvain Fauvel

Report message to a moderator

Previous Topic:	Re: ORA-08103: object no longer exists
Next Topic:	E450 Database Performance vs Intel Based Equivalent for Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 16 18:53:16 CDT 2024