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.
2. ARCS – Need more data storage?
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.”
3. Oracle Database — In-Depth Security (Preventive, Detective and Administrative)
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.”
4. Oracle Enterprise Manager 13c Series – Installation
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.”
5. Remove “XDB initialized” from alertlog
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:
2022-10-12T13:42:54.212579+00:00
XDB initialized.
2022-10-12T13:43:48.993302+00:00
XDB initialized.
Then goes through the solution.
6. No value of a page item when using a Dynamic Action
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.”
7. Intervals go ISO-8601 #JoelKallmanDay
Alex writes:
“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.”
Read on…
8. Is SQL #lowcode? #JoelKallmanday2022
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
Apps Associate tweeted Oracle #CloudWorld starts today!
SQL Daily shared a link to free resources
Paper.li
Stories from Analytics Advantage, Database Administration Tips and Jonathan Lewis
Videos such as:
Oracle Analytics Live! Webinar September 2022 edition
Oracle APEX Automations: Create Automation [1]