TechnologyCategory

Author:-SOUMEN KUMAR DAS   Connecting to Microsoft SQL Server database from Oracle using SQL SERVER GATEWAY FOR ORACLE   Hostname Port DB Name Oracle Database (Source) esesslxXXXX.world 1521 ORAPROD1 SQLSERVER Data base (Target) ESESSMW9999.world 1433 SQLDB_PROD Oracle Gateway esesslxXXXX.world 1522 DG4MSQL   Following steps are involved.. Download Oracle Database Gateways… Continue Reading CONNECTING TO MICROSOFT SQL SERVER DATABASE FROM ORACLE USING DATABASE GATEWAY USING SQL SERVER GATEWAY FOR ORACLE

AWR report analysis 12c in depth-part 2 This document is continuation of AWR report analysis in depth step by step which will provide you an idea to understand AWR report more quickly. Please refer to first part:- http://clouddba.co/awr-report-analysis-depth-part-1/ H.SQL Ordered by Elapsed Time in AWR REPORT For A:- For B:-… Continue Reading AWR report analysis 12c in depth-part 2

1.Let me  create a test case : I will take different OS statistics and run time statistics to compare with AWR report generated after execution. Case A.About test case in lower CPU:- I will create a table first create table t (id number, sometext varchar2(50),my_date date) tablespace data; Now I… Continue Reading AWR report analysis in 12c depth-part 1

Adaptive Cursor Sharing:   This document will explain step by step to analyze adaptive cursor sharing. Let’s start with the basics. Let’s create a table as a copy of dba_objects.   SQL> create table t as select * from dba_objects; Now, if we run a query like ‘select object_name from… Continue Reading Adaptive Cursor Sharing

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 ‘10046 trace name context forever, level 12′; System altered. Elapsed: 00:00:00.18 SQL> create table t1(c1 number,c2 char(2000)); Table created. Elapsed: 00:00:00.03 SQL> set autotrace on; SQL> set autotrace traceonly; SQL>… Continue Reading Comparison between exadata and non-exadata executions test case

Logical IO vs Physical IO vs Consistent gets I have created 1 GB table T1.   Let me check how many blocks are there in the table after I have analyzed it.   SQL> select BLOCKS from user_tables where table_name=’T1′;    BLOCKS ———-    139153   Autotrace report Let me clean buffer… Continue Reading Logical IO vs Physical IO vs Consistent gets oracle

I referred some reference from my favorite Tim Hall blog (ORACLE_BASE) A.Basic of optimizer statistics: – The optimizer cost model relies on statistics collected about the objects involved in a query, and the database and host where the query runs. Statistics are critical to the optimizer’s ability to pick the… Continue Reading Oracle 12c gather statistics oracle deep dive