Oracle 10g vs Oracle 11g query performance

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