32.1 SDO_TRKR.CREATE_TRACKING_SET

Format

SDO_TRKR.CREATE_TRACKING_SET(
  tracking_set_name  IN VARCHAR2,
  num_trkr_queues    IN NUMBER(38) DEFAULT 4,
  num_loc_queues     IN NUMBER(38) DEFAULT 1);

Description

Creates a tracking set, specifically the tables and queues required for the location tracking server.

Parameters

tracking_set_name

Name of the tracking set.

num_trkr_queues

Number of queues to create to manage the tracking messages. The default value for this parameter is 4. For large numbers of regions in the tracking regions table, more tracker queues may improve performance. For every tracker queue created a scheduler job is also created, so the number of tracker queues should also be balanced with system resources.

num_loc_queues

Number of queues to create to manage the location messages. The default value for this parameter is 1. If a large number of objects are being tracked, more location queues may improve performance. For every location queue created a scheduler job is also created, so the number of location queues should also be balanced with system resources.

Usage Notes

This procedure creates the necessary tables and queues required for the location tracking server. This is the first step required for enabling the location tracking server

For conceptual and usage information about the location tracking server, see Location Tracking Server.

Examples

The following example creates a tracking network named TRACKING_EXAMPLE with 8 tracking queues and 8 location queues.

EXECUTE SDO_TRKR.CREATE_TRACKING_SET('TRACKING_EXAMPLE', 8, 8);