SDO_NET.GET_PARTITION

Format

SDO_NET.GET_PARTITION_SIZE(      
  network              IN VARCHAR2,      
  partition_id         IN VARCHAR2,      
  link_level           IN NUMBER DEFAULT 1,      
  include_user_data    IN VARCHAR2 DEFAULT 'FALSE',      
  include_spatial_data IN VARCHAR2 DEFAULT 'FALSE'
) RETURN NUMBER;

Description

Gets the estimated size (in bytes) for a specified combination of partition ID and link level.

Parameters

network: Network name.
partition_id: Partition ID number.
link_level: Link level (default = 1). The link level reflects the priority level for the link, and is used for network analysis, so that links with higher priority levels can be considered first in computing a path.
include_user_data: TRUE if the size should include any user data associated with the network elements represented in each BLOB, or FALSE (the default) if the size should not include any user data.
include_spatial_data: TRUE if the size should include spatial geometry definitions associated with the network elements represented in each BLOB, or FALSE (the default) if the size should not include spatial geometry definitions.

Usage Notes

The returned size of a network partition is a rough estimate and might vary depending on the Java Virtual Machine and garbage collection.

For information about using partitioned networks to perform analysis using the load on demand approach, see Network Analysis Using Load on Demand.

Examples

The following example returns the number of bytes for the partition associated with partition ID 1 and link level 1 in the SDO_PARTITIONED network, not including any user data or spatial data.

SELECT SDO_NET.GET_PARTITION_SIZE('SDO_PARTITIONED', 1, 1, 'N', 'N') FROM DUAL;
 
SDO_NET.GET_PARTITION_SIZE('SDO_PARTITIONED',1,1,'FALSE','FALSE')
---------------------------------------------------------
                                                     5192