Mastering the Oracle Stack, One Post at a Time.
Oracle Database, the related services (cloud) and various options in the database.
As a DBA, you must be familiar with the various tools provided by My Oracle Support (MOS) for diagnostics and health check. Here are few every DBA must be familiar with, which will help you when everyone else in the organization is jumping on you to resolve a failure or troubleshoot a performance issue. 1513912.2 … Read more
In May 2014, the following #oratidbit relating to invisible columns were tweeted. In #DB12c, you can make a column in table as INVISIBLE. When you make it invisible, the COL# column in COL$ dictionary is updated to 0, thus is not included in the “SELECT *” or “INSERT INTO VALUES”, unless specifically selected. When you … Read more