STEP BY STEP PROCEDURE OF GI UPGRADE FROM 11.2.0.3 TO 11.2.0.4 USING CLI OR SILENT MODE
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 […]
Installation
Oracle DBA
General Performance tuning
Performance monitoring or tuning tool for SQL query taking long time using various tools like explain plan,sql monitor,awrsqrpt,sqlhc
Performance monitoring or tuning tool for SQL query taking long time using various tools In that post,I will explain
General Performance tuning
AWR setup and configuration
1.General Information Memory versions of statistics regularly transferred to disk by MMON. AWR stores base statistics:-counters and value statistics. ASH
security
Enable DDL logging in Oracle 12c
We need to enable DDL logging sometimes to track all DDL operations performed in database level. Step 1:-Please set
General Performance tuning
STATISTICS_LEVEL parameter Oracle 12c
You determine the level of statistics collection on the database by setting the value of the STATISTICS_LEVEL parameter. The values
General Performance tuning
Real time performance tuning using Oracle SQL Developer
Real time performance tuning using Oracle SQL Developer SQL developer is free tool can be downloaded from Oracle .I
General Performance tuning
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
How to investigate real time over all performance bottleneck (enq: TX – row lock contention) using OS tools like top/sar/vmstat,ASH,AWR,ORATOP
General Performance tuning
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
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