Nov 15, 2000 #1 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
Can anyone help me on how to use vsize function to calculate memory occupied my each record. I need syntax. Thanks in advance Amol
Nov 16, 2000 #2 carp MIS Sep 16, 1999 2,622 US 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 Upvote 0 Downvote
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