If you’re using AQ, then it’s simple to setup simple enqueue and dequeue facilities on your local database to provide all sorts of asynchronous style processing in your applications. As long as you’re applications are designed and built to handle it, the “fire and forget” model to keep user applications responsive, and all of the “heavy lifting” done in the background is a very attractive one.
You can also use AQ to achieve the (more...)
Last week we hosted a webinar about how PL/SQL developers can manage their PL/SQL code bases with Gitora
, the version control tool for PL/SQL. Many thanks to everyone who attended. You can watch the recording of the webinar and view the slides below.
The webinar consist of two parts:
1) Version Control Strategies for PL/SQL
2) Live Demo of GitoraVideo
Just back from completing my 3rd Florence Marathon (Firenze Marathon or Maratona di Firenze if you prefer). A great run around a fantastic city. I really enjoyed it and my finish time wasn’t too bad for my little legs.
While in Florence I noticed some great, localized Asics billboards for the event and they reminded me of how personal technology drives the adoption of what might seem to be “curious rituals” of behaviour, be it (more...)
So more on this cloud stuff then.....
Well in this case the work is just as applicable to a normal on premises configuration with 'standard' Active directory (other types of ldap directory can be used but i guess AD is the most widespread).
In this particular case (a follow up to my post on configuring HA for cloud control in Azure
) i now want to enable single sign on to this cloud control using (more...)
I'm a big fan of generating data with dual, using a perk of the connect by syntax.
I think Tom Kyte was the originator of this technique. It's not necessarily the fastest method, but it's super convenient - no table required.
Today I wanted to know how many weekdays a year, so I defined 365 rows on the fly using sysdate to turn these into each day of the year. Then I ran a simple (more...)
InfoDie Select-Statements in diesem Blogpost habe ich von anderen Webseiten kopiert. Daher ist dieser Beitrag eher als Zusammenfassung unterschiedlicher Lösungsversuche zu sehen und dient mir als schnelle Hilfe bei der Verkleinerung eines zu großen Tablespaces. Schaut euch die Quellen an, die sehr viel detaillierter auf die jeweiligen Probleme eingehen.
Wer kennt nicht die Situation? Der DBA ruft an und meint der TEMP Tablespace verbraucht mehrere hundert Gigabyte an Speicher.
Was ist in solch einer (more...)
Do you often find yourself not focusing at work? Or, you try to focus, but something else comes along and distracts you? I know how this feels. I’ve listed eleven ways to remove distractions and increase focus in this article. I’ve been able to improve my focus by removing some of the distractions I have […]
How can you delete a table in SQL? Learn how to do this by using the DROP TABLE statement in this article. How Can I Delete a Table in Oracle SQL? To delete a table in Oracle SQL (or any SQL for that matter), you run a statement called DROP TABLE. It’s called DROP because […]
Last week my kids’ school went on a field trip to the University of Santa Cruz to observe a black hole multimedia exhibition. We were invited there by Enrico Ramirez-Ruiz, the astrophysicist and the fellow parent at the school. When Enrico is not busy pushing the frontiers of science (he is impartial to violent explosions), he teaches astrophysics to children age 4 to 12.
The exhibition combined the visualized data from recent Extreme Mass (more...)
Thanks to all those who attended my session on “Policy Based Cluster Management In Oracle 12c” during Sangam16. I have uploaded my presentation here.
Your comments and feedback are always welcome.
You might be interested in this:
Here is another email we got Wednesday from a Dodeca Excel Add-In for Essbase customer. This customer has a lot of VBA macros running some automation with Essbase and asked for some assistance. We told it was as easy as replacing they Essbase function declarations file with our Dodeca Add-In function declarations file, and then setting the variables that contain the location for the Dodeca-Essbase server. In other words, replace this file:
With this file:
I was troubleshooting backup from standby databases and encountered an oddity which I wanted to verify.
Backing Up Archived Redo Logs with RMAN
Before beginning the backup, RMAN switches out of the current redo log group, and archives all online redo logs that have not yet been archived, up to and including the redo log group that was current when BACKUP command with any of the following clauses:
ARCHIVELOG FROM …
A bizarre one this week....
We upgraded one of our criticial production apps from 220.127.116.11 to 18.104.22.168 (+ latest PSU) and everything went well during the upgrade and seemingly afterwards too, that was until we had reports from the business that some data transfers from another system into this one were often being delayed.
After a bit of investigation we found the data was being pulled over by a (more...)
I’m off to UKOUG again this year. It’s an awesome conference, and I’ll be doing three talks there.
On Monday at 3:30 it’s my first keynote talk “12 Things You’ll Love About the Oracle Database 12.2”, followed up at 6pm by “AskTom – One Year On”.
On Tuesday, at 3:30 I’ll be doing a talk for anyone want to come up to speed on all of the partitioning features with “Partitioning 101”.
For automation of all of my processes I need Jenkins in my development server.
First I had installed Jenkins as Docker container via Vagrant Docker provider. But with this architecture it was very complicated to create docker images and run Docker containers on the Docker host, in this case my Vagrant Virtualbox.
So for simplification I have decided to install Jenkins with the provisioning of the Vagrant Virtualbox via a shell provider in my Vagrantfile:
A question that has come up while preparing to deliver another Exadata Optimisation Class is whether you can offload queries against Global Temporary Tables (GTT) or not. There are subtle differences between heap tables and GTTs such as how statistics are handled and where they are stored that merit a little investigation.
I have used the lab environment on the X3-2 (Exadata 22.214.171.124.0, 126.96.36.199.160419 RDBMS) to test (more...)