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
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...)
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...)
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:
Quickstart installer doesn’t require an Oracle Database but uses a Java
Database. In order to use BAM, an Oracle Database is (more...)
So I wrote part 1 at lunchtime to vent my frustration and hoped it would be followed up with, "I've arrived"
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...)
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
New... [Read More]
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...)
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 […]
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:
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]
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.
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...)