- Oracle 12c CDB – metadata & object links internals: erläutert die grundsätzliche Problematik mit Daten, die über Container-Grenzen hinweg sichtbar sein sollen, sowie die Rolle des Parameters _oracle_script und die Verwendung von "Metadata links" und "Object links".
- 12c Multitenant internals: AWR (more...)
I had decided to move one of my blogs to a self-hosted model to get more control over plugins and other things. After reading up a bit on different vendors I found Digital Ocean to be my choice. What’s not to like with a place that can spin up a complete Linux with WordPress installed and ready for me to use? Yes, it only takes them seconds and it is powered by SSD. Adding that (more...)
Q6: How do you instrument your code?
Hopefully those in the 22% who do not add instrumentation just didn't understand the question.
Instrumentation is another term for adding debugging information to your code. There is plenty of commentary on this topic and done right it can make tracking down problems a breeze.
It can be as simple as knowing when a procedure (more...)
I have got a website with a search form. I want to display a limited number of results to the user and have him/her navigate through different pages. Is this possible using plain SQL?
Of course this is possible. It might take some thinking, but that has never hurt anyone (yet). First we need a table with some randomly sorted data in it. In this example I (more...)
Even though a space is a regular character, the client didn't want spaces at the beginning or end of a string. Any spaces in the middle were fine.
Of course this could be handled by the application, but it must also be implemented in the database. Using a check constraint with a regular expression will prevent the end user from entering unwanted data.
To try things out, let's just start with a simple table with (more...)
Just a short post to announce that I’ll be presenting an User Group Forum session. Thanks ODTUG!
“In this session learn about the new Java-based command line interface that takes advantage of Oracle SQL Developer’s scripting engine. It delivers a modern command line interface that is backward compatible with SQL*Plus but also introduces new commands and features that have been missing for a long (more...)
He had done all the right things in regard to debugging the problem, but didn't know enough about APEX to know which settings to investigate.
I think developers new to APEX need the occasional post like this to give them an idea on how to start looking into a (more...)
Tuesday, September 20, 2016
5:00 PM to 7:00 PM
138 Minna Street, San Francisco, CA (map)
Oracle OpenWorld is a time for us to join together and learn all about what Oracle has to offer. But let’s get real, it’s always nice to get free beer. To help show us a good time here in San Francisco, our good friends in the Oracle ADF and Database developer group are planning a Oracle Developers (more...)
Because my hero is Cary Millsap, I'm going to do what he did and publish my
Brendan Tierney and (more...)
As does seem to occur from time-to-time, I’m out there in the weeds again and sorting out a solution that fits a customer’s need. They wanted to know if they could write Oracle EBS 12.2 Concurrent Manager Programs in Ruby. They don’t want to write Java.
Logging is a very useful feature of WebLogic.
Unfortunately the log levels, which are set after a clean install of WebLogic or some of the Fusion Middleware product creates a lot of noise and therefore it costs I/O performance.
Additional after analyzing an issue with logging often resetting the log level is forgotten.
Here you get a script to reset the log levels at regular intervals or after a trace session.
#!/usr/bin/python execfile('get_environment.py') (more...)
Virtual Development Server: Add swapfile to VirtualBox as requirement for installing Oracle or build Oracle docker images
As I want later build Oracle docker images, some of this need a swapfile.
Per default my used Vagrantbox, does not have one, so later steps will fail.
As in the last blog I use a Vagrant shell provider.
... # add swapfile to the box config.vm.provision :shell, :path => "add_swap.sh" ...
This calls the script add_swap.sh in the created VirtualBox machine.
Make sure, that you create your swapfile on a supported (more...)
update sqlfail set last_posting_date = date'2016-08-18';
It’s been a while since I’ve published here. You see, I’ve been kind of busy.
Back in January 2015 I was lucky enough to join Oracle as part of their Developer Advocate team. My focus is SQL.
You see I love working with SQL. And I love helping others. So joining the Developer Advocates was a great chance to combine these passions :)
Which leads some to ask:
Why is your site (more...)
JavaOne and OOW 2016: You Don't Want to Miss These Sessions
If you are attending JavaOne and/or Oracle OpenWorld, here are my sessions recommendations.
If you need to send almost any message to almost any phone from your Oracle database, and you want to use straight PL/SQL, you may want to consider using my Clicksend API.
- SMS (Short Message Service)
- MMS (Multimedia Message Service)
- Text to Voice
I have released the first beta version of my Oracle PL/SQL API for Clicksend. Read the installation instructions, API reference and download the release from here:
Sending an SMS is as (more...)
- Nested Loops Join Batching: seit 11g die häufigste Variante. Im Plan erscheinen zwei Nested Loops steps: zunächst (more...)