Oracle Database - Recursive call caused by space requests

> Database > Oracle Database

Table of Contents

1 - About

Recursive calls can be performed to satisfy requests for space due to :

  • disks sort
  • a large modification to a table that require it to extend

This is generally not a problem with locally managed tablespace where space is managed as bitmaps in the datafile headers. It can happen with dictionary-managed tablespace, where space is managed in database tables much like your own data is managed.

By default from the version 9iR2, the system tablespace is created as a locally managed tablespace and you can't create any dictionary-managed tablespace

Advertising
db/oracle/recursive_calls_space.txt · Last modified: 2017/09/06 19:29 by gerardnico