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...PLSQL
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...