Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)

lundi 31 octobre 2016

Initial Extent Size of a Partition Changed to 8MB from 64KB After Upgrade to 11.2.0.2 or Later

 


This feature is controlled by _partition_large_extents for tables and _index_partition_large_extents for indexes

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
set linesize 210
col "Parameter" format a30
col "Session Value" format a20
col "Instance Value" format a20
col "Desc" format a70
select a.ksppinm  "Parameter", c.ksppstvl "Instance Value", ksppdesc "Desc"
from sys.x$ksppi a, sys.x$ksppcv b, sys.x$ksppsv c
where a.indx = b.indx and a.indx = c.indx
and substr(ksppinm,1,1)='_'
and a.ksppinm like ('%_partition_large_extents');
 
Parameter                      Instance Value   Desc
------------------------------ ---------------- -------------------------------------------------------
_partition_large_extents       TRUE             Enables large extent allocation for partitioned tables
_index_partition_large_extents TRUE              Enables large extent allocation forpartitioned indices

The details of the behavior change are available in the below metalink.

Doc ID 1295484.1 — Initial Extent Size of a Partition Changed to 8MB from 64KB After Upgrade to 11.2.0.2 or Later.

Aucun commentaire:

Enregistrer un commentaire