Blogs of the week
This blog begins with, “During one of the discussions, <at POUG2022> I claimed Oracle can – under specific circumstances – do a partition pruning, even when the partition key isn’t somewhere defined as a filter.
It’s probably easiest to show it by a simple example.
He goes on to show some data and an example.
Erik Erikson writes, “More than the other Oracle Cloud EPM applications, Account Reconciliation (“ARCS”) has the most need for file attachments. For each recon, there could very will be a requirement to upload a bank statement or other supporting documentation. If these are stored in the regular EPM database, it can quickly use all of the available space, make snapshots larger (since the attachments are included), increase the time to clone production to test, etc.”
Erman Arslan says, “While thinking about database security, we need consider all the aspects. Preventing access to data is the key, but detecting unexpected accesses and managing our secure environment should also be in our focus.
Today’s post will be about Oracle Database Security.. We’ll look at the Oracle products that we use in order to prevent the unauthorized access, monitor and report the access, realize our vulnerabilities (and fix them) and secure the database both in place -physically (at the backend directly on the disk + before queries ever reaching the database) and on-the-fly when queried — logically.”
Alfredo says, “I wanted to create a video series covering the basics of Oracle Enterprise Manager 13c. These series are designed to provide insights on how to install, configure and manage Oracle Enterprise Manager 13.5.
This week we are going to cover the installation phase of Oracle Enterprise Manager 13.5.”
This blog explores the following problem:
There is an unpublished Bug 29845449 in Oracle 19c, causing the following message to be written frequently in the DB alertlog:
Then goes through the solution.
Dimitri Gielis says, “Sometimes you expect to see some data in your Oracle APEX application and it’s not there... in this post I will describe one use case I see more often and how to solve it.”
“My recent discovery in Oracle Database 21c, the innovation release, is how intervals can also be in ISO-8601 format.
The ISO-8601 format is an international standard for describing Date and Time formats in data exchanges.
There are two flavors of interval in the Oracle Database, “Day to Second” and “Year to Month” and there are specialized functions to convert strings in a certain format to an interval.”
Kim Berg Hanson writes, ” I was giving 3 presentations at OUG Norways event yesterday, one of which was an old one of mine on analytic functions (oldie but goodie.) Afterwards Morten Braten tweeted about it using the hashtag #lowcode. That got me thinking… could SQL be considered low-code?”
This week on Twitter
SQL Daily shared a link to free resources
Videos such as:
Oracle Analytics Live! Webinar September 2022 edition
Oracle APEX Automations: Create Automation