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 Technical…Read 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. I am available for short-term support assignments, off-hours, vacation or holiday coverage with pre-arrangement. Data migrations and custom installations will be considered. I would love to implement GoldenGate and replicate data - from anything, to anything, as long as one node is Oracle. Obviously. vetting should take place before you need me. Let's get started now.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 have…Read 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 database…Read 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 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 Manager…Read 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 done…Read 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 a…Read 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 more