Oracle DB 12.1.0.2
RHEL 7.4
Hello Team,
can anyone pls advise what value should I use with BINARY_DOUBLE?
Reference:
https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_space.htm#i1002261
set serveroutput on
DECLARE
ub NUMBER;
ab NUMBER;
cl sys.create_table_cost_columns;
BEGIN
cl := sys.create_table_cost_columns(
sys.create_table_cost_colinfo('VARCHAR2',11 ) ,
sys.create_table_cost_colinfo('VARCHAR2',2 ) ,
sys.create_table_cost_colinfo('VARCHAR2',20 ) ,
sys.create_table_cost_colinfo('NUMBER',20) ,
sys.create_table_cost_colinfo('NUMBER',20) ,
sys.create_table_cost_colinfo('TIMESTAMP (6) , <<<<<<<<<<<<<<<<<<------------------- should i replace this with DATE,NULL ?
sys.create_table_cost_colinfo('VARCHAR2',30 ),
sys.create_table_cost_colinfo('VARCHAR2',20 ) ,
sys.create_table_cost_colinfo('VARCHAR2',20 ) ,
sys.create_table_cost_colinfo('VARCHAR2',10 ) ,
sys.create_table_cost_colinfo('BINARY_DOUBLE , <<<<<<<----------------------------
sys.create_table_cost_colinfo('VARCHAR2',255) ,
sys.create_table_cost_colinfo('NUMBER',10) ,
sys.create_table_cost_colinfo('TIMESTAMP (6), <<<<<<<<<<<<<<<<<<------------------- should i replace this with DATE,NULL ?
sys.create_table_cost_colinfo('VARCHAR2',100 ) ,
sys.create_table_cost_colinfo('VARCHAR2',100 )
);
DBMS_SPACE.CREATE_TABLE_COST('BIREPORT',cl,16709155 ,10,ub,ab);
DBMS_OUTPUT.PUT_LINE('Used s = ' || TO_CHAR(ub));
DBMS_OUTPUT.PUT_LINE('Allocated s = ' || TO_CHAR(ab));
END;
Thanks,
Joe
/