Database Tuning (MOSC)

MOSC Banner

12c query performance slow

edited Jun 29, 2018 2:13AM in Database Tuning (MOSC) 4 commentsAnswered

Hello team,

I am facing one problem, one of my queries was running fine, but all of sudden it is taking time, after some time (10 mins) I rerun the same query it was executing in the same time frame. I am not getting why the query is misbehaving.

1) indexes/table stats are up to date.

2) execution plan is not changing.

3) there is no change is sql.

4) DB version, 12.1

thanks in Adv.

thanks,

Javed

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