SQL> variable used_bytes number; SQL> variable alloc_bytes number; SQL> exec dbms_space.create_index_cost('create index cust_idx2 on cust(first_name)',:used_bytes,:alloc_bytes); PL/SQL procedure successfully completed. SQL> print :used_bytes USED_BYTES ---------- 25 SQL> print :alloc_bytes; ALLOC_BYTES ----------- 65536 SQL> create index cust_idx2 on cust(first_name); Index created. SQL> select bytes from user_segments where segment_name='CUST_IDX2'; BYTES ---------- 65536 SQL> |
DBA's Home Page - A website for Oracle, Greenplum and PostgreSQL DBA's > DBA's Forum, Routine Tasks and Activities >