Database Administration (MOSC)

MOSC Banner

2 Users are fetching same objects but the time taking is different for small objects. Can you please

edited Mar 21, 2019 5:00AM in Database Administration (MOSC) 2 commentsAnswered

Hi All,

End user using his own credential to read/fetch data and the time consuming ~15 sec but at the same time he is using application user (APPS) it is taking ~7 sec to complete the task. But his query is if he fetch the big data with his own credentials then it might take long time.

As a DBA, what i need to check as what is causing the issue. Any help/suggestion please. I have search in metalink and google as well but unable to find certain document on this. Thanks in advance.

Regards,

Ravi

Tagged:

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