Entries in Oracle Server (2)
Oracle 12 the Green Database - Oracle 12 Eco
Posted on Tuesday, October 14, 2008 at 12:54PM
by
Karl Reitschuster
in Architecture, CBO, FUN, News, Oracle Server
|
Post a Comment
| 
Email
Karl Reitschuster
in Architecture, CBO, FUN, News, Oracle Server
|
Post a Comment
| Email
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;
Oracle 11g : A deeper granularity level to SQL performance metrics
Posted on Wednesday, April 2, 2008 at 07:35AM
by
Karl Reitschuster
in Oracle Server
|
Post a Comment
|
3 References
| Email
Karl Reitschuster
in Oracle Server
|
Post a Comment
|
3 References
| Email
With Oracle 10g Oracle introduced a new key column spread over the dynamic performance views - the SQL_ID; The SQL_ID identified a SQL statement. The SQL_ID was needed to persist all performance metrics of a specific SQL statement in a repository. With Oracle 11g the granularity even gets deeper. With the new columns SQL_EXEC_ID and SQL_EXEX_START performance data could be collected of a specific execution of a specific SQL statement! What a quantum leap in monitoring!
