Hello,
I'm new here hopefully i did not broke any rules already, Here's the problem, I'm getting the OUT OF MEMORY exception/SERVER UNAVAILABLE error when fetching large amounts of data in the ff. environment.
-windows 2003
-.net framework 1.1
-asp.net using vb as code
-oracle 9i database.
the develpment server has 2gigs of memory so I think its not an issue. I've tested the query and it works on plSQL developer but when i put it to use with .net to display in the datagrid the exception happens..please help me..tnx
2  1946 
running your query from the oracle interface should take lesser memory than from an external application.
Just being curious, How many rows/columns of data are you getting, have you used just a select statement, or is it more than just a select.
If possible could you give more details upon that exception, because if you generally put the exception into a search engine you get a lot of good results.
cheers
running your query from the oracle interface should take lesser memory than from an external application.
Just being curious, How many rows/columns of data are you getting, have you used just a select statement, or is it more than just a select.
If possible could you give more details upon that exception, because if you generally put the exception into a search engine you get a lot of good results.
cheers
hello,
I don't encounter such problems whith ordinary single table select statements, I do use nested statements connecting to other db's with the use of oracle's dblink functionality. Also, the .Net application has checkboxes w/c correspond to 1 set of select statement per checkbox. I use Union to join all the statements then get the results then the "Out of Memory Exception" as soon as the app server's memory limit for .Net is consumed...than ks in advance!
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: JP |
last post by:
In my application I use several class files that contain reusable code. I
create an instance of a class (once) when ever I need to use it.
//stand-alone cs file
XHTML_Library objXHTMLHolder = new XHTML_Library();
objXHTMLHolder.
..
..
..
(How do I dispose of objXHTMLHolder at the end of the page)
|
by: Arthur Langham |
last post by:
I'm passing a dataset from a client to a server component
using remoting, and with large datasets I get an out of
memory error. The server retrieves the data just fine,
however it fails somewhere between the return statement in
the server and the assignment of the returned value in the
client. Both the client and server are on a single machine
that has plenty of memory (I checked the task manager to
make sure).
I don't think it's a...
|
by: Steve Buster |
last post by:
All right, I have read every forum, newsgroup etc about
this issue and no one seems to know how to fix it. I am
getting a "Server Application Unavailable" exception
running my .NET 1.1 application. I use W2K SP4 and have
applied the hot Fix KB824146 and KB824105, both IE fixes.
I don't have VS installed because this is a Quality
Environment. I do have .NET SDK and .NET 1.1 Runtime
installed. I can't change my APSNET user to run as...
|
by: Raju |
last post by:
Hi ,
We are develoed the .net application(asp.net, vb.net and sql server ). Till
yesterday there was no problem with the application. Is was working fine.
In our application we have one Lock and Unlock Button. When you click on
Lock button, the page will turn into ReadOnly mode. When you click on Unlock
the page will turn into Edit Mode.
Now When I press the Lock or Unlock Button after 2 to 3 minutes in the
Browser iam getting the below...
|
by: Anton |
last post by:
{Willy Skjveland} Hi, how can I trace a Memory leak in aspnet_wp.exe?
{Rheena} One moment please while I search it for you. It may take me a few
moments
{Willy Skjveland} I need to find out which application and which dll and
asmx page that cause the problem.
{Rheena} May I know what operating system you are using?
| | |
by: Jon B |
last post by:
Hi All!
I have a ASP.NET 2.0 site that works on the Windows 2000 Server. However,
when I tried to view this site on my local Windows XP machine, I get "Server
Unavailable". If I switch the Windows XP IIS back to ASP.NET 1.1 then I get
the Configuration Error (which is understandable because I'm trying to run
an ASP.NET 2 site with 1.1 framework).
I can however view other ASP.NET 1.1 sites on my local Windows XP machine.
It's only the...
|
by: xievvv |
last post by:
We are experiencing a memory leak in one of our applications. It is a web-based reporting system that produces large (> 500mb) PDF reports. It takes approx 4 hours to run the largest of these reports and during this process we have been experiencing issues with the aspnet worker process being recycled as the application's memory keeps growing to around 600mb. From my investigation, it appears that the memory is becoming bloated with character...
|
by: James |
last post by:
I realize the Garbage Collector does a lot of this for me, but I'm having
trouble wrapping my head around something. We've been running into
System.OutOfMemoryException on our production servers running ASP.NET
1.1.4322. It's very intermittent and I don't know exactly what's causing
it. We do use a lot of a Session variables in our application and I'm
wondering if it's possible that when our load is the heaviest, if we're
storing large...
|
by: robert.waters |
last post by:
I have an Access database frontend linked via ODBC to a large
(gigabytes) mysql database.
I need to view a large amount of data in a a textbox (variable up to
300K), but I receive a 'there isnt enough memory' error whenever I
scroll past N number of bytes in a textbox that has been filled with a
lot of data. I am not sure what N is, but for a large chunk of data
it occurs at about the halfway scroll, and smaller chunks might not
throw...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
