Oracle Database - Recursive call caused by space requests

Card Puncher Data Processing


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

Discover More
Card Puncher Data Processing
Oracle - Recursive Calls

Sometimes, in order to execute a SQL statement issued by a user, Oracle must issue additional statements. Such statements are called : recursive calls or recursive SQL statements. For example :...

Share this page:
Follow us:
Task Runner