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);
Parent topic: SDO_TRKR Package (Location Tracking)