Author:-SOUMEN KUMAR DAS Connecting to Microsoft SQL Server database from Oracle using SQL SERVER GATEWAY FOR ORACLE Hostname […]
AWR report analysis 12c in depth-part 2 This document is continuation of AWR report analysis in depth step by step
1.Let me create a test case : I will take different OS statistics and run time statistics to compare with
Adaptive Cursor Sharing: This document will explain step by step to analyze adaptive cursor sharing. Let’s start with the
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
A.Enabling SPM manually to stabilize plan for a particular query For this test case I will create a table with
Logical IO vs Physical IO vs Consistent gets I have created 1 GB table T1. Let me check how
I referred some reference from my favorite Tim Hall blog (ORACLE_BASE) A.Basic of optimizer statistics: – The optimizer cost model
Author:-https://www.linkedin.com/in/maheshsrikakula/ Oracle License Cost Calculation basics How to enable/disable oracle license features at Binary Level