Re: Performance

Hello Stephan,
Your tablespaces are ok - tablespaces never change performance that much. The CBO does though, even 50.000 rows can slow you down ... if you do a full tablescan on it. Good luck,

     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 berichtnieuws qED_8.99635$Un4.3684699_at_nlnews00.chello.com...
> 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.
...
> > > Thanks
> > > Stephan
Received on Mon Jul 22 2002 - 07:18:24 CDT