Monitor real time active session statistics by ORAPUB tool
The tool was devised by Craig from ORAPUB which is excellent to monitor what happens in session real time. 1.First […]
General Performance tuning
General Performance tuning
General Performance tuning, Technology
Cache buffer chain CBC latch simple query to investigate
For deep understanding on CBC,please refer to below links:- http://www.proligence.com/pres/ioug14/2014_431_Nanda_ppr.pdf and Video tutorial from ORAPUB. I am just going to
General Performance tuning
Performance monitoring or tuning tool for SQL query taking long time using various tools like explain plan,sql monitor,awrsqrpt,sqlhc
Performance monitoring or tuning tool for SQL query taking long time using various tools In that post,I will explain
General Performance tuning
AWR setup and configuration
1.General Information Memory versions of statistics regularly transferred to disk by MMON. AWR stores base statistics:-counters and value statistics. ASH
General Performance tuning
STATISTICS_LEVEL parameter Oracle 12c
You determine the level of statistics collection on the database by setting the value of the STATISTICS_LEVEL parameter. The values
General Performance tuning
Real time performance tuning using Oracle SQL Developer
Real time performance tuning using Oracle SQL Developer SQL developer is free tool can be downloaded from Oracle .I
General Performance tuning
How to investigate real time over all performance bottleneck (enq: TX – row lock contention) using OS tools like top/sar/vmstat,ASH,AWR,ORATOP and OEM
How to investigate real time over all performance bottleneck (enq: TX – row lock contention) using OS tools like top/sar/vmstat,ASH,AWR,ORATOP
General Performance tuning
Test case when index size can grow than table size and effect of rebuild index
Test case preparation I am going to create test case to simulate different index test cases Test case
General Performance tuning
AWR report analysis 12c in depth-part 2
AWR report analysis 12c in depth-part 2 This document is continuation of AWR report analysis in depth step by step
General Performance tuning
AWR report analysis in 12c depth-part 1
1.Let me create a test case : I will take different OS statistics and run time statistics to compare with