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
Explain plan By: peanand on Wed, 29 June 2005	1	1118	Wed, 29 June 2005 08:23 By: Mahesh Rajendran
Logical database design By: hafeez_splendid on Tue, 21 June 2005	5	1517	Mon, 27 June 2005 13:20 By: andrew again
Index for temporary table By: liux99 on Fri, 24 June 2005	3	2150	Fri, 24 June 2005 16:31 By: andrew again
Archival of Production Database By: ppriya_r on Mon, 13 June 2005	6	1697	Wed, 22 June 2005 17:06 By: skempins
How to optimize this sql By: pjsiong on Wed, 22 June 2005	7	1282	Wed, 22 June 2005 09:41 By: Art Metzer
Need some info Capacity Planning ---- Urgent By: hafeez_splendid on Mon, 20 June 2005	1	1016	Tue, 21 June 2005 16:13 By: andrew again
How to increase Performance of Composite Primary Key By: mukeshsingh868 on Tue, 21 June 2005	1	965	Tue, 21 June 2005 16:03 By: andrew again
Need some help resizing SGA parameters By: prestoj8 on Tue, 21 June 2005	1	1219	Tue, 21 June 2005 04:09 By: girish.rohini
Reg. Performance Issue with XML By: d.dineshkumar on Tue, 21 June 2005	0	1893	Tue, 21 June 2005 02:03 By: d.dineshkumar
Measuring time exection By: jef1 on Sat, 18 June 2005	2	1591	Mon, 20 June 2005 04:07 By: limer
choosing the right query By: srraajesh on Sat, 18 June 2005	3	1216	Sun, 19 June 2005 06:23 By: Mahesh Rajendran
how to avoid the full table scan? By: confident on Mon, 13 June 2005	2	6162	Sat, 18 June 2005 03:56 By: srraajesh
VERY URGENT -- SQL- TUNING By: Fl_reader on Wed, 15 June 2005	5	1434	Thu, 16 June 2005 14:40 By: smartin
Decide the size of every component of SGA in given case? By: sunil_v_mishra on Mon, 25 April 2005	7	3014	Thu, 16 June 2005 14:38 By: smartin
Storage recomendation please By: storspoven on Wed, 15 June 2005	1	1721	Thu, 16 June 2005 14:33 By: smartin
Locally Managed Table syntax By: livetaurean19 on Wed, 15 June 2005	8	2530	Wed, 15 June 2005 16:38 By: Mahesh Rajendran
How do you cleanup chained rows! By: jake374 on Wed, 15 June 2005	9	1889	Wed, 15 June 2005 16:03 By: jake374
getting bad Performance during use By: hartmut.stumpf@stratos.ag on Wed, 15 June 2005	5	2808	Wed, 15 June 2005 15:24 By: smartin
Which parameter? By: sunil_v_mishra on Mon, 13 June 2005	8	1521	Wed, 15 June 2005 08:45 By: smartin
which view to use to know about global partitioned index By: tom_k_mishra on Tue, 14 June 2005	1	863	Tue, 14 June 2005 14:00 By: smartin
SQL QUERY NOT USING BITMAP INDEX By: puneetsachar on Mon, 13 June 2005	8	3541	Tue, 14 June 2005 09:30 By: smartin
Index on varchar2(2500) By: sandeep55 on Mon, 13 June 2005	7	2541	Tue, 14 June 2005 09:25 By: smartin
RBO is there in oracle 10g? By: sunil_v_mishra on Mon, 13 June 2005	5	1695	Tue, 14 June 2005 09:21 By: smartin
FTS even there is an index on table. By: sunil_v_mishra on Mon, 13 June 2005	5	1491	Tue, 14 June 2005 08:39 By: Maaher
HELP ON STATSPACK By: sponguru_dba on Mon, 06 June 2005	2	1311	Tue, 14 June 2005 04:33 By: sponguru_dba
who is the user executing query which is using more disk space? By: sunil_v_mishra on Thu, 09 June 2005	2	1360	Mon, 13 June 2005 23:13 By: sunil_v_mishra
Document security model By: vpronnikov on Mon, 13 June 2005	3	1117	Mon, 13 June 2005 10:03 By: smartin
Oracle sequence By: belboey on Sun, 12 June 2005	2	1177	Mon, 13 June 2005 09:36 By: smartin
When to use index By: d.dineshkumar on Fri, 03 June 2005	6	2314	Mon, 13 June 2005 05:53 By: d.dineshkumar
Constraint state in DWH environment (rely disable novalidate) By: henning.schroer on Sun, 12 June 2005	0	2720	Sun, 12 June 2005 04:30 By: henning.schroer
Explain Plan - number of rows returned. By: Lee Sutton on Wed, 08 June 2005	5	2380	Fri, 10 June 2005 08:08 By: Lee Sutton
Index Question By: j_potucek on Tue, 03 May 2005	2	1248	Thu, 09 June 2005 04:15 By: nabeelkhan
What is happening with this sql? By: rramanat on Fri, 27 May 2005	15	4184	Wed, 08 June 2005 20:10 By: rramanat
select large amount of data By: r2d2dev on Wed, 08 June 2005	1	1081	Wed, 08 June 2005 15:47 By: Art Metzer
forced view By: ramvenky on Tue, 07 June 2005	4	3706	Wed, 08 June 2005 00:20 By: nabeelkhan
URGENT:-Performance Tuning. By: milind_sri on Wed, 18 May 2005	8	2178	Tue, 07 June 2005 15:28 By: skempins
Stubborn Query By: tansdot on Thu, 02 June 2005	4	1505	Tue, 07 June 2005 06:35 By: nabeelkhan
How to read the execution plan By: shibu on Wed, 01 June 2005	6	2383	Mon, 06 June 2005 09:06 By: smartin
Composite bitmap indexes By: tansdot on Fri, 03 June 2005	2	6418	Mon, 06 June 2005 08:49 By: smartin
can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: reyazan on Sat, 07 May 2005	11	6511	Sun, 05 June 2005 09:00 By: girish.rohini