March 2016

Views as “stored text”

You’ll often see comments that views are not copies of the data, they are merely the stored text of a query that defines.

This is by and large true, but don’t forget, this is not  the same as saying we simply take whatever text you give us, and store it.

Let’s take a look at a simple example proving that this is not the case.

RMOUG’s Movie Night and WIT Panel

Last night I attended our RMOUG WIT’s movie night.  We partnered with Regis and the choice in movie has received a lot of great reviews, titled, Code-  Debugging the Gender Gap.

New Series of EM Blog Posts

One thing I like seeing is how people use Enterprise Manager. It’s one of the most enjoyable parts of speaking at conferences (apart from the social networking, of course), because quite often the users of Enterprise Manager find ways of using the product that we in Product Management might never have thought of. Sometimes that can lead to useful product enhancements, and other times it leads to much head shaking in disbelief (but since I don’t like exposing that side much you’ll have to grab me at a conference to hear some of those more “interesting” examples!)

Oracle Midlands : Event #14 – Summary

Last night was Oracle Midlands Even #14 with Lothar Flatz.

The session started with “Raiders of the Data Dictionary I: Indexing for the Workload” where Lothar discussed a project he worked on based around completely revamping the indexing of a system. I guess the best way I can describe it is to say it’s a more scientific approach to indexing, using the contents of the dictionary to provide information about columns and column groups used in queries to determine the indexes to create. In some ways the approach was quite extreme (throw everything away and start again), but I also admire the bravery of that approach!

Database dictionary corruption ? Maybe not.

At first glance, this looks like a major drama. Some sort of database dictionary corruption, or internal error. But we’ll see, it’s actually fine.

Let’s do a simple describe on an existing table


SQL> desc MY_TABLE
 Name                          Null?    Type
 ----------------------------- -------- --------------------
 EMPNO                                  NUMBER(38)
 ENAME                                  VARCHAR2(30)
 HIREDATE                               DATE
 DEPTNO                                 NUMBER(38)
 SAL                                    NUMBER(38)

Now of course, that could a synonym, or a view… so let’s also make sure that we are actually dealing with a real table.

Creating and Verify RSA SSH Keys

As we migrate to the cloud, secured credentials are starting to become a standard in most DBAs worlds.  If you don’t take the time to understand ssh keys and secured credentials, well, you’re not going to get very far in the cloud.

Hybrid Gateways and the Oracle Public Cloud with EM13c

This is going to be a multi-post series, (I have so many of those going, you’d hope I’d finish one vs. going onto another one and coming back to others, but that’s just how I roll…:))

Quiz

Can you spot anything that might appear to be a little surprising about this (continuous) extract from a trace file ? The example is from 10.2.0.5, but 11g and 12c could produce similar results (or direct path read equivalents):

Gluent New World: In-Memory Processing for Databases

As Gluent is all about gluing together the old world and new world in enterprises, it’s time to announce the Gluent New World webinar series!

The Gluent New World sessions cover the important technical details behind new advancements in enterprise technologies that are arriving into mainstream use.

These seminars help you to stay current with the major technology changes that are inevitably arriving into your company soon (if not already). You can make informed decisions about what to learn next – to still be relevant in your profession also 5 years from now.

Think about software-defined storage, open data formats, cloud processing, in-memory computation, direct attached storage, all-flash and distributed stream processing – and this is just a start!

OGh DBA Day – Call for Papers!

While part of this packed event is already underway (SQL Celebration Day bit), the DBA…