Many times the need will arise to quickly look for a session that executes a query. We might want to see the plan it ran with, the memory it consumes, the sql text, the session id, if… read more
How can we run multiple scripts in Oracle in Unix environment
In the article we will see how to easily and quickly create a script that can execute multiple other scripts in an Oracle database in a Unix environment. It even provides the ability to stop in case of an error. Creating the executable… read more
How to force a plan in an Oracle database
In a previous article we saw why a query can run with a different plan and how to force one in SQL Server. In this article we will see how to force a plan in an Oracle database with... read more
How to bulk data into database using Oracle Data Pump (impdp)
Many times we will need to keep the table data and their metadata (packages, procedures, functions, etc.) so that we can then import them into the same or a different system. In a previous article we saw the use of Oracle Data… read more
The Great Database Battle – SQL Server vs Oracle Database
The two best-known RDBMS (Relational Database Management Systems) with the largest market shares are Microsoft SQL Server and Oracle Database. They have a lot in common but also a lot of differences between them. Let's see in detail: Filegroups: They are… read more
How can we see historical image of a table in Oracle Database with Flashback Query
Many times we will need to see what entries the table had some time ago. We may still have to restore it from a wrong update or even drop. In Oracle this is easily done using flashback query… read more
How do we return an Oracle database to the previous state of a restore point (Flashback Database to guaranteed restore point)
In the article we will analyze how we can use the flashback database function in a guaranteed restore point in an Oracle database. The flashback database belongs to the category of data protection and provides the possibility to freeze the… read more
Is query join performed between SQL Server and Oracle tables? (aka PolyBase)
In the article we will see a magical way so that we can use in select queries data from external sources (without Linked Server) and more specifically from Oracle Database. What is PolyBase As of SQL Server 2016 the… read more
How to export bulk data from Oracle database using Oracle Data Pump (expdp)
Many times we will need to keep the table data and their metadata (packages, procedures, functions, etc.) so that we can then import them into the same or a different system. The data can be extracted using the… read more
