Oracle database’s dynamic performance views, better known as v$ views, have loads of useful information related to the internals of Oracle database. But you have to...
Continue reading...Scripts
Creating Private Database Link in Another Schema
Sometime as a DBA you’ll need to (re)create a private database link in another schema. If you have that schema’s password, it’s pretty straight forward; grant...
Continue reading...Copy to Clipboard – KiTTY or Putty
I sometimes forget to add this function to the .bashrc file in a new server that I setup for Oracle database or middleware, and then I...
Continue reading...