Author Archives: Bobby

I am trying to figure out how much non-logged write I/O an Oracle database is doing. I want to run an ALTER DATABASE FORCE LOGGING command on the database so that I can use Oracle GoldenGate(GGS) which reads updates from … Continue reading →

The Arizona Oracle User Group (AZORA) is cranking up its meeting schedule again now that the blazing hot summer is starting to come to an end. Our next meeting is Friday, September 27, 2019 from 12:00 PM to 4:00 PM … Continue reading →

Definition of analog: of, relating to, or being a mechanism or device in which information is represented by continuously variable physical quantities Merriam Webster Dictionary Introduction I just finished going off on a major tangent away from my normal home … Continue reading →

For Oracle versions 11.2 through 18 I have been applying quarterly patches to a test database and then gathering the Oracle home into a tar file. When we want to roll out a new database server with the latest patches, … Continue reading →

I found out that my blog backup script was failing so I had to rewrite it to handle dropped connections to my remote sftp server. In the process I broke out as much of the code as I could into … Continue reading →

I was asked to look at a batch SQL query that ran for 12 hours on June 4th. I messed around with some other ideas and then went back to my best method for tuning long running batch queries. I … Continue reading →

I was on call again last week and Sunday night I used a SQL Profile to fix a performance problem. We rolled out some updates Saturday night and the modified query ran fine in some cases, but others ran for … Continue reading →

We have the slides from the two talks at our May 17th AZORA Meetup. Here are Stephen Andert’s slides: Networking is NOT just cables and fiber! Here are Doug Hood’s slides in three parts: Using SQL and PLSQL for Mid-Tier … Continue reading →

I have been doing a lot of Oracle and PeopleSoft work this year, but I am trying to continue to develop my MySQL and Amazon Web Services (AWS) knowledge at the same time. My goal is to learn some new … Continue reading →

Quick post. I tried https://livesql.oracle.com/ for the first time. Looks like you can try out the latest version of Oracle for free. You can type in SQL statements in your web browser. There seem to be a boatload of scripts … Continue reading →