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

Use order by in the select statement:
Select * from
v$pwfile_users
order by username;

In article <809ehj$4js$1_at_news.seed.net.tw>,   "fumi" <fumi_at_tpts5.seed.net.tw> wrote:
>
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 11 1999 - 12:22:48 CST