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
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
|