Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_SPACE.CREATE_TABLE_COST - binary_double field

RobeenFeb 13 2020 — edited Feb 14 2020

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

/

Comments

Murali Pasumarti

You are almost there, try the below,

Equals(Integer,PropValue(Core.Children),0)

(Or) you can execute a Query with #Children Equal 0.

1 - 1

Post Details

Added on Feb 13 2020
5 comments
196 views