[…]
It is during our darkest moments that we must focus to see the light!
Our greatest weakness lies in giving up. The most certain way to succeed is always to try just one more time.
[…]
Life is like riding a bicycle. To keep your balance you must keep moving.
[…]
Fall 2020 Canada
[…]
Leafs of Canada
[…]
Lucky misses the summer days
[…]
Believe you can or cannot, either way, you are right!
[…]
Looking for Locking / Blocking Sessions in ORACLE
There are many ways to find locking /blocking sessions in Oracle, this is what I normally use. If Blocker is identified, in certain case you many need to kill the blocker session with below command: […]
PowerShell to retrieve and parse RSS news feeds
RSS is a very command news feeds, often I need to retrieve the feeds and load into the relational database. Recently I’ve been using PowerShell to manage schedule jobs on Windows system. I found it’s pretty easy to do RSS feeds in PowerShell. Here is a small sample code to share: […]
Step by step instruction to setup an Oracle Active Standby Instance using RMAN
This instruction is created for Oracle on Windows, it also applies to Unix/Linux installations. The difference will be mainly the folder path locations. Master Instance: ProdServer:1521/DB1 Target Active Standby Instance: StandbyServer:1521/DB1STANDBY (new installation) Preparation: Run below query to check if ARCHIVING LOG, FORCE LOGGING is enabled on the Primary database, if not enable them. On […]