Blogs
1. ORA-00479: RVWR process terminated with error followed by ORA-479
Mahmmoud Adel posted about an error that occurs on a 19c DB, when trying to enable the FLASHBACK mode on a standby DB. He gives an analysis and solution.
2. Natural Selection & Converged Databases (Oracle finds good solutions 🙂 — JSON & In-Memory
Erman Aslan writes, “Today’s post will be about Natural Selection and Oracle Converged Database (especially about JSON and in-memory capabilities).”
He concludes with: “As the title of this article implicitly states, natural selection looks for good solutions, and it finds them. So, it is not hard to make a connection to our enterprise data environments and conclude that, in our enterprise environments where Oracle databases exist at the heart of all the things and processes related to data, many problems are solved with the capabilities of these databases and if that’s the case it is similarly tempting to evaluate the good solutions that Oracle finds through its evolution.”
3. Automatic Plan Management – not the cure all.
Ric Van Dyke begins this blog with, “There has been a decent amount of buzz out there about Oracle’s Automatic SQL Plan Management. It’s not exactly new, this feature has its roots in 11. Starting in 19 for Autonomous databases it is on by default. Which isn’t necessarily a bad thing.
My concern is that folks may make a bad assumption about how this works.
The actually assumption that this feature works on is that the code is well written to begin with. This isn’t a mechanism that will be able to rewrite code to make it better, it will just make sure that the plan used for the code doesn’t get worse. Those are two very different things. “
4. Oracle Enterprise Manager 13c Series – Patching
Alfredo Krieg shares a video covering the patching of Oracle Enterprise Manager 13.5.
5. What does Legacy really mean?
Brendan Tierney writes, “In the IT industry we hear the term “legacy” being using, but that does it mean? It can mean a lot of different things and it really depends on the person who is saying it, their context, what they want to portray and their intended meaning. In a lot of cases people seem to use it without knowing the meaning or the impact it can have. This can result in negative impact and not in the way the person intended.”
6. Looking for GRANT ALL on objects
Pete Finnegan says, “This is the second part of the GRANT ALL on objects post that I made recently. This final look at this issue covers a simple SQL script that can be used to locate common objects where GRANT ALL has been used.
We found in the last post – Part 1 – that a grant of ALL on a table results in 12 individual grants in 19c. First let’s find out how many grants are made on typical objects such as table, view, PL/SQL and a type.”
7. New apex.date JS API in APEX 21.2
Daniel Hochleitner writes, “As John already teased in his blog post about the JavaScript API changes in APEX 21.2, there is a new apex.date namespace coming.
Main purpose of it is to have an out-of-the-box replacement for Moment.js which is part of APEX since we introduced our Calendar region with FullCalendar version 3. In APEX 21.1 this region was updated to use the newer version 5 of the underlying FullCalendar library, and this particular version doesn’t come with Moment.js anymore and changed many other things, especially from an API point of view.”
8. API more than a payload – Cloud Lunch Learn
This blog says, “Today I was fortunate enough to present at one of the Cloud Lunch and learn events (you can register for any of the events here and see previous sessions here). One of the questions asked at the end of the session was recommended reading on APIs. So I’ve gathered up some links to books I’d suggest worthwhile reading I’d suggest.”
- Enterprise API Management: Design and deliver valuable business APIs by Luis Weir (Amazon.co.uk)
- The Design of Web APIs by Arnaud Lauret (direct from Manning) (Amazon.co.uk)
- Designing APIs with Swagger and OpenAPI by Joshua S. Ponelat and Lukas L. Rosenstock (direct from Manning) (Amazon.co.uk)
- API Security in Action by Neil Madden (direct from Manning) (Amazon.co.uk)
- OAuth2 in Action by Justin Richer and Antonio Sanso (direct from Manning) (Amazon.co.uk)
9. Data – You’re Actually What Makes the World Turn
Paul Lewis writes a letter to ‘data’!
10. Star Schema Design in Oracle: Fundamentals
Dani Schnider says, “What are the design rules for good performance in a star schema in an Oracle database? This blog post series introduces some recommendations for the physical database design. This first post is about constraints and indexes.”
OBIEE News
Stories from yvrk1973.blogspot.com, dgielis.blogspot.com and alfredokriegdba.com
Videos such as: