(Andrejus Baranovskis) Starting from JET 6.0.0 Composite Components (CCA) are renamed to be Web Components (I like this new name more, it sounds more simple to me). In today post I will talk about Web Component writeback property and importance of it.
Tag: Oracle
Goldengate ERROR OGG-02037 Failed to retrieve the name of a missing Oracle redo log.
(Fahd Mirza Chughtai) One extract got abended and wasn’t able to start in Oracle Goldengate Version 12.2.0.1.160517 23194417_FBO. The redologs were present but extract was still abended and threw following error in the report file.
Scheduling Exports of Your Data Using the Cart
(Jeff Smith) This post won’t show you how to acutally do the scheduling bits – I’m going to assume you know how to use contrab or Windows Scheduler -but I will show you how to get SQL Developer setup so that you can call it from the command-line to do your export.
Partitioning — 11 : Composite Partitioning
(Hemant K Chitale) Oracle allows Composite Partitioning where a Partition can, itself, be Sub-Partitioned.
DBID Problem @ ODA – or Count von Count (Sesame Street) calculates DBIDs
(Robert Crames) I did some more investigations to get an explanation for that problem with the extra long DBIDs and the resulting problems when creating new databases on an ODA …
Interval versus Range partitions
(Connor McDonald) One of the nice things about partitioning in the database is that partition pruning can quickly eliminate the requirement to read large amounts of data when the partitioning key(s) are appropriately provided in your queries (and DML).
INFO vs DESC – Learning About your Oracle Schema Objects at the Command Line
(Jeff Smith) Here’s an 8 minute video walk through of using INFO and DESC in Oracle SQLcl.
FIRST_ROWS_10 CBO Is Hopeless, It’s Using The Wrong Index !! (Weeping Wall)
(Richard Foote) There’s an organisation I had been dealing with on and off over the years who were having all sorts of issues with their Siebel System and who were totally convinced their performance issues were due directly to being forced to use the FIRST_ROWS_10 optimizer.
List the server group memberships of your domain
(Martien van den Akker) Last few years I posted on installation of Fusion Middleware. One of the features of FMW12c is the concept of Server Groups.
Design considerations to replicate Data Lake site for Availability
(Saurabh K. Gupta) Why replicate a data lake? Building an enterprise data lake demands heavy weightlifting in terms of cost, planning, technical design, architecture, and operational excellence.
