In another article we have seen how to install Oracle Data Guard, how to create a database as Physical Standby and how to create a Snapshot Standby. In this article we will see how to convert a database that is physical… read more
How to roll back an Oracle Database using a restore point in a Data Guard environment
In a previous article we saw how we can roll back an Oracle Database through flashback database to guaranteed restore point. In this article we will see what procedure we follow in case we have primary and standby databases… read more
How can we increase performance on Oracle GoldenGate Replicat target with parallelism?
If we choose to do the Initial Load before synchronization via GoldenGate Replicat or simply Replicat has a large volume of data to synchronize, one Replicat thread is not enough. In this article we will see two ways to… read more
How to create users in databases that belong to a SQL Server Always On Availability Group
When we create new users in databases that belong to an Always On Availability Group in SQL Server, we want them to work even if they failover to a Secondary node, but when we create a new login in a SQL… read more
How to create a Logon Trigger to control which users are allowed to connect to an Oracle Database
Many times, for security reasons, we may want specific users to connect only from specific machines - servers, and in the event that a connection comes from a different machine, not allow access but display a rejection message.… read more
How do we collect the actual execution plan from queries using Extended Event and how do we read its data
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
