Solved

AWR report Analysis !

Posted on 2009-04-14
4
887 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
how to tune this sql query 61 101
percentage remaining 6 40
UNIX SCP 5 47
Difference in number of minutes between 2 timestamps 16 25
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…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

707 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now