OraFAQ Forum: Performance Tuning » size of the tables

Home » RDBMS Server » Performance Tuning » size of the tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

size of the tables [message #64805]

Sun, 08 February 2004 20:43

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

Report message to a moderator

Re: size of the tables [message #64811 is a reply to message #64805]

Mon, 09 February 2004 06:56

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

Report message to a moderator

Previous Topic:	1oo Hit Ratio
Next Topic:	local vs dictionary tablespaces

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 19 21:47:08 CST 2021