(Maarten Smeets) The asynchronous nature of code running on Node.js provides many interesting options for service orchestration. In this example I will call two translation services (Google and SYSTRAN). I will call both of them quickly after each other (milliseconds). The first answer to be returne
Tag: Oracle
Index Competition in #Oracle 12c
(Uwe Hesse) Suppose you want to find out which type of index is best for performance with your workload. Why not set up a competition and let the optimizer decide? The playground:
OBIEE 11g: Outer join in the Physical Layer now possible
(Vishal Pathak) We know that we can perform outer joins in OBIEE in the Logical Layer. The problem with this mechanism is that it is not possible for one logical table sources (LTS) to join to a fact by an inner join and the other to join to the fact by an outer join.
Oracle Database Cloud (DBaaS) Performance Consistency – Part 2
(Randolf Geist) This is the second part of this installment, comparing the performance consistency of the DBaaS cloud offering with a dedicated physical host. This time instead of burning CPU using a trivial PL/SQL loop (see part 1) the test harness executes a SQL statement that performs logical I/O
Note to self for blocking locks
(mdinh) Session 1 starts UPDATE and nothing else.
TABs in Your Code?
(Jeff Smith) Not to start a religious war, but white space in your code can cause havoc when you’re doing code compares and versioning.
Data Redaction and Data Pump in #Oracle 12c
(Uwe Hesse) What happens upon Data Pump Export if tables are being exported that have a Data Redaction Policy? I got that question several times in class, which is why I put the answer here , so I can refer to it subsequently.
Convert GeoJSON document to Sdo_Geometry objects
(Simon Greener) Convert GeoJSon to Sdo_Geometry. Individual snippets, not a whole document.
Virtual columns
(Patrick Barel) Maarten wrote a post on Virtual Columns in the oracle database. I read a blogpost on preventing people issuing SELECT * on a table. This was done in a different database, so I decided to try it out in my Oracle Database.
Splitting Strings: PL/SQL
(stewashton) Marc Bleron and Todd Hershiser gave me some very valuable feedback through their comments on my recent “Splitting Strings” posts. The big news is: PL/SQL beats SQL!
