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
General Performance tuning
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, 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
General Performance tuning
Clustering Factor and it’s effect on non-assm and assm tablespace
Clustering Factor and it’s effect on non-assm and assm tablespace. The clustering factor is a measure of the ordernesss of
General DBA, General Performance tuning
Index in 12c by example test case
A. B-Tree Indexes I have discussed more details in the below blog. http://clouddba.co/index-internal-oracle-using-simple-test-case/ B.Invisible Indexes Deciding which columns to index
General Performance tuning
How histogram can affect query plan change hence performance
How histogram can affect query plan change hence performance. 1.Let me create a test case.I am loading the table with