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: Tue Dec 06 21:47:07 CST 2022