I have 90% memory utilization on my server which have oracle DB 11G with my customized ERP Solution. My appl run fines with max memory utilization of 30 to 40% when i have less users however in peak hours its memory utilization reached 90% with slows down the complete ERP solution ans user is unable to perform transactions. I have checked my memory utilization and got processes with dir path $ORACLE_HOME/bin/oracle with max ram usage. i think these are the processes which executing my SQL queries. I just need the detail of quries with their RAM usage so that i can figure out culprate one and optimize it.
is there any way find out query wise detail of RAM Utilization/ CPU utilization??????