Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Amount of data fetched by query

Praveen Bezawada
Respected Contributor

Amount of data fetched by query

Hi
On HP-UX 1100 using Oracle 8.0.5 which is the variable which specified the amount of data that can be fetched by a single query.
Thanks in advance
Praveen
4 REPLIES
Steve Slade
Frequent Advisor

Re: Amount of data fetched by query

Praveen,

I am not sure if I am reading your question correctly - Do you wish to limit the amount of rows returned from your database query? If so then the sql clause rownum will do this.

Eg. Select * from my table where rownum < 10 will limit to 9 rows.

Otherwise, are you having problems with a long running query which fails? In which case it could be that you are using up too much memory sorting, etc. This limit can be increased by the kernel parm maxdsize which sets the amount of memory 1 process can have in pages (4k I believe)
If at first you do not succeed. Destroy all evidence that you even attempted.
Praveen Bezawada
Respected Contributor

Re: Amount of data fetched by query

I am talking about result of a query which gives large amount of data. I was wondering if there is any configurable parameter in Orcale which specifies the amount of data that can be fetched in a single sql query.

Thanks
Praveen
Alexander M. Ermes
Honored Contributor

Re: Amount of data fetched by query

Are we talking about access with SQLPlus,
Forms, Reports or ODBC ?
Within Forms, Reports or MS-ACCESS you have a prefetch count parameter. I have not seen such a thing in SQLPlus, but perhaps there is somebody, who can correct that.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Steve Slade
Frequent Advisor

Re: Amount of data fetched by query

Praveen,

The only Oracle parameter which will effect the amount of data returned in a query is the one above (rownum). Otherwise, Oracle will always (Memory/Disk allowing), return every record which matches your query - even if that means the complete contents of your table(s) in your query.
If at first you do not succeed. Destroy all evidence that you even attempted.