Re: SQLGLS dump on 64bit

"My-Works" <info_at_my-works.org> wrote in message news:b8lc1o$h56$1_at_grillo.cs.interbusiness.it

> but the program hangs during SQLGLS call. The only way to stop it is
> kill -9
> unix command.
>
> After this next two lines where added to the trace file:
> STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE '
> STAT #1 id=2 cnt=1 pid=1 pos=1 obj=222 op='TABLE ACCESS FULL OBJ#(222) '
>
> What can I do?
> Thanks
> Misha

I found your message on Metalink. I don't know the answer. I'm curious what the session is waiting on (look at v$session_wait where sid = <your hanging session>). Does the shadow process use CPU? If you don't turn on sql_trace, is there a trace file? Or any message in alert.log?

Also, look at Bug No. 2849474 on Metalink. It talks about unsigned long vs. unsigned int.

Yong Huang

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG