OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
>>>Wired SQL Tuning issue, maybe Oracle's bug<<<< ORACLE XE, 10G, Solaris, Windows By: elawcn on Wed, 27 February 2008	1	1805	Wed, 27 February 2008 20:55 By: rleishman
Execution time differences between Devl and Test Oracle 10g/Windows2000 By: gold_oracl on Tue, 26 February 2008	3	1866	Tue, 26 February 2008 16:56 By: rleishman
Index Oracle 10g By: subbu_tce on Mon, 25 February 2008	3	1653	Tue, 26 February 2008 00:53 By: subbu_tce
Whats the difference between these two queries ? - tunning purspective oracle 9.0.2 By: gksenthilkumar on Mon, 25 February 2008	1	2079	Mon, 25 February 2008 22:59 By: rleishman
Oracle Slows down. By: ora_2007 on Mon, 25 February 2008	2	5494	Mon, 25 February 2008 15:30 By: alanm
Effect of size of composite primary key on IOT performance. By: Dipali Vithalani on Mon, 25 February 2008	7	4502	Mon, 25 February 2008 03:46 By: Michel Cadot
Tune the SQL Qury windows, oracle 10g By: gentleman777us on Sun, 24 February 2008	2	2326	Sun, 24 February 2008 23:44 By: rleishman
Procedure slow in Oracle 10g Oracle Enterprise 10.2.0.3.0 By: toastmax on Thu, 14 February 2008	8	5676	Sat, 23 February 2008 11:16 By: alanm
statspack oracle,8.1.7, unix By: sheldon1982 on Fri, 22 February 2008	5	2513	Fri, 22 February 2008 04:30 By: Michel Cadot
Temp tablespace resizing By: shahnazurs on Thu, 21 February 2008	3	2473	Fri, 22 February 2008 03:55 By: shahnazurs
sql tuning By: guyj on Tue, 12 February 2008	11	2971	Fri, 22 February 2008 02:51 By: michael_bialik
SQL getting timed out. By: senthildurga on Fri, 22 February 2008	1	1934	Fri, 22 February 2008 01:22 By: Michel Cadot
Pivoting or Cross Tab Report Unix, Oracle 10g By: S.Rajaram on Tue, 19 February 2008	2	1988	Thu, 21 February 2008 12:14 By: S.Rajaram
Execution time differences between environments Oracle 10g/Windows2000 By: gold_oracl on Thu, 21 February 2008	4	2375	Thu, 21 February 2008 11:56 By: BlackSwan
Whey sometimes using Exists Function is better By: epall on Wed, 20 February 2008	7	2926	Thu, 21 February 2008 07:01 By: rleishman
Optimization for Large-Volume Data Streams Oracle 8i,Windows 2000 By: ramsatish on Thu, 21 February 2008	2	1994	Thu, 21 February 2008 05:58 By: michael_bialik
I cant understand this behavior By: iblazquez on Wed, 20 February 2008	4	2638	Thu, 21 February 2008 03:48 By: Michel Cadot
wrong execution plan By: daniesh.shaikh@gmail.com on Fri, 15 February 2008	15	5279	Wed, 20 February 2008 23:43 By: daniesh.shaikh@gmail.com
Oracle Tuning By: ram anand on Wed, 20 February 2008	3	2233	Wed, 20 February 2008 16:59 By: rleishman
Negative Number for Logical Reads on Statspack Report Oracle 9.2.0.7 By: Greeno on Tue, 19 February 2008	1	3736	Tue, 19 February 2008 19:42 By: BlackSwan
After Collecting Statistics database is very very slow Oracle Enterpride Edition, 9.2.0.1.0 , Windows By: GaneshRamadoss on Tue, 19 February 2008	1	1370	Tue, 19 February 2008 06:02 By: Mahesh Rajendran
Improving data loading into tables By: irremediable on Tue, 19 February 2008	11	2811	Tue, 19 February 2008 03:25 By: Mahesh Rajendran
Query to be tuned which uses a table hint /+ USE_CONCAT / in Oracle 10g. By: suneelchetty on Wed, 13 February 2008	9	4348	Mon, 18 February 2008 22:42 By: rleishman
Query tunning required By: gksenthilkumar on Sat, 09 February 2008	7	3868	Sun, 17 February 2008 17:34 By: gksenthilkumar
Different partitioned table import By: kulkarni_m6 on Fri, 15 February 2008	11	3165	Fri, 15 February 2008 16:48 By: Mahesh Rajendran
sql tuning unix, 8.1.7 By: daniesh.shaikh@gmail.com on Fri, 15 February 2008	6	2809	Fri, 15 February 2008 13:20 By: daniesh.shaikh@gmail.com
Procedure is running from more than 3 hrs but do not return the results By: it_me24 on Fri, 15 February 2008	3	2338	Fri, 15 February 2008 07:29 By: Michel Cadot
A query with one additional condition slows down By: irremediable on Wed, 13 February 2008	11	2354	Fri, 15 February 2008 07:29 By: irremediable
TOAD / Oracle qeps By: rgoldwrx on Tue, 29 January 2008	21	9394	Fri, 15 February 2008 02:37 By: jayassun
need help in tuning this query 8.1.7,Unix By: daniesh.shaikh@gmail.com on Thu, 14 February 2008	5	3290	Thu, 14 February 2008 23:08 By: daniesh.shaikh@gmail.com
calling a function from remote db 8.1.6.3 By: fortheppl on Thu, 14 February 2008	1	2098	Thu, 14 February 2008 05:58 By: Michel Cadot
disk read speed ORACLE9i By: dendroid66 on Mon, 11 February 2008	1	1799	Mon, 11 February 2008 10:47 By: Michel Cadot
Delaying insert... By: ataufique on Sun, 10 February 2008	2	1790	Sun, 10 February 2008 11:41 By: Kevin Meade
Improvong performance of SQL script By: aviana on Fri, 08 February 2008	1	1945	Fri, 08 February 2008 09:30 By: Michel Cadot
Tool/method for detecting changed executions plans By: fcastill69 on Tue, 05 February 2008	6	1919	Fri, 08 February 2008 04:18 By: fcastill69
Index Entry Oracle,9i,SunOs By: shahnazurs on Thu, 07 February 2008	1	1697	Thu, 07 February 2008 11:28 By: Michel Cadot
Dictionary_cache = 0 ? By: DrNeko on Mon, 04 February 2008	8	2302	Wed, 06 February 2008 17:01 By: DrNeko
RBO to CBO migration Oracle 9i By: sairajesh on Wed, 06 February 2008	1	1895	Wed, 06 February 2008 04:46 By: Michel Cadot
Deletion records - Performance By: ora_2007 on Wed, 06 February 2008	5	2464	Wed, 06 February 2008 03:12 By: ora_2007
DB deadlock issue By: rballal on Fri, 01 February 2008	21	4279	Wed, 06 February 2008 02:13 By: Michel Cadot