Solved

AWR report Analysis !

Posted on 2009-04-14
4
892 Views
Last Modified: 2013-12-18
Dear Experts
 
   Can u please  look into AWR report & kindly suggest few things to improve the Performance of DB!  

Thanks & regards
 JD
awrrpt-1-481-489-1-.txt
0
Comment
Question by:junaid_baig1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 18

Expert Comment

by:sventhan
ID: 24139198
what is the issue?
Is it something specific you'd like to know from this report?
0
 

Author Comment

by:junaid_baig1
ID: 24141464
Yes ! I want to improve the Performance of DB ! Can  u please suggest  few things that  i can do in order to improve the performance of DB after looking into the AWR report !
0
 
LVL 18

Accepted Solution

by:
sventhan earned 500 total points
ID: 24141915
all you have to do is download spviewer.com tool and that'll analyze the awr for you.
I also recomend you to have this tool.
http://www.dba-oracle.com/t_sample_statspack_analysis.htm
 have fun with awr.
good luck.
0
 

Author Comment

by:junaid_baig1
ID: 24145369
 thanks it works

regards
JD
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Via a live example, show how to take different types of Oracle backups using RMAN.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question