March 2016

This Gluent New World webinar is based on my RAM is the new disk and how to measure its performance article series:

• RAM is the new disk – Introduction
• RAM is the new disk – tools for measuring CPU efficiency and RAM access
• RAM is the new disk – Columnar vs Row-oriented data access test results

I’m using the Oracle Database In-Memory option as an example here, but the same rules apply to other row & column stores as well.

I’ve written a bunch of stuff about WebLogic over the last few years, but it’s kind-of scattered throughout the site. When I was gearing up for my session at the Middleware SIG recently I figured it was about time I collected it all together, so I added a new WebLogic page to the site. It’s on the menu and the quick links.

Much the same as the SQL and PL/SQL pages, it really is just a bunch of links to other stuff. I tend to put my articles in version-specific locations, because it suits me, but I realise it’s not ideal for everyone. I think this gives me the best of both worlds.

Introduction

The oracle alert.log and listener.log contain useful information to provide answer to questions like:

• When did the Instance start?
• When has the Instance been shutdown?
• When did ORA- occur? With which code?
• Which IP client did connect to the Instance? With which user?
• How did it connect? Through a service? Through the SID?
• Which program has been used to connect?
• A connection storm occurred, what is the source of it?

What about having all this information centralized? What about having the possibility to gather, format, search, analyze and visualize this information in real time?

To achieve this, let’s use the ELK stack:

I recently recorded an interview with Dan Iverson and Kyle Benson for the PeopleSoft Administrator Podcast. It has been spread over three episodes. There is lots of other good stuff on the website and other episodes that are well worth listening to.

(25 March 2016) #21 - Temporary Tables