| Telnet query buffer restriction? [message #122047] |
Thu, 02 June 2005 09:57  |
TLegend33
Messages: 203
Registered: March 2005
|
Senior Member |
|
|
I connect through VPN to one of our clients running Oracle 8.0.5 on AIX 4.3. Once the tunnel is authenticated, I connect to their Oracle box via a Telnet session. For whatever reason, if I run a query from sqlplus that produces approximately 10 rows, the output is fine. However, if I execute another simple query that will return more than 10 or so rows, the query just seems to hang and no output is produced. Below are the queries I ran and also counts to demonstrate the expected output:
select count(file_name) from dba_data_files where autoextensible = 'YES';
COUNT(FILE_NAME)
----------------
8
select count(file_name) from dba_data_files where autoextensible = 'NO';
COUNT(FILE_NAME)
----------------
89
select file_name, bytes/1024/1024 "MB", maxbytes/1024/1024 "MaxMB" from dba_data_files where autoextensible = 'YES';
FILE_NAME MB MaxMB
--------------------------------------------- ---------- ----------
/u01/oradata/ORCL/system01.dbf 45 16383.9922
/u01/oradata/ORCL/mrttemp.dbf 73 100
/u01/oradata/ORCL/ihdssys.dbf 110 16383.9922
/u01/oradata/ORCL/ihdsidx.dbf 98 16383.9922
/u01/oradata/ORCL/chargeIdx01.dbf 150 2000
/u01/oradata/ORCL/responsibilityIdx01.dbf 214 2000
/u01/oradata/ORCL/paymentIDX01.dbf 165 2000
/u01/oradata/ORCL/coPaymentIdx01.dbf 7.125 100
select file_name, bytes/1024/1024 "MB", maxbytes/1024/1024 "MaxMB" from dba_data_files where autoextensible = 'NO';
As you can see, the query returning 8 rows functions correctly, however the query expected to return 89 rows simply hangs. This query is very simple and there is no resource contention. I'm thinking there's some resource limit with Telnet...I'm at a bit of a loss. Any help would be appreciated as this is quite a pain!
Thanks!
|
|
|
|
| Re: Telnet query buffer restriction? [message #138611 is a reply to message #122047] |
Thu, 22 September 2005 12:14  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
Honestly saying i dont have much idea about telnet session ... but if your query is executing nicely on server when u r not connecting through vpn on the server by telnet session that means there is no problem related to database it may be some thing related to netwroking ..
I hope so.....
Regards
Always Friend Sunilkumar.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
