[…]
It is during our darkest moments that we must focus to see the light!
Month: December 2020
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 […]