Re: Performance

Thanks, I'll try your suggestions!

To be honest: this is the first time for me that I got involved in 'performance' problems.

I use all standard settings: I thought: 50.000 ROWS is nothing for Oracle so tuning is not needed.

Can you please take a look at my tablespaces: are they ok?

  a.. I did not analyze the tables.
  b.. I don't know if CBO is used.

"rs" <info_at_bytelife.com> wrote in message news:3d3a8a02$0$11417$7a0f4ed3_at_energis-news-env...
> 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 - 14:08:06 CDT