Skip to content
GotoDBA
  • Blog
  • Presentations
  • Speakers
    • Speakers / Speaking
    • Becoming a Speaker
    • Building a Presentation
  • Consultants
    • Becoming a DBA Consultant
    • 8 things DBA Consultants Do
    • Before You Become a Consultant
    • Before You Become an Independent Consultant
    • Different Types of Projects for a Consultant
    • Personal Skills
    • Workplace Politics
    • The DiSC Assessment
    • Meeting a New Client
    • Financial Management
  • Podcast
  • Services
  • About
    • About Me
    • Contact
Close Button
Twitter Linkedin

Researching a BugResearching a Bug

June 19, 2018June 19, 2018 | Liron AmitziLiron Amitzi | 0 Comment | 8:55 am

A few months ago we hit an Oracle bug related to streams replication crash after creating an index (bug 21320182). There is a patch so we installed the patch in

Read MoreRead More

Datapach issuesDatapach issues

June 13, 2018June 13, 2018 | Liron AmitziLiron Amitzi | 2 Comments | 8:15 am

This week I worked on a messy patch. I have a RAC environment with 12.1.0.2 and an old PSU and all kind of one-off patches and I wanted to install

Read MoreRead More

V$LOCK Missing InformationV$LOCK Missing Information

May 15, 2018May 15, 2018 | Liron AmitziLiron Amitzi | 0 Comment | 11:16 am

In our first BCOUG Tech Day conference, I presented my session “Look Inside the Locking Mechanism”. I presented this topics before a few times and prepared a few demos to

Read MoreRead More

BCOUG Tech Day 18 SummaryBCOUG Tech Day 18 Summary

May 14, 2018May 14, 2018 | Liron AmitziLiron Amitzi | 2 Comments | 8:55 am

On April 27th (2018) we had our first BCOUG Tech Day conference! If you are reading this and you’re part of an OUG board, you know how stressful and how

Read MoreRead More

Did You Know #26 – Restoring Standby Control FileDid You Know #26 – Restoring Standby Control File

May 2, 2018May 2, 2018 | Liron AmitziLiron Amitzi | 0 Comment | 10:15 am

If you read my post Restoring Standby Database, you know that one of the problems I had was that the new control file refused to open the database with resetlogs

Read MoreRead More

Restore Standby DatabaseRestore Standby Database

April 19, 2018April 19, 2018 | Liron AmitziLiron Amitzi | 2 Comments | 8:45 am

Over the years I ran into all kind of weird and wonderful backup and restore scenarios. This case has challenged me for a while now and I finally had the

Read MoreRead More

Did You Know #25 – Archives in FRADid You Know #25 – Archives in FRA

April 11, 2018April 11, 2018 | Liron AmitziLiron Amitzi | 9 Comments | 8:27 am

One of my clients is restoring their database backup to another server for some testing. They do it periodically so we can also verify that the backup is good (which

Read MoreRead More

Did You Know #24 – Blocked InstancesDid You Know #24 – Blocked Instances

March 13, 2018March 13, 2018 | Liron AmitziLiron Amitzi | 4 Comments | 9:05 am

Even after years of working with something, you can always learn new stuff. Today I tried to create a standby database using the duplicate command. When you duplicate a database

Read MoreRead More

Tool to Assist with Basic SQL AnalysisTool to Assist with Basic SQL Analysis

March 6, 2018March 6, 2018 | Liron AmitziLiron Amitzi | 8 Comments | 8:40 am

I just came back from RMOUG Training Days conference. It was my first time in Colorado (and obviously my first RMOUG training day) and it was really great (I wrote

Read MoreRead More

RMOUG Training Days 2018RMOUG Training Days 2018

February 26, 2018February 26, 2018 | Liron AmitziLiron Amitzi | 3 Comments | 8:08 am

This year was the first time I attended (and spoke) at RMOUG Training Days. Last year I submitted a few sessions but they were rejected. This year I had the

Read MoreRead More

Posts pagination

Previous 1 … 11 12 13 … 25 Next

Subscribe

Top Posts

  • Oracle Real Memory Usage
  • Checking SQL Progress in Oracle
  • SEHA - Standard Edition High Availability in Oracle DB
  • Analyzing the Listener.log
  • Oracle Data Guard Explained - Step By Step

Categories

  • Cloud (3)
  • Conferences (30)
  • Database Development (48)
  • Database Security (5)
  • Database Thoughts (26)
  • Database Tuning (29)
  • DB Camparison (5)
  • Did You Know (37)
  • Features (59)
  • Funny (1)
  • How Things Work (34)
  • Infrastructure (72)
  • Other stuff (30)
  • Troubleshooting (35)
  • Uncategorized (4)
  • Upgrade (11)

My Twitter

My Tweets

RSS Feed

  • RSS - Posts
  • RSS - Comments
Copywrite and disclaimer information
Privacy policy

Industrial WordPress Theme © Liron Amitzi, GotoDBA.com, 2019. Powered by

Scroll Up