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
Histogram Issue oracle 9.2.0.6 By: ankush_chawla on Mon, 05 October 2009	3	2068	Mon, 05 October 2009 13:23 By: Michel Cadot
hard parse for SQL (merged) By: casttree on Fri, 02 October 2009	4	3135	Mon, 05 October 2009 07:51 By: JRowbottom
Too many columns in one index Oracle 10g By: virmahi on Sun, 04 October 2009	5	3059	Mon, 05 October 2009 07:26 By: JRowbottom
flush shared pool oracle 8.1.7.0.0, windows 2003 server By: ranjit@buddhaair.com on Sat, 03 October 2009	12	9618	Mon, 05 October 2009 07:17 By: JRowbottom
Does "alter system flush shared_pool" statement impact to performance? Oracle 10g, crossover OS! By: trantuananh24hg on Thu, 16 July 2009	4	17425	Fri, 02 October 2009 07:53 By: Michel Cadot
Slow Insert APPEND into Temporary Table By: spv73 on Fri, 02 October 2009	2	6113	Fri, 02 October 2009 07:44 By: Michel Cadot
Query tuning By: gajini on Tue, 22 September 2009	6	4428	Mon, 28 September 2009 12:21 By: madhuottapalam
Performance tuning in Oracle 10 G By: madhuottapalam on Mon, 28 September 2009	3	2737	Mon, 28 September 2009 11:17 By: madhuottapalam
Slow query performance Oracle 9i, Windows XP By: brunom on Thu, 17 September 2009	8	4512	Mon, 28 September 2009 03:31 By: brunom
performance issue wtith single instance database oracle 10gr2 10.2.0.3 windows2000 By: sherkhan@infodynamic.net on Wed, 02 September 2009	3	2243	Mon, 28 September 2009 01:26 By: sherkhan@infodynamic.net
Need A Small help on Tuning this query. 10.2.0.2 By: balakrishnay on Sun, 27 September 2009	5	6220	Sun, 27 September 2009 08:22 By: rleishman
Bulk insert is faster then insert into select * ...... Oracle 10g, Unix By: dasgupta.amitava@gmail on Sun, 11 January 2009	15	21331	Thu, 24 September 2009 03:11 By: Dipali Vithalani
Stale statistics and Dynamic Sampling Oracle 10gR2 (10.2.0.4) By: Ferrarist on Wed, 23 September 2009	5	5548	Wed, 23 September 2009 03:19 By: Michel Cadot
FLUSH SHARED_POOL Oracle,10.2.4.0,linux By: sundarfaq on Mon, 21 September 2009	5	3659	Tue, 22 September 2009 03:33 By: bishtoo
db block gets, consistent gets By: rkl1 on Tue, 14 June 2005	14	36812	Mon, 21 September 2009 04:25 By: Michel Cadot
Performance Tuning Sun Solaris By: kmkumar24 on Sat, 19 September 2009	3	2707	Mon, 21 September 2009 03:41 By: JRowbottom
Question about parallel processing. 10.2.0.3 Sun Sparc. By: vjeedigunta on Sat, 19 September 2009	2	2332	Sat, 19 September 2009 10:42 By: Michel Cadot
alternate for Table Partitioning By: mr.rajeshyadav on Thu, 17 September 2009	3	2563	Fri, 18 September 2009 03:53 By: JRowbottom
Query Performance issue Oracle, 10.2.0.1, Solaris By: bhas_m on Thu, 17 September 2009	2	2624	Thu, 17 September 2009 19:41 By: rleishman
update statement issue oracle9i By: manoj12 on Thu, 17 September 2009	1	1918	Thu, 17 September 2009 08:29 By: JRowbottom
Use of Bind variable By: sameertuladhar on Tue, 15 September 2009	2	2463	Wed, 16 September 2009 23:05 By: sameertuladhar
EXECUTE IMMEDIATE 'set autotrace on'; ORA-00922: missing or invalid option Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod \|\| TNS for 32-bit Windows: Version 10.2.0.3.0 - Production By: rtnataraj on Tue, 15 September 2009	4	9182	Wed, 16 September 2009 04:57 By: JRowbottom
Error Creating STATSPACK on Oracle10g By: bahy91 on Fri, 13 July 2007	19	26723	Tue, 15 September 2009 20:02 By: diri
Useing USE_HASH in a GROUP BY Clause (merged 7) sqlplus,10g,windows By: pstanand on Mon, 14 September 2009	9	5121	Tue, 15 September 2009 00:00 By: pstanand
TEMP tablespace getting filled up with multi table join By: poratips on Wed, 09 September 2009	14	6016	Sun, 13 September 2009 14:54 By: michael_bialik
Use of DBMS_LOGSTDBY By: bahy91 on Fri, 31 August 2007	3	8426	Thu, 10 September 2009 10:53 By: Michel Cadot
I/O cost was very high Windows Server 2003, Oracle 10.2.0.4 By: trantuananh24hg on Wed, 09 September 2009	3	2600	Wed, 09 September 2009 22:27 By: trantuananh24hg
DBMS_STATS running slow. Oracle ,10.2.0.4,sun sparc By: replicated on Tue, 08 September 2009	1	5763	Tue, 08 September 2009 10:06 By: BlackSwan
To limit Cpu consumption Oracle 10.2.0.4, Solaris 9 By: dasuwal@gmail.com on Fri, 28 August 2009	4	3343	Sun, 06 September 2009 21:32 By: trantuananh24hg
Wait event problem Oracle 10g By: Nikolin on Tue, 01 September 2009	5	7211	Sat, 05 September 2009 10:13 By: BlackSwan
Query run faster without indexes. Why? Oracle 11g By: JorgeAbreu on Thu, 03 September 2009	18	5252	Fri, 04 September 2009 20:01 By: JorgeAbreu
"Database Time Spent Waiting (%)" are at 100 for event class "Concurrency" Oracle 10g r2, HP-UX 11.31 Itanium By: miguechancleto on Wed, 02 September 2009	0	12522	Wed, 02 September 2009 11:16 By: miguechancleto
tuning undo oracle10.2.0.4 hp-ux ia By: suzyque54 on Sun, 30 August 2009	2	3289	Sun, 30 August 2009 14:01 By: BlackSwan
time consuming query oracle 10g By: rajasekhar857 on Sun, 09 August 2009	11	9756	Sat, 29 August 2009 05:46 By: andydba
A question about LRU in shared pool By: serenaender on Mon, 24 August 2009	3	2311	Fri, 28 August 2009 00:05 By: trantuananh24hg
dataguard tunning: checkpoint completed 11.1.0.7 By: aline on Tue, 25 August 2009	8	11879	Thu, 27 August 2009 07:22 By: JRowbottom
oracle query running slow By: rareraja on Wed, 26 August 2009	2	5304	Thu, 27 August 2009 00:38 By: Michel Cadot
How to change SYS password? Oralce 10g By: kkxenon on Wed, 26 August 2009	5	2642	Wed, 26 August 2009 05:40 By: Michel Cadot
Bitmap & Normal Index for same column - Oracle Oracle 9i By: nocturnal on Mon, 17 August 2009	3	2946	Wed, 26 August 2009 05:04 By: Nirnay Jaiswal
Insert performance with index rebuild 10gR2 solaris By: othergoodboy on Wed, 19 August 2009	2	2187	Thu, 20 August 2009 00:01 By: Michel Cadot