dbms_output and the scheduler

One of the nifty things in 12c is the ability to pick up DBMS_OUTPUT output from your scheduler jobs. So if you haven’t built an extensive instrumentation or logging facility, you’ll still have some details you can pick up from the scheduler dictionary views. Let’s look at an example


SQL> create or replace
  2  procedure do_stuff is
  3  begin
  4    dbms_output.put_line('Commenced');
  5    dbms_lock.sleep(30);
  6    dbms_output.put_line('Working');
  7    dbms_lock.sleep(30);
  8    dbms_output.put_line('Done');
  9   (more...)

Have fun #KScope16

Full and utter credit goes to the gang at CommitStrip, you should check it out.
http://www.commitstrip.com/en/2016/06/20/coder-bingo/

I thought a few choice replacements would help Joel Kallman and team rip into what I'm sure will be another stellar set of Sunday Symposium in Chicago.

Credit to CommitStrip, text modified from original

We'll be listening around the world, keep your tweet on.

Not a good day – so I am allowed to wallow in self pity – the final chapter


After parts I and II this is the final chapter.

I got to the airport hotel about 7pm, and just couldn't be bothered to eat. I should have done, I was entitled to British airways paying for it, but I was just too weary.

I also met people on the same flight as me from Belfast who were given £10 vouchers for outlets at the airport and no one offered me that. Probably they were (more...)

Processing large XML files in the SOA Suite by Emiel Paasschens

clip_image002Read large XML files in chunks

Introduction

At my current project, XML files are uploaded by the end-user to be processed in the Oracle SOA Suite. The XML files contain information about employers and their employees. Because an employer can have hundreds and even thousands of employees, these XML files can be quite large.
Processing such large XML files consumes a lot of memory and can be a bottleneck especially when multiple end users are (more...)

LittleArduinoProjects now with fancy catalog!

I keep finding new uses for GitHub Pages - situations where in the past I would otherwise have spun up a web site on heroku or similar. But if the site can be static, and especially if you are already hosting the git repository at GitHub, Pages are perfect.

For a long time, I've maintained the LittleArduinoProjects project index as a simple table in the README. But it wasn't particularly nice or usable, so I (more...)

Video : CASE Expressions and CASE Statements

Today’s video is about CASE expressions and CASE statements.

The guest in today’s video is Scott Wesley, who is currently plugging his new book called Pro jQuery in Oracle Application Express. He will no doubt use the vast quantities of money he makes from the books sales to throw outlandishly extravagant barbecues, because that’s all they do down under. 🙂

Cheers

Tim…


Video : CASE Expressions and CASE Statements was first posted on June (more...)

SOA & BPM 12.2.1 Installation and Configuration Workshop by John VanSant


clip_image002Overview of Workshop

This workshop will guide the participant through the installation of a non-development environment for SOA and BPM Suite v12.2.1. This workshop won’t cover the installation of the SOA Quickstart install, but the installation of the production software. Some notable differences between the Quickstart install and production bits are:

  • The Quickstart installer doesn’t require an Oracle Database but uses a Java Database. In order to use BAM, an Oracle Database is (more...)

On "random" CI failures

I closed a bug yesterday that's been kicking around for almost a year as a sometimes fails on CI but no-one can figure out why frustration.

Sooner or later you'll hear someone suspect it must be a problem with CI. Which is ironically funny in a shoot-the-messenger kind of way!

Thankfully our "CI issue" turned into a for-real bug. In short, the code involved many classes with near 100% test coverage. It had been read (more...)

Not a good day – so I am allowed to wallow – Part II


So I wrote part 1 at lunchtime to vent my frustration and hoped it would be followed up with, "I've arrived"

Not so

After two hours in one lounge and another two in the BA lounge my 1325 flight was delayed ten, twenty, thirty minutes and finally we boarded the plane. With a following wind I might, just might make the 1600 flight.

Seated, belted and then an announcement from the pilot (more...)

Are You Pursuing the Most Current Version of Oracle Identity Governance Certification?

The Oracle Identity Governance Suite 11g Essentials exam | 1Z0-459 and Oracle Identity Governance Suite 11g Certified Implementation Specialist certification retire on October 31, 2016. 

