(Michael McLaughlin) Often, the biggest problem with regular expressions is that those who use them sometimes don’t use them correctly.
Tag: Oracle
ON COMMIT Materialized View Causes ORA-02050 and ORA-02051
(Andrew Reid) This example replicates a problem I discovered today. I tested it in an Oracle 11.2 database. First I created an empty table called tab1:
Oracle Mobile Cloud Service – External SOAP Service Connector
(Andrejus Baranovskis) These days everything is about MCS/MAF. I’m also looking into this new area, but I’m trying to mix traditional ADF topics and new things.
REGEXP_LIKE Behavior
(Michael McLaughlin) Often, the biggest problem with regular expressions is that those who use them sometimes don’t use them correctly.
ON COMMIT Materialized View Causes ORA-02050 and ORA-02051
(Andrew Reid) This example replicates a problem I discovered today. I tested it in an Oracle 11.2 database. First I created an empty table called tab1:
Oracle Mobile Cloud Service – External SOAP Service Connector
(Andrejus Baranovskis) These days everything is about MCS/MAF. I’m also looking into this new area, but I’m trying to mix traditional ADF topics and new things.
Automation for DBA – Ansible part 1
(Marcin Przepiorowski) In this post I would like to move forward with software provisioning and configuration. In my last post I covered a ways to build a “core VM” and now it’s a time to add some software and configuration to it.
Lock by reference
(ycolin) As you may know, not indexing foreign key can have a huge impact on lock behavior and hurt database scalability (Not only with Oracle).
The Oracle PL/SQL Results Cache
(David Fitzjarrell) Oracle offers a results cache in the database (from 11.2 onwards) and in PL/SQL (again, from 11.2 onwards) which can greatly reduce execution time of repeated statements when insert/update/delete activity is not heavy.
Automation for DBA – Ansible part 1
(Marcin Przepiorowski) In this post I would like to move forward with software provisioning and configuration. In my last post I covered a ways to build a “core VM” and now it’s a time to add some software and configuration to it.
