On a limited budget

When your limited budget is zero that probably means you are unemployed and perhaps trying to become an Oracle DBA. Oracle is freely available up to a point, but, it requires a license for one to be completely successful. Some version of many, if not most, Oracle database products is available on the “Oracle TechnicalRead moreRead more

Self-Tuning

These documents were written during a recent tuning project. They have been sanitized to remove proprietory references. tuning notes implementation These were written for Oracle11g. 19c is the current Oracle version, and more changes are coming in 20c. Pluggable databases are an option today, but they are the default standard starting with 20c. We haveRead moreRead more

Errata

Searching for answers to Oracle product failure questions on Google seems a useless effort. All Oracle products are licensed and therefore entitled to Oracle support. The questions get answered and there’s no discussion on the public internet. Google is still your friend, but it has limitations. Sure, you will find answers to most known databaseRead moreRead more

Oracle RAC: Call me a Convert

Having worked with Oracle since their first version outside of the CIA gives me a different perspective on the product and features than most people hold. I met Larry Ellison twice in my life, but know him through documentation, media and a whole lot of hearsay, mostly, urban legend. My employer, Systems Development Corporation (SDC)Read moreRead more

Flash quit working. Finally!

We knew it was going to happen sometime, but, yesterday? No. The Flash requirement left the default Oracle Express console after 12c. I never used Express much since I always had the full-fledged OEM product. The old Express wasn’t much. The new Express is even less. Oracle Enterprise Manager (OEM) has become Oracle Enterprise ManagerRead moreRead more

Never Tune SQL Again

When using an Oracle database (11g to 19c) to execute SQL code the correct place to tune is in the Oracle instance. While it is advisable to write code to standards in any tool, it is still best to let Oracle decide the optimal path to the data. This kind of tuning cannot be doneRead moreRead more

Fail-over Database

This document describes the process to implement a standby database. It was written to bring the development team up to speed on the method being undertaken to provide database high-availability, and to describe the features and problems associated with such a configuration. The OracleAutomated Standby Database feature provides the ability to create and maintain aRead moreRead more

What does the “g” in Oracle10g mean?

Originally written in 2004 shortly after Oracle10g was released. Oracle would like you to jump into the grid and buy into all that it offers.  What is not clear immediately is the complexity of these systems, nor what they offer.  The central piece of the grid in this new version of database software is failed technology, reworked,Read moreRead more