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
Index Oracle 10g By: subbu_tce on Mon, 25 February 2008	3	1328	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	1465	Mon, 25 February 2008 22:59 By: rleishman
Oracle Slows down. By: ora_2007 on Mon, 25 February 2008	2	5266	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	4009	Mon, 25 February 2008 03:46 By: Michel Cadot
Tune the SQL Qury windows, oracle 10g By: gentleman777us on Sun, 24 February 2008	2	1675	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	5327	Sat, 23 February 2008 11:16 By: alanm
statspack oracle,8.1.7, unix By: sheldon1982 on Fri, 22 February 2008	5	1706	Fri, 22 February 2008 04:30 By: Michel Cadot
Temp tablespace resizing By: shahnazurs on Thu, 21 February 2008	3	2131	Fri, 22 February 2008 03:55 By: shahnazurs
sql tuning By: guyj on Tue, 12 February 2008	11	2565	Fri, 22 February 2008 02:51 By: michael_bialik
SQL getting timed out. By: senthildurga on Fri, 22 February 2008	1	1657	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	1640	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	1723	Thu, 21 February 2008 11:56 By: BlackSwan
Whey sometimes using Exists Function is better By: epall on Wed, 20 February 2008	7	1665	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	1269	Thu, 21 February 2008 05:58 By: michael_bialik
I cant understand this behavior By: iblazquez on Wed, 20 February 2008	4	1566	Thu, 21 February 2008 03:48 By: Michel Cadot
wrong execution plan By: daniesh.shaikh@gmail.com on Fri, 15 February 2008	15	3048	Wed, 20 February 2008 23:43 By: daniesh.shaikh@gmail.com
Oracle Tuning By: ram anand on Wed, 20 February 2008	3	1720	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	3280	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	1199	Tue, 19 February 2008 06:02 By: Mahesh Rajendran
Improving data loading into tables By: irremediable on Tue, 19 February 2008	11	2286	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	3974	Mon, 18 February 2008 22:42 By: rleishman
Query tunning required By: gksenthilkumar on Sat, 09 February 2008	7	3605	Sun, 17 February 2008 17:34 By: gksenthilkumar
Different partitioned table import By: kulkarni_m6 on Fri, 15 February 2008	11	2857	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	1722	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	1657	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	1997	Fri, 15 February 2008 07:29 By: irremediable
TOAD / Oracle qeps By: rgoldwrx on Tue, 29 January 2008	21	8833	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	2260	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	1631	Thu, 14 February 2008 05:58 By: Michel Cadot
disk read speed ORACLE9i By: dendroid66 on Mon, 11 February 2008	1	1206	Mon, 11 February 2008 10:47 By: Michel Cadot
Delaying insert... By: ataufique on Sun, 10 February 2008	2	1374	Sun, 10 February 2008 11:41 By: Kevin Meade
Improvong performance of SQL script By: aviana on Fri, 08 February 2008	1	1454	Fri, 08 February 2008 09:30 By: Michel Cadot
Tool/method for detecting changed executions plans By: fcastill69 on Tue, 05 February 2008	6	1676	Fri, 08 February 2008 04:18 By: fcastill69
Index Entry Oracle,9i,SunOs By: shahnazurs on Thu, 07 February 2008	1	1141	Thu, 07 February 2008 11:28 By: Michel Cadot
Dictionary_cache = 0 ? By: DrNeko on Mon, 04 February 2008	8	1912	Wed, 06 February 2008 17:01 By: DrNeko
RBO to CBO migration Oracle 9i By: sairajesh on Wed, 06 February 2008	1	1485	Wed, 06 February 2008 04:46 By: Michel Cadot
Deletion records - Performance By: ora_2007 on Wed, 06 February 2008	5	1770	Wed, 06 February 2008 03:12 By: ora_2007
DB deadlock issue By: rballal on Fri, 01 February 2008	21	3620	Wed, 06 February 2008 02:13 By: Michel Cadot
Incremental logic on a complex query By: iammanohar on Tue, 05 February 2008	6	2594	Tue, 05 February 2008 08:53 By: S.Rajaram
oracle 10g analyze table temporary segments oracle 10g By: vipull.sayal on Tue, 05 February 2008	1	6293	Tue, 05 February 2008 03:40 By: Michel Cadot