Database Administration (MOSC)

MOSC Banner

Database performance issue

edited Jan 13, 2020 10:37AM in Database Administration (MOSC) 18 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center