Re: V$PWFILE_USERS

2001-11-08 Thread Riswandi
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

Re: V$PWFILE_USERS

2001-11-08 Thread Riswandi
     8.1.5     - Original Message - From: Shreeni To: Multiple recipients of list ORACLE-L Sent: Friday, November 09, 2001 12:40 PM Subject: RE: V$PWFILE_USERS This is well known/documented bug.  See Metalink for details.  Gues it was corrected 8.1.6

RE: V$PWFILE_USERS

2001-11-08 Thread Tatireddy, Shrinivas (MED, Keane)
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

RE: V$PWFILE_USERS

2001-11-08 Thread Shreeni
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

V$PWFILE_USERS

2001-11-08 Thread Riswandi
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: in