Re: strange select issue

On Thu, 18 Sep 2003 21:02:54 GMT, "Tom" <tomNOSPAM_at_teameazyriders.com> wrote:

>8.1.5
>solaris 7
>
>Hi,
>
>I have a very odd issue that i can't work out and there are no hints at all
>from the alert log.
>
>If i do the following..
>
>select x from tablename order by x;
>
>this works fine
>
>if i do
>
>select * from tablename order by x;
>
>this just hangs forever. I'm suspecting its instance related as i have since
>dropped the user and tried to reimport their data and it also hangs. I can't
>find any errors being produced at all. The instance has been bounced and the
>box reboted. I can't find any datafiles that are at their limit of size but
>if they were i would expect oracle to complain lots.
>
>any thoughts as i'm stumped now and this is now kinda urgent
>
>thanks
>
>Tom
>

issue
alter session set events='10046 trace name context forever, level 12'

This will generate a trace file in the user_dump_dest directory, which will show you *what* it is waiting for.
8.1.5 is a can of worms and have been desupped long since. The 8.1 productline will be laid to rest on December 31, 2003

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Sep 18 2003 - 16:28:05 CDT