Skip to main content

Oracle DBA Information at one place

Search This Blog

Troubleshooting DB Performance Issues with AWR

on August 19, 2014

Get link
Facebook
X
Pinterest
Email
Other Apps

Troubleshooting DB Performance Issues with AWR

https://support.oracle.com/epmos/main/downloadattachmentprocessor?attachid=1456176.1%3A94&action=inline

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Post a Comment

Oracle DBA Information

Popular Posts

How to read AWR reports

How to read AWR reports : The output of the AWR report contains a wealth of information that you can use to tune your database. The output of the AWR report can be divided into the following sections: Report Header This section is self explanatory which provides database name, id, instance if RAC , platform information and snap interval. (database workload time duration in review). This report is for instance number 2 of my RAC environment. So if you need to the analysis on RAC environment, you need to do it separately of all the instances in the RAC to see if all the instances are balanced the way they should be. DB Name DB Id Instance Inst num Startup Time Release RAC TestRAC 3626203793 TestRac2 2 17-Aug-11 19:08 11.1.0.6.0 YES Host Name Platform CPUs Cores Sockets Memory (GB) T estRAC Linux 64-bit for AMD 8 8 2 31. 44 Snap Id Snap Time Sessions Cursors/Session Begin Snap: 28566 27-Sep-11 01:00:21 130 4.8 End Snap: 28567 27-Sep-11 02:00:43 135 ...

Oracle Golden Gate on RAC

Oracle Golden Gate on RAC 1 Oracle GoldenGate GGSCI Commands http://docs.oracle.com/goldengate/1212/gg-winux/GWURF/ggsci_commands.htm RAC Oracle GoldenGate - Heartbeat process to monitor lag and performance in GoldenGate (Doc ID 1299679.1) Note 966181.1 Installing GoldenGate For Oracle RAC Note 965373.1 Installing And Configuring OGG In A RAC Environment Note 970876.1 Oracle ASM RAC EXTRACT Hanging Note 967390.1 Using Alternative Archived Log Destination On Oracle RAC Note 1242965.1 Re-enabling a RAC thread got extract abend with 'begin time .. prior to oldest log in log history.' Note 957112.1 Encountered SCN That Is Not Greater Than The Highest SCN Already Processed Note 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest Note 1342635.1 How the mapping of OGG thread ...

Oracle DBA ALL Interview questions and answers..

Oracle DBA ALL Interview questions and answers.. Flash back interview questions: ************************************** Questions you always wanted to ask about Flashback Database… Nov 6, 2009 / By André Araujo Tags: Oracle Last Friday in the Sydney Oracle Meetup I talked about Oracle Flashback technology and how it helps to reduce downtime. The session generated great interest among the attendees, which led to interesting discussions and many questions about the subject. Some of the questions couldn’t be answered during the meeting so I’ve followed up on them and I’m posting the answers here since they may be of interest for many others. Q: Is there a separate background process for writing flashback logs? A: Yes. RVWR (Recovery Writer, a.k.a Flashback Writer) was introduced in Oracle 10g to write flashback data from the Flashback Buffer in the SGA to the flashback database logs on disk. Q: Do I need to shutdown and mount the database to turn flashback on? A: A...

Powered by Blogger