Row count in Oracle #247
-
|
Good afternoon, For example if I run simple test and select e.g. 400 records. I'm trying to confirm in the network packet, that there were 400 records received back. |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments 5 replies
-
this is the beginning of the response: and this is the end of the response: |
Beta Was this translation helpful? Give feedback.
-
|
Yes, the value is found in the error record (found at the end of the response). It is the third field (starting at byte 0x95c and consisting of the bytes 0x02, 0x01, 0x90) and indicates the value is 400. Since that field can only go up to 4 bytes (2 ^ 32) the value is also found near the end of the record (starting at byte 0x97e and also consisting of the bytes 0x02, 0x01, 0x90) and indicates the value is 400. This value can go up to 8 bytes (2 ^ 64). The Python driver only pays attention to the second value (for DML) and ignores it for queries -- since by that point the driver has already processed all of the rows and doesn't need to be told how many are there! |
Beta Was this translation helpful? Give feedback.
-
|
Thank you, that's helpful. I can see it is changing with number of records. specifically this part on the second line: and this line at the end: |
Beta Was this translation helpful? Give feedback.
-
|
The The stuff after the SQL statement is a 13 element array of integers containing a variety of information. You can find what some of them mean by looking at the Python code: https://github.com/oracle/python-oracledb/blob/main/src/oracledb/impl/thin/messages.pyx#L2010-L2034 Are you trying to understand the protocol in order to write a different driver? Or is this just for interest? |
Beta Was this translation helpful? Give feedback.
-
|
we are trying to understand the protocol structure to create network error handling. potentially in the future we might try to implement some client driver for communication with database. if there is some general specification explaining client to server and server to client communication, it would be helpful to understand some network transmission problems in our environment |
Beta Was this translation helpful? Give feedback.
-
|
There is no separate specification. If you're writing a driver for another programming language, please let us know. |
Beta Was this translation helpful? Give feedback.
-
|
currently it is only for error handling. we run different activities with sqlplus, jdbc and python-oracledb and try to compare if we see the network having different load. and sometimes we see some unexpected network activities, that we can't explain without looking into network packets. |
Beta Was this translation helpful? Give feedback.
Yes, the value is found in the error record (found at the end of the response). It is the third field (starting at byte 0x95c and consisting of the bytes 0x02, 0x01, 0x90) and indicates the value is 400. Since that field can only go up to 4 bytes (2 ^ 32) the value is also found near the end of the record (starting at byte 0x97e and also consisting of the bytes 0x02, 0x01, 0x90) and indicates the value is 400. This value can go up to 8 bytes (2 ^ 64).
The Python driver only pays attention to the second value (for DML) and ignores it for queries -- since by that point the driver has already processed all of the rows and doesn't need to be told how many are there!