Blog: Bobby Durrett

210 blogs updated: 7 min. ago
Copy Oracle performance reports to SharePoint using Python
I have a couple of Oracle performance reports that I upload from my work Windows 7 laptop to our corporate SharePoint site on Office 365 on ...
28-07-2018 02:25:16 Bobby Durrett Oracle
MySQL client slow to display the first row of a large result set
A coworker of mine asked me to look at a MySQL query that was running longer than we want it too. If they added a LIMIT 1000 clause at the e...
01-06-2018 23:41:35 Bobby Durrett Oracle
Python script to backup remote directory using sftp
This is the sftp version of the ftp script I published in an earlier post. It logs into a remote host using sftp and backs up a remote direc...
30-05-2018 19:46:53 Bobby Durrett Oracle
Database links and SCNs on June 23, 2019
A few days or weeks ago I saw a Twitter post about database links failing on Oracle databases next year. So, I have researched this issue. M...
17-05-2018 01:38:18 Bobby Durrett Oracle
Larger SCN numbers July 1, 2019 on
I'm trying to research a couple of notes about database links failing in June of 2019. Evidently somewhere around that time the SCN numbers ...
11-05-2018 23:18:55 Bobby Durrett Oracle
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 co...
02-05-2018 20:12:43 Bobby Durrett Oracle
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 Den...
14-04-2018 02:40:19 Bobby Durrett Oracle
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 HP-...
10-04-2018 01:18:51 Bobby Durrett Oracle
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 ...
08-03-2018 23:54:40 Bobby Durrett Oracle
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...
06-03-2018 20:50:50 Bobby Durrett Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.