Reports connection property information.
sa_conn_properties ( [ connection-id ] )
DBA authority required. Users without DBA authority must be granted EXECUTE permission to run the stored procedure.
Returns the connection ID as Number, PropNum, PropName, PropDescription, and Value for each available connection property. Omitting the connection-id produces results for all connections.
For a listing of available connection properties, see "Connection properties" in SQL Anywhere Server – Database Administration.
sa_conn_properties
Number PropNum PropName PropDescription Value 1,2,'BytesReceived','Bytes received by server','4157' 1,3,'BytesReceivedUncomp','Bytes received after decompression','4241' 1,4,'BytesSent','Bytes sent to client','15192' 1,10,'CacheHits','Cache Hits','1291' 1,11,'CacheReadIndInt','Cache index interior reads','58' 1,12,'CacheReadIndLeaf','Cache index leaf reads','121' 1,15,'CacheRead','Cache reads','1318' 1,19,'CacheReadTable','Cache table reads','387' 1,20,'CacheReadWorkTable','Cache work table reads','4' 1,21,'CarverHeapPages','Cache pages used for carvers','0' 1,39,'ClientStmtCacheHits','Number of prepares not required because of the client statement cache','0' 1,40,'ClientStmtCacheMisses','Number of prepares in the client statement cache which were prepared again','0' 1,41,'Commit','Number of commit requests','1' 1,48,'Cursor','Declared cursors','4'1,41,'Commit','Number of commit requests','1'
To get cache hit statistics for the entire cache, use sa_eng_properties,
and see the output lines for CacheHitsEng, CacheReadEng, and DiskReadEng.
If you run the same query on the catalog store repeatedly, the first
time you should see reads increase but no cache hits; as you repeat
the query, cache hits increase in step with cache reads.
