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…
Sarat 1) What are pre-checks you do before doing point in time recovery? 2) There is no previous level zero…
Heman Sahi 1. Your RMAN backup triggered, you deleted snapshot controlfile at backend, what will happen to your running backup…
I referred some reference from my favorite Tim Hall blog (ORACLE_BASE) A.Basic of optimizer statistics: - The optimizer cost model…