In this blog, Atul Kumar covers:
- Understanding JavaScript Libraries
- Step by Step: How to use JS libraries in Integrations
- Conclusion
- Frequently Asked Questions
2. Using server-side JavaScript in APEX processes
Martin Bach writes, “In this installment of the mini-series you will learn how to write more complex server-side logic using MLE/JavaScript ECMAScript modules.”
He goes through:
- Sample App
- Tables
- Quick Time Entry
- Adding MLE code to the page
- Create the MLE module
3. Oracle Sharding methods compared to YugabyteDB
Franck Pachot begins his blog with, “Oracle has long been a leader in partitioning, distributing, and replicating databases. They offer shared-storage RAC for High Availability and Log-Streaming Data Guard for Disaster Recovery. However, on built-in shared-nothing replication, Oracle is now a follower of the Distributed SQL innovation initiated by Spanner and pursued by CockroachDB, TiDB, and YugabyteDB with Raft consensus replication. In 23c, Oracle added Raft replication to follow its competitors as an alternative to primary-standbys configurations. However, there is still a great deal of innovation to provide this on top of Oracle’s existing partitioning schemes without building a new database architecture, and that’s what I’ll describe here.”
4. 5 Factors to Consider When Moving Oracle Workloads to the Cloud
This blog covers 5 Key Factors:
- Evaluating Your On-Premise Database
- Shared or Dedicated Cloud Environment?
- Security
- Oracle Licensing Impact In Cloud Computing Environments
- Choose The Right Partner
5. How to relink Oracle for Enterprise or Standard Edition?
Mike Dietrich covers:
- From Enterprise to Standard Edition
- Relink Oracle for Standard or Enterprise Edition
- Final Comment
6. APEX Interactive Grid: Cell Selection as Default
This blog begins with, “When you want to copy a specific value from an Interactive Grid, you would need to change Row Selection to Cell Selection in the Actions menu. When you don’t want to expose the Actions-menu, or just to make it more convenient for your users, having Cell Selection as the Default might be more convenient.”
The blog then goes on to give us the code to do so.
7. TLS and Wallet Enhancements in Oracle Database 23c
This blog covers:
- Transport Layer Security (TLS) 1.3 Support
- TLS Connections Without Wallets
- Improved Local Auto-Login Wallets
- TLS Certificate DN Match
- Prevent Use of Deprecated Cipher Suites
and links to some relevant articles e.g. Transport Layer Security (TLS) Connections without a Client Wallet in Oracle Database 23c
8. Generative AI Comes to Looker via Vertex AI and BigQuery BQML
Mark Rittman links to this video in his blog:
9. How to Influence Physical IO sizes with Oracle MBRC
Ron Ekins says, “In this blog post I am going to explore the use of multiblock read count (MBRC) on an Oracle 19c Database.”
He concludes with, “In this blog I have shared how the dynamic, system and session level db_file_multiblock_count (MBRC) parameter can be used to influence physical storage IOs for full table scans (FTSs) operations. The unsupported, undocumented, underscore parameter _asm_maxio may offer alternative approach to control ASM maximum IO sizes for non-FTSs but that’s the topic for another post.”
10. How To Create Database Link
This blog is full of useful code to create the code and goes through the steps involved:
- Prerequest
- Creating Database Link
- Connectivity Test
- Drop DB Link