Monitor real time active session statistics by ORAPUB tool
The tool was devised by Craig from ORAPUB which is excellent to monitor what happens in session real time. 1.First […]
General Performance tuning
Docker
DOCKER CONCEPT FOR DBA– PART 9 : How to use docker tar command in docker to re-instantiate new docker
1.Creating docker tar file from docker image.We can transfer that tar file and import to another docker instance. root@deb-VirtualBox:~# docker
Docker
DOCKER CONCEPT FOR DBA – PART 8 How to build docker image from docker file
1.You need to create docker file first.Below is example of small test docker file. root@deb-VirtualBox:~# cat test_docker.file FROM centos:latest RUN
PostgreSQL
PostgreSQL DBA part1 :-Installation of PostgreSQL 9.6 in Linux
I will show how you can install PostgreSQL 9.6 in Linux 7.This document is based on guidance provided by EDB
Oracle DBAAS 1z0-160
Oracle DBaaS 1z0-160 part 33 :-Patching in Oracle cloud RAC database
Step 1:-Please check available patch and run precheck Step 2:-Pre-check results failed with below message Step 3:-Update RDK using below
Linux, Technology
Oracle Virtual Box VM:-How to create network setting and interface in Oracle Virtual Box to connect internet as well as connect from host
This note will describe the process to connect Oracle Virtual box VM directly from your host using ssh as well
Oracle DBAAS 1z0-160
Oracle DBaaS 1z0-160 part 32 :-On-premise database migration to oracle cloud using data pump conventional Export/Import
On-premise database migration to oracle cloud using data pump conventional Export/Import This is simplest migration if you prefer to migrate
General Performance tuning, Technology
Cache buffer chain CBC latch simple query to investigate
For deep understanding on CBC,please refer to below links:- http://www.proligence.com/pres/ioug14/2014_431_Nanda_ppr.pdf and Video tutorial from ORAPUB. I am just going to
Oracle DBAAS 1z0-160
SSH connection from on-premise Linux or Unix host to Oracle cloud
Problem 1.First I copied the private key generated by puttygen (The public key was provided during DB creation in oracle
Oracle DBAAS 1z0-160
TDE encryption setup for migrating on-premise backup to Oracle cloud using RMAN
This note describe how we can configure TDE encryption for RMAN backup in on-premise database to migrate to Oracle cloud.