Blog

Exadata Database Machine: 12c Administration Workshop

This Exadata Database Machine: 12c Administration Workshop training introduces you to Oracle Exadata Database Machine, covering the features and capabilities of the Exadata Database Machine X6 product family. In this course, you will be introduced to Oracle Database Exadata Cloud Service. Explore the various Exadata Database Machine features and configurations, with emphasis on the unique … Continue reading Exadata Database Machine: 12c Administration Workshop

Demo for Oracle Database Locking Policy

https://www.youtube.com/watch?v=6GUZ9STZ4po

Oracle Database Locking Policy – Back to Basics

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

Virtual Machine with Oracle Database 12c R2 12.2 and Oracle Restart

https://youtu.be/qsepeUPQ-JU For more information on how to get this VM and other similar machines, please refer to:https://ahmedfattah.com/2020/06/13/oracle-virtual-machines-for-sale/ ThanksAhmed

Oracle Virtual Machines for Sale !

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 !

Oracle Single-Instance Database Creation in a Clustered Environment

https://www.youtube.com/watch?v=LTXFohjMwqY

Python Script to Track Coronavirus in Your Country

covid is python package to track the Coronavirus spread in your country.It requires Python 3.6 or later.To install this package: pip install covid Following is a sample script to use this package to track coronavirus numbers for specific country ( here I use Egypt with id=71 as an example): Following is a sample output for … Continue reading Python Script to Track Coronavirus in Your Country

Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation

While trying to open one pluggable database, I got the following errors: Background: While installing Apex 20.1 in one PDB, and while being very close to the installation completion, the session fully stucked.I restarted the database (the CDB), then I tried to open the PDB, but I got the above errors. While searching for this … Continue reading Alter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation

Python Script to format the output of one SQL statement

I received a text file from a client that contains the output of one sql script (The output represents detailed statistics about all sql statements running in one critical database). The output is similar to the following: You can download a sample file similar to that of our client from:https://1drv.ms/u/s!ArrpKxPFc2APxRw0izNXIYqVHGdw?e=UCgUBs The output is not formatted … Continue reading Python Script to format the output of one SQL statement

ORA-38760 While starting an Oracle Database

This is a quick post about an issue that I faced while trying to start one database yesterday. When I was trying to open one 12cR1 database, I got the following error: SYS SQL>alter database open;alter database open*ERROR at line 1:ORA-38760: This database instance failed to turn on flashback database The database status was "mounted": … Continue reading ORA-38760 While starting an Oracle Database