(Fahd Mirza) Due to some unexpected data load, the space in DATA diskgroup became critically low on one of the production systems during middle of night on the weekend. There was no time to get a new disk and we needed the space to make room for new data load scheduled to be run after 3 hours.
(stewashton) Applications today use “optimistic locking” to avoid lost updates.
(Hemant K Chitale) Earlier I have already demonstrated adding and managing custom services in a RAC environment in a blog post and a video.
(Uwe M. Küchler) Some troubles — especially those happening only sporadically — are not so easy to shoot and call for a deeper understanding of the matter. In the following real-world example this means: SQL*Net Tracing and some knowledge about the inner workings of the server’s operating system, pa
(stewashton) My goal is to show how ORA_ROWSCN can help deal with the problem of “lost updates”. Before that, I need to explain the use case I have in mind: an OLTP application that provides a transactional API in the database, using JSON for data interchange, across a stateless connection.
(Harry Dragstra) While I prefer a “loosely coupled architecture” for replication between Oracle and SQL Server, sometimes a direct (database) link cannot be avoided. By using DBMS_HS_PASSTHROUGH for data extraction the 2 other ETL processes (transformation and load) can be configured and administere
(connormcdonald) Interval partitioning was a great feature when it arrived in version 11, because we no longer had to worry so much about ensuring partitions were available for new data when it arrived.
(Uwe Hesse) Virtual Private Database (VPD) aka Fine Grained Access Control may seem complicated at first when you look at the fine documentation about it.
(Bobby Curtis) Starting in Oracle GoldenGate 188.8.131.52, the manager process is more secure than in previous releases of Oracle GoldenGate. After the inital install and running of the Manager process, you may run into the following warning message upon a restart of the Oracle GoldenGate environment:
(mdinh) I was working on automating debug information to submit to Oracle Support and thought I share implementation for what was requested.