Pages

Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Know your tables in Oracle

Thursday, 14 February 2013

DBA_TABLES View 




Have you ever thought of knowing statistics about your tables in oracle.
Statistics in terms of Owner,Tablespace, Number of Rows, Number of Blocks used, Number of Blocks empty,etc.
I was just trying to see what system tables does oracle has with it.
I tried
select * from tab;

BOOM BOOM what a surprise More then 2000 objects listed ...................
some of these objects are tables and some of these objects are views.


Read more ...