MFA Icon

MFA for Oracle Community

Starting September 2025, Oracle Community will require Multi-Factor Authentication (MFA) for all member logins. This simple extra step helps protect your account—and the community data—by adding an additional layer of security during sign-in.

Read more about MFA
Skip to content
SQL Performance (MOSC)
MOSC Banner

db file scattered read by index range scan

edited Jan 1, 2018 4:00AM in SQL Performance (MOSC) 6 commentsAnswered

Hello experts,

                       Today I have found an interesting SQL performance issue in a reporting database which gets refreshed every night and turns into read write mode in the morning.Below is the environment details.

opatch lspatches
24917954;OJVM PATCH SET UPDATE 11.2.0.4.170117
24006111;Database Patch Set Update : 11.2.0.4.161018 (24006111)
17501296;

uname -a
SunOS  5.11 11.3 sun4v sparc sun4v

One query used by SQL server report usually takes 1-3 minutes but takes 15-45 mins between 8 and 9:30 AM.We know there are other jobs runs during that time and lot of parallel salves are used by underlying query during that time.I have attached awr sqlreport and ASH report.What I have observed is db file scattered read for below operation.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center