Home » Developer & Programmer » Forms » EXECUTE_QUERY throws Disk I/O Error
EXECUTE_QUERY throws Disk I/O Error [message #321876] Wed, 21 May 2008 12:19 Go to next message
smadje
Messages: 3
Registered: May 2008
Location: US
Junior Member
Hello Martin,

EXECUTE_QUERY is not able to fetch more than 100,000 records from the table, it throws the disk I/O error on temporary record buffer file. The temp file goes more than 2GB. Do we have any alternative solution?

The code that we execute is as follows
GO_BLOCK('OBJECT');
SET_BLOCK_PROPERTY('OBJECT',default_where,'PROCESS_CODE = ''' || :control.process_code || '''');
EXECUTE_QUERY;
Re: EXECUTE_QUERY throws Disk I/O Error [message #321896 is a reply to message #321876] Wed, 21 May 2008 14:37 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
[not helpful at all, but ...]

Ummm ... what do you plan to do with 100.000 records? Scroll through all of them and review what's in there?
Re: EXECUTE_QUERY throws Disk I/O Error [message #321918 is a reply to message #321896] Wed, 21 May 2008 16:25 Go to previous messageGo to next message
smadje
Messages: 3
Registered: May 2008
Location: US
Junior Member
Business want to review the records that are processed in last 6 months period.
Re: EXECUTE_QUERY throws Disk I/O Error [message #321927 is a reply to message #321876] Wed, 21 May 2008 19:22 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please do NOT add a new question at the end of an old thread!

I assume you are running on a Unix box. Redefine the file system block handling on your box so that it will handle 'large files'.

David
Re: EXECUTE_QUERY throws Disk I/O Error [message #321949 is a reply to message #321896] Wed, 21 May 2008 21:45 Go to previous message
smadje
Messages: 3
Registered: May 2008
Location: US
Junior Member
Thanks David. Next time I will make sure to create a new thread. I will work with UNIX Syadmin team to redefine the file system block and let you know the result.
Previous Topic: Not methods recognize OCX
Next Topic: Changing Tab Pages Colors in Forms 10g
Goto Forum:
  


Current Time: Fri Dec 09 00:08:44 CST 2016

Total time taken to generate the page: 0.09242 seconds