Re: performance

-> I am running 2 instances simultaniously
-> Memory is no problem, so swapping does not occur
-> There are two tablespaces: 100Mb each, storage: initial 250K next 250K

Today I loaded the two tables in the scott/toger default 8.1.7 ORCL database.
As I expect, the performance is perfect on that one. I installed again the full scheme in another instance, selected from the same tables
using same query and response is bad...

-> So it seems the other tables DO influence...

Stephan

"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 Tue Dec 31 2002 - 13:32:00 CST