Re: Performance

Hello Stephan,
Guess you found the cause already: the 50.000 records table. This table can NOT delay the working of Forms - it sounds like a CBO problem.
- Do you use the Cost Based Optimizer ?
- Did you analyze the tables ?
  (Run the dbmap.sql script on my sql-site to check this) Try an explain plan of the queries involved and you will probably find a full table scan !
Cheers,

     Roelof Schierbeek

R.Schierbeek, DBA

e-mail: info_at_NOSPAMbytelife.com
www   : www.bytelife.com
sql   : www.bytelife.com/sql4dba.htm

Stephan <test_at_test.com> schreef in ...
> Hi there,
>
> a question regarding speed.
> - winnt, Oracle 7.3.4
> - Oracle Forms 6i
> - 2 tablespaces each 100Mb : 1 for indexes (say 50), 1 for tables (say
50),
> largest table contains 40.000 records
> ........
> ==================================
> All (say 10) our customers have no complaints against speed, except for 1:
> When we import the exports coming from our customers on 1 machine
(different
> instances, same parameters and tablespaces) in our office we conclude they
> all perform the same (as one would expect). The number of records the
> customers have inside the tables is almost the same, the structure is
> exactly the same, so it would be strange if there were big differences in
> speed.
> But 1 of our customers has slow speed. And yes, when we import that
database
> into an instance we also see poor performance!
> The main difference to the other databases: there is 1 table -containing
> 50.000 records- which has 0 records in all the other -fast- databases.
>
> --->But the STRANGE thing: can this table delay the working of Forms even
no
> data is retrieved from it on a form?
>
> --> How can I find the bottleneck?
>
> --> Other suggestions (for example concerning storage params)?
>
> Thanks
> Stephan
Received on Sun Jul 21 2002 - 05:10:15 CDT