Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VSIZE Function

Status
Not open for further replies.

amolso

Programmer
Sep 8, 2000
71
IN
Can anyone help me on how to use vsize function
to calculate memory occupied my each record.
I need syntax.
Thanks in advance
Amol

 
From Metalink:

se the VSIZE comand to determine the number of bytes taken by data stored in
Oracle.

For example:
============

select vsize(2) from dual;

VSIZE(2)
-----------
2


select vsize(-2) from dual;

VSIZE(2)
-----------
3


select vsize(9999999999) from dual;

VSIZE(9999999999)
-------------------
6
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top