Subscribe to Blog via Email
Join 1,048 other subscribersArchives
Category Archives: Uncategorized
Post Collaborate and on call week post
So, I was at the Collaborate 2018 Oracle user group conference last week and I am on call this week. I have not posted anything about the conference so I thought I would try to get something out there. I … Continue reading
Posted in Uncategorized
Leave a comment
Getting geared up for Collaborate 2018 #C18LV
I’m leaving for Las Vegas a week from this Sunday for the Collaborate 2018 conference #C18LV. I’m doing the same two talks that I did in Denver at RMOUG Training Days. Here are the times and locations for the talks if … Continue reading
Posted in Uncategorized
Leave a comment
Had to set parallel_max_servers to 2 for Delphix clone
This is a quick note about a problem I had creating a Delphix virtual database clone of a production database. This is an older 11.1.0.7 HP-UX Itanium database. I tried to make a new virtual database copy of the production … Continue reading
Posted in Uncategorized
Leave a comment
Does an automated cloud data warehouse need partitioning and indexes?
This is a late post inspired by my time at RMOUG Training Days 2018. I attended two RMOUG Training Days presentations about automated cloud data warehouse database systems. The first was about Snowflake. The second was about Oracle’s coming Autonomous … Continue reading
Posted in Uncategorized
Leave a comment
Pushing predicates into MySQL subqueries
I am just getting started looking at MySQL performance tuning but I thought I would share something that I may have figured out. I’m working with a query that does a count and a group by in a subquery and … Continue reading
Posted in Uncategorized
Leave a comment
Follow up from RMOUG Training Days talks
I have uploaded a zip of my two RMOUG Training Days talks here: zip During the Toastmasters talk there was a question about finding a club in your area. Here is how to find a Toastmasters club near you. Go … Continue reading
Posted in Uncategorized
Leave a comment
Early morning RMOUG post
Well, it is early Wednesday morning here at the Westin hotel in Denver where the RMOUG Training Days conference is being held. I can’t sleep anyway so I thought I would write-up some of my impressions of yesterday’s presentations. I … Continue reading
Posted in Uncategorized
Leave a comment
Should I use SQL or Python?
We had an outage on an important application last Thursday. A particular SQL statement locked up our database with library cache: mutex X waits. I worked with Oracle support to find a bug that caused the issue and we came up … Continue reading
Posted in Uncategorized
3 Comments
RMOUG Training Days 2018 early registration deadline rapidly approaching
The deadline for early registration for RMOUG Training Days 2018 is rapidly approaching. The deadline is January 12. The early registration fee is $385 for RMOUG members and $450 for non-members. There is a packed agenda over the three-day event. The hotel costs … Continue reading
Posted in Uncategorized
Leave a comment
Both talks accepted for Collaborate 18
IOUG accepted both my Toastmasters and Python talks for Collaborate 18. RMOUG also accepted them both so I will be doing these two talks in both February and April. I am a little surprised because I have had talks rejected by IOUG … Continue reading
Posted in Uncategorized
2 Comments