With up to 25 yrs experience anf knowledge of Oracle Internals, specilized in the database performance troubleshooting and tunning. For every production incident, present graphic analysis report of the root cause and make the database optimization proposals.
A professional in the area of Oracle database capacity planning and forecasting. Everything is based on the historical data, half yr or one yr forecasting with graphs.
The major monitor and analysis tools I developed to make the job easier
(1) real time graphic web monitor for Database load files, waiting events, Latching etc.
(2) real time graphic web monitor for OS vmstat, mpstat, iostat, netstat etc.
(3) graphic analysis web tool for the trends development for various performance and business metrics for the database and OS.(4) Correlate the frond-end performance metrics like response time, throughput, Java YGC,FGC, heap size etc with backend metrics in real time graphing. Response time histogram study in real time.