The 11g Oracle DBA can now apply an invisible performance patch (an Invisible Index)
on a non-performing query on a production system, without any impact on other queries.
Invisible indexes are not considered by the optimizer. These indexes are only used with a hint.
Here is a demo.
SQL> conn scott/tiger
Connected.
SQL> select * from cat;
TABLE_NAME [...]

Popularity: 181 points

Flashback Data Archive (track all changes to a record over time).
For flashback data archive you need a tablespace first.
In this demo I have created a tablespace named testarea1
Now I can create a Flashback Archive with:
CREATE FLASHBACK ARCHIVE DEFAULT fla1 TABLESPACE testarea1
QUOTA 10G RETENTION 1 YEAR;
Flashback archive created.
You can Remove the Flashback Archive as well with:
DROP [...]

Popularity: 281 points

One of the great new 11g features is SQL Replay.
You can use the SQL Replay Advisor to analyze the SQL performance impact of any type of system changes. (E.g. Database or Application upgrade, OS changes, Schema changes, database parameter changes, SQL Tuning like using a SQL profile).
How does SQL Replay work? Basically the SQL Replay [...]

Popularity: 418 points

Two weeks a brand new Eclipse called Europa has been released.
This release is just as the previous one (Callisto; version 3.2) a combination a range of of Eclipse projects.
So this release is not only one for the Java IDE, but also the Web Tools Platform (WTF), Eclipse Modeling Framework (EMF), CDK, Eclipse Dynamic Language [...]

Popularity: 257 points

Yesterday Oracle launched the Oracle 11g Database during a live webcast from New York.
This morning we received the mail that our non-disclosure agreement time is over. We can finally start blogging about the Oracle 11g Database. As a Beta Tester LogicaCMG tested already several of the new-hot features of the Oracle 11g Database.
My personal top [...]

Popularity: 279 points

This is the final day of the conference. The space shuttle should return from space this afternoon, but the whether is too cloudy and rainy. They properly need to stay up there for an extra day or two.
Down on earth the presentations continued with Duncan Mills from Oracle Corporation, speaking about ADF bindings and how [...]

Popularity: 157 points