Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 12-13-2009, 06:11 PM   #1
Registered: Nov 2003
Location: Lebanon
Distribution: RHEL 5/CentOS 5/Debian Lenny/(K)Ubuntu Is Dead/Mandriva 10.1
Posts: 670
Blog Entries: 7

Rep: Reputation: 31
OCI limitation on size of data fetched ?

Hi All

Client Server
Debian Lenny
Instant client 10.2
SQL Plus 10.2
Latest Apache/PHP and OCI

Win 2003 + Oracle 8.x
On the client server I can connect to the Oracle server through php and execute all kinds of queries that do not fetch a lot of data. But once the data being fetched is more than roughly 100kbyte nothing seems to happen anymore, a tcpdump only shows acks being sent from the client to the server.


select * from table where rownumber < x "x is 1 to 45" <-- This returns the result correctly in a second

select * from table where rownumber < y "y is 46 and up" <-- This query simply keeps hanging, no time out nothing, if executed from command line it hands if executed in the browser it just keeps loading. If tcpdump is launched to monitor it, after the first two seconds all that happens is that the client sends acks to the server.

However, if I use sqlplus 10.2 on the same Debian server, I can execute
select * from table, and all 16000 rows are fetched and displayed in the sqlplus console.

I really dont know what the problem is and what to look for here. Is the data being returned back to the client in SQL Plus in a differnet fashion than in OCI ? What could be the problem ?

Any hints are appreciated.



Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] why Attachments size limitation ? increase it ...!! raju.mopidevi LQ Suggestions & Feedback 8 12-02-2009 04:41 PM
How to send "fetched"mail into a separate folder for each pop3 account fetched anovick Linux - Newbie 2 03-12-2005 07:24 AM
Samba file size limitation enygma Linux - Networking 2 02-07-2005 02:59 PM
Is there a file size limitation in Linux? lazyboy0001 Linux - Software 12 08-12-2004 08:28 PM
File size limitation? jbrashear Linux - General 7 04-03-2004 01:53 AM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 10:34 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration