[Mon Mar 15 16:38:08 2010].531000 CGI Request 1 on process 4056
[Mon Mar 15 16:38:08 2010].531000 msOracleSpatialLayerOpen called with:
GEOMETRIE FROM MY_LINE_TABLE using unique ID srid 82015 (Layer pointer
01F9D568)
[Mon Mar 15 16:38:08 2010].656000 msOracleSpatialLayerOpen. Shared
connection not available. Creating one.
[Mon Mar 15 16:38:08 2010].656000
msConnPoolRegister(labels,MY_CONNECTION,022A2CA0)
[Mon Mar 15 16:38:08 2010].687000 msOracleSpatialLayerFreeItemInfo was
called.
[Mon Mar 15 16:38:08 2010].687000 msOracleSpatialLayerGetItems was called.
[Mon Mar 15 16:38:08 2010].687000 msOracleSpatialLayerInitItemInfo was
called.
[Mon Mar 15 16:38:08 2010].687000 msOracleSpatialLayerInitItemInfo was
called.
[Mon Mar 15 16:38:08 2010].687000 msOracleSpatialLayerWhichShapes was
called.
[Mon Mar 15 16:38:08 2010].687000 msOracleSpatialLayerWhichShapes. Using
this Sql to retrieve the data: SELECT ID, NAME, GEOMETRIE FROM MY_LINE_TABLE
WHERE SDO_FILTER( GEOMETRIE, MDSYS.SDO_GEOMETRY(2003, :srid,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),:ordinates ),'querytype=window') =
'TRUE'
[Mon Mar 15 16:38:08 2010].687000 msOracleSpatialLayerWhichShapes. Bind
values: srid:82015   minx:2434248.916000   miny:5406417.084000
maxx:2765508.084000   maxy:5670471.916000
[Mon Mar 15 16:38:08 2010].687000 msOracleSpatialLayerWhichShapes getting
ordinate definition.
[Mon Mar 15 16:38:08 2010].703000 msOracleSpatialLayerWhichShapes converting
to OCIColl.
[Mon Mar 15 16:38:08 2010].703000 msOracleSpatialLayerWhichShapes bind by
name and object.
[Mon Mar 15 16:38:08 2010].703000 msOracleSpatialLayerWhichShapes name and
object now bound.
[Mon Mar 15 16:38:09 2010].93000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 0
[Mon Mar 15 16:38:09 2010].93000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 1
[Mon Mar 15 16:38:09 2010].93000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 2
[Mon Mar 15 16:38:09 2010].93000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 3
[...and so on...]
[Mon Mar 15 16:51:12 2010].748000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 1024
[Mon Mar 15 16:51:13 2010].29000 msOracleSpatialLayerNextShape on layer
01F9D568, Fetched 1024 more rows (2048 total)
[Mon Mar 15 16:51:13 2010].29000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 1025
[...and so on...]
[Mon Mar 15 16:51:13 2010].107000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 2048
[Mon Mar 15 16:51:13 2010].529000 msOracleSpatialLayerNextShape on layer
01F9D568, Fetched 1024 more rows (3072 total)
[Mon Mar 15 16:51:13 2010].529000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 2049
[...and so on...]
[Mon Mar 15 16:51:13 2010].685000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 3072
[Mon Mar 15 16:51:14 2010].60000 msOracleSpatialLayerNextShape on layer
01F9D568, Fetched 1024 more rows (4096 total)
[Mon Mar 15 16:51:14 2010].60000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 3073
[...and so on...]
[Mon Mar 15 16:51:14 2010].139000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 4096
[Mon Mar 15 16:51:14 2010].342000 msOracleSpatialLayerNextShape on layer
01F9D568, Fetched 1024 more rows (5120 total)
[Mon Mar 15 16:51:14 2010].342000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 4097
[...and so on...]
[Mon Mar 15 16:51:14 2010].467000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 5120
[Mon Mar 15 16:51:14 2010].748000 msOracleSpatialLayerNextShape on layer
01F9D568, Fetched 1024 more rows (6144 total)
[Mon Mar 15 16:51:14 2010].748000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 5121
[...and so on...]
[Mon Mar 15 16:51:14 2010].826000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 6144
[Mon Mar 15 16:51:15 2010].60000 msOracleSpatialLayerNextShape on layer
01F9D568, Fetched 1024 more rows (7168 total)
[Mon Mar 15 16:51:15 2010].60000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 6145
[...and so on...]
[Mon Mar 15 16:51:15 2010].170000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 7168
[Mon Mar 15 16:51:15 2010].373000 msOracleSpatialLayerNextShape on layer
01F9D568, Fetched 815 more rows (7983 total)
[Mon Mar 15 16:51:15 2010].373000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 7169
[...and so on...]
[Mon Mar 15 16:38:11 2010].859000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 7981
[Mon Mar 15 16:38:11 2010].859000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 7982
[Mon Mar 15 16:38:11 2010].859000 msOracleSpatialLayerNextShape on layer
01F9D568, row_num: 7983
[Mon Mar 15 16:38:11 2010].859000 msOracleSpatialLayerNextShape on layer
01F9D568, Fetched 0 more rows (7983 total)
[Mon Mar 15 16:38:11 2010].859000 msOracleSpatialLayerFreeItemInfo was
called.
[Mon Mar 15 16:38:11 2010].859000 msOracleSpatialLayerClose was called.
Layer: 01F9D568, Layer name: labels. Layer connection: MY_CONNECTION
[Mon Mar 15 16:38:11 2010].859000 msOracleSpatialLayerClose. Cleaning
layerinfo handlers.
[Mon Mar 15 16:38:11 2010].859000 msOracleSpatialLayerClose. Release the
Oracle Pool.
[Mon Mar 15 16:38:11 2010].859000
msConnPoolRelease(labels,MY_CONNECTION,022A2CA0)
[Mon Mar 15 16:38:11 2010].859000 msConnPoolClose(MY_CONNECTION,022A2CA0)
[Mon Mar 15 16:38:14 2010].890000 msDrawMap(): Layer 87 (labels), 6.359s
[Mon Mar 15 16:38:14 2010].890000 msDrawMap(): Drawing Label Cache, 0.000s
[Mon Mar 15 16:38:14 2010].890000 msDrawMap() total time: 6.359s
[Mon Mar 15 16:38:15 2010].15000 msSaveImage() total time: 0.125s
[Mon Mar 15 16:38:15 2010].15000 mapserv request processing time (msLoadMap
not incl.): 6.484s
[Mon Mar 15 16:38:15 2010].15000 msFreeMap(): freeing map at 0198B370.
[Mon Mar 15 16:38:15 2010].15000 msOracleSpatialLayerClose was called.
Layer: 01F9D568, Layer name: label. Layer connection: MY_CONNECTION
[Mon Mar 15 16:38:15 2010].15000 freeLayer(): freeing layer at 01F9ABC0.
[Mon Mar 15 16:38:15 2010].15000 freeLayer(): freeing layer at 01F9D568.
[Mon Mar 15 16:38:15 2010].15000 freeLayer(): freeing layer at 01FEC0B8.