Tag: DBA Lounge

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 >

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 retrieve growth history for oracle tablespaces

A customer recently asked us to identify tablespaces that most contributed to sudden space consumption on ASM. It’s easy enough to find what’s using the most space, but finding what’s been growing is a little less straightforward. Fortunately, Oracle keeps…

Read More >

Listener over Infiniband on Exadata (part 1)

Nice topic, right? Beautiful thing to work with when you have Oracle Engineered Systems. So, why would you configure a listener over the InfiniBand Network? How does that make sense in your environment and how would you leverage that? Background…

Read More >

Shutdown while upgrading to 18c

My colleague and friend Gleb Otochkin has already blogged about installing 18c – Installing Oracle 18c using command line – but I thought that I would share my experience. My plan was to upgrade my 12.2 pluggable database to 18c…

Read More >

Azure SQL managed instance: new member of the family!

SQL Server is one of Microsoft’s strongest enterprise software products. Both in terms of revenue and industry reputation, it is widely adopted for its ease of use while at the same time offering high end features in terms of security,…

Read More >

Oracle service secrets: migrate transparently

In the third post in this series, Bjoern Rost, Principal Consultant at Pythian, explains how to migrate transparently using Oracle services.

Read More >

InnoDB flushing and Linux I/O

Ivan Groenewold, MySQL Database Consultant at Pythian breaks down InnoDB flushing and Linux I/O.

Read More >

When the default value is not the same as the default

Bjoern Rost, Principal Consultant at Pythian, explains what steps to take when the default value is not the same as the default.

Read More >

An UNDO in a PDB in Oracle 12c?

Fred Denis, Pythian Oracle Database Expert, challenges the idea that there can be only one UNDO tablespace in a multi-tenant architecture.

Read More >
Page 1 of 6112345...10...Last Page »