Subtotal of oracle index establishment

SQL > create index idx_test on test (id1) tablespace IDX nologging online parallel 4 * * Index created.SQL > alter index idx_test noparallel;Index altered.SQL > select degree from dba_indexes where index_name='IDX_TEST' In a 2407 application of DEGREE--1, it is necessary to modify the general index of a table with a data level of 10 million or above with a large number of visits (aforme b) to a unique constraint (aformab) create index idx_test on test (ameme bjorc) online. Alter table test add constraint cons_test unique (a dint bjorc) using index idx_test; first moves the table space: SQL > alter table test move tablespace LLC;Table altered. Then move the table space of the index: SQL > alter index idx_test rebuild tablespace LLC;Index altered. Query the distribution of the index (or table) on the data file: SELECT DISTINCT (b.file_name), a.owner, a.segment_name FROM dba_extents a, dba_data_files b WHERE a.file_id = b.file_id AND a.segment_name = 'IDX_LOTHISTORY_MODULEID' AND a.owner =' RPT'

Re-index and focus on the use of temporary tablespaces:

SELECT round ((f.bytes_free + f.bytes_used) / 1024 / 1024, 2) "total MB", round ((f.bytes_free + f.bytes_used)-nvl (p.bytes_used, 0)) / 1024 / 1024, 2) "Free MB", d.file_name "Datafile name", round (nvl (p.bytes_used, 0) / 1024 / 1024, 2) "Used MB" Round ((f.bytes_free + f.bytes_used) / 1024, 2) "total KB", round ((f.bytes_free + f.bytes_used)-nvl (p.bytes_used, 0)) / 1024, 2) "Free KB", round (nvl (p.bytes_used, 0) / 1024, 2) "Used KB", 0 "Fragmentation Index" FROM sys.v_$temp_space_header f Dba_temp_files d, sys.v_$temp_extent_pool p WHERE f.tablespace_name (+) = d.tablespace_name AND f.file_id (+) = d.file_id AND p.file_id (+) = d.file_id