About that --
SELECT * FROM v$pwfile_users WHERE sysdba='TRUE'
I think this is a know bug with some of the Oracle version.

Don't ask me why but if you play a little with the select statement it does let you see the result. For example try following --


select username, sysdba, sysoper from v$pwfile_users
group by username, sysdba, sysoper;

Other variations of this SELECT may work as well.

- Rajeev