Subscribe to Blog via Email
Join 970 other subscribersArchives
Author Archives: Bobby
Free Machine Learning Class from MIT
I noticed this new class from MIT: https://ocw.mit.edu/courses/electrical-engineering-and-computer-science/6-036-introduction-to-machine-learning-fall-2020/ It is about machine learning and is free. I think it has some built in exercises with automatic grading but no instructor to interact with. Since ML is such a hot topic … Continue reading
Posted in Uncategorized
2 Comments
60,000 sessions in 64 gigabyte VM using shared servers
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
Posted in Uncategorized
2 Comments
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