Re: DBA Job Functions

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


--
http://www.freelists.org/webpage/oracle-l