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
Configuring the database parameters By: hafeez_splendid on Wed, 13 July 2005	3	4524	Thu, 14 July 2005 08:10 By: smartin
Influence of snapshot (STATSPACK) in object locks By: oskarthik on Thu, 14 July 2005	0	3167	Thu, 14 July 2005 07:53 By: oskarthik
functional desing advise needed By: mjschwenger on Wed, 06 July 2005	5	3916	Thu, 14 July 2005 04:52 By: ziggy
Database performance issue By: Hina on Tue, 12 July 2005	5	4200	Thu, 14 July 2005 00:14 By: milind_sri
using statspack .......! By: balavignesh on Wed, 13 July 2005	0	3421	Wed, 13 July 2005 09:51 By: balavignesh
Sql Tuning - (urgent) By: rc_ashish on Thu, 07 July 2005	2	2825	Wed, 13 July 2005 05:19 By: SoporteDBA
wait events By: subusona on Fri, 08 July 2005	2	3112	Wed, 13 July 2005 05:01 By: SoporteDBA
steps for tuning oracle...! By: balavignesh on Tue, 12 July 2005	3	4000	Tue, 12 July 2005 11:23 By: smartin
Regarding CPU utilization By: d.dineshkumar on Tue, 12 July 2005	4	3848	Tue, 12 July 2005 08:15 By: d.dineshkumar
Trace files not getting generated By: srinivas4u2 on Fri, 08 July 2005	2	6157	Mon, 11 July 2005 14:19 By: srinivas4u2
how to find out where oracle is using paging and swapping (merged) By: ravivkumar on Sat, 09 July 2005	6	4539	Mon, 11 July 2005 11:35 By: srinivas4u2
shutting down database By: kinjal on Fri, 08 July 2005	7	4241	Mon, 11 July 2005 10:12 By: smartin
composite index or single column index? By: liux99 on Wed, 06 July 2005	3	3565	Wed, 06 July 2005 13:15 By: smartin
SQL*Net messages By: mjschwenger on Wed, 06 July 2005	1	3060	Wed, 06 July 2005 12:05 By: smartin
unable to allocate 4128 bytes of shared memory ("shared pool By: lordtorero on Fri, 24 June 2005	4	14832	Mon, 04 July 2005 01:53 By: ziggy
Explain plan By: peanand on Wed, 29 June 2005	1	2586	Wed, 29 June 2005 08:23 By: Mahesh Rajendran
Logical database design By: hafeez_splendid on Tue, 21 June 2005	5	4498	Mon, 27 June 2005 13:20 By: andrew again
Index for temporary table By: liux99 on Fri, 24 June 2005	3	4238	Fri, 24 June 2005 16:31 By: andrew again
Archival of Production Database By: ppriya_r on Mon, 13 June 2005	6	5530	Wed, 22 June 2005 17:06 By: skempins
How to optimize this sql By: pjsiong on Wed, 22 June 2005	7	3008	Wed, 22 June 2005 09:41 By: Art Metzer
Need some info Capacity Planning ---- Urgent By: hafeez_splendid on Mon, 20 June 2005	1	2989	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	2808	Tue, 21 June 2005 16:03 By: andrew again
Need some help resizing SGA parameters By: prestoj8 on Tue, 21 June 2005	1	2909	Tue, 21 June 2005 04:09 By: girish.rohini
Reg. Performance Issue with XML By: d.dineshkumar on Tue, 21 June 2005	0	3327	Tue, 21 June 2005 02:03 By: d.dineshkumar
Measuring time exection By: jef1 on Sat, 18 June 2005	2	3847	Mon, 20 June 2005 04:07 By: limer
choosing the right query By: srraajesh on Sat, 18 June 2005	3	3441	Sun, 19 June 2005 06:23 By: Mahesh Rajendran
how to avoid the full table scan? By: confident on Mon, 13 June 2005	2	7995	Sat, 18 June 2005 03:56 By: srraajesh
VERY URGENT -- SQL- TUNING By: Fl_reader on Wed, 15 June 2005	5	3002	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	6562	Thu, 16 June 2005 14:38 By: smartin
Storage recomendation please By: storspoven on Wed, 15 June 2005	1	3817	Thu, 16 June 2005 14:33 By: smartin
Locally Managed Table syntax By: livetaurean19 on Wed, 15 June 2005	8	4200	Wed, 15 June 2005 16:38 By: Mahesh Rajendran
How do you cleanup chained rows! By: jake374 on Wed, 15 June 2005	9	5052	Wed, 15 June 2005 16:03 By: jake374
getting bad Performance during use By: hartmut.stumpf@stratos.ag on Wed, 15 June 2005	5	5543	Wed, 15 June 2005 15:24 By: smartin
Which parameter? By: sunil_v_mishra on Mon, 13 June 2005	8	3197	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	2427	Tue, 14 June 2005 14:00 By: smartin
SQL QUERY NOT USING BITMAP INDEX By: puneetsachar on Mon, 13 June 2005	8	6175	Tue, 14 June 2005 09:30 By: smartin
Index on varchar2(2500) By: sandeep55 on Mon, 13 June 2005	7	5806	Tue, 14 June 2005 09:25 By: smartin
RBO is there in oracle 10g? By: sunil_v_mishra on Mon, 13 June 2005	5	4559	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	4045	Tue, 14 June 2005 08:39 By: Maaher
HELP ON STATSPACK By: sponguru_dba on Mon, 06 June 2005	2	3533	Tue, 14 June 2005 04:33 By: sponguru_dba