SQL Performance (MOSC)

MOSC Banner

db file sequetial read while performing insert

edited Aug 14, 2016 5:00AM in SQL Performance (MOSC) 3 commentsAnswered

Hello,

We have top insert statement with high IO in OEM if we go at SQL level it shows db file sequential read wait event

any script to check if it is correct index and it is not skew one. How to implement reverse index?

It is doing sequetial read as clear in below output as P3=1

My db version is 11.2.0.4

db_multi_block_read set to default and when I do show parameter then value shows 128.

Let me know some script and area to check and based on that I can fix the issue.

Note: I ran sqltuning and it suggested to create two indexes and hence I created but I do not see any improvement.

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