Tag Archives: database

Getting started with the new observability exporter for Oracle database

My colleague Paul Parkinson recently published our new unified obserability exporter for Oracle Database on GitHub, you can read about it here. I wanted to start playing around with it to see what we can do with it. In this … Continue reading

Posted in Uncategorized | Tagged , , , , | Leave a comment

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

Posted in Uncategorized | Tagged , , , , , , , , | 11 Comments

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!  

Posted in Uncategorized | Tagged , , , , , | Leave a comment

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

Posted in Uncategorized | Tagged , , , | Leave a comment

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

Posted in Uncategorized | Tagged , , , | Leave a comment

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

Posted in Uncategorized | Tagged , , , , | Leave a comment

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

Posted in Uncategorized | Tagged , | Leave a comment

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

Posted in Uncategorized | Tagged , , | 1 Comment

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

Posted in Uncategorized | Tagged | 3 Comments

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

Posted in Uncategorized | Tagged | 1 Comment