Ora-27077: Too Many Files Open While Running A Query On V$PWFILE_USERS
Last updated on OCTOBER 24, 2016
Applies to:Oracle Server - Enterprise Edition - Version: 188.8.131.52
Information in this document applies to any platform.
SQL> select count(*) from v$pwfile_users;
ORA-27077 : too many files open
The command "lsof | grep orapw" retruns a lot of rows and after restarting the instance it is seen that the lsof command will return one new row for each new execution of the query on v$pwfile_users.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms