Re: Discoverer error (about memory)

How "big" is the workbook? You'd probably be amazed at just how much data is being cached on the app server to support your workbook, especially if it's a crosstab with many columns. One option would be to extract the query from the session running the workbook (not necessarily the same as the SQL Inspector shown in Discoverer) and seeing just how much data it generates when run in sqlplus.

It's also dependent on how many concurrent Discoverer users the app server is supporting. There may be enough memory and disk cache to handle this workbook, but if there are many other users on the server running smaller workbooks, that can add up fast.

Also, if the app server is M$ Windows, check what services are running on that box -- work with your windoze admin to shut off any unnecessary services as they'll be consuming memory and processor cycles.

"Roberts" <member14470_at_dbforums.com> wrote in message news:2421481.1043228269_at_dbforums.com...
>
> When trying to open some bigger workbook from database, Oracle9iAS
> Discoverer shows error.
>
> Discoverer Plus shows:
> No data is shown because an error occurred while running the query.
>
> The error message is such:
> The server is running low on virtual memory. This can happen due to
> insufficient disk space or heap space on the server. Please contact
> your Discoverer Administrator for assistance.
>
> The AS has fysical memory 512MB, virtual - 1,5GB. Used virtual ~1GB.
> There isn`t shortage of disk space or virtual memory of AS machine. I
> suppose the problem is in Discoverer configuration.
>
> The memory settings in pref.txt file are default:
> [Application]
> CacheFlushPercentage = 25 # Percent of cache flushed if
> the cache is full.
> MaxVirtualDiskMem = 1024000000 # Maximum amount of disk memory
> allowed for the data cache.
> MaxVirtualHeapMem = 5120000 # Maximum amount of heap memory allowed
> for the data cache.
>
> Are there other files wich define the memory settings for Discoverer?
>
> What I have to do?
>
> --
> Posted via http://dbforums.com
Received on Sun Jan 26 2003 - 04:31:38 CET