In an earlier article we saw how we activate the Query Store to monitor the performance of the queries and the plan they ran. But as we said, the Query Store has quite a performance impact, so we may want some lightweight profiling. In this... read more
How do we find what permissions a user has in an Oracle database
In this article we will see how we can easily find what privileges a user has either on objects such as tables, or system rights such as e.g. the right to create users. At first we will see one by one… read more
How we enable Unified Auditing in Oracle Database
In a previous article we saw how to activate Auditing in Oracle Database, in this article we will see how to activate Unified Auditing which allows us to put filters and so that we can record. Unlike the… read more
What is PostgreSQL and how do we do a full installation
In this article we will look at another Relational Database Management System (RDBMS) PostgreSQL. PostgreSQL is the most advanced open source relational database. As open-source, it does not require the purchase of a license and is free. OR… read more
How do we configure GoldenGate replication to read from Oracle Data Guard Standby
In this article we will see how we can configure an extract process to extract its trail files from the Standby logs without affecting the Primary. This way is called… read more
How can we connect Oracle Database to SQL Server using Oracle Gateway on Linux
In this article we will see how we can execute queries on remote SQL Server from Oracle Database on Oracle Linux / Red Hat Linux. In a previous article we saw how the reverse process is done so that we can connect from... read more
How do we automate the process of checking the integrity of databases in SQL Server without using a maintenance plan
From time to time we have to check the integrity of our bases for any corruptions. In this article we will see the easiest and most efficient way to check for corruption in all instance databases. This… read more
How can we connect Oracle Database to SQL Server using Oracle Gateway on Windows
In a previous article we saw how we can run queries on a remote SQL Server from an Oracle Database located on Linux through Oracle Database Gateway. In this article we will see how to install Oracle Gateway respectively... read more
How can we get email whenever PGA memory exceeds a limit in Oracle database
When an Oracle database is heavily used by many connections / sessions, one or some of them may consume a large percentage of memory (RAM). If there is a problem and it is not addressed due to lack of memory it may… read more
