Oracle

Do you have enough Redo?

The question of whether a database has enough redo logs available is quite common. The documentation suggests to use FAST_START_MTTR_TARGET and V$INSTANCE_RECOVERY.OPTIMAL_LOGFILE_SIZE to identify “the optimal” redo log size based on the target recovery time. I’ve never used it and can’t comment if it is a correct/reasonable way or not. The easiest way to identify…

How to recover a subset of an Oracle database

Today’s blog post will discuss how to recover a subset of an Oracle database. Many of you would have come across different recovery scenarios, but I’ll be talking about a very different one that happened to me. The following are the details after receiving a call from a client, and checking the environment myself. i) This…

Online Storage Migration without ASM

I recently blogged about Playing with ASM Online Migration and still soul searching from not having jumped on the ASM band wagon. How can online storage migration be performed before ASM came about? One option is using Logical Volume Manager (LVM) and I will demonstrate: Display Volume Group [root@lax ~]# vgdisplay –verbose vg02 Using volume…

Missing UKOUG Tech13 — But Still in Manchester at OakTable World UK 2013

This is the first year since 2006 that I don’t present and don’t attend UKOUG Technology annual conference. Sad but I had to withdraw because I didn’t believe UKOUG has been making the right choices in the past little while. The trigger was the introduction of the limit of six presentations per company to present at the conference which I believe doesn’t really serve well the conference attendees nor my company that I’m so passionate about nor my colleagues that I’m so proud to work with.

Batched Table Access

When I first saw the suffix BATCHED in an Oracle execution plan from 12c, I was curious to see what is hidden behind and how it works. I had some spare time for testing and wanted to share my findings with you here.

Page 8 of 140« First Page...678910...20...Last Page »