Category: Blog Post
-
ODC Appreciation Day : Reduce CPU usage by running the business logic in the Oracle Database
ODC Appreciation Day : Reduce CPU usage by running the business logic in the Oracle Database Here is my #ThanksODC post. A long one… There’s a point that should always be a major topic for database developer community discussions: where to run the procedural code. The access to data is in the database, for sure,
-
Configuring Technologies to Work with Java Mission Control
Configuring Technologies to Work with Java Mission Control Introduction Java Mission Control was introduced with JDK 7u40. With JDK 8u40 and later, you can get JMC to monitor any Java workload out of the box. However, in order to customise how JMC and JFR will act we need to configure the Java Virtual Machines and
-
Unindexed Foreign Keys in Oracle and PostgreSQL
Unindexed Foreign Keys in Oracle and PostgreSQL In Oracle we need to have a index on the foreign key column as soon as we have the intention to delete from the parent row, or a locking situation may block all transactions around the child table. PostgreSQL has a similar way to manage isolation, with MVCC,
-
A new web application for the DBOD service
A new web application for the DBOD service Introduction The DBOD service maintains a web interface allowing “database on demand” users to carry out ordinary tasks without intervention of the administrators. It is with a view to ergonomy, but above all to modularity and scalability, that a complete redesign of this application has been initiated.
-
Oracle write consistency bug and multi-thread de-queuing
Oracle write consistency bug and multi-thread de-queuing Here is a quick test I did after encountering an abnormal behavior in write consistency and before finding some references to a bug on StackOverflow (yes, write consistency questions on StackOverflow!) and AskTOM. And a bug opened by Tom Kyte in 2011, that is still there in 18c.
-
Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID
Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID Did you ever try to query DBA_EXTENTS on a very large database with LMT tablespaces? I had to, in the past, in order to find which segment a corrupt block belonged to. The information about extent allocation is stored in the datafiles headers, visible though X$KTFBUE, and queries
-
Oracle Cloud: upload large files through the Object Store REST API
Oracle Cloud: upload large files through the Object Store REST API In the previous post I used a simple oci-curl() function as a Command Line Interface to the Oracle Cloud Infrastructure without installing any client tool or language. It was easy for simple things such as starting and stopping services. But it can also be
-
Oracle Cloud: start/stop automatically the Autonomous Databases
Oracle Cloud: start/stop automatically the Autonomous Databases In the previous post I’ve setup all the environment to be able to easily control the OCI services without bothering with the sign-in headers, and without installing anything. In this post I’ll used the oci-curl() function to stop all my Autonomous Database services. In the previous post, I’ve
-
Oracle Cloud Infrastructure API Keys and OCID
Oracle Cloud Infrastructure API Keys and OCID As you may have read in the news, CERN is testing some Oracle Cloud services. When a large organisation is using the Cloud Credits, there's a need to control the service resources. This requires automation and then the GUI interface from the Cloud portal is not sufficient. We
-
Optimizer Statistics Gathering – pending and history
Optimizer Statistics Gathering – pending and history How do you manage when you need to gather statistics on some tables in a critical environment? Some queries are too long because of stale statistics. But other queries on the same tables are ok. You cannot leave the inital problem without fixing it. Adding hints or SQL