Understanding how oracle internally manages the transactions is very crucial for your applications. Dealing with the database as a black box (sending queries and receiving results), will end up with bad performance to your application or/and non-scalable application. Oracle uses locks to internally manages the concurrent access to data.Only one transaction can modify any piece … Continue reading Oracle Database Locking Policy – Back to Basics
Are you looking for a virtual machine to do some hands-on labs or practice something (i.e. for Educational purposes}? Do you have the time to build these virtual machines yourself? Below are some really nice Virtual Machines, that I invested allot of time to build on Oracle Virtual Box, and that I used them personally … Continue reading Oracle Virtual Machines for Sale !
In this post, I'm going to explain how to install Oracle sample schemas, if they are not already installed. If you created a database sing DBCA , you can select to install the sample schemas: Or you can install sample schemas manually after the database creation as explained in this post. Download the Scripts: Starting … Continue reading Installing Oracle Sample Schemas (19.3)
This is a quick post about installing Oracle Database 19c (19.3) on my laptop (Windows 10). Procedure will be presented as screen cast. As far as I remember, Oracle 19c was released during Mar-2019 for Linux, and during Apr-2019 for SPARC Solaris and during Jun-2019 for Windows,zLinux , HP and AIX Software Download: First of … Continue reading Oracle Database 19c (19.3) Installation on Windows (Step-by-Step)
Oracle Database 19c is now available for Linux x86-64. To download the software:https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Also, the documentation is available at: https://docs.oracle.com/en/database/oracle/oracle-database/19/books.html Enjoy ! ThanksAhmed