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
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
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
ORACLE INTERVIEW QUESTIONS
Redo,Undo,Control file interview questions
Thanks Akhil Mohan. Debasis Maity: 1.Why controlfile and redolog file multiplexed? Control file : A control file is a small
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