As a technical person who works with a relational database every day, there are needs for me to know the database schemas. I need a graphical schema to show relationships of tables as a reference which I can review from time to time. And when a new product or a new version of an existing … Continue reading SchemaSpy — Graphical Database Schema Metadata Browser
Month: April 2020
Redo & Standby Redo files created as OMF when duplicating a standby database
Redo log is crucial for recovery. An Oracle database consists of two or more redo log files. If a database is in archive mode, Oracle database writes changes (change vectors, a.k.a redo entries) to one of redo log files while others are being archived. Redo records are buffered in a circular fashion in the redo … Continue reading Redo & Standby Redo files created as OMF when duplicating a standby database
pyenv installation on Oracle Linux 6.10
In this post, I am demonstrating how to install pvenv on an Oracle Linux 6.10 and hwo to use pvenv to create a virtual envrionment with a python 3 version which is different than the version 2.6.6 coming with Oracle Linux 6.10. In one of my prvious posts, I've explained different types of Python virtual … Continue reading pyenv installation on Oracle Linux 6.10
Getting AWR report every hour automatically
This week I got a request to share a script I wrote years ago -- a script to generate AWR report automatically every hour and email it out to whoever is interested in it. Bascially it uses Oracle's script awrrpti.sql. As the comments in the SQL script say, once the following variables defined, running it … Continue reading Getting AWR report every hour automatically
JoeLi's TechLife 