Extract Database Object Header Comment with Powershell

Some database objects in my current project are created by ORM or a PL/SQL-framework and hence need not to be put under source control; All manual created objects are strictly stored in source control.

Every database object definition under source control is stored as DDL file. And every file starts with a comment about the database object properties. Once an object is created in database and it's definition is added to source control it's time to automate some repeating stuff like creating a comment header. For the current project I use Windows Powershell for this. All stuff which needs to be generated is done via PL/SQL. The return value of these functions is very simple : a collection of strings.

Click to read more ...

Access Oracle Database with Windows Powershell 2.0

Updated on Tuesday, February 2, 2010 at 08:31AM by Karl Reitschuster

This year I plan to implement database build automation. There are lot of manual tasks for a developer DBA to create and deploy a release package.
I decided to use the Windows Powershell as build tool. it integrates best in the Windows environment to access ...

Click to read more ...

Upgrading from Oracle Database 10g to 11g: What to expect from ...

Almost 3 years after introducing Oracle 11g Release 1 Oracle posted a white paper migrating CBO from Oracle 10g to 11g; Ok - better late then never. There are a lot of topics so the white paper is well recommended to read; you will find it here

/Karl

Converting Timestamp to Date ...

Hi reader,

i needed to convert the date fraction from a times tamp type variable; Usually the way is to convert the time stamp to string and then to convert it back to date; Hmmm ... . This looks not very elegant ;-)

Click to read more ...

Oracle 11g Release 2 coming soon

Hi,

got an E-Mail for a Oracle 11g Release 2 Roads how.

It seems 11.2 is coming soon; Most interesting which platforms will be served first. A lot of platforms even had no 11.1 release deployed. for example Mac OS X, Sun Solaris X86_64, ...

Our environment running with 10.2 will be candiates for 11.2!!

/Karl

Oracle 10.2.0.4 for for MAC OS X on Intel x86-64 released

 

Hi Reader,

i could not believe it;

but it's true. Oracle continues to develop Oracle Server on Mac OS X; and shipped now Oracle 10.2 for OSX;

Here the download link : Oracle Database 10g Release 2 (10.2.0.4.0) for MAC OS X on Intel x86-64

and much thanks to Oracle;

/Karl

PS.: there are some restrictions to the release - for example DbConsole would not work ...

Zone Alarm !!!

Hi,

the title is not a title of a Science Fiction film or of a Hackers memories intruding networks or a gaming title but is SUN Solaris related. SUN Solaris 5.10 introduced a virtualization concept called Zones. A Zone is like a logical/virtual machine on a SUN Server Hardware. Zones are nearer bound to resources then for example a VM like VMware or Parallels (on Mac); This keeps the frictional loss of resources lower.

At our customer site database servers are driven in SUN Solaris Zones. Resources dependend on the implementation of a zone could be shared between the Zones. Hardware is better utilized.

But one drawback is here - it's to specify performance;

Click to read more ...

Terracotta - the return of OODBMS?

Do you remember?

About 10 years ago OODBMS (Poet, Gemstone, Versant, ...) seemed to be starting to replace RDBMS; The idea for using OODBMS was simple - if the programming model is OOP why not persist Objects with an OODBMS directly instead of populating it's properties and class hierarchy into a couple of tables? It was the reason Oracle 8 came with object relational features; But they (OODBMS) failed for following reason:

Click to read more ...

Tanel Poders - Snap it!!!

Tanel Poder holds a 2 day session in Düsseldorf last week; This was not my first Tuning/Troubleshooting training. But it was extraordinary what Tanel showed us when usual ways would not work

Click to read more ...

Oracle 12 the Green Database - Oracle 12 Eco

Now living in a time of financial crisis and a growing gap of natural resources
a new paradigma - a new database paragdima is needed.

For Oracle 12 i think this could be Oracle 12 Eco;

Click to read more ...