Category: Technology

  1. Home
  2. Technology
April 7, 2018

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 Got permission denied while trying to connect to the Docker daemon socket at unix:///var/run/docker.sock: Get http://%2Fvar%2Frun%2Fdocker.sock/v1.37/images/json: dial unix /var/run/docker.sock: connect: permission denied Now I will login to root sudo su – cd /var/run [root@debasiseric1 run]# ls -al docker.sock srw-rw—- 1 […]

Read More
April 7, 2018

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. The use of Linux containers to deploy applications is called containerization. Containers are not new, but their use for easily deploying applications is. Containerization is increasingly popular because containers are: Flexible: Even the most complex applications can be containerized. Lightweight: Containers […]

Read More
April 5, 2018

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 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 Oracle High Availability Services release version on the local node […]

Read More
April 4, 2018

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 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 test_p(id number,name char(100)); declare v_m number; begin for i in […]

Read More
April 2, 2018

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 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. The advisor report produced by  ADDM reports are used by […]

Read More
April 2, 2018

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 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 2:-Identify where the xml files of DDL logging will be […]

Read More
April 2, 2018

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 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 required for a performance baseline are not collected. Oracle strongly […]

Read More
March 30, 2018

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 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 sessions of https://clouddba.co/test-case-when-index-size-can-grow-than-column-size-and-effect-of-rebuild-index/) CREATE OR REPLACE procedure TEST.manyupdates as v_m […]

Read More
March 30, 2018

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 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 every test case.   SQL>create table t(id number,sometext varchar2(50),mydate date); […]

Read More

Debasis Maity

Translate

Ad

Please connect me in linkedin

Top Posts & Pages

Follow Us