Continuous Delivery and the Oracle database (III)

In this series of blogs about Continuous Delivery and the Oracle database, I describe how to automate deployments (installations). In the previous two Blogs I have described the tools and techniques used to create and install migration scripts.

In this Blog I will describe the ‘(un)happy flow’ for a database deployment: what to do if the deployment (installation) is correct (the ‘happy flow’) and what to do if it goes wrong (the ‘unhappy flow’)?

Introduction
(more...)

Samsung Phones with 6.01 Update and Failures on Email Sends, Social Media, etc.

I was surprised on April 20th when I awoke to find a 1.3G OS update on my Samsung Galaxy 6 Edge+.  I’d never experienced any issues with an update before, so I quickly connected my phone to the WiFi and let it download then upgrade my phone, anxiously awaiting what new Android features awaited me.

no_michael_bluth

It Broke

I proceeded through my day, but was concerned as battery (more...)

The Amazon Kindle Fire 10 HD Tablet

No, you didn’t get a review of my Samsung Tab S2….I didn’t have it long enough to review it!  Actually, I had it just over six months and yes, it was beautiful and yes, I love it and no, it didn’t survive the fall on the tile, even in the protective cover at Denver International Airport.

cring

Needless to say, I love my tablets and I’ve had a (more...)

Slow Fast Mview Refreshes



Today i was doing a small proof of a concept with a materialized view - i don't use these that often as use cases don't come up too much. In this particular case i was doing a test of what is/isn't possible when having a fast refresh-able mview on a table join.

