Sunday, June 9, 2013

How to Retrieve ORACLE Usage Statistics

As promised before, I'm going to tell you how to retrieve ORACLE usage statistics. Just as MySQL, ORACLE also stores its statistics in some internal databases.Here is an SQL script to retrieve its disk usage statistics.

NOTE: Make sure you replace ":owner" with admin username.

Reference: http://stackoverflow.com/questions/264914/how-do-i-calculate-tables-size-in-oracle

Next post will be on how to retrieve statistics data in Apache Cassandra.

No comments:

Post a Comment