Author Archives : Charles Kim

Home  >>  Author : Charles Kim

Virtualizing Microsoft SQL Server on VMware Best Practices Part 1

On September 16, 2017, Posted by , With Comments Off on Virtualizing Microsoft SQL Server on VMware Best Practices Part 1

For the first part of many series on virtualizing Microsoft SQL Server on VMware, let’s focus on the storage aspect of the virtalized infrastructure. Majority of the SQL Server performance issues can be correlated back to storage configuration. Typically, relational databases, especially in the production workloads, produce heavy I/O workloads. When storage is misconfigured, performance […]

v$recovery_process view to track database recovery operations for Data Guard

On September 2, 2015, Posted by , In Data Guard, With Comments Off on v$recovery_process view to track database recovery operations for Data Guard

Here’s a simple script to look at the v$recovery_process view: [crayon-55e6916dca6c9939057983/]

Monitoring the Physical Standby with v$dataguard_stats

On September 2, 2015, Posted by , In Data Guard, With Comments Off on Monitoring the Physical Standby with v$dataguard_stats

The following dg_check_lag.ksh script can be leveraged to monitor a Data Guard environment and to send alerts if the apply lag or transport lag exceeds a specified threshold in the dg_check_lag.conf file. In our example, the dg_check_lag.conf file specifies a threshold of three hours. If we encounter a lag in redo transport or apply lag […]

Applying the April 2015 PSU to Oracle 12.1.0.2

On May 16, 2015, Posted by , With Comments Off on Applying the April 2015 PSU to Oracle 12.1.0.2

First, download and apply the patch patch: 6880880 from support.oracle.com or from https://updates.oracle.com/download/6880880.html Download the latest PSU from Doc ID 756671.1. Unzip the PSU, cd to the directory, and check for one-off patch conflict detection and resolution. [oracle@dal66a 20299023]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 12.1.0.1.7 Copyright (c) 2015, Oracle Corporation. […]

Collaborate 2014 – Extreme Oracle DB Infrastructure As A Service Paper

On May 12, 2015, Posted by , In Cloud Computing SIG,Linux,RAC, With Comments Off on Collaborate 2014 – Extreme Oracle DB Infrastructure As A Service Paper

Abstract Learn the secrets of the trade to rapidly provisioning Oracle DB Infrastructure-As-A-Service. This extreme session will cover topics of delivering Linux-As-S-Service, RAC-As-A-Service, ASM-As-A-Service, Database-As-A-Service, Backup-As-A-Service, and even Data-Guard-As-A-Service . Advanced techniques to deploy enterprise RAC and non-RAC database deployments in an automated fashion will be shared . Save days and even weeks of deploy […]

UA-43005198-1