(Natik Ameen) Tokens are used to capture and store the environment variable values in the header of the GoldenGate trail record file. The trail file header contains a lot of information about the physical environment that produced the trail file and trail file contents.
Tag: Oracle
Oracle’s SQL Tuning Advisor and SQL Developer
(Jeff Smith) If you have the Tuning Pack licensed, a couple of things become available for you in SQL Developer:
Oracle Cloud – About buttons, icons, links and other stuff…
(Marco Gralike) While scrolling to the DBaaS interface pages, I realized that I was spending a lot of time getting to know and learn the current interface look-and-feel.
Full Table Scan – Friend or Foe?
(John Brady) Many people consider a Full Table Scan (FTS) in a query execution plan to be a bad thing – reading every record from a table to find only those records the query needs.
Loading LOB from a file
(connormcdonald) I observed this idiosyncracy recently when loading some lob from external files using PL/SQL:
ADF BC REST Support for List Of Values (LOV) Data
(Andrejus Baranovskis) ADF BC REST service out of the box supports LOV list data. You can define LOV for ADF BC View Object attribute and use it straight away in REST service.
CREATE an APEX_COLLECTION and SELECT the data via SQL Developer
(Tobias Arnhold) Maybe this an old hat but a lot of people don’t know how to use and analyze APEX_COLLECTION properly. For myself it is a good reminder and saves me about 2 minutes instead of googling around.
AWR Warehouse Jobs in EM13c
(Kellyn Pot’Vin-Gorman) As I’m playing with the AWR Warehouse in EM13c, I noticed a few changes that may send up a red flag and wanted to assist in removing those.
FBDA — 1 : Testing Flashback Data Archive in 12c (NonCDB)
(Hemant K Chitale) Some testing I’d done with Flashback Data Archive (henceforth called FBDA in this and subsequent posts, if any) in 11.2.0.4 left me with uncertainty about the automatic purging of data beyond the Retention Period.
SQLCL Monitoring itself with Longops
(Kris Rice) Longops is a great way to monitor things that take some time to do work.
