(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
Tag: Oracle
ORA-00933 SQL command not properly ended Solution
(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.
Reset Oracle Password
(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.
NOLOGGING Bad For Recovery
(mdinh) What doesn’t kill you makes you stronger.
Backup Oracle Databases to AWS S3
(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.
Long Parsing and PGA limits
(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
Oracle Database Result Cache Troubleshooting
(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.
Node.js application using SSE (Server Sent Events) to push updates (read from Kafka Topic) to simple HTML client application
(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.
Oracle B-Tree Index On A BLOB
(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.
A Sneak Peek at Oracle’s Chatbot Cloud Service and 5 Key Factors Necessary for Bot ROI
(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
