(Dbaharrison) Now we’re doing more stuff in the cloud I’ve had to dust off my old sysadmin hat and start doing more of the stuff I’d forgotten about from when i was a sysadmin (10+ years ago). This week I’ve been setting up ASM instances in Azure so i had to do all the work around making the disk de

(Ben Brumm) Are you getting the ORA-00933: SQL command not properly ended error? Learn what causes it and how to resolve it in this article.

(Michael McLaughlin) This blog entry shows you how to reset the system password for an Oracle Database. It uses a Linux image running Oracle Database 11g Express Edition. It assumes the student user is the sudoer user.

(mdinh) What doesn’t kill you makes you stronger.

(Kamran Bakhshandeh) There are different options for backing up Oracle databases to Cloud, but using Oracle Secure Backup module to take backups into AWS S3 is one of the most efficient methods in terms of costs and backup/restore performance.

(Timur Akhmadeev) Recently I’ve seen not so smart optimizer behavior: one query took long time to parse, and ended with an error hitting PGA_AGGREGATE_LIMIT in few minutes; another query was just parsed for ages while using reasonable (under 2G :)) amount of PGA and still could hit PGA_AGGREGATE_LIM

(Martin) I was troubleshooting an issue where the Oracle Database Result Cache did not get used when the RESULT_CACHE hint was specified inside a subquery.

(Lucas Jellema) This article describes a simple Node.js application that uses Server Sent Events (SSE) technology to push updates to a simple HTML client, served through the Express framework.

(David Fitzjarrell) An interesting question was posted on the Oracle General Database forums recently inquiring about creating a B-Tree index on a BLOB to speed queries looking for NULLs in that BLOB.

(Matt Hornung) In early May, I flew out to Oracle HQ in San Francisco for an early look at their yet-to-be released Oracle Intelligent Bots Service. The training left me ecstatic that the technology to quickly build great chatbots is finally here. However, the question remains, can chatbots provide