2011-05-08

DBMS_SPACE.CREATE_TABLE_COST

This procedure is used in capacity planning to determine the size of the table given various attributes. The size of the object can vary widely based on the tablespace storage attributes, tablespace block size, and so on. There are two overloads of this procedure.
·         The first version takes the column information of the table as argument and outputs the table size.
·         The second version takes the average row size of the table as argument and outputs the table size.

This procedure can be used on tablespace of dictionary managed and locally managed extent management as well as manual and auto segment space management.
Syntax
DBMS_SPACE.CREATE_TABLE_COST (

Niciun comentariu:

Trimiteți un comentariu