Blog: Bobby Durrett


208 blogs updated: 67 min. ago
SQR with 077 umask creates file with 611 permissions
I ran across this strange situation. An SQR opened a new data file for output and created the file with 611 permissions. We needed group rea...
10
23-06-2017 18:33:37 Bobby Durrett Oracle
Unrolling loop speeds up program
This is a follow-up to my earlier post about the assembly language book that I am working through. I have struggled to speed up a program us...
13
22-06-2017 23:45:27 Bobby Durrett Oracle
Modified PythonDBAGraphs to use datetime on X axis
I modified PythonDBAGraphs to use datetime objects on the X axis for all the reports except ashcpu.py. This lets you hover the mouse over a ...
13
17-06-2017 02:51:55 Bobby Durrett Oracle
Pushed out new version of PythonDBAGraphs
I pushed out a new version of PythonDBAGraphs. I got a new laptop at work so I am setting it up with the software that I need to do my job. ...
17
03-06-2017 00:27:44 Bobby Durrett Oracle
X86-64 Assembly Book
I have written earlier blog posts about my diversion from studying Oracle to studying computer science. Here are some relevant posts: url1,u...
11
24-05-2017 23:41:50 Bobby Durrett Oracle
Finished reading the Snowflake database documentation
I just finished reading the Snowflake database documentation and I thought I would blog about my impressions. I have not spent a lot of time...
15
16-05-2017 20:51:28 Bobby Durrett Oracle
Submitted two abstracts for Oracle OpenWorld 2017
I submitted two abstracts for Oracle OpenWorld 2017. I have two talks that I have thought of putting together: Python for the Oracle DBA Toa...
11
19-04-2017 21:27:41 Bobby Durrett Oracle
How to find the object that caused ORA-08103 error
A developer told me that two package executions died with ORA-08103 errors and he didn't know which object caused the errors. I found two tr...
24
17-04-2017 22:01:09 Bobby Durrett Oracle
Optimizer bug fix makes a query run more than 3 times slower
I'm working on an 11.1.0.7 to 11.2.0.4 upgrade and found a handful of queries that run more than 3 times longer on 11.2.0.4 than 11.1.0.7. T...
17
12-04-2017 22:43:04 Bobby Durrett Oracle
_small_table_threshold=1000000 results in > 5x query speedup
Today I sped a query up by over 5 times by setting _small_table_thre shold=1000000. Here is the query elapsed time and a piece of the plan s...
16
07-04-2017 23:50:01 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.