Re: V$PWFILE_USERS

From: Riswandi <riswandi_at_polyfincanggih.com>
Date: Thu, 08 Nov 2001 23:26:01 -0800
Message-ID: <F001.003C0745.20011108230017@fatcity.com>

Thank you very much
 
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message -----
  <DIV
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
  <A href="mailto:Shrinivas.Tatireddy_at_med.ge.com"
  title=Shrinivas.Tatireddy_at_med.ge.com>Tatireddy, Shrinivas (MED, Keane)
  
  

To: <A href="mailto:ORACLE-L_at_fatcity.com"
title=ORACLE-L_at_fatcity.com>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; .
<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 - 01:26:01 CST