The A-Team Chronicles
Our other publications
Building a Custom BPM Worklist, Oracle InSync 2011 User Group presentation
Performance Tuning for Oracle Business Process Management Suite 10g, Oracle Whitepaper, July 2011
Performance Tuning for Oracle Business Process Management Suite 11g, Oracle Whitepaper, February 2013
Oracle BPM Suite 11g: Advanced BPMN Topics, Packt Publishing, September 2012
Fusion Middleware 12.1.2: Developing Applications with Continuous Integration
Fusion Middleware 12.1.3: Developing Applications with Continuous Integration
Tag Archives: database
Getting to know Docker – a better way to do virtualization?
In this post, with guest co-writers Edwin Biemond (@biemond) and Joel Nation (@joelith), we will explore virtualization with Docker. You may have heard of Docker, it is getting a lot of interest lately, especially with the recent announcement that Google … Continue reading
SOA/BPM 11g purging whitepaper
The long awaited whitepaper on purging SOA/BPM 11g databases by Michael Bousamra with Deepak Arora and Sai Sudarsan Pogaru has been released and is available here. I recommend you take a look!
Getting started with tuning your SOA/BPM database using AWR
Update: When I initially published this post, I was relying on information from a single source inside Oracle, however since publishing it, I have been discussing the content further with other sources in the Oracle community, and in the course … Continue reading
Purging old instance data from SOA/BPEL 10g
My colleague Deepak Arora (see his blog here) has written an excellent white paper on purging old instance data from SOA Suite/BPEL 10g and also a great blog post on automating the deletion of old partitions. If you are interested in … Continue reading
Purging old instance data from SOA/BPM 11g
When you are running a lot of instances of your composites through SOA/BPM 11g in your testing/development environment, you will start to fill up the available space in your database with the logging and auditing information for these instances. From … Continue reading
Recovering an Oracle database after doing something bad to your SPFILE
Well it has been over a year since the last time I broke my database, but I did it again today! This time I increased the sga size without also increasing some other parameter, and the database would not start, … Continue reading
Running JDeveloper 11g and Oracle database on Mac OS X
A quick note to my fellow Mac OS X users who want to use JDeveloper 11g to do development and testing on Mac OS X. I found the newly released JDeveloper 11g (the one that came with the Fusion Middleware … Continue reading
Free space in Oracle tablespaces
I occasionally want to know what tablespaces I have defined, how big they are and how much free space is available. Thanks to Praveen at http://www.expertsharing.com/2008/02/26/calculate-size-of-tablespace-free-space-of-a-tablespace/ for providing the following query, which makes this information available easily. set pages 999; … Continue reading
Database won’t start because of missing datafile
I had a situation today where my database would not start because “someone” had deleted a datafile. While deleting the datafile at the OS level was probably not a particularly good decision, things like this do happen occasionally, so how … Continue reading
Restoring an Oracle database backup to another version of the database
Picked up a handy little tip. If you want to move a bunch of data from one Oracle database to another, you can use the exp and imp utilities to dump the data and restore it respectively. But what if … Continue reading
