I have a table with 5 billion records and I'm issuing the following query using OCI api OCIStmtExecute:
SELECT "SESSION_ID" AS "ColumnValue@@@",COUNT(*) AS "VALUE_FREQ_@@@" FROM "ALL_UNIQUE_5BILLION" GROUP BY "SESSION_ID" ORDER BY 2 DESC, 1 ASC
The OCI api returns -1. The OCIErrorGet api called right after returns only an empty text for the error message. I turned on Oracle Net Configuration client tracing, and in the trace file I see the message after my select query:
Why does it end the channel? Is this by design? It is not due to network disconnection, as this is inside company LAN and this problem happens every time.
The database server version is Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
and I'm using a 11gr2 OCI Oracle client.
When I run the same query via the SQL Developer, I get the error
No more data to read from socket
Vendor code 17410Error at Line:1