row size, table size, storage size

[dba_admin]

I think this question is pretty easy.

(1) How do you get the row size for the following table? Is there a function in Oracle to calculate this?

SQL> desc cq.MASTER_OPLOG
Name Null? Type
----------------------------- -------- --------------------
SERIAL_NO NUMBER(10)
REPLAY_TIME DATE
REPLICA_TIME DATE
REPLICA_ID NUMBER(10)
EPOCH_NO NUMBER(10)
SCHEMA_ID NUMBER(10)
SCHEMA_REV NUMBER(10)
SCHEMAREV_VERSION NUMBER(10)
TYPE NUMBER(10)
PACKLET_LEN NUMBER(10)

(2) How do you estimate your table size so that you can plan your storage?

[julian]

(1) Are you familiar with the function VSIZE?
(2) ANALYZE TABLE MASTER_OPLOG COMPUTE STATISTICS;
Then, select AVG_ROW_LEN from USER_TABLES where TABLE_NAME = MASTER_OPLOG; Since you know how many rows you have in MASTER_OPLOG, you know now the size of the table.

[nabaig]

Where can I get more information about how to use vsize?

Thanks,
Nizar

[jmodic]

Oracle's SQL manual.

http://otn.oracle.com/docs/products/...tion.htm#80073