Expertoracle.com Website Review

performance tuning basics 16 : using sql tuning health-check script (sqlhc) this post will cover the sql tuning health check script basics and how you can use it to collect the key information regarding a poorly performing sql. sqlhc helps you on focusing on specific sql and checking cost-based optimizer (cbo) statistics, schema object metadata, configuration parameters and other elements that may influence the performance. statement that has already been executed and is in memory to generate the report so it do not actually execute the sql all lover again. continue readingperformance tuning basics 16 : using sql tuning health-check script (sqlhc) block corruptions are one of the common source of database outages. a database block is corrupted when its content has changed from what oracle database expects. correcting block corruptions can prove to be a lengthy and costly exercise and requires good expertise 0n the dba block corruption can happen at logical level or physical level. also, such corruption can impact a single block or huge number of blocks in continue readingphysical and logical block corruption in oracle database the oracle’s automatic workload repository (awr) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes.  the report generated by awr is a big report and it can take years of experience to actually understand all aspects of this report. in this post we will try to explain some important sections of awr, significance of those sections and also some important tips. please note that explaining all sections of awr will not be possible so we will stick to some of the most frequently note that this is not comprehensive information and goal is to help in giving an overview of few key sections to junior dbas as a primer and to encourage them to build further the knowledge in related fields.. oracle enterprise manager (oem) 13c – part 3 : new features in oem 13c (13.2) oem 13c (13.2) has many new features which make this version more useful than the previous oem versions. if you are moving from oem 12c