Have you had a good Summer?
Here’s a round up of the blogs that have caught my eye over July and August:
Mike Dietrich shares why this isn’t just a simple upgrade. You MUST upgrade to Oracle Database Database 19c. No further discussion needed!
Maria Colgan writes about why she’s really looking forward to this October event.
Time to reconnect with the community, get inspired, boost knowledge and visit Las Vegas. What’s not to love?
Julian Dontcheff writes about how the Automatic Segment Advisor can be at times resource consuming and even slow down your database. And what to do about it.
Are you writing a Tech Conference Abstract? Here’s some really solid advice on what to do, and what NOT to do.
Have you ever tried to delete a few million rows from a table with several hundred milllions of rows with a DELETE statement? If yes, then you know that this is a very bad idea. With Oracle Partitioning you can do this more elegant and much faster. Dani Schnider tells you how.
Hassan AbdElrahman explains how to create a profile option in Oracle Apps r12.
Jonathan Lewis gives us a lightweight note on the risks of hinting. His summary says,
“This note is just another simple demonstration that hints do not guarantee plan stability across upgrades – and then showing that it can take a few experimental steps to discover what’s new in the optimizer that is making your previous set of hints ineffective.
Typically the problem will be the availability of new transformations (or enhancements to existing transformations) which manage to invalidate the old hints before the optimizer has had a chance to consider them.”
Buğra ÇOMAK says, “Oracle RAC provides clustering by allowing multiple computers to run Oracle RDBMS software simultaneously while accessing a single database. In a non-RAC Oracle database, a single instance accesses a single database. The database consists of a collection of data files , control files and redo logs located on disk . Example contains a collection of Oracle-related memory and background processes running on a computer system.”
Sumit Singh covers the OCI Gateways Networking:
* Internet Gateway
*Dynamic Routing Gateway
“A Gateway is a network component that allows data to flow from one network to another. Gateways serve as an entry and exit point for a network as all data going outside of a network must pass through it. As the name suggests it acts as a gate between two networks.”
10. Trim CPU
Another one from Jonathan Lewis – which concludes with, “I don’t think that anything I’ve done or described in this note could be called rocket science (or telescope science as, perhaps, it should be in honour of Webb); but it has shown how much insight you can gain into what Oracle is doing and how you may be able to pin-point excess work using a few simple mechanisms that have been around for more than 15 years.”
Read the blog!
Videos such as: