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 […]
General Performance tuning
Oracle DBA
General Performance tuning
Adaptive Cursor Sharing
Adaptive Cursor Sharing: This document will explain step by step to analyze adaptive cursor sharing. Let’s start with the
General Performance tuning
Comparison between exadata and non-exadata executions test case
First we need to load data SQL> alter session set tracefile_identifier=’ABC’; Session altered. Elapsed: 00:00:00.01 SQL> alter system set events
General Performance tuning
SPM oracle 12c test case
A.Enabling SPM manually to stabilize plan for a particular query For this test case I will create a table with
General Performance tuning
Logical IO vs Physical IO vs Consistent gets oracle
Logical IO vs Physical IO vs Consistent gets I have created 1 GB table T1. Let me check how
General Performance tuning, oracle 12c
Oracle 12c gather statistics oracle deep dive
I referred some reference from my favorite Tim Hall blog (ORACLE_BASE) A.Basic of optimizer statistics: – The optimizer cost model
General DBA
Oracle License Cost Calculation basics
Author:-https://www.linkedin.com/in/maheshsrikakula/ Oracle License Cost Calculation basics How to enable/disable oracle license features at Binary Level
cloud control 13c
Oracle 13c cloud control agent installation
OMS Server: Where runs the Enterprise Manager Middleware Client Server: Where we’re going to install the agent 1.Pre-requisites setup to
General DBA, General Performance tuning
Oracle PGA (Program Global Area) in 12c
What is PGA The Program Global Area (PGA) is a private memory region that contains the data and control information