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 ;-)
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;
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:
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
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;
Setting DBMS_STATS Environment
Hi Reader,
with Oracle 10g all default parameters of the DBMS_STATS package are defined as default in the data dictionary accessible with the DBMS_STATS GET_PARAM Method :
Tuning Leading '%' Queries - a simple approach
Hi reader,
usually queries using LIKE and leading '%' cannot be indexed. So an idea would be to mirror the string content with the string reverse function to be able to put the '%' operator at the end :

