Home > Default > Oracle 10g vs Oracle 11g query performance

Oracle 10g vs Oracle 11g query performance

October 11Hits:2
Advertisement
Hi everyone,
We are moving from Oracle 10g to Oracle 11g database.
I have a query which in Oracle 1g takes 85 seconds to run, but when I run the same query in Oracle 11g database, it takes 635 seconds.
I have confirmed that all indexes on tables involved are enabled.
Does anyone have any pointers, what should I look into. I have compared explain plans and clearly they are different. Oracle 11g is taking a different approach than Oracle 1g.
Thanks

Answers

Pl post details of OS versions, exact database versions (to 4 digits) and init.ora parameters of the 10g and 11g databases. Have statistics been gathered after the upgrade ?
For posting tuning requests, pl see these threads
HOW TO: Post a SQL statement tuning request - template posting
When your query takes too long ...
Pl see if the SQL Performance Analyzer can help - MOS Doc 562899.1 (TESTING SQL PERFORMANCE IMPACT OF AN ORACLE 9i TO ORACLE DATABASE 10g RELEASE 2 UPGRADE WITH SQL PERFORMANCE ANALYZER)
HTH
Srini

Read other 2 answers

Tags:

Related Articles

  • Oracle 10g vs Oracle 11g query performanceOctober 11

    Hi everyone, We are moving from Oracle 10g to Oracle 11g database. I have a query which in Oracle 1g takes 85 seconds to run, but when I run the same query in Oracle 11g database, it takes 635 seconds. I have confirmed that all indexes on tables invo

  • Oracle 11g Migration performance issueOctober 11

    Hello, There a performance issue with Migration from Oracle 10g(10.2.0.5) to Oracle 11g(11.2.0.2). Its very simple statement hanging for more than a day and later found that query plan is very very bad. Example of the query is given below: INSERT INT

  • Oracle 11g Database PerformanceNovember 30

    We have Oracle 11g (11.1.0.6) database on HP-UX (IA). It's around 200G database, and we have lot of batch job and reports running against this database. This database is performing really bad, whenever we restart the application and the database its

  • Oracle Forms6i Query Performance issue - UrgentNovember 30

    Hi All, I'm using oracle forms6i and Oracle DB 9i. I'm facing the performance issue in query forms. In detail block form taking long time to load the data. Form contains 2 non data blocks 1.HDR - 3 input parameters 2.DETAILS - Grid - Details HDR inpu

  • Oracle 11g:Query to return only 1 to 1 relationship & random selectionOctober 11

    Hi I have a complex query to modify but I have below the sample tables and data with only very few fields(only affected fields). Query based on 2 tables b_test and s_test. Pls see below. create table b_test(building_id number not null,invalid varchar

  • In Oracle 11g query, how can I refer to results of different column ....October 11

    I want to be able to refer to the results of C1 in another column expression C2. I get ORA-00904: "C1" invalid identifier, which makes sense. I know that I can repeat the entire very long CASE again in my C2 DECODE, but wondering if I can save t

  • Oracle 11g Vs previous versionOctober 11

    Hi, can someone please explain Oracle 9i/10g Query Execution vs Oracle 11g Query Execution features for some of the new statements introduced in 11g using CBO. How the SQL vs PL/SQL caching using Oracle 11g ? Can we use Optimization Hints in Oracle 1

  • Oracle 11g- Straing behaviour of query after importing from Oracle 10gOctober 11

    Hi, I have a table in Oracle 10g as follows: Create Table xyz (col1 varchar2(50), col2 varchar2(50)); With following Data Col1     Col2 A     320 A     110 A     290 A     380 B     ABC B     256 B     LMN I am running following Query select * from x

  • SQL performance slow -- oracle 10g to oracle 11gNovember 30

    Hi, We are have two development server, here we can call server10 and server11. Server's having same hardware and OS, but different oracle version, server 10 and server 11 having oracle 10g and oracle 11g respectively. Problem, when you run sql query

  • Oracle 11g advantages for performanceOctober 11

    Hello, I am doing test of Client side result set cache on oracle 11 g rel2 ,O/S- RHEL i am doing test as below on 2 Oracle 11g rel2 test servers on RHEL one oracle 11g rel2 instance is used as server1,from other oracle 11g rel2 server2, i am running

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.654 s.