Performance issue with new 9i database
From: Shankar <shankarvs_at_gmail.com>
Date: 24 Jun 2004 14:50:45 -0700
Message-ID: <3dc522c8.0406241350.444042e3_at_posting.google.com>
Hello,
I am seeing huge performance problems on the queries executed against 9i database. I am not too familiar with 9i, But I would like to ask the DBA to check whether all the parameters are set right to gain optimum performance.
Date: 24 Jun 2004 14:50:45 -0700
Message-ID: <3dc522c8.0406241350.444042e3_at_posting.google.com>
Hello,
I am seeing huge performance problems on the queries executed against 9i database. I am not too familiar with 9i, But I would like to ask the DBA to check whether all the parameters are set right to gain optimum performance.
Currently the default optimizer is set to first_rows.
Most of the queries executed against this database have group by clause
The inner most queries ( that is queries against the tables directly)
comes back very fast. But if I combine them to run the whole query, it
never comes back
Number of records in each table is not more than 3000 and after the
conditions, each of the inner queries comes back with only few hundred
records.
So what could be the problem?
Thanks in advance
Shankar
Received on Thu Jun 24 2004 - 23:50:45 CEST