Home » RDBMS Server » Performance Tuning » size of the tables
size of the tables [message #64805] Sun, 08 February 2004 20:43 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
hi all, i got 300 tables in my database. how to find out the size of each table so that while tuning SQL queries i know which table is of what size? any script to calculate the table sizes will be much appreciated.

thanx in advance
Re: size of the tables [message #64811 is a reply to message #64805] Mon, 09 February 2004 06:56 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
example:

SQL> execute dbms_stats.gather_schema_stats('THIRU');

PL/SQL procedure successfully completed.

SQL> select table_name,blocks,num_rows from user_tables;

TABLE_NAME                         BLOCKS   NUM_ROWS
------------------------------ ---------- ----------
DEPT                                    4          4
EMP                                     4         14
T                                       0          0
T2                                      4          4
T3                                      5          1
TIMESTAMP_T                             5          1
T_BAK                                   4         14
T_TEMP                                  0          0

8 rows selected.



-Thiru
Previous Topic: 1oo Hit Ratio
Next Topic: local vs dictionary tablespaces
Goto Forum:
  


Current Time: Thu Mar 28 06:45:21 CDT 2024