Category Archives: Uncategorized

September 27 Arizona Oracle User Group Meeting

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

Posted in Uncategorized | Leave a comment

Analog Detour

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

Posted in Uncategorized | 3 Comments

Rolling out patched 19c home using gold image

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

Posted in Uncategorized | 7 Comments

Python Script To Backup Linux Directory To Windows

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

Posted in Uncategorized | 1 Comment

Batch Query Reduced from 12 hours to 45 Minutes

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

Posted in Uncategorized | 6 Comments

Another On Call Week, Another SQL Profile (or two)

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

Posted in Uncategorized | 2 Comments

Slides and My Impressions from May 17th AZORA Meetup

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

Posted in Uncategorized | Leave a comment

MySQL Source Installs for each RDS version

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

Posted in Uncategorized | 1 Comment

Tried Live SQL

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

Posted in Uncategorized | Leave a comment

Installed 19.3 on Linux on VirtualBox

I noticed that Oracle database 19.3 was available to download so I installed it on a Linux VM under VirtualBox. I cloned my base Oracle Linux 7 VM and did a yum -y update to get it up to the … Continue reading

Posted in Uncategorized | Leave a comment