A few of the latest for your enjoyment…
Blogs of the week
Ric Van Dyke writes, “This year I’ve been on a gig working with a good sized Exadata implementation. I really don’t know how big it is, my job is to tune queries not the database. Before this gig I’d only done a little bit of work on Exadata and wasn’t well aware of the system. Yes I knew the technical aspects of how Exadata worked, the storage cells, offloading, and such. But to work with it day after day is something much more. Indexing is a hot topic around Exadata. There are some who think there shouldn’t be any indexes at all on an Exadata system. That is likely a bit extreme. Fewer indexes for sure. Primary Keys must have them and Foreign Keys really should. Other indexes that would be created for performance might not be a good idea. There are two reasons of this…”
Scott Wesley began his blog with, “A common follow up clarification on forums is regarding the version of the relevant tool.
Questions relating to Oracle APEX could be impacted by the APEX version, the database version, and perhaps the ORDS version – in addition to what browser is being used. The information on the RAD stack can be resolved in one (concatenated) SQL query. APEX was easy, there is a simple one row view, which ultimately translates to a function returning a literal.
Same with ORDS, I didn’t even bother with a scalar subquery when I put it all together. The Oracle database version had a few options, each with nuance.”
Brendan Tierney shares, “There are a number of different ways to load data into your Autonomous Data Warehouse (ADW) environment. I’ll have posts about these alternatives. In this blog post I’ll go through the steps needed to load data using Object Storage. This might appear to have a large-ish number of steps, but once you have gone through it and have some of the parts already setup and configuration from your first time, then the second and subsequent times will be easier.”
Connor McDonald links to this post first and foremost. Then goes on to say, “But I wanted to show a simple demo of how management of cursors continues to improve with each version of the database.
This blog, which is part of a series begins with, “Continuing our Oracle SQL for EPM series, today we’ll start to talk about analytic functions and how can we use them for more than “just” analytics. To start with, let’s talk about RANK().”
Richard Foote writes, “I am SOOOO struggling with this nightmare block editor but here goes. Please excuse any formatting issues below:
I thought it was time to show the new Oracle 19c Automatic Indexing feature in action and what better way than to go through how I created my first ever Automatic Index.”
Stewart Ashton begins by saying, “For very long lists, we need the return values to be
LISTAGG can only return
VARCHAR2 lists, but XML and JSON aggregate functions can return
CLOBs! As an exercise, I’ll start from
ALL_OBJECTS: I want to make a list of all fully qualified object names for each object type. ”
This week on Twitter
Satyendra Pasalapudi tweeted a link to Getting Started with Oracle Functions and Object Storage
Javier Torres shared Oracle Demonstrates Innovation by the Boat Load at SailGP
Videos such as:
PCMCS Implementation: Decisions and Challenges | Mike Killeen
ONLINE table maintenance WITHOUT upgrading to 12c Release 2