Oracle DBACategory

Step by step procedure of GI upgrade from 11.2.0.3 to 11.2.0.4 using CLI or SILENT mODE   In this section we will guide you how to upgrade the GI using cli. Step 1: Before upgrade the ‘HAS’ shows version 11.2.0.3 for release and software version. $ crsctl query has releaseversion… Continue Reading STEP BY STEP PROCEDURE OF GI UPGRADE FROM 11.2.0.3 TO 11.2.0.4 USING CLI OR SILENT MODE

Performance monitoring or tuning tool for SQL query taking long time using various tools   In that post,I will explain using various method or tool to investigate performance problem of particular sql query. Let me create a test case first   create table test_c(id number,name char(100),address char(100),create_date date); create table… Continue Reading Performance monitoring or tuning tool for SQL query taking long time using various tools like explain plan,sql monitor,awrsqrpt,sqlhc

1.General Information Memory versions of statistics regularly transferred to disk by MMON. AWR stores base statistics:-counters and value statistics. ASH data is firstly captured first to memory in 1 second interval for active sessions only.ASH data is reduced by 10 times sample in memory data.ASH data is used by ADDM.… Continue Reading AWR setup and configuration

We need to enable DDL logging sometimes to track all DDL operations performed in database level.   Step 1:-Please set ENABLE_DDL_LOGGING to TRUE   Enter user-name: / as sysdba SQL> show parameter ENABLE_DDL_LOGGING; NAME TYPE VALUE ———————————— ———– —————————— enable_ddl_logging boolean FALSE SQL> alter system set ENABLE_DDL_LOGGING=TRUE; System altered. Step… Continue Reading Enable DDL logging in Oracle 12c

You determine the level of statistics collection on the database by setting the value of the STATISTICS_LEVEL parameter. The values for this parameter are: • BASIC: No advisory or other statistical data is collected. You can manually set other statistic collection parameters such as TIMED_STATISTICS and DB_CACHE_ADVICE.Many of the statistics… Continue Reading STATISTICS_LEVEL parameter Oracle 12c

Real time performance tuning using Oracle SQL Developer   SQL developer is free tool can be downloaded from Oracle .I use it frequently as my performance tuning day to day arsenal.It is great tool to analyze both overall system performance as well as particular SQL tuning. Let me go thorugh… Continue Reading Real time performance tuning using Oracle SQL Developer

How to investigate real time over all performance bottleneck (enq: TX – row lock contention) using OS tools like top/sar/vmstat,ASH,AWR,ORATOP and OEM   I will simulate “row lock contention” using following procedure( I will resue my test case mentioned in Test case 4:-Now I will run update in parallel 10… Continue Reading How to investigate real time over all performance bottleneck (enq: TX – row lock contention) using OS tools like top/sar/vmstat,ASH,AWR,ORATOP and OEM

Test case preparation   I am going to create test case to simulate different index test cases   Test case 1:-First we create procedure to parallel insert in 10 sessions.The insert query will insert data based on random values generated from select query.Please note I will run gather stats after… Continue Reading Test case when index size can grow than table size and effect of rebuild index

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