allocinfo

Returns a list of allocation pages that are stored in an object allocation map (OAM) page.

Syntax

allocinfo(db_id, page_id, "help" | "alloc pages on oam")

Parameters

  • db_id – is the database ID.
  • page_id – is the page ID.
  • help – shows available options.
  • alloc pages on oam – provides allocation page information.

Examples

  • Example – Provides a list of allocation pages that are stored in an object allocation map (OAM) page:
    select allocinfo(1,888,"alloc pages on oam")
    ----------------------------------- 
00010000000003

Usage

Mechanism to retrieve all allocation pages for a particular partition or index. Returns NULL for an invalid page when using the alloc pages on oam option value.

Permissions

You must have sa_role to execute this command.
Parent topic: Transact-SQL Functions