Database performance issue
Hello,
I have oracle 11.2 enterprise running on Windows server 2012
Application team are always complaint about the performance.
the nature of the application is that they do two things:
1- upload batch file on the application
2- Select data from database
this actions not occurs all the day, it may be 2 hours per day
i have checked the AWR report i found the below:
Soft Parse % : 39.82
% Non-Parse CPU : 66.70
Buffer Hit % : 51.30
Library Hit % : 69.22
Execute to Parse % : 51.24
Start End
Buffer Cache : 1,136M 1,248M
Shared Pool Size : 710M 646M
i checked the machine CPU and memory and it's Ok.
do you recommend any parameter to check Or modify in the database Memory configuration.