Björn Bolltoft’s Blog: Oracle Database Managebility

I know, there are so many blogs out there. Some are good and helpful, others are driven by marketing messages only. But I believe this one will become a really good one in the Oracle universe: Björn Bolltoft’s Blog: Oracle Database Manageability.

Björn Bolltoft’s Blog: Oracle Database Managebility

First of all, let me say some words about Björn.… [Read More]

Default Changes SPFILE Parameters – Oracle 12.2

This is the 4th posting in my series about init.ora/SPFILE parameters in Oracle Database 12.2.0.1.

Roy and I did a comparison between default parameter settings in Oracle Database 11.2.0.4 vs Oracle Database 12.1.0.2 vs Oracle Database 12.2.0.1.… [Read More]

Oracle Database Documentation – From Past to Present

Yesterday one of my colleagues, well known Data Guard Guru Larry “Murphy” Carpenter, sent out an internal email with links to older and recent Oracle Database Documentation. Reason why you should use the below links: Some sites in the www have stored copies of the doc – but some may represent not the most recent state or may not be complete.… [Read More]

DBUA can ignore underscores with “keepHiddenParams”

The Database Upgrade Assistant (DBUA) is the graphical tool to upgrade Oracle databases. And the DBUA removes underscore parameters by default from the SPFILE when upgrading a database. If you don’t want this, there’s a way to tell it how DBUA can ignore underscores with “keepHiddenParams”.

DBUA can ignore underscores with “keepHiddenParams”

The DBUA by default will remove all underscores and events before actually doing an upgrade.… [Read More]

Avoid Poor Performance and Wrong Results in 11.2.0.4

One of the best notes in MOS got refreshed last night for Oracle Database 11.2.0.4. It has not only information about performance bugs but also about the worst and meanest category of issues, wrong query result bugs. Those are the ones I call the “sleeping beauties” as you as a DBA usually won’t recognize them.… [Read More]