Archive for the 'Oracle Infrastructure' Category

I Struck Oil at Miracle Oracle Open World 2007

Tuesday, October 2nd, 2007 by Yuri van Buren

This was my second time at the Miracle Conference at Lalandia in Denmark.
Again it was “power-pact”.
Mogens Norgaard explained that a lot of conferences have about 80% information and only 20% networking possibilities. This conference is different. Mogens managed to increase the 20% networking up to 80% while still remaining 80% of usefull information. The way [...]

Popularity: 329 points

Blogging about 11g - Part 10 - Enhanced Optimizer Statistics Maintenance

Tuesday, September 25th, 2007 by Yuri van Buren

In Oracle 11g you now can modify gather_database_stats default values with set_global_prefs, set_database_prefs, set_schema_prefs, set_table_prefs in the dbms_stats package.
An even greater new feature is that in Oracle Database 11g, you can separate statistic gathering from statistic publishing.
This allows you to control when new statistics are published. Everybody must have run in to this once, [...]

Popularity: 265 points

Blogging about 11g - Part 9 - Password Complexity Checker

Friday, August 31st, 2007 by Yuri van Buren

In Oracle 11g you can enable the built-in Password Complexity Checker function.
Background info can be found in the Database Security Guide.
The Oracle Database provides a sample password verification function in the PL/SQL script UTLPWDMG.SQL
(located in ORACLE_BASE/ORACLE_HOME/RDBMS/ADMIN) that, when enabled, checks whether users are correctly creating or modifying their passwords. The UTLPWDMG.SQL script provides two password [...]

Popularity: 417 points

Blogging about 11g Part 8 - Interval Partitioning

Friday, August 24th, 2007 by Yuri van Buren

DBA’s can finally use the Automatic Interval Partitioning option.
Test steps following the Oracle By Example (OBE) scripts available at
http://otnbeta.us.oracle.com/db11gr1/trng/obes/index.htm:
– create interval partitioned table
create table newsales
( prod_id number(6) not null
, cust_id number not null
, time_id date not null
, channel_id char(1) not null
, promo_id number(6) not null
, quantity_sold number(3) not null
, amount_sold number(10,2) not null
)
partition by range [...]

Popularity: 256 points

Blogging about 11g - Part 5 - SQL Plan Management

Monday, August 20th, 2007 by Yuri van Buren

The new 11g SQL plan management feature enables the optimizer to maintain a history of
execution plans for a SQL statement. Using the execution plan history the optimizer is
able to detect a new plan representing a plan change for a SQL statement. When the
optimizer detects a new plan, it stores the new plan and marks it [...]

Popularity: 241 points

Blogging about 11g - Part 3 - Flashback Data Archive a.k.a. Total Recall

Tuesday, July 24th, 2007 by Yuri van Buren

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: 318 points

Blogging about 11g - Part2 - SQL Replay

Wednesday, July 18th, 2007 by Yuri van Buren

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: 513 points

Blogging about 11g - Part1 - The Launch

Thursday, July 12th, 2007 by Yuri van Buren

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: 305 points

New OraSRP in Beta Online

Thursday, February 22nd, 2007 by Yuri van Buren

I just spotted on Howard J Rogers blog (www.dizwell.com) that Egor Starostin has put a new Beta version of its excellent Oracle Resource Profiler on line. It was not available for download anymore for several months.
http://www.oracledba.ru/orasrp/
It doesn’t have a web server interface yet like the previous version but that should be coming in the [...]

Popularity: 283 points

UKOUG RAC SIG some revealing experiences.

Wednesday, August 9th, 2006 by Piet de Visser

This SIG meets 3 times per year, and always has interesting albeit somewhat nerdy speakers with highly relevant content. It generally provides some very Refreshing and marketing-free information.
This meeting as one of the best I have visited in the last two years.
There was one particluar item with some real criticism of an oracle product [...]

Popularity: 226 points