Yes, and what is the explain plan in both cases.
Jim
"Ulrik Hoffmann" <ulrik.peer_at_hoffmann-kiel.de> wrote in message
news:8vituu$4oqjr$1_at_ID-13717.news.dfncis.de...
>
> "Christian Greven" <greven.christian_at_baufeldt.de> schrieb im Newsbeitrag
> news:8vitp3$7hq$00$1_at_news.t-online.com...
> > System 1 with NoName-server: Pentium II 400, 265 ram. My function needs
> > about 30 minutes
> >
> > System 2 with Compac-Server: Pentium III 700, 1000 ram. The same
function
> > runs since 4 days.
> >
> > The database on system 1 is an export from system 2.
> >
> > Analyze indexes and analyze table speeds up same subqueries. One
subquery
> > got now only 3 minutes, before it was more than 10 hours.
> >
> > Hase any one an idea???
>
> Hi Christian,
>
> is the initORCL.ora the same on both systems?
>
> Try select sum(value)/1024/1024 from v$sga
>
> on both systems.
>
> What are the parameters for
> shared_pool_size
> db_block_buffers
> db_block_size
> sort_area_size
>
> ?
>
>
> Bye
> Uli
>
>
>
>
>
>
>
>
>
>
Received on Thu Nov 23 2000 - 06:02:33 CST
