(robertCrames) Since today, Oracle Database Appliance software release 22.214.171.124.0 is available … I took the chance to download and install the new release – this is the story:
(Bobby Durrett) On December 2nd we ran into a problem with one of my scripts that uses the DBA_HIST_SQLSTAT view. It did not show the full run time of a SQL statement that ran for several hours.
(Jeff Smith) The 18.4 version product lines of SQL Developer, SQLcl, Data Modeler, and ORDS we’re pretty much limited to bug fixes.
(Uwe Hesse) The technique to recover only certain objects from an ordinary backup is called Virtual Access Restore.
Little things worth knowing: the latest public-yum-ol7.repo configuration file enables an upgrade to UEK R5
(Martin Bach) For a little while now I have been using Ansible for all installation/configuration tasks I do in the lab.
(stewashton) I frequently use what I call “SQL templates”, where I replace multiple placeholders by calculated values. Here are two methods that don’t require a stored procedure.
(Franck Pachot) Virtual Private Databases (VPD) is an Enterprise Edition feature related to security. It restricts the scope of Data Manipulation Language to a subset of the table rows by transparently adding a where clause before executing them.
(Andrejus Baranovskis) These days I’m actively working with VBCS/JET Cloud product from Oracle. The more I work with VBCS the more I like it. VBCS follows similar declarative development concepts as Oracle ADF, this makes it easy to get up to speed with VBCS development.
(David Fitzjarrell) There are occasions when two or more data sets need to be combined to produce the desired results, and a join is not possible (no common columns, no common data values to join on).
(Mohamed Azar) RMAN Backup script :