Re: Problem with database 8.1.7. release 3 with patchset 2

From: Đuro Dretvić <Djuro.Dretvic_at_Infodom.hr>
Date: Thu, 22 Nov 2001 21:16:12 +0100
Message-ID: <9tjm3m$jil$1@sunce.iskon.hr>

Thanks for all your answers.

Here are some additional information about that computer and database.

Question:                                                            Answer:

1.What type of disk controller do you have?         - SCSI (2 disks in


(second one is a mirror disk) Database is on one phisical disk

2. What kind of disks do you have?                      - IBM
3. Do you have NG2IO boards?                           - No
4. What kind of RAM?                                        - 100 MHZ    (2
modules of 512)
5. What kind of network connection?                   - 100baseT?
6. Manufactor of Computer                                   - Compaq (1 CPU)

7. Number of rollback segments in RBS in RBS tablespace: 28
(storage parameters : initial 512 K, next 512 K optimal 4096, minimum number
8)

8. ROLLBACK (1 segment DES_ROLLBACK) (do i need this rollback tablespace and segment)
 ( I have created it when was installing repository)

9. Number of  REDO LOG files                              - 3  (  10 MB

each)
10. Fragmentation is possible. ( I'm planning to perform reorganization using Quest Space Manager).

-Aditional question: Is this normal behavior. When I start this database
(8.1.7.3) it is occupied about 700 MB of memory.
But at peek time of work (when all users working) it raises to 1.5 GB (then it uses about 500 MB of virtual memory).

Regards Djuro. Received on Thu Nov 22 2001 - 14:16:12 CST