Home » RDBMS Server » Performance Tuning » How test performance of table? and how to calucalate row size min and max of the Table
- How test performance of table? and how to calucalate row size min and max of the Table [message #133990] Tue, 23 August 2005 02:48 Go to next message
sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore
Member

i have a tables with 12 million records and 48 milion records and 24 million records

now i want calucalate the performance of those tables,how can i do that

for the above same tables i have calucalate space accoupied for each row and entaire table

please tell me the best way .....


advance thanks

Sreenivas
- Re: How test performance of table? and how to calucalate row size min and max of the Table [message #134306 is a reply to message #133990] Wed, 24 August 2005 04:36 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Pls gather table statistics first.

Regds
Girish
- Re: How test performance of table? and how to calucalate row size min and max of the Table [message #134614 is a reply to message #133990] Thu, 25 August 2005 14:34 Go to previous message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

First gather the statistics .. and then check the dba_tables for a column called as avg_row_len (i dont remember the column name...cant login to db now Smile ) that should give you the row length ..

Regarding the table size ..
select sum(bytes)/1024/1024 MB from dba_segments where segment_name='TABLE_NAME';

Hope that helps
-Sai Jeedigunta
Previous Topic: tune the query
Next Topic: Optimizer=Choose Error
Goto Forum:
  


Current Time: Fri Mar 07 14:27:09 CST 2025