Adapt Next Extents with BRCONNECT (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

Adapt Next Extents with BRCONNECT

Use

You can use BRCONNECT to adapt the next extents size. The aim is to avoid the structure of tablespaces deteriorating – that is, breaking up into a large number of small extents – because this reduces database performance.

Recommendation

We strongly recommend you to use this BRCONNECT function rather than the equivalent SAPDBA one, sapdba -next <tablespace(s)>. The reason is that we will in future no longer develop the SAPDBA functions, whereas BRCONNECT functions will always be fully up-to-date.

Prerequisites

The database tables and indexes are assigned to one of a number of categories. The standard size of the next extent for each category is defined in the tables TGORA (for tables) and IGORA (for indexes).

Activities

When a table requires adapting, the size of the next extent is determined using an algorithm. This also makes sure that the value of MAXEXTENTS for a table or index is not less than the value defined in the TGORA or IGORA table.

You can exclude specified tables or indexes from this function by using the next_exclude parameter.

You can specify individual values for NEXTEXTENTS or MAXEXTENTS using the next_special parameter.

For more information on the command line options for adapting the next extents, see -f next.