Re: Buffer or Fast I/O problem

From: Ruslan R. Laishev <Laishev_at_SMTP.DeltaTel.RU>
Date: Fri, 02 Oct 1998 12:30:42 +0400
Message-ID: <36148F32.CEA9CE4F@SMTP.DeltaTel.RU>

Eivind Rigstad wrote:
>
> Hi
>
> I have a problem concerning Oracle 7.3.3.4 and Alpha OpenVMS 7.1.
>
> It takes a long time to connect to both server manager and SQLplus. Further,
> when I do select from a table it seems like the result of the query is
> beeing buffered and displayed in portions.
>
> The only clue I have, is a non fatal error message in the alertfile saying
> at database startup:
> ** Unable to create SGA Buffer Object - Fast I/O will not be used. non fatal
> error = 20 **

1. Check out for installed patch ALPSHAD04_071 (for VLM & Fast I/O)
2. Check out counters by "show memory /all/full" -> Buffer Object Usage
3. Try to increasy SYSGEN's MAXBOBMEM to eq GBLPAGES
4. If you have CI cluster checkout SYSGEN's FAST_PATH, to be 1

Ref: Oracle7 for Alpha OpenVMS Installation Guide, Release 7.3.3,OpenVMS SYSGEN Parameters

        OpenVMS Alpha Guide to 64-Bit Addressing and VLM Features

>
> I do hope that anyonecan help me
>
> Thank you un advance
>
> Eivind Rigstad

--
Be well.

+OpenVMS [Sys|Net] HardWorker........................................+
Delta Telecom JSC,                             Cel:  +7 (901) 971-3222
191119,Russia, St.Petersburg,                                 116-3222
Transportny per. 3                             Fax:  +7 (812) 112-1099
RSA FingerPrint:              D1C7 F4D1 9123 25A8  1C12 2F46 8A83 293A

+http://www.levitte.org/~rlaishev/ .......... SysMan rides HailStorm + Received on Fri Oct 02 1998 - 03:30:42 CDT