Re: Standby Oracle 8i server as report server - Error!

Hi Alexander,
If I remember correctly, the feature that lets you open the Standby database "Read Only" really DOES mean read only. This is fine for small queries that can be processed in memory, but larger queries (with sorts or joins) will normally have to write to the TEMP tablespace while they are running.
This could well be the cause of your problem.

The only thing I could suggest is re-tuneing the instance so that you can process much lager sorts in memory before using the temp tablespace. (I think the SORT_AREA_... parameters would be a good place to start)

Hope this helps

Will Parsons

"Alex Andr." wrote:
>
> Hello!
> I try to use my standby Oracle 8i on SCO UnixWare 7 as report server
> and open it in "Read only" mode. Short queries work good but complex
> queries end with core file and internal Oracle error.
> Someone try to do this? It work?
>
> Thank you for any replay.
> Alexander.

--

ISS UNIX support
The University Of Leeds.
0113 233 5670 Received on Thu Dec 23 1999 - 08:57:42 CST