If you have been preparing for this exam, consider pursuing the more current Oracle Identity Governance Suite 11g PS3 Certified Implementation Specialist. Earn this certification by passing Oracle Identity Governance Suite 11g PS3 Implementation Essentials | 1Z0-339.

Keep your skills current.

Updates to Big Data Lite 4.5

There are some updates to Big Data Lite 4.5 that you will want to take advantage of: Updated Big Data SQL configuration enables predicate pushdown to engage - which can have pretty dramatic performance benefits Update to the Big Data Spatial framework (fixes a configuration issue) New... [Read More]

Top Reason I’ve Learned Everyone Should Use Delphix- Week 2

I’ve been going through some SERIOUS training in just over a week.  This training has successfully navigated the “Three I’s”, as in its been Interesting, Interactive and Informative.  The offerings are very complete and the knowledge gained is limitless.

I’d also like to send a shout out to Steve Karam, Leighton Nelson and everyone else at Delphix who’s had a hand in designing the training, (more...)

LAST CALL: 2016 Excellence Awards – Nominate TODAY!

It is nomination time!!!

This year's Oracle Cloud Platform Innovation – Excellence Awards will honor customers and partners who are creatively using Oracle products. Think you have something unique and innovative with Oracle Data Integration & Governance products?

We'd love to hear from you! Please submit today in the Data Integration & Governance category.

The deadline for the nomination is Wednesday June 30, 2016. Win a free pass to Oracle OpenWorld 2016!

Let’s reminisce a (more...)

Programming for Style and Beautiful Black Boxes – is Fast Performance an Afterthought?

Uncategorized
| Jun 24, 2016
June 24, 2016 I have been working with an Enterprise Resource Planning (ERP) system platform for a bit over 16 years.  Through various methods of observation, including the use of 10046 extended Oracle SQL traces, Process Monitor traces, Wireshark traces, and just general observation of the various components of the ERP system, I noticed a […]

INSERT into a View with a GROUP BY Clause

When I wrote the previous post, about updatable views, I noticed an interesting issue.

The documentation says:

If a view is defined by a query that contains SET or DISTINCT operators, a GROUP BY clause, or a group function, then rows cannot be inserted into, updated in, or deleted from the base tables using the view.

Let’s create a view with a GROUP BY clause and a group function:

ORA$BASE> create table t  (more...)

Debugging PL/SQL Collections Revisited

I talked about using the debugger to inspect a collection in PL/SQL using SQL Developer a few years ago. It’s been so long in fact that when Steven asked if I had a post on it, I said ‘no.’ We had gotten a question from a reader on how to look at collections while you’re debugging them. If you... [Read More]

Never …

From time to time a question comes up on OTN that results in someone responding with the mantra: “Never do in PL/SQL that which can be done in plain  SQL”. It’s a theme I’ve mentioned a couple of times before on this blog, most recently with regard to Bryn Llewellyn’s presentation on transforming one table into another and Stew Ashton’s use of Analytic functions to solve a problem that I got stuck with.

Here’s a (more...)

The Secret to Maximizing Your Oracle OpenWorld Experience

One day can make a huge difference. If you're already attending Oracle OpenWorld, get the most out of your conference experience by adding on Oracle University Preconference training.  

Oracle University Preconference training is a one-day event held on Sunday, September 18 at Golden Gate University near Moscone Center. Sessions run from 8:30 am-3:30 pm with an hour break for lunch.

Why attend? Because Oracle experts are on-hand to provide deep dives into accelerated technical (more...)

Master Oracle SOA Suite 12c by Lucas Jellema

clip_image002

Design, implement, manage, and maintain a highly flexible service-oriented computing infrastructure across your enterprise using the detailed information in this Oracle Press guide. Written by an Oracle ACE director, Oracle SOA Suite 12c Handbook uses a start-to-finish case study to illustrate each concept and technique. Learn expert techniques for designing and implementing components, assembling composite applications, integrating Java, handling complex business logic, and maximizing code reuse. Runtime administration, governance, and security are covered in this (more...)

Not a good day – so I am allowed to wallow in self pity


I am a global person, I travel a lot, I work in a global market and I believe in the EU. So the UK Brexit has hit me hard. Like Tim, I am going through grief, but I have the perfect distraction:

Today, I am meant to, fly to Chicago for Kscope16.

When I booked my flight, which is one of the events that is funded by my employer, I selected a route London (more...)