If you have an Interactive Report with the Subscription feature enabled, users can “subscribe” to the report, getting a daily email with the results of the report. Unfortunately, however, this feature doesn’t work as expected if it relies on session state – e.g. if the query uses bind variables based on page items to filter the records. In this case, the subscription will run the query with a default session state – Apex doesn’t remember what the page item values were when the user subscribed to the report.
Parallel execution in Oracle seems to be a topic of myths, mysteries and misunderstandings. In this post I hope to clear up at least one of them by diving into a discussion about parallel DML. Actually, I want to show you two things that can go wrong with it.
My demo setup and case are pretty simple, I just create two copies of dba_objects:
I started hearing the term ‘data lake’ a few years ago but didn’t pay a ton of attention to it. Today, the term’s still around and so is the hype. According to this article on Wikipedia (https://en.wikipedia.org/wiki/Data_lake) the term is poorly defined and has morphed significantly since it was coined by James Dixon.
SQL Server is a conventional RDBMS created in partnership between Microsoft and Sybase in ~1989. Since then, SQL Server has only ever run on the Windows operating system.
Infoworld ranked SQL Server as the second most popular database (along with MySQL). SQL Server is considered by many to be in the top 3 database systems (for popularity), competing head to head with Oracle’s database product.
For much of my career as a DBA, I spent a lot of time working on issues that technology and software are eliminating. Issues like space management, performance management, building new systems and configuring complex availability options like Clustering.
Why is this changing? There are many reasons, but the most prominent are: mature Virtualization technologies, the public cloud, cheaper hardware, and significantly better automation tools.
A little while ago after a question from a customer about supporting Oracle products on the Google Cloud Platform (GCP) I decided to take a look for any updates to the Oracle public cloud support policies. The document can be easily found on the Oracle website. I quickly noticed some significant changes in the new version of the document.