Skip to content

query

Listing and querying Oracle Enterprise Manager metric extensions

I recently wanted to work on Metric Extensions automation, and realized the task was a bit more complicated than I thought. My original idea was to look into the emcli verb list, but I was unlucky. In fact, emcli does not allow you to retrieve information about Metric Extensions. I had to dig further, looking into the Enterprise Manager SYSMAN… 

M-Files BD – Queries: objectType, class, filters, date tokens

In the previous posts of this series, I covered the anatomy of a dashboard definition and the seven widget types (KPI & gauge, line & area, donut, bar & table) the engine supports, as of now. In this one, we will go through the Business Dashboard queries, i.e. the query section that I pretty much ignores so far. It is… 

Using Oracle API for MongoDB on OCI

If you’ve ever had to deal with MongoDB after years (or even decades) of working with SQL, you’ve probably realized that querying JSON documents can sometimes be painful, to say the least. In response to this, Oracle (and others) use a not-so-native adaptation of SQL to query JSON documents. And if you’ve ever had to deal with these SQL-based JSON… 

Documentum – xPlore Dsearch not starting with a stuck rebuild

I recently faced another interesting issue (c.f. this one) with Documentum xPlore where the Dsearch would refuse to start because of a stuck online rebuild. It happened on a Kubernetes environment using custom images we built (for security and scalability). The K8s Nodes were split across two DataCenters for DR reasons. However, one of the DataCenter had an important issue… 

Documentum – xPlore CPS temporary folder not being cleaned properly

At a customer using Documentum inside Kubernetes, unusually frequent restarts of xPlore containers were noted a couple weeks after the introduction of CPS Only pods on the different Production environments. The customer had a very simple Standalone xPlore setup, with Dsearch+IndexAgent, but without CPS Only Nodes. It was noticed at this customer that the indexing and search load was reaching… 

Grail and Dynatrace Query Language

In my last dynatrace blog, I presented how to go from logs to dashboard. This could look like a complex process for such a simple task. Moreover, this does not work on historical data as metric will be only populated at the time of the definition even if it was present in the log before. Recently, dynatrace introduced Grail. Grail… 

RDBMS (vs. NoSQL) scales the algorithm before the hardware

By Franck Pachot . In The myth of NoSQL (vs. RDBMS) “joins dont scale” I explained that joins actually scale very well with an O(logN) on the input tables size, thanks to B*Tree index access, and can even be bounded by hash partitioning with local index, like in DynamoDB single-table design. Jonathan Lewis added a comment that, given the name…