-f next (SAP Library - SAP Database Guide: Oracle (BC-DB-ORA-DBA))

-f next

This BRCONNECT function adapts the next extents of database tables. For more information, see:

Adapt Next Extents

Algorithm for Determining Next Extent Size

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.

Function options:

-e|-exclude: Defines tables and indexes to be excluded from adapting next extents

Input syntax: -e [<owner>.]<table>,[<owner>.]<index>,<tablespace>|<object_list> |all_part|null

Default: No exclusion, process all selected objects

all_part means that SAP partitions (such as in Business Information Warehouse and Advanced Planner and Optimizer) are excluded from the check.

null invalidates the exclusion list defined by the next_exclude parameter. This means that no tables or indexes are excluded from processing.

You can use this option to exclude from processing tables or indexes with exceptional space parameters. This option overrides the next_exclude parameter.

-f|-force: Forces the next extent size of all selected tables and indexes to be reduced to the maximum free extent size in the tablespace or to the maximum next extent size (next_max_size parameter) if required.

Input syntax: -f free|max|both|nocasc

Default: both

The next extent size is not normally reduced, but only rounded down to the next multiple of 5 times the database block size.

free: reduces the next extent size to the maximum free extent size in the tablespace

max: reduces the next extent size to the value of parameter next_max_size

both: reduces the next extent size to the smaller of the values free and max

nocasc: With this option, you can prevent the check and, if necessary, the adjustment of NEXT extents from being implicitly performed for all indexes for the selected tables. This option is only provided for exceptional situations.

-l|-limit: Defines the maximum number of next extents (MAXEXTENTS)

Input syntax: -l <count>

Default: Settings from tables TGORA and IGORA

0 means unlimited number of extents

This option overrides the next_limit_count parameter.

-m|-max: Defines the maximum size for next extents, which must not be exceeded when a next extent is adapted

Input syntax: -m <size>

Default: 2 GB - 5 * <database block size>

0 means unlimited next extent size

You can specify this option in KB, MB, or GB. This option overrides the next_max_size parameter.

-o|-owner: Defines the database owner of tables and indexes to be processed

Input syntax: -o <owner1>[,<owner2>,...]

Default: SAPR3/SAP<SID> in a standard database or all SAP owners in a multi-schema database.

This option overrides the next_owner parameter.

-s|-special: Defines special sizes of next extent and maximum number of next extents for exceptional tables and indexes

Default: Derived from internal rules for determining next extent size

This option overrides the next_special parameter.

<size>: size of next extent for specified table or index (NEXTEXTENT)

<limit>: maximum number of next extents for specified table or index (MAXEXTENTS)

all_sel: sets NEXTEXTENT and MAXEXTENTS attributes to a certain value for all the database objects selected using the -t function option or the next_table parameter (see below).This option is provided for exceptional situations.

null invalidates the special list defined by the next_special parameter. It means that no tables or indexes are to be processed in a special way.

-t|-table: Defines the database objects (that is, tables, indexes, or tablespaces) to be processed

Default: All objects of selected owners

all: All SAP tables and indexes

special: Only tables and indexes defined in the next_special parameter

This option overrides the next_table parameter.