Re: DBA Job Functions
- From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
- To: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- Date: Fri, 2 Mar 2018 12:22:11 +0300
Mladen,
You could have used the 10046 trace. That would tell you what is you
application waiting for.
On recent oracle versions I wouldn't start from 10046, because in more than
80% cases it's overkill and it requires more time(you need to wait end of
execution, otherwise you will not get row statistics) than other more
real-time tools, for example, Session Snapper, ASH, RTSM, v$session_event,
etc...
At this point, I have to ask: have you read Cary Millsap's book?
"Optimizing Oracle Performance" by Cary and Jeff Holt? Yes, of course, long
time ago :)
Moreover, I subscribed to his blog (as to many others from this thread) and
some of my scripts are based on Cary's scripts.
So what's your point? Don't you think that it's much better to send more
detailed questions? Mail-list is not a telegram or twitter :D
On Fri, Mar 2, 2018 at 10:04 AM, Mladen Gogala <gogala.mladen@xxxxxxxxx>
wrote:
At this point, I have to ask: have you read Cary Millsap's book?
On 03/01/2018 08:48 PM, Sayan Malakshinov wrote:
There are a lot of different types of problems, so it's more important to
determine what information you need to troubleshoot current issue, and only
after that you can choose a tool which can show it.
In your case I think sqlplus+v$active_session_history (perhaps with
v$segment_statistics) should be enough. For example, my script from not yet
published post: https://github.com/xtender/xt_scripts/blob/
master/ash/top_predicates.sql
It shows top predicates from ASH for table access analysis
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
--
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org
Other related posts:
- » DBA Job Functions- Sheehan, Jeremy
- » Re: DBA Job Functions- Chris Taylor
- » Re: DBA Job Functions- Powell, Mark
- » RE: DBA Job Functions- Sheehan, Jeremy
- » RE: DBA Job Functions- Sheehan, Jeremy
- » Re: DBA Job Functions- Niall Litchfield
- » RE: DBA Job Functions- Sheehan, Jeremy
- » RE: DBA Job Functions- Mark W. Farnham
- » Re: DBA Job Functions- Jared Still
- » RE: DBA Job Functions- Sheehan, Jeremy
- » Re: DBA Job Functions- Mladen Gogala
- » Re: DBA Job Functions- Kenny Payton
- » Re: DBA Job Functions- Dominic Brooks
- » Re: DBA Job Functions- Andy Sayer
- » RE: DBA Job Functions- Sheehan, Jeremy
- » RE: DBA Job Functions- Sheehan, Jeremy
- » RE: DBA Job Functions- Mark W. Farnham
- » Re: DBA Job Functions- Cary Millsap
- » Re: DBA Job Functions- Ram Raman
- » Re: DBA Job Functions- Sayan Malakshinov
- » Re: DBA Job Functions- Mladen Gogala
- » Re: DBA Job Functions- Mladen Gogala
- » Re: DBA Job Functions- Mladen Gogala
- » Re: DBA Job Functions - Sayan Malakshinov
- » Re: DBA Job Functions- Sayan Malakshinov
- » RE: DBA Job Functions- Tefft, Michael J
- » RE: DBA Job Functions- Sheehan, Jeremy
- » Re: DBA Job Functions- Ram Raman
- » Re: DBA Job Functions- Sayan Malakshinov
- » Re: DBA Job Functions- Jared Still
- » Re: DBA Job Functions- Mladen Gogala
- » RE: DBA Job Functions- Mark W. Farnham
- » Re: DBA Job Functions- Mladen Gogala
- » Re: DBA Job Functions- Lothar Flatz
- » Re: DBA Job Functions- Mladen Gogala
- » Re: DBA Job Functions- Sayan Malakshinov
- » Re: DBA Job Functions- Dominic Brooks
- » Re: DBA Job Functions- Mladen Gogala
- » Re: DBA Job Functions- Mladen Gogala
- » RE: DBA Job Functions- Noveljic Nenad