docker concept for DBA-part-2 Run docker for non-privileged user (Other than root)
You need to change group to docker for user (non-privileged user) otherwise you get following error:- [user@debasiseric1 ~]$ docker images…
7 years ago
Docker concept -part 1-Concept and Installation of docker in CentOS
A. Basic Concept of docker Docker is a platform for developers and sysadmins to develop, deploy, and run applications with containers.…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago
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…
7 years ago