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
oracle gateway
CONNECTING TO MICROSOFT SQL SERVER DATABASE FROM ORACLE USING DATABASE GATEWAY USING SQL SERVER GATEWAY FOR ORACLE
Author:-SOUMEN KUMAR DAS Connecting to Microsoft SQL Server database from Oracle using SQL SERVER GATEWAY FOR ORACLE Hostname
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
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
ORACLE INTERVIEW QUESTIONS
Backup and recovery Interview questions
Sarat 1) What are pre-checks you do before doing point in time recovery? 2) There is no previous level zero
ORACLE INTERVIEW QUESTIONS
RMAN interview questions
Heman Sahi 1. Your RMAN backup triggered, you deleted snapshot controlfile at backend, what will happen to your running backup