Re: ORACLE hangs after query 'select * from v$pwfile_users' in SQL*Plus session

Roger Jackson <rjackson_at_wire.net.au> wrote in message news:806aac$3pc$1_at_caley.wire.net.au...
> Hi everyone,
>
> Database and Platform details.
>
> Oracle v8.0.5.2.1 32Bit
> AIX V4.3.2
>
> Has anybody come across this problem?
>
> When you run the following query from SQL*Plus
> select * from v$pwfile_users;
>
> All SQL*Plus sessions hang and you have to perform a shutdown abort. You
> cannot start another SQL*Plus session, you can only access server manager.
>
> You also receive an ORA-0600 but I don't have the arguments in front of me.
> Although there is only one argument.
>
> Oracle WWS said it is a known bug and the solution was to perform a shutdown
> abort. I have been told that this bug has been fixed in v8.0.6 which as far
> I understood was not going to be released. Can somebody out there confirm
> this?

[snip]

I receive an error in my Oracle8i on NT sp4: ORA-600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], [] But the sessions can go on.

In my Oracle 8.0.4, it's OK. Received on Tue Nov 09 1999 - 09:27:47 CST