Guys,
Querying my v$session_wait shows 10 rows each DB FILE SEQUENTIAL
READ and DB FILE SCATTERED READ.
manuals explain it all b'coz of I/O.
there are 33 tables and 110 indexes in the same USERS tablespace
with only one datafile USERS01.DAT of size 12GB.
it's physically laid out in
Moving stuff around won't reduce I/O traffic, it'll just spread it
around across different devices.
Don't focus on how much I/O your system does, focus on how much *time*
an important process spends *doing* I/O. It's Amdahl's Law: If you
improve I/O latencies by 50%, but your program spends only
PROTECTED]
@rediffmail.ccc:
om Subject: sequential reads/scattered reads
Sent by: root
Cary Millsap,
i selected the top 25 SQL statements in the system over various
periods . all are SELECT statements only waiting for reads.
querying v$session_wait also shows more than 10 records each for
DB FILE SCATTERED READS and DB FILE SEQUENTIAL READS.does not it
mean that it's b'coz of
:
om Subject: sequential
reads/scattered reads
Sent by: root
07/11/2002
07:33 AM
Please
respond to
ORACLE-L
Guys,
Querying
]
@rediffmail.ccc:
om Subject: sequential
reads/scattered reads
Sent by: root
07/11/2002
07:33 AM
Please
respond to
ORACLE-L
ORACLE-L
oraoraora
[EMAIL PROTECTED]
@rediffmail.ccc:
om Subject: sequential
reads/scattered reads
Sent by: root
07/11/2002
07:33 AM
Are you sure that these are the ones that are slowing
the system down ? Did you try to find out at what
time of the day the system is really slow and execute
your wait/event queries at that time ? Did you get
a slice of 10046 data when the application was actually
running slow ?You could
oraoraora [EMAIL PROTECTED]
@rediffmail.ccc:
om Subject: sequential
reads/scattered reads
Sent by: root
07/11/2002
07:33 AM
Please
oraora [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/11/2002 04:33 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:sequential reads/scattered reads
Guys,
Querying my v$session_wait shows 10 rows each DB
10 matches
Mail list logo