| Monitor performance [message #630178] |
Mon, 22 December 2014 02:57  |
 |
Banurs
Messages: 5
Registered: December 2014
|
Junior Member |
|
|
Hi,
Can you please suggest some tools to monitor the performance in oracle, like sql profiler in sql server.
Thank you,
Banu
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Monitor performance [message #630333 is a reply to message #630327] |
Wed, 24 December 2014 10:52  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Before diving into the the morass of performance analyzing tools, I'd start by asking if the performance degradation was sudden or gradual. Stale/badly out-of-date stats are a regular cause of performance problems. Not trying to start a war on performance tuning approach, but understanding when the issue started, which users experience it and when can save a lot of time in tracing the cause... I agree that AWR reports are excellent if you know what you're looking at.
[Updated on: Wed, 24 December 2014 10:54] Report message to a moderator |
|
|
|
|
|
| Re: Monitor performance [message #630404 is a reply to message #630393] |
Fri, 26 December 2014 07:36 |
 |
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
|
Senior Member |
|
|
You are assuming that your problem is with Oracle. The description provided of the task was "analyzing the reason for slow running website with oracleDB". Your first step should be to determine what percentage of a round trip is spent in Oracle and how much outside. You should be using a typical or at least repeatable task with the website. Break down the transaction into pieces that can be monitored. Your people should have network monitoring tools that can tell you this percentage. Then you know if the problem you are fixing is Oracle or not. Once you know this you can spent time in the right place.
Given your description though it may be that someone has already done this. If so, ask for the timings on NON-ORACLE databases doing the same queries for proof.
Or your could just assume it is Oracle and look at the TOP-N SQL to see if any of it is part of your web transaction. Here is a link to the scripts provided by my new book on SQL Tuning called - "Oracle SQL Performance Tuning and Optimization: Its all about the Cardinalities". The scripts are free so share them. One of the scripts is my top-n script. It will show you most expensive SQL on each instance for the database you are connected to.
Also, if you do decide that SQL is your problem and you need to tune it, I have attached the first chapter of my new book on SQL tuning here. This is the promotional chapter but it is the full chapter and it too is free so share it please. It will teach you about the role of Cardinality in SQL Tuning and give you more tools to speed your tuning work. You do NOT need to buy the book to use the scripts and share the promotional chapter and scripts with others.
Kevin
added scripts file
[Updated on: Sat, 03 January 2015 09:32] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
