(connormcdonald) I was reading an interesting discussion today about multiple databases each containing large amounts of read-only data. If that read-only data is common, then it would make sense to have a single copy of that data and have both databases share it.
Tag: Oracle
ORDS Standalone and URI Rewrites
(Kris Rice) My last post How to add an NCSA style Access Log to ORDS Standalone explained what the ORDS standalone is and that is based on Eclipse Jetty. Jetty offers far more than ORDS exposed in it’s standalone.
OHS URL Rewrite
(Martien van den Akker) First half of this year I did two SAML2 implementations on Weblogic. One of those was to implement Single Sign On against ADFS for Apex applications.
Optimization of Foreign Key Constraint Creation
(Oren Nakdimon) In a recent post I showed that Oracle does a nice optimization when we add a new (nullable with no default value) column with an inline (a.k.a. “column-level”) check constraint in a single ALTER TABLE statement. This optimization does not apply for out-of-line (“table-level”) check c
Error ORA-01033 After Doing a Switchover in a 12.1 RAC Environment
(Rene Antunez) The other day I did a switchover in a RAC environment , which went pretty smooth , but after doing the switchover in the primary, I kept getting the following error:
Cloning an Oracle Home
(Zahid Anwar) You may wish to clone an Oracle Home, for example you have all your databases on a single Oracle Home but you want to separate Development from Test.
SUM is better than DISTINCT
(connormcdonald) There is a good chance that (based on this blog post title) that you’re expecting a post on SQL, and that’s understandable. But I’ll come clean nice and early – that was just to lure you in
Oracle IOTs against SQL Server Clustered Indexes
(Kellyn Pot’Vin-Gorman) I’m itching to dig more into the SQL Server 2016 optimizer enhancements, but I’m going to complete my comparison of indices between the two platforms before I get myself into further trouble with my favorite area of database technology.
Optimization that Violates Data Integrity
(Oren Nakdimon) In the previous post I showed that Oracle does a nice optimization when we add a new (nullable with no default value) column with an inline check constraint in a single ALTER TABLE statement.
search for the missing ORA-04068
(Martin Berger) Oracle Active Dataguard is a great software for offloading read only activities from the primary nodes to nodes which is not utilized anyhow (at least during non-disaster times).
