Re: DBA Job Functions

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: Sayan Malakshinov <xt.and.r@xxxxxxxxx>, Ram Raman <veeeraman@xxxxxxxxx>
  • Date: Fri, 2 Mar 2018 02:04:37 -0500

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2018