Are you getting the ORA-00933: SQL command not properly ended error? Learn what causes it and how to resolve it in this article. ORA-00933 Cause You have run an SQL statement and have gotten this error: ORA-00933: SQL command not properly ended What causes this error? Most likely, the SQL statement you’re running has a […]
Like many organizations, yours is likely under pressure to reduce costs and resources, while increasing storage capacity and compute power. In response, many are making the leap to the cloud or at least seriously investigating cloud platforms. While the DBA role is still critical in this new world, DBAs need to modernize their skills to keep up as their companies make the move toward the cloud. That’s why we created this list of 5 key skills you will need in the cloud.
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.
In this post I will show you how to install, configure and use Oracle Secure Backup to take your Oracle database backups to AWS S3. This method can be used for Oracle database version 9.2 or higher.
In this example, database version is 12c and platform is Linux x86_64.
Organizations today are under pressure to reduce IT costs and resources while increasing storage capacity and compute power. In response, many are making the leap to the cloud or at least seriously investigating cloud platforms as a way to address these needs. They also want to take advantage of the promise that cloud solutions will help them introduce new revenue streams through capabilities like big data analytics, mobile applications or the Internet of Things.
The Database Star Academy membership is now open! Here’s what you need to know. What Is the Database Star Academy Membership? It’s a membership site with a monthly fee, that gives you access to many different online video courses and PDF guides related to Oracle database development. What’s Included? As part of your membership, you […]
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. As the main query has a sysdate inside, the RESULT_CACHE Hint can not be specified for the main query, but only for the subquery.
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_LIMIT but after way more time – up to an hour.
In this article, I’ll explain what I mean by “focused learning” and why it’s a good idea for your career. What is Focused Learning? When we want to learn something, we tend to research on it. We look for websites, articles, videos on the topic. Or we enrol in a university course, if it’s career […]