SQL Performance (MOSC)

MOSC Banner

Load test

edited Jan 11, 2016 10:02AM in SQL Performance (MOSC) 10 commentsAnswered

Hi All,

As part of release application team performed load test in Pre-Production environment and seen some strange behavior in database that the only one query is consuming more cpu during the load test and more buffer cache wait event. This query is mostly touching internal tables and internal objects that sys.obj$,sys.$tab views and it's to difficult to identify the tables which it's referring. Can  any one suggest me why only one query is appearing during load test and why it's pointing some dictionary views instead of the original tables.How can we measure that load test output is OK or not good.

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