Tag: dba

How to Make Oracle Use the Correct Index

Learn a simple method to make Oracle use the index required for a SQL Query.

Read More >

DBAs and the Cloud: Evolving Roles and New Challenges

Do businesses have the right skills and expertise internally to take full advantage of both the tactical and strategic benefits of the cloud? To help you determine what skills are needed on your team, we’ve developed a list of 5 key skills of modern DBAs in the era of cloud. And for a complete picture of what cloud means for your DBA team, Warner Chaves, one of Pythian’s principal consultants, has written a white paper outlining how database management is different in the cloud, and the key skills the modern DBA must have.

Read More >

Three Announcements from Oracle OpenWorld You Probably Didn’t Hear

The buzz from OpenWorld this year was the permanently free Oracle Cloud offering, the new Exadata X8M (reportedly capable of 12 million I/O per second!), Oracle Autonomous Cloud at Customer, and the new Blockchain table. Here are three interesting or…

Read More >

Exadata: 7 Useful Commands to check Port/Sensor Alarms

Some days ago I was checking for the alarm below, with a very generic message: Message=The aggregate sensor /SYS/CABLE_CONN_STAT has a fault. So, I decided to document some useful commands I used to verify all ports/sensors in my Exadata cluster….

Read More >

Minimal Networking Knowledge Recommended for DBAs

In a recent post, I summarized what I consider to be the minimal topics one should be familiar with in order to do technical work with databases.  One thing I left out, except for it being implicitly included in “Hardware…

Read More >

How to Prevent Linux 7 Housekeeping from Breaking Oracle

Linux 7 introduced multiple changes and enhancements to the kernel. Among them was automated housekeeping for temporary files. In version 6, tmpwatch is available to manage unused files in temp directories. It can be scheduled via cron to automatically keep…

Read More >

How to accurately measure data guard lag events

If you work with Data Guard, the lag between the primary and standby database is an informative but difficult metric to measure. I’ve encountered some “solutions” that use the COMPLETION_TIME in (G)V$ARCHIVED_LOG for the standby destination as the time of…

Read More >

Dbatools and a SQL Agent

The mission: Tell every DBA around the world about a secret formula that will give them powers. What power do you think that is? Freedom! Freedom to go work on projects that you want to do versus constantly putting out…

Read More >

Datascape podcast episode 14 – the impact of automation on the DBA career

In this episode we are going to continue talking about the evolution of the DBA career, specifically as it pertains to automation. Today we are under more pressure than ever to automate our tasks. This is driven by cloud-first initiatives…

Read More >

Datascape podcast episode 1 – discussing the future of the DBA career

For much of my career as a DBA, I spent a lot of time working on issues that technology and software are eliminating. Issues like space management, performance management, building new systems and configuring complex availability options like Clustering. Why…

Read More >
Page 1 of 41234