This content has been marked as final. Show 2 replies
Have you read any documentation/concepts on Oracle database?
If not you could read a hundred pages of replies and not get near your answer as you wont be able to understand them.
high level ask these questions before you go near the database.
Where is the application slow?
who is it slow for?
is it slow at particular times?
Has there been any changes in the application?
Was it ever fast? whats changed since it was fast to when it got slow.
Have you a test environment? ask all the above questions of that as well.