Monthly Archives: March 2021

Just a quick note. I have an application that is generating thousands of inactive sessions and with the default dedicated server configuration we are having to add more and more memory to our virtual host to support the connections. We … Continue reading →

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 →

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 →

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 →

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 →

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 →

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 →