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
Query performance By: ora_2007 on Tue, 26 February 2008	8	3672	Thu, 28 February 2008 03:09 By: MarcS
Rebuild all the indexes of schema By: kamragulshan on Tue, 26 February 2008	7	8330	Wed, 27 February 2008 21:09 By: rleishman
>>>Wired SQL Tuning issue, maybe Oracle's bug<<<< ORACLE XE, 10G, Solaris, Windows By: elawcn on Wed, 27 February 2008	1	1997	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	2078	Tue, 26 February 2008 16:56 By: rleishman
Index Oracle 10g By: subbu_tce on Mon, 25 February 2008	3	1851	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	2305	Mon, 25 February 2008 22:59 By: rleishman
Oracle Slows down. By: ora_2007 on Mon, 25 February 2008	2	5701	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	4879	Mon, 25 February 2008 03:46 By: Michel Cadot
Tune the SQL Qury windows, oracle 10g By: gentleman777us on Sun, 24 February 2008	2	2498	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	5957	Sat, 23 February 2008 11:16 By: alanm
statspack oracle,8.1.7, unix By: sheldon1982 on Fri, 22 February 2008	5	2714	Fri, 22 February 2008 04:30 By: Michel Cadot
Temp tablespace resizing By: shahnazurs on Thu, 21 February 2008	3	2689	Fri, 22 February 2008 03:55 By: shahnazurs
sql tuning By: guyj on Tue, 12 February 2008	11	3391	Fri, 22 February 2008 02:51 By: michael_bialik
SQL getting timed out. By: senthildurga on Fri, 22 February 2008	1	2109	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	2250	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	2572	Thu, 21 February 2008 11:56 By: BlackSwan
Whey sometimes using Exists Function is better By: epall on Wed, 20 February 2008	7	3186	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	2248	Thu, 21 February 2008 05:58 By: michael_bialik
I cant understand this behavior By: iblazquez on Wed, 20 February 2008	4	2826	Thu, 21 February 2008 03:48 By: Michel Cadot
wrong execution plan By: daniesh.shaikh@gmail.com on Fri, 15 February 2008	15	5694	Wed, 20 February 2008 23:43 By: daniesh.shaikh@gmail.com
Oracle Tuning By: ram anand on Wed, 20 February 2008	3	2411	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	3904	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	1482	Tue, 19 February 2008 06:02 By: Mahesh Rajendran
Improving data loading into tables By: irremediable on Tue, 19 February 2008	11	3403	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	4658	Mon, 18 February 2008 22:42 By: rleishman
Query tunning required By: gksenthilkumar on Sat, 09 February 2008	7	4135	Sun, 17 February 2008 17:34 By: gksenthilkumar
Different partitioned table import By: kulkarni_m6 on Fri, 15 February 2008	11	3524	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	3068	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	2585	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	2734	Fri, 15 February 2008 07:29 By: irremediable
TOAD / Oracle qeps By: rgoldwrx on Tue, 29 January 2008	21	10244	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	3616	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	2219	Thu, 14 February 2008 05:58 By: Michel Cadot
disk read speed ORACLE9i By: dendroid66 on Mon, 11 February 2008	1	1942	Mon, 11 February 2008 10:47 By: Michel Cadot
Delaying insert... By: ataufique on Sun, 10 February 2008	2	2055	Sun, 10 February 2008 11:41 By: Kevin Meade
Improvong performance of SQL script By: aviana on Fri, 08 February 2008	1	2081	Fri, 08 February 2008 09:30 By: Michel Cadot
Tool/method for detecting changed executions plans By: fcastill69 on Tue, 05 February 2008	6	2125	Fri, 08 February 2008 04:18 By: fcastill69
Index Entry Oracle,9i,SunOs By: shahnazurs on Thu, 07 February 2008	1	1822	Thu, 07 February 2008 11:28 By: Michel Cadot
Dictionary_cache = 0 ? By: DrNeko on Mon, 04 February 2008	8	2682	Wed, 06 February 2008 17:01 By: DrNeko
RBO to CBO migration Oracle 9i By: sairajesh on Wed, 06 February 2008	1	2034	Wed, 06 February 2008 04:46 By: Michel Cadot

Pages (119): [ « ‹ 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Mon Sep 08 20:33:56 CDT 2025