(David Fitzjarrell) For several years the FORALL loop, in conjunction with the BULK COLLECT operation, has allowed PL/SQL developers to more efficiently process data by eliminating the row-by-row fetch cycle in favor of a bulk load into memory.
Tag: Oracle
LOBs from afar
(connormcdonald) This has always been a nuisance. There you are – getting all the bells and whistles with LOBs…until a database link enters the room
Changing the port number on a GoldenGate Microservice using REST
(Bobby Curtis) The new Oracle GoldenGate Microservices architecture provides a lot of new functionality and opens up a lot of possibilities. Part of these possiblies is to ability to interact with Oracle GoldenGate from a REST API stand point.
Friday Fun SQL Lesson – union all
(Scott Wesley) Our office kitchen is unavailable this Friday, so the call was put out for pub lunch.
How to Setup Node.js and Oracle JET on Oracle Linux
(Andrejus Baranovskis) What if you want to develop Oracle JET in Oracle Linux? Certainly this is possible – both Node.js and Oracle JET run on Oracle Linux or any other Linux distribution. If you follow Oracle JET Setup Guide, you will see Node.js is listed as prerequisite.
#GoldenGate Microservices (5 of 5) … Performance Metrics Service
(Bobby Curtis) This is post 5 of a 5 part post related to Oracle GoldenGate 12.3 Microservices and the final one on the HTML5 web page access. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.
Prepare and link bind Oracle Database Cloud, Application Container Cloud, Application Container Cache and Event Hub
(Lucas Jellema) A fairly common combination of Oracle Public Cloud services that I use together – for example for the implementation of microservices – is DBaaS, Application Container Cloud, Application [Container] Cache and Event Hub.
Adaptive serial direct path read decision ignores object statistics since 12.1
(Sayan Malakshinov) On versions 11.2.0.2 – 11.2.0.4 Oracle uses objects’ statistics to make direct path reads decision (of course, if “_direct_read_decision_statistics_driven” haven’t changed it to “false”), and we can force serial direct reads on statement level using sql profiles with hints INDEX_
Transparent Data Encryption (TDE) In Oracle 12c
(Anuradha Mudgal) Today we are going to talk about Transparent Data Encryption (TDE) In Oracle 12c. First, have look at the introduction of TDE. After the introduction, we have steps to configure TDE.
Regular database restore tests are important
(ilmarkerm) I came to work today morning and there was an alert in my inbox saying that one of the large databases failed the nightly restore test.
