From riswandi@polyfincanggih.com Thu, 08 Nov 2001 23:26:01 -0800 From: "Riswandi" Date: Thu, 08 Nov 2001 23:26:01 -0800 Subject: Re: V$PWFILE_USERS Message-ID: MIME-Version: 1.0 Content-Type: text/plain Thank you very much  
----- Original Message -----
From: Tatireddy, Shrinivas (MED, Keane) To: Multiple recipients of list ORACLE-L Sent: Friday, November 09, 2001 12:50 PM Subject: RE: V$PWFILE_USERS The v$pwfile_users generates an internal error if the client process fetched from it directly more than once. If only a single fetch is done that retrieves all the rows needed, then it works fine. An order by clause will allow the sort step to fetch all rows in a single call, and then it does not matter how many fetches the client process does, the sort already completed the fetch from v$pwfile_users. ora-600 [1113] SELECTING FROM V$PWFILE_USERS IF MORE THAN 14 SYSDBA USERS 1: Use SVRMGRL 2: When SQL*Plus must be used, use an order by clause: SQL> select * from v$pwfile_users order by 1; .   HTH Srinivas   -----Original Message-----From: Riswandi [mailto:riswandi@polyfincanggih.com]Sent: Friday, November 09, 2001 1:40 AMTo: Multiple recipients of list ORACLE-LSubject: V$PWFILE_USERS Hi,   Does anybody knows what the error below means or how te solve the problem?   007> select * from V$PWFILE_USERS;ERROR:ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], []   no rows selected 007> SELECT * FROM SYS.V_$PWFILE_USERS;ERROR:ORA-00600: internal error code, arguments: [KSSRMP1], [], [], [], [], [], [], []   no rows selected 007>   brgrds, Risc