| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle RDBMS running on Netware 4.10
alfee wrote:
>
> Oracle Bequeath Protocol Adapter : v2.2.2.0.4
> Oracle NLSRTL : v3.1.4.0.1
> Oracle Driver for Netware : 7.2.2.4.6
> Oracle SPX Protocol Adapter : v2.2.2.0.4
> Oracle SQL*Net v2 Driver : v2.2.2.0.4
> Oracle TNS Library : v2.2.2.0.4
> Oracle TNS Listener : v2.2.2.0.4
> Oracle Toolkit : v2.0.10.1.5
> Oracle PL/SQL : v2.2.2.3.0
> Oracle CORE : v3.4.2.2.0
>
> I have a schedule backup job running on every midnight, using Arcserve
> 5.01g. Before the backup start to run, it will shut down the Oracle
> database server and restart it after finish backup. During running
> down Oracle command, there is a error message:
>
> 4-11-97 12:01:33 am Server-4.10-2715
> Severity=1 Locus=16 Class=19
> Module did not release 3536 resources
> Module : Oracle7 Server for Netware v7.2.2.4
> Resource : Small memory allocations
> Description : Alloc Memory (Bytes)
>
> This error also occurs when manual shut down.
>
> At now, I have many questions and hope any experts can give me a hand.
> 1. How many memory will Oracle eat? There are 15-20 connections.
> Please tell me the formula.
Total memory used =
System Global Area + Fixed Size + Variable Size + Database Buffers + Redo Buffers
System global area can be changed by several variables, SHARED_POOL_SIZE,
DB_BLOCK_SIZE, DB_BLOCK_BUFFER, LOG_BUFFER. PGA can be changed by LOG_FILES, DB_FILES
and OPEN_LINKS.
>
> 2. Is there any tools to measure and tune the utilitization of Oracle?
There are a lot of monitoring and tuning tools provided by the third parties such as Platinum and BMC. For Oracle, you can use utlbstat/utlestat, Server Manager Monitor, Enterprise Manager and other data dictionary views to measure and tune the Oracle.
>
> 3. I have 128MB RAM in my server and two 4.3GB SCSI HDDs, most likely
> there are 50-60 connections. Is it enough in this case?
It depends on the memory allocated to Oracle. Anyway, it is not quite sufficient for 5-60 connections due to the number of transactions expected from my experience.
> 5. I want to setup a new Netware server for Oracle, is it worth to do?
For the performance and safety, it is better to do in this way. For the cost, it is certainly not a good way.
>
> 6. Do any Netware settings I need to change?
> Please refer to the tuning guide for Oracle on Netware.
--- Name : Lun Wing San (Certified Oracle Database Administrator) Title : Oracle Database Administrator and System Administrator of QRC and HKPC Phone : (852)27885841 This posting represents the personal opinions of the author. It is not the official opinion or policy of the author's employer. Warranty expired when you opened this article and I will not be responsible for its contents or use.Received on Sat Apr 12 1997 - 00:00:00 CDT
 |
 |