Hi Tom
Could please provide a little bit more info on how 'select * from
v$pwfile_users' crashed your production database.
What did actually happened ? What do mean with the 'crashed' ?
With regards
Alex Afanassiev
Oracle DBA, TOC OPS/Internet.Operations
Tel: (03) 8 661 20 61
Fax: (03) 9 650 36 74
> -----Original Message-----
> From: Tom Pall [SMTP:tom_at_cdproc.com]
> Sent: Thursday, October 19, 2000 1:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: internal error when selecting from V$PWFILE_USERS.
>
> There's a known bug that has to do with arraysize in sql*plus that causes
> the ora-0600 when
> selecting from v$pwfile_users. Be very careful. A select * from
> v$pwfile_users not only caused a
> fatal error in one of our DBA's sessions, but also crashed a production
> database.
>
> ----- Original Message -----
> From: Amar Kumar Padhi <mailto:TS2017_at_emirates.com>
> To: Multiple recipients of list ORACLE-L
> <mailto:ORACLE-L_at_fatcity.com>
> Sent: Wednesday, October 18, 2000 4:06 AM
> Subject: internal error when selecting from V$PWFILE_USERS.
>
>
> Hi,
> I am getting ora-600 when I give a select from v$pwfile_users from
> sql*plus.
> The same statement is working when I connect as sysdba in svrmgr30.
> My remote_login_passwordfile is set to 'EXCLUSIVE' and I have used
> orapwd80 to create a password file.
>
> I am not able to think of any remote possibility as to why it should
> be happening. Any ideas? scripts missed out during installation etc. etc.
>
> Thanks,
> Amar
> 00-971-50-7883254
> ts2017_at_emirates.com
> amar_padhi_at_hotmail.com
Received on Wed Oct 18 2000 - 18:59:32 CDT