The colder nights are setting in. Light the fire, grab a cuppa – and here are some blogs worth a view:
Adityanath Dewoolkar begins by saying, “Recently one of BU person in my project requested us to send scheduled report for RMAN Backup completion for one of critical databases. As this requirement was from Business, I thought of having it simple & less techie. After exploring few options, I thought of using OEM reporting functionalities & found its really amazing.
This post will guide you on how to create custom information publisher report.”
Soumya gives a single script to gather various information off your database.
Hemant begins his blog with, “In general, most database backups with RMAN always include the “correct” set of ArchiveLogs. This is done either with :
1. BACKUP DATABASE PLUS ARCHIVELOG
2. ALTER SYSTEM ARCHIVE LOG CURRENT ; followed by BACKUP ARCHIVELOG”
Maria Colgan writes, “The volume of data being stored in databases has grown exponentially in recent years. So too has the need to rapidly generate value or business insights from that data.
Parallel execution is the key to processing large volumes of diverse data quickly, as it subdivides complex tasks into a number of small tasks allowing multiple processes to accomplish a single complex task.”
Mike Dietrich says, ” I think I should start a blog post series of surprises. At least, this time it’s not harmful at all. But it still a surprise. And ACE Director Rodrigo Jorge reported about it and did ask me for more details. So yes, here we have Another surprise: DBMS_PDB in Oracle 22.214.171.124.”
Dimitri Gielis says, “This post is part of the Getting Started with Plug-ins Pro APEX plug-ins series.”
Boris Dahav says, “A year ago Oracle announced the Oracle always free tier. Let me describe shortly what it is and point to few great examples what to do with it.”
Gary Gordhamer asks, “What are your options for testing performance changes when moving from Oracle 11g to 19c?”
Ross Lowenthal writes, “One of my least favorite database administration activities is managing users – creating users, changing passwords, granting roles – zero fun.”
Connor McDonald says, “If you are loading a data warehouse or similar environment where your default approach would probably be to compress all objects because they are predominantly read only, you do not need to head back into your DDL scripts and add a “COMPRESS” clause to every table.”
This week on Twitter
Kashif Manzoor tweeted Creating React + GraphQL Serverless Web application using AWS Amplify
Lucas Jellema posted Oracle Functions–Mental Picture vs. Physical Reality
Videos such as:
Connor Mcdonald 25 years of tips and tricks
Create an Application on Oracle Cloud Infrastructure