For my initial basic test i just set up the following example (there are no PK's here -  not my choosing - it's (more...)

ANSI SQL with Analytic Functions on Snowflake DB

Here is another installment of my Top 10 blog list of cool features of Snowflake Elastic Data Warehouse: At Snowflake, we believe that it should be easy to access, query, and derive insights from your data. To support that, we provide our users with the ability to query all their data using ANSI compliant SQL […]

OTN Article: Oracle Database 12c: "Colección automática de estadísticas para cargas masivas"

Oracle Technology Network continue publish our article. My next article published OTN Latina in Spanish language.



You can read this article at : OTN Latina
Oracle Database 12c: "Colección automática de estadísticas para cargas masivas"


You can read this article also in English : http://otechmag.com/magazine/2015/winter/mahir-m.-quluzade.html


My special thanks my friends Joel and Sebastian ! 

Best Regards
Mahir M. Quluzade

Learning to answer questions for yourself!

notes-514998_640It’s not important that you know the answer. It’s important you how to get the answer!

I’m pretty sure I’ve written this before, but I am constantly surprised by some of the questions that come my way. Not surprised that people don’t know the answer, but surprised they don’t know how to get the answer. The vast majority of the time someone asks me a question that I can’t answer off the top of my head, (more...)

Improving PL/SQL performance in APEX

One of the simplest tuning techniques to encapsulate PL/SQL used in APEX within packages, minimising the size of anonymous blocks. This applies to any PL/SQL within the page, including computations, processes, plugins, dynamic actions, validations, shortcuts and dynamic PL/SQL regions.

This change can make a big impact in the execution time of PL/SQL as it's processed at compile time instead of interpreted at runtime.

Plug-ins can be wonderful black boxes and consumers may not care (more...)

Your New Favourite Band? Watch Straps Are Smart Too

At last wearable technology makers are getting it: The fashion or style dimension of wearable tech (or #fashtech) is critical to user acceptance and market success. 

They’re all at it now, hiring fashionistas left, right, and center to consult on, design, and wear their wearables. The hot wearabletech space at the moment is, of course, smartwatches with seemingly everyone offering a device (Swiss Army?) while now considering impact of how fashionable (more...)

Wearable Tech: Haptic Heartbeat UX

We know that user experience (UX) is increasingly an emotional concept and we need to design accordingly

UX is about how people feel about using applications. User experience design also enables us to express emotion too: Just look at the growth in popularity of emoji for example.

Here’s another emotional design feature I like: the Digital Touch capability on the Apple Watch that lets you share your own very heartbeat with another Apple Watch (more...)

Last week in Stream Processing & Analytics 4/18/2016

This is the 10th installment of my blog series around Stream Processing and Analytics.

Two days later than planned, was traveling and had again trouble with my power supply😦

So what happened in the world of Stream Processing? For me the most interesting news last week was the release of Storm 1.0.

I’m a  storm user for more than (more...)

PS360: A utility to extract and present PeopleSoft Configuration and Performance Data

Introduction

Lots of information about the configuration and operation of a PeopleSoft system is stored in the database.  Of course, most of the application itself is stored in the PeopleTools tables, for example, there are also performance metrics, particularly about batch processes.
PS360 is a new tool that I am working on that will use just SQL scripts to extract that data to flat files, and package them up in a zip file so that (more...)

EM13c- BI Publisher Reports

How much do you know about the big push to BI Publisher reports from Information Publisher reporting in Enterprise Manager 13c?  Be honest now, Pete Sharman is watching…. :)

george

I promise, there won’t be a quiz at the end of this post, but its important for everyone to start recognizing the power behind the new reporting strategy.  Pete was the PM over the big push in EM13c and has a (more...)

Collaborate’16: Slides are available

First, of all, I would like to thank everybody who came to my presentations on Collab'16! It was a pleasure talking FOR you :-) A lot of nice questions/comments/follow-ups.

Second, some SlideShare uploads (as promised):
- my talk about user-defined functions - that's where I was talking a lot about execution counts and the impact of Cost-Based Optimizer on them:
http://www.slideshare.net/MishaRosenblum/plsql-userdefined-functions-in-the-read-world

- updated version of my "Printing without Printers" talk. As usual, I (more...)

Oracle Security Vulnerability Scoring Metric Change (CVSS)

No, Oracle security vulnerabilities didn’t just get a whole lot worse this quarter.  Instead, Oracle updated the scoring metric used in the Critical Patch Updates (CPU) from CVSS v2 to CVSS v3.0 for the April 2016 CPU.  The Common Vulnerability Score System (CVSS) is a generally accepted method for scoring and rating security vulnerabilities.  CVSS is used by Oracle, Microsoft, Cisco, and other major software vendors.

As we have discussed previously (more...)

Oracle E-Business Suite 11i CPU Security Patches Only Available for Tier 1 Support Customers

Oracle E-Business Suite 11i is impacted by 8 security vulnerabilities in the April 2016 CPU, which includes the Oracle Configurator and Oracle Complex Maintenance, Repair, and Overhaul security bugs listed under the Oracle Supply Chain Products Suite.

Starting with the April 2016 Critical Patch Update (CPU), Oracle E-Business Suite 11i security patches are only available for Oracle customers with Tier 1 Support contracts, previously referred to as Advanced Customer Support (ACS).  Tier 1 Support (more...)

Oracle Cloud – DBaaS instance down for no apparent reason – (how archive log mode and storage shortage forced the instance to its knees)

My Oracle Public Cloud DBaaS instance did not respond. On closer investigation, it turned out to be down. Mounting the database ended with an ORA-3113 End of Communication Channel. Investigation of the startup log and the database alerts indicated that no new archive log files could be created. The DBaaS instance is in archive log mode – and has created quite a chunk of archive log files over the last few months – now causing (more...)

Using guaranteed restore points to navigate through time

Some months ago I worked on a project where we thought it would be a good idea to use multiple guaranteed restore points to be able to navigate through time back and forth. Sadly we ran into some unexpected behaviour of the Fast Recovery Area.

Prologue.

This was basically a consolidation project. A rather complicated one: many tables had to be read from five other databases and its data needed to be inserted into the (more...)

Column Groups

Patrick Joliffe alerted the Oracle-L list to a problem that appears when you combine fixed length character columns (i.e. char() or nchar())  with column group statistics. The underlying cause of the problem is the “blank padding” semantics that Oracle uses by default to compare varchar2 with char, so I’ll start with a little demo of that. First some sample data:


rem     Script:         col_group_char_bug.sql
rem     Author:         Jonathan Lewis
rem     Dated:          Apr 2016

execute  (more...)

The importance of cohesion

"Come on, come on, let's stick together" - Bryan Ferry

There's more to PL/SQL programs than packages, but most of our code will live in packages. The PL/SQL Reference offers the following benefits of organising our code into packages:

Modularity - we encapsulate logically related components into an easy to understand structure.

Easier Application Design - we can start with the interface in the package specification and code the implementation later.

Hidden Implementation (more...)