Database System Views – A quick comparison

One of the best friends of Database Administrators , irrespective of race(read engine) and religion (read edition)  are the System Views.  System Views have simplified troubleshooting and performance tuning a lot in the past few years. Couple of versions ago DBAs had to write complex scripts and stored procedures to join, extract, transform and compare data to reach performance matrix. But now the database vendors got smarter and created system and dynamic views that does all that behind the scene and give the DBAs the information in a more intelligent fashion.
Lets compare some of the key dynamic views DBAs use on a regular basis :

The above and many more dynamic and systems views and routines can be found for those three databases at

If anyone has any tips and tricks or useful scripts, please post it on the comments

About rpillai

I am a technology enthusiasts and love to work with databases and other technology. Learning new things everyday and don't think the path ever ends ...
This entry was posted in database, db2, how to, Oracle, sql server and tagged , , , , , , , , , , . Bookmark the permalink.