Category Archives: Uncategorized

SymPy Tutorial Repository

I have been playing with the Python SymPy package and created a repository with my test scripts and notes: https://github.com/bobbydurrett/sympytutorial Might be helpful to someone. I just got started. I had used Maxima before. SymPy and Maxima are both what … Continue reading

Posted in Uncategorized | Leave a comment

ORA-14767 when day of month > 28 with interval partitioning month interval

Creating a range partitioned table with a date type partitioning column and a month interval must have a starting partition that has a day < 29 or it gets an ORA-14767 error. The error message “Cannot specify this interval with … Continue reading

Posted in Uncategorized | 3 Comments

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 | Leave a comment

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