Simulate a where clause on a “long” type column from SQLPlus
As a DBA you sometimes have to take time to look for tricks to accomplish tasks that seem simple at […]
Oracle
Exadata
Retrieve serial numbers and other useful information from Exadata
It’s been a while since my last post!Today, I wanted to share with you some useful commands to extract information
Oracle
Do my database services run on the preferred instance (s)?
Today, I just want to share with you a little script that I use, which allows me to quickly check
MongoDB
How user authentication works in a shared MongoDB cluster
Today, I want to clarify an important point about users authentication in a MongoDB sharded cluster because this seems to
Oracle
Install EM13c agent and add targets using the Linux command line only
A few days ago, I was asked to find a way to automate the addition of newly created Linux virtual
Elasticsearch
Elasticsearch: useful commands for DBAs
As a production DBA, you can fall into a situation where you have to act on an environment you do
Scripting
Retrieve the exit code of all the commands in a pipeline with “PIPESTATUS”
When developing shell scripts, it is common usage to check the exit code of a command in order to check
Oracle
Recovering from loss of all control files
“Sometimes shit happens”. That’s what I thought when I realized that I had lost all the control files of one
Oracle
Extract the list of all databases with server and OS version of Oracle Enterprise Manager Cloud Control repository
Today, I’m going to share with you a simple SQL query that will allow you to quickly extract useful information
MongoDB
Get indexes usage for all collections of all databases of your MongoDB instance
One possible area of improvement when you encounter bottlenecks when inserting or updating in MongoDB is to limit the number