Home » Developer & Programmer » Designer » How to calculate a row size of table
How to calculate a row size of table [message #90763] Tue, 02 November 2004 21:15 Go to next message
Anoop Rawat
Messages: 6
Registered: November 2004
Junior Member
 

can anybody pls help me.

Suppose i want to calculate the rowsize of the following table .

can pls tell me what is the formula to calculate the rowsize of table.

And what is the formula to set pctfree and pctused.

TEST>desc e123                                                    
 Name                                      Null?    Type                     
 ----------------------------------------- -------- --
 ENAME                                            VARCHAR2(10)             
 ENO                                                NUMBER(2)                
 DOJ                                                DATE                     
                                                                             
Regards

Anoop Rawat
Re: How to calculate a row size of table [message #90764 is a reply to message #90763] Wed, 03 November 2004 06:40 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
select ename, vsize(ename)+vsize(eno)+vsize(doj) Row_Bytes
from e123;
Re: How to calculate a row size of table [message #90766 is a reply to message #90764] Thu, 04 November 2004 02:41 Go to previous messageGo to next message
Anoop Rawat
Messages: 6
Registered: November 2004
Junior Member
Thanks for your reply.

Can u pls tell me what is vsize. whether it is orcale supplied package or what...

Regards
Anoop Rawat
Re: How to calculate a row size of table [message #90769 is a reply to message #90763] Wed, 10 November 2004 08:01 Go to previous messageGo to next message
José D'Andrade
Messages: 1
Registered: November 2004
Junior Member
MS SQL Server

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=4924
Re: How to calculate a row size of table [message #90771 is a reply to message #90766] Fri, 12 November 2004 05:31 Go to previous messageGo to next message
Ravi Kanth Perepu
Messages: 8
Registered: August 2004
Junior Member
Hi Anoop,

VSIZE returns the number of bytes in the internal representation of expr. If expr is null, then this function returns null.
its a oracle supplied function.

Note :- This function does not support CLOB data directly. However, CLOBs can be passed in as arguments through implicit data conversion.

Regards
Ravi
Re: How to calculate a row size of table [message #90777 is a reply to message #90771] Mon, 22 November 2004 18:15 Go to previous message
Anoop Rawat
Messages: 6
Registered: November 2004
Junior Member
Thanks for your help .
Regds
Anoop Rawat
Previous Topic: contact mechanisms and addresses
Next Topic: Not able to edit in sql prompt
Goto Forum:
  


Current Time: Thu Mar 28 15:37:31 CDT 2024