DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - global cache freelist

global cache freelist

All releasable locks are used and a new one has been requested. To make a resource element available, a resource element is pinged.

This event is used for two purposes:

  1. Switching sessions

If a time-out period has been specified, then wait that amount of time for the session to be detached.

  1. Killing sessions

From either KILL SESSION or internal request. Having posted a session that it should kill itself, wait for up to 1 minute for the session to terminate. Wait Time:

The duration of the resource get operation to ping the resource element.