Re: performance

Stephan,

Thanks for including the Oracle version, operating system, and its version.

My initial impression is a datafile fragmentation (e.g. data chaining) !!BUT!! I don't have enough facts to justify this gut feel.

What are the storage characteristics of these two databases (e.g. datafiles, tablespaces, indexes, and tables)? How are they the same and how are they different?

Lastly, is the initial size of the tablespace for the full scheme load large enough to hold the full scheme?

Remember YOU are our 5 senses; we know nothing more than what you tell (show) us.

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA

http://www.bmoshier.net/bertram

"Stephan" <test_at_test.com> wrote in message news:Jq%P9.23$Ua7.11811_at_nlnews00.chello.com...
> Oracle 8.1.7 NT2000:
>
> Running 2 databases on the same machine, 'same' init parameters.
>
> - in database 1 I imported the full user-scheme (say 30 tables).
> - in the database 2 I imported only 2 tables of that user-scheme (one
> having
> 20 records, the other 2000).
>
> * When I select from database 2 by means of:
> "select id_district, district_name FROM district, district_street where
> (district_id=id_district) AND (place_street_id=707)"
> the performance is good.
> * Running the same query against database 1 gives very poor
> performance: 2
> seconds for retrieving the 3 records!!
>
> The explain-plan for the querie is the same on datab1 and datab2.
> SELECT STATEMENT Cost = 3
> HASH JOIN
> TABLE ACCESS FULL DISTRICT
> INDEX FAST FULL SCAN DISTRICT_STREET_UNIQUE
>
> When I drop all objects from database 1 execept the 2 tables, the
> performance stays poor....
>
> Please help me!
>
> Thanks
> Stephan
>
>
>
>
>
Received on Mon Dec 30 2002 - 14:20:47 CST