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; .
<SPAN
class=000470914-09112001> 
<SPAN
class=000470914-09112001>HTH
<SPAN
class=000470914-09112001>Srinivas
<SPAN
class=000470914-09112001> 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Riswandi   [mailto:riswandi_at_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 Received on Fri Nov 09 2001 - 00:28:18 CST