Old ventures and new adventures

I have some news, two items actually.

First, today (it’s still 18th June in California) is my blog’s 8th anniversary!

I wrote my first blog post, about Advanced Oracle Troubleshooting, exactly 8 years ago, on 18th June 2007 and have written 229 blog posts since. I had started writing and accumulating my TPT script collection a couple of years earlier and now it has over 1000 files in it! And no, I don’t remember (more...)

Create #em12c users fast and easy!

Over the last few months, I’ve been working a project where I’ve started to dive into EM CLI and the value that EM CLI brings to cutting down on doing things like creating Enterprise Manager users. Hence the reason for this post.

Note: If you haven’t looked into EM CLI yet, I encourage you to do so. A good starting point is here. Plus there is a whole book written on the topic by some (more...)

Was I Mentioned During Oracle’s Q4 2015 Results Call?

hurd

In a proud moment for me, it appears that Mark Hurd, CEO of Oracle, has mentioned my flashdba blog during the Oracle Q4 2015 results call. At least, that’s what I’m reading into this section from the transcript published by Seeking Alpha:

We grew in storage in the quarter and this is — really we are going through a shift in storage now. We released our SAN product FS1 in the quarter which (more...)

How to configure Power Distribution Units on Exadata X5

I’ve done several Exadata deployments recently and I have to say of all the components PDUs were hardest to configure. Important to notice that unlike earlier generations of Exadata the PDUs in X5 are Ehnanced PDUs and not Standard.

Reading the public documentation (Configuring the Power Distribution Units) it says that on PDUs with three power input leads you need to connect the middle power lead to the power source. Well I’ve done (more...)

Please Sell

Oracle's financial results for Q4 of their fiscal year 2015 came out a few minutes ago.  Seems they missed targets on license revenues and earnings per share.  So the stock may be headed for the professional investor's dog house.  I've even read of an analyst or two publishing a "sell" rating on Oracle stock.

Geez, please sell.  Drive the price down.  I can buy some more shares on the cheap and laugh all the way (more...)

Oracle Enterprise Manager Cloud Control 12c Release 5 (12.1.0.5) : My first two installations

em-12cI’ve done a couple of play installations of EM12c 12.1.0.5, just to get a feel for it. You can see the result of that here.

From an installation perspective, everything was pretty similar to the previous releases. I tried the installation on both OL5 and OL6, in both cases using 12c as the database repository. (more...)

Reverse Key

A question came up on the OTN database forum recently asking if you could have a partitioned index on a non-partitioned table.

(I’m not sure whether it would be quicker to read the manuals or try the experiment – either would probably bothere quicker than posing the question to the forum. As so often happens in these RTFM questions the OP didn’t bother to acknowledge any of the responses)

The answer to the question is (more...)

Integration Is Hard

If you know me at all, you know I love services-based integration.  The whole idea of interfacing, moving and exchanging data, guided by industry standards...I'm an enthusiastic supporter.  The appeal of this idea made me an ardent supporter of Oracle's Fusion Applications.  And I still believe it's an important part of the potential for today's SaaS offerings.

So I'll share a secret with you...I really hate services-based integration.  It's hard.  Packaged integrations rarely (more...)

A Database Wordfile…

It is not often that something like the following happens on Google while searching for…

Ansprechend auf allen Kanälen: Cross-Media-Marketing

Werbung nervt? Techniker und Einkäufer sind allergisch gegen Marketing? Nein! Aktuelle Studien zeigen, dass B2B-Entscheider für gezielte und relevante werbliche Kommunikation heute offener sind, denn je. Auffallend hoch ist dabei das Vertrauen in starke und bekannte Marken. Auf einem zunehmend unübersichtlichen und komplexen Markt stehen diese klar für Orientierung und Qualität.

Allerdings sieht zielführendes Marketing heute ganz anders aus, als noch vor wenigen Jahren. Der Grund: Im Web-Zeitalter ist die Zahl der möglichen Kommunikationswege explosionsartig (more...)

Groovy Tuesday: Threshold Errors and Setting Field Values

This article is a quick tip that I discovered whilst writing a script for an unrelated testcase.

When writing integrations you don't not always know how much data you are going to get back from an API. You'll test it of course, and hopefully get some good ideas based on its specification, but we all know if complexity and variation can get in, then they will.

So whilst you should ensure your calls limit the (more...)

New Enterprise Manager Release Allows Customers to Manage Their Hybrid Cloud from a Single Interface

Oracle is today announcing Oracle Enterprise Manager 12c Release 5, which simplifies the journey to the cloud.  For the first time, you will be able to manage your hybrid cloud as one, from a single pane of glass.

According to a recent Computerworld survey, cloud consumers are struggling with security issues, integration headaches and performance concerns in public and hybrid cloud environments.

The latest release of Oracle Enterprise Manager addresses these concerns through new (more...)

Oracle Enterprise Manager Cloud Control 12c Release 5 (12.1.0.5) is Ready to Download

Enterprise Manager Cloud Control 12c Release 5 is avaliable to download. The new release is designed to monitor and manage both your on-premise and Oracle Cloud deployments which is called “Hybrid Cloud” by Oracle. You can deploy Management Agents onto the Oracle Cloud virtual hosts to manage Oracle Cloud targets just as you would any other targets. EM12c R5 also supports data cloning between on-premise and Oracle Cloud. Integration with Oracle Enterprise Manager Ops Center (more...)

Why you don’t want to set _partition_large_extents = FALSE

I've seen some blogs recommending that _partition_large_extents be set to FALSE for a variety of space conserving reasons without the authors thinking about the negative impact this is going to have on Smart Scan. Large Extents cause an INITIAL allocation of 8 MB and a NEXT allocation of 1 MB and they have been the default for table spaces on Exadata since 11.2.0.2. You can verify that large extents are in use by (more...)

Dynamic Sampling

Following on from an OTN posting about dynamic sampling difficulties I had planned to write a blog post about the difference between “not sampling when hinted” and “ignoring the sample” – but Mohamed Houri got there before me.

It’s just worth highlighing a little detail that is often overlooked, though: there are two variations on the “dynamic sampling” hint, the cursor level and the table level, and the number of blocks sampled at a (more...)

CBO Series

About a year ago I came across a couple of useful articles from Stefan Koehler, which is when I added his name to my blog roll. As an introduction for other readers I’ve compiled an index for a series of articles he wrote about the CBO viewed, largely, from the perspective of using Oracle to run SAP. Today I realised I hadn’t got around to publishing it, and there’s been a couple of additions since (more...)

Surfs Up! #KScope15 Beach Club: Opening Soon!

I know this is last minute but wanted to remind everyone that the Annual ODTUG KScope event starts in less that a week! As always, I will be there with my ACE Director hat on (literally). I will be giving My Talks at KScope during the week. One on SQL Developer Data Modeler (SDDM), and […]

Oracle Database 12c: Interactive Quick Reference

12c DB Architecture


© Eddie Awad's Blog, 2015. | Permalink | Add a comment | Topic: Oracle | Tags: ,

Log Buffer #427: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers various blog posts from the last week regarding Oracle, SQL Server and MySQL.

Oracle:

  • Merging Overlapping Date Ranges with MATCH_RECOGNIZE
  • The latest version of Enterprise Manager, EM 12.1.0.5, has been announced!
  • Kdump is the Linux kernel crash-dump mechanism. In the event of a server crash, Kdump creates a memory image (vmcore) that can help in determining the cause of the crash.
  • APEX Connect Presentation and Download of (more...)

Mac SQL Developer Install

This how you install SQL Developer on Mac OS Yosemite. The first thing you need to do is download and install Java 8, not Java 7 on your Mac OS Yosemite, as suggested on some web sites. You can determine whether or not Java is installed by running the following command:

Mac-Pro-3:~ username$ java -version
No Java runtime present, requesting install.

You must accept the Java license to install Java 8 on the (more...)