• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 290
  • Last Modified:

STATSPACK Report

Can anyone explain the meaning of these top 5 events in my STATSPACK report ?

Top 5 Timed Events
~~~~~~~~~~~~~~~~~~                                                                                        % Total
Event                                                            Waits                     Time (s)                Ela Time
-------------------------------------------- ------------ ----------- ------------------------
db file sequential read                          15,400,432           46,686                   71.04
log file sync                                                 2,148,363             9,500                    14.46
db file scattered read                            4,053,185             5,187                     7.89
db file parallel write                               198,237                 2,200                     3.35
buffer busy waits                                     167,461                 808                         1.23
0
raj_k_s
Asked:
raj_k_s
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
Explain how?  These should be defined in the online docs.
0
 
raj_k_sAuthor Commented:
what I mean to ask is the meaning of these events. e.g. what is the meaning of db file parallel write ? and how should I avoid this ?
0
 
slightwv (䄆 Netminder) Commented:
Did you look in the docs?

This is 11g docs but many of these parameters haven't changed:

http://www.oracle.com/pls/db112/search?remark=quick_search&word=db+file+parallel+write

>> and how should I avoid this ?

What makes you think you need to avoid this?  There always will be a top 5 list.  This does not mean they are 'bad'.  You need to look at them and make the decision based on the database and the applications using the database.

This might be normal database activity.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now