Subscribe to Blog via Email
Join 1,053 other subscribersArchives
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