Ours is a OLTP database, when i watch the top sessions i always find the processes MMAN, MMON, MMNL , CJQ0, QMNC in the top 15 sessions. are these processes very resource consuming ones?...
Database : 10g
Printable View
Ours is a OLTP database, when i watch the top sessions i always find the processes MMAN, MMON, MMNL , CJQ0, QMNC in the top 15 sessions. are these processes very resource consuming ones?...
Database : 10g
May be your instance has a less number of user server processes.
Is your system so active?
Tamil
Hi Tamil,
Its a heavily accessed database with lot of online transactions from around the country.