SQL Server Configuration Manager is a tool in which many settings of SQL Server are made. In this article, I’ll refer to many of …
Read More »ORA-04031 Unable To Allocate 720 Bytes of Shared Memory
The error ORA-04031 occurs on the shared pool which can indicate one of two things: 1) Insufficient space for the shared pool OR 2) …
Read More »How to improve database performance on MongoDB part3
You should read below articles before reading this article. “How to improve database performance on MongoDB part 1“, “How to improve database performance on …
Read More »Oracle Data Pump (expdp and impdp)
Oracle data pump is new version of imp and exp utilities. It is faster and flexible to the imp and exp utilities used in previous Oracle …
Read More »Reconfiguring Grid Infrastructure Components
If you have cloned an existing server as another server, even if ASM disks and all files are moved, then services like ohas css …
Read More »Benchmark performance of MySQL using SysBench
Before installing MySQL instance, we must evaluate the CPU, Memory, Disk IO performance, Disk size, network of the server, also the maximal QPS(Query Per Second), concurrent …
Read More »POSTGRESQL DATABASE PERFORMANCE – 2
This article is the second article of the performance series. You can find the first articles link “POSTGRESQL DATABASE PERFORMANCE – 1” In the …
Read More »POSTGRESQL DATABASE PERFORMANCE – 1
If we examine some performance parameters in postgresql, I will mention a few parameters that will be quite useful for performance. You can configure …
Read More »Priority Settings in db2
Hi DBAs, how are you? Let’s talk about how to reserve resources for the db2 utilities so they do not compete (directly) with user …
Read More »How To Cancel Concurrent Request from Back End
There are 2 Steps for Cancelling Concurrent Request from Back End : Step 1 :- 1. Run the below SQL query. Give the …
Read More »