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
Author: debrucer
I am retired from non-Oracle DBA positions as a primary responsibility. I am currently maintaining multiple Oracle databases hosted on Virtual Machines (VMs) in the cloud. Certified AWS solution architect associate level, experience in or exposure to Azure, Google and Oracle clouds.On a limited budget
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