view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

Describing Performance Improvements (Beware of Ratios)

Recently, I received into my Spam folder an ad claiming that a product could “...improve performance 1000%.” Claims in that format have bugged me for a long time, at least as far back as the 1990s, when some of the most popular Oracle “tips & techniques” books of the era used that format a lot to state claims.

Beware of claims worded like that.


Oracle User Group in Thailand(OUGTH) has been developed since 2010, after we had been developed Oracle in Thai (Oracle Community in Thailand) since 2009. We changed web be and we develop this web as central for person who interest and use Oracle Products in Thailand.

Exadata Part III: Compression

With this posting, we look at the New Feature Hybrid Columnar Compression that is only available with the Exadata Database Machine, offering stunning compression ratios together with high query speed. Meanwhile we have not less than 6 different kinds of Table Data Compression methods: BASIC compression, introduced in Oracle 8 already and only recommended for [...]

Oracle SQL Developer 3.0 Early Adopter 3 Available

SQL Developer 3.0 Early Adopter 3 is available for download.
The main new features is the integration with SQL Developer Data Modeler 3.0, providing read and write access for designing and developing data models
(The readme.html for SQL Developer Data Modeler 3.0 can be found in the SQL Developer installation in the folder \sqldeveloper\sqldeveloper\extensions\oracle.datamodeler).

Full new feature list.

Oracle Critical Patch Update - January 2011

This week Oracle release the latest
Oracle Critical Patch Update Advisory.
As usual :"Due to the threat posed by a successful attack, Oracle strongly recommends that customers apply CPU fixes as soon as possible."
It fixes some remotely exploitable bugs without the need for username and password.

Nulls the novice and experts trap

Novices and experts alike can fall in the null's hole.

In Oracle there are many reasons for that:

Ler mais /

Strok Project

Two days ago I was presented to the Strok Project (and no, it's not a project to bring babies :-) ). To put it simple: it's a project to make secure electronic identity across Europe using the national eID.
It's a great way to allow a person to validate against government sites, enroll to university courses (Erasmus for example).
If you are in Europe and like eID check it's already being

Missing the point: Developer versus Designer

Did you ever experience a situation like that? :-)
Maybe not with a designer, ...

Books and presentations

As you probably know that my first co-authored book Expert Oracle Practices was released in 2009. I have co-authored one more book Pro Oracle SQL with my esteemed colleagues. This books covers many aspects of better SQL development. Have fun reading :-)

view counter