SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-22-2008, 05:22 PM
| ||||
| ||||
 performance 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      |
|
02-22-2008, 05:23 PM
| ||||
| ||||
| Re: performance Stephan wrote: > -> 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@test.com> wrote in message > news:Jq%P9.23$Ua7.11811@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 > > > > > > > > > > Your conclusion is not valid. Given the information you have provided I could speculate as to dozens of reasons for the difference. But having more tables isn't one of them. Daniel Morgan |
 |
« Re: Outrage that OCP exams are now unproctored - Comments?
|
Cannot log into Oracle Management Server. »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 02:17 PM.
