Trace file:
===========
*** SERVICE NAME
SYS$BACKGROUND)
*** SESSION ID
3295.1)
ktsmgtur(): TUR was not tuned for 1644 secs
ktsmg_advance_slot(): MMNL advances slot after 1786 seconds
*** 2010-01-10 05:30:11.004
Process m000 is dead (pid=32562, state=3):
Unable to schedule a MMON slave at: Auto Flush Main 1
Attempt to create slave process failed.
Can happen for several reasons:
- No process state objects
- Reached OS set limits
- A shutdown was going on
Check alert log for more details.
CHECKS:
=======
SQL> show parameter process
NAME TYPE VALUE
———————————— ———– ——————————
processes integer 2000
SQL> show parameter session
NAME TYPE VALUE
———————————— ———– ——————————
sessions integer 2318
SQL> select count(*) from v$session;
COUNT(*)
———-
1994
SELECT COUNT(*) FROM v$process;
COUNT(*)
———-
1990
Solution
========
- kill processes which generates the processes ( usually from http)
- restart database
- this error coresponds with ORA-3136
Hope this helps.