Re: Performance on Netware 7.3 ( Or Lack Of)

In message <3336a15c.2347622_at_news.centroin.com.br> - lsantos_at_pobox.com (Luis Santos)Sun, 23 Mar 1997 22:05:49 GMT writes:
:>
:>BC Computing Limited <BCCOMP_at_bccomp.demon.co.uk> wrote:
:>
:>> Hi,
:>>
:>> Can anyone suggest a cause for the following problem :
:>>
:>> I have 32,000 records in a table, to produce a total value
:>> of these records takes 1 min 32 sec.
:>>
:>> When I had 31,500 records it took 1 min.
:>> when I had 31,000 records it took 30 sec.
:>> when I had 30,000 records it took 3 sec.
:>>
:>> I'm running Oracle 7.3 for Netware and Forms 4.5 V1.2.1
:>>
:>> I would be very grateful if anyone can tell me what's happening
:>> here because I just can't work it out !!!
:>>
:>>
:>> Cheers
:>> Chris Prince

Check the extents structure of your table. The dictionary view user_segments should return the number of extents for the table. It sounds as if the table is heavily fragmented and split all over the tablespace. Tuning Oracle fom Oracle Press and Oracle Performance Tuning from O'Reilly lots of useful hints about Oracle Tuning. I am convinced that it has nothing to do with Netware. We run a Netware Server with an airline decision support system on a 486/100 with 64MB and 2.5 GB of data without performance problems.
However make sure that you have no file server activity on the database server.

brgds Received on Mon Mar 24 1997 - 00:00:00 CST