OraFAQ Forum: Performance Tuning » How test performance of table? and how to calucalate row size min and max of the Table

Home » RDBMS Server » Performance Tuning » How test performance of table? and how to calucalate row size min and max of the Table

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

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

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

Report message to a moderator

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

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Pls gather table statistics first.

Regds
Girish

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	tune the query
Next Topic:	Optimizer=Choose Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 16:52:51 CST 2024