Exact memory usage of a Linux process
Understanding how memory utlisation works in Linux is somewhat complex. Even popular Linux tools such as 'top' and 'ps' do not report…
List all indexes in an Oracle tablespace
Sometimes Oracle DBAs need to do some tablespace cleaning and moving indexes from one tablespace to another. If you have hundreds of indexes this may…
Choose the Database Index: Selectivity and Cardinality
It is a known fact that most of the database performance tuning is achieved by building a suitable index. In most database engines, such as Oracle an…
Happy Birthday - 6 years old!
This blog, one of the first ones in the Maltese islands, computes its 6th year today. One can browse through old blogposts in the archives menu on th…
Create Oracle Backups in Enterprise Manager
If your Oracle database is connected to the Oracle Grid you can easily manage your backups through Enterprise Manager. This allows you to schedule a …
