Hello,
I don't have much experience as a DBA and we are using older version of Oracle database. We are facing slowness in Oracle Database 10g since few months.
Details of DB Server as Below ::
Database :: 10.2.0.5
OS :: redhat - 4
RAM :: 12 GB
SGA :: 3136.31 MB
I tried to gather stats of DB objects but no performance gain.
So, I tried to look at which process at OS level that which process is consuming more memory using "htop" command.
I have found process "ora_dbw0" which is consuming 23% of memory(constantly) and CPU usage is 0 %.
I don't know that it is ok that this process consuming this much memory or I need to analyze why it is consuming 23% of memory.
Please guide me to resolve the performance issue.
Thanks.