How to recognize your oracle database architecture #JoelKallmanDay

I’m very happy to notice Tim Hall‘s blog note – Joel Kallman Day 2022 : Announcement on Twitter and LinkedIn on Sep 27th (at the end of last month). To be honest I’ve participated the commemoration day twice resptectively on 2019 and 2021 (2020 – “called off it” due to the pandemic). Of course I…

A series of blog notes about Vertica Database

Last month I specially took large amount of time writing several blog notes about Vertica Database on modb. Now I collect them into a total list here: What’s Vertica Database? Using Tableau to visualize the Vertica Database by “DB Time” (Chinese) Using Tableau to visualize the Vertica Database by “LPS & TPS” (Chinese) Using Tableau…

The catalogue of visualizing performance data

Hello everybody, happy new year 2022! Hope to you keep safe and healthy. Perhaps you’re curious about why I haven’t frequently published blog posts in recent two months. Nope, my several blog notes have been continuously published on modb (which is a popular and famous database technology community in China) during the period of that…

Oracle Performance Metrics #JoelKallmanDay

I’ve finished reading the blog post published by Tim Hall on his blog on Oct 04, 2021, you know he shared it by LinkedIn and Twitter as well on the same day. Yes, so many oracle folks and friends all retweet his post (of course include me), It has no doubt that that post has…

The query result of a view will be different than before if whose related table has subsequently inserted some new data

A few days ago I once published a SQL script about how to check and monitor the used size of several big tables in your oracle database on my Github repo. Here I have to illustrate that I use a VIEW to simplify/mask the complex query result of retrieving big tables using a SQL statement…

Autonomous Database Quick Start Tutorial – 3

In this tutorial I will show you how to visualize my data in my Oracle Autonomous DataWarehouse (the ADW database instance of Oracle Autonomous Database). Before you read this post you need firstly read my another two number of blog posts have been published a couple of days ago. They are in sequence as follows:…

Autonomous Database Quick Start Tutorial – 2

In the previous tutorial I have finished provisioning an Oracle Autonomous Data Warehouse and connecting to it with SQL Worksheet. Therefore, in this tutorial I will guide you how to loading data into my autonomous database (ADW) instance. I will upload some files to Object Storage of the Oracle Cloud Infrastructure (OCI) and create sample…

Autonomous Database Quick Start Tutorial – 1

With Oracle Autonomous Database we make it quick and easy for you to create a secure, fully managed database service in the Oracle Cloud which allows you to start loading and analyzing your data immediately. What is an Autonomous Database? Oracle Autonomous Data Warehouse (ADW) and Oracle Autonomous Transaction Processing (ATP) are built around the…

Three Approach finding out the different entries between two LOG files

I guess some guys and friends who have followed my social media on both Twitter and LinkedIn may have noticed that a couple of days ago I once announced A demo with secure copying RMAN EXP[DP] backup files to another server has been added into my Github repository. Especially full_and_incr_scp_oracle_rman_expdp_or_exp_3.sh is one of my most…

ORA-10560: block type ‘KTU UNDO BLOCK’

In the middle of last month an oracle Data Guard standby database of our production system there had shown the very weird message in its ALERT log file.