Category Archives: Uncategorized

ORA-00904 DBMS_XPLAN HINT DBMS_LOB GRANT

I ran this query with a hint: I ran this select to get the plan: I was getting this error: Column Projection Information (identified by operation id): 1 – “BLOCKS”[NUMBER,22] ORA-00904: : invalid identifier I found that my user or … Continue reading

Posted in Uncategorized | 2 Comments

Finding queries with bad plans from an AWR report of a load test

I want to document some recent steps that I have been taking to support new development on a transactional system. Every time the system has a new release, if that release includes Oracle SQL changes, I am asked to create … Continue reading

Posted in Uncategorized | 2 Comments

Simple tools I use

Just a quick note about two tools I use: TextPad – my favorite text editor. I know everyone has their own, but this is mine. UnixUtls – Unix like tools on a Windows command line. Bobby P.S. I need to … Continue reading

Posted in Uncategorized | 2 Comments

Wrapped Lines and Squished Pictures

I have been having trouble using WordPress on this blog. I keep having long lines wrapped instead of having a slider that readers can use to see the end of the lines. Also, pictures that looked fine when I posted … Continue reading

Posted in Uncategorized | Leave a comment

DBVERIFY (dbv) outputs block_id for bigfiles

I posted a question about this and didn’t find an answer. I searched both Oracle’s support site and the internet in general. I ran the DBVERIFY utility dbv against a bigfile datafile that had corrupt blocks and wanted to relate … Continue reading

Posted in Uncategorized | Leave a comment

$6 per month for blog on AWS

It looks like this blog is costing me about $6 per month on AWS which is cool. I was paying about $200/year or about $17 per month on iPage. I am not sure what I am missing. This blog is … Continue reading

Posted in Uncategorized | Leave a comment

Created MySQL Scripts Repository

Most of my work is with Oracle databases but I have been starting to learn a little bit about MySQL. Where I work, we have a bunch of on premises Oracle databases including large and active ones with various challenging … Continue reading

Posted in Uncategorized | 2 Comments

Updated Centos VM to Oracle Linux

I was using Centos Linux for Nethack programming and playing on my home laptop. Evidently Centos is going away at the end of 2021 and Tim Hall had a post about moving Centos to Oracle Linux. So, I did it. … Continue reading

Posted in Uncategorized | Leave a comment

Moved my blog to AWS

It has been two years or more since I first thought about moving my blog to Amazon Web Services (AWS) from iPage, the hosting company that this blog has always been on. My company uses AWS for a number of … Continue reading

Posted in Uncategorized | Leave a comment

Up on AWS

I have more to do but I have bobbydurrettdba.com pointing to an Amazon EC2 virtual machine. Seems faster. I still have email forwarding done on iPage and they still have the domain registration and dns. I plan to work on … Continue reading

Posted in Uncategorized | Leave a comment