Today I've implemented an approach to monitor OGG latency. Here I will describe what I've done. 1. Create a table gg_latency in source and target databases: create table gg_latency
We had a performane issue for a prodcution database today. The CPU utilization went up. When I logged into the server and tried to log into
the database as sysdba, I got ORA-00020 error: $sqlplus "/ as sysdba"
SQL*Plus: Release 126.96.36.199.0 Production on Fr...
I have a monitoring job set up to alert me when the buffer gets per execution of a SQL above certain threshold.
Today I received one as below: =================================================
start : 13-MAR-15 02.00.23.885 PM
end : 13-MAR-15 03.00.48.1...
Recently I have been planning to upgrade a 10.2.0.4 Oracle database to 188.8.131.52. For that, I created a test db called minidb to play with upgrade steps. At the end, I need to bring up a listener for that db. This is what I've just learned: do you know we ca...
- Oracle DBA, present
Born in Chongqing, grew up in Shanghai, both in China. Earn a living in USA now as an Oracle DBA. I find I am enjoying what I am doing with Oracle. Before starting my IT career, I had several years of research experiences in the area of catalysis, materials chemistry,computational chemistry and computer simulations.