Multiple Oracle processes in sk_wait state on server.
Issue
- Multiple Oracle process observed in sk_wait state.
0 S username 995 987 0 80 0 - 17528 sk_wai 2015 ? 00:00:00 /u01/app/oracle/product/11.2.0.4/bin/sqlplus -s
0 S username 1585 1583 0 80 0 - 17528 sk_wai 2015 ? 00:00:00 /u01/app/oracle/product/11.2.0.4/bin/sqlplus -s
0 S username 2992 2979 0 80 0 - 17528 sk_wai 2015 ? 00:00:00 /u01/app/oracle/product/11.2.0.4/bin/sqlplus -s
0 S username 4512 4509 0 80 0 - 17528 sk_wai 2015 ? 00:00:00 /u01/app/oracle/product/11.2.0.4/bin/sqlplus -s
0 S username 4828 4827 0 80 0 - 17528 sk_wai 2015 ? 00:00:00 /u01/app/oracle/product/11.2.0.4/bin/sqlplus -s
0 S username 6392 6385 0 80 0 - 17528 sk_wai 2015 ? 00:00:00 /u01/app/oracle/product/11.2.0.4/bin/sqlplus -s
0 S username 7719 7713 0 80 0 - 17528 sk_wai 2015 ? 00:00:00 /u01/app/oracle/product/11.2.0.4/bin/sqlplus -s
0 S username 9378 9369 0 80 0 - 17528 sk_wai 2015 ? 00:00:00 /u01/app/oracle/product/11.2.0.4/bin/sqlplus -s
0 S username 11180 11177 0 80 0 - 17528 sk_wai 2015 ? 00:00:00 /u01/app/oracle/product/11.2.0.4/bin/sqlplus -s
Environment
- Red Hat Enterprise Linux 6.2
- Oracle Database
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
