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
tablespace related By: sidd_411 on Wed, 19 March 2008	1	1654	Wed, 19 March 2008 06:00 By: Michel Cadot
Simple query going for a full table scan By: Flash on Tue, 18 March 2008	4	2294	Wed, 19 March 2008 01:19 By: rleishman
Procedure taking long time to execute By: anandhi80 on Wed, 12 March 2008	16	5342	Tue, 18 March 2008 22:00 By: rleishman
Database parameters for tuning By: manoj12 on Tue, 18 March 2008	2	4201	Tue, 18 March 2008 04:57 By: manoj12
Why did I not use the index? Windows XP, Oracle 10.2.0.2 Release By: trantuananh24hg on Thu, 13 March 2008	4	2221	Sun, 16 March 2008 21:09 By: trantuananh24hg
sqlplus: query takes too much time sqlplus:oracle database By: viko on Fri, 14 March 2008	4	5199	Sun, 16 March 2008 20:20 By: gamyers
Doubt regarding ORA-30036: unable to extend segment by 8 in undo tablespace By: rolex.mp on Sun, 16 March 2008	0	9223	Sun, 16 March 2008 06:11 By: rolex.mp
Help - Stored Outline Oracle 9i R2 on RHEL By: OraKaran on Tue, 11 March 2008	4	4569	Fri, 14 March 2008 12:25 By: OraKaran
Waits During Inserts . By: faiz_hyd on Thu, 13 March 2008	2	2351	Thu, 13 March 2008 13:52 By: faiz_hyd
How to get recordcount & elapsed time without get result set while run proc in sql*plus? oracle 9.2.0.1.0 By: gksenthilkumar on Wed, 12 March 2008	3	3804	Thu, 13 March 2008 01:11 By: rleishman
AWR report By: balaji1482 on Wed, 12 March 2008	0	6518	Wed, 12 March 2008 16:14 By: balaji1482
package not completing By: chriswitt on Wed, 12 March 2008	3	2184	Wed, 12 March 2008 15:28 By: Michel Cadot
need help! how to intercept sql command of update Oracle 10g xe, Windows xp By: jarbouni on Wed, 12 March 2008	4	4475	Wed, 12 March 2008 06:49 By: Michel Cadot
Query takes too much time 10.1.0.5.0/HPUX By: it_me24 on Tue, 11 March 2008	3	2111	Tue, 11 March 2008 21:58 By: rleishman
Statspack By: sairajesh on Mon, 03 March 2008	11	2755	Tue, 11 March 2008 03:28 By: JRowbottom
IMPROVE PERFORMANCE WHEN INSERT RECORDS By: curlybird on Tue, 11 March 2008	2	2252	Tue, 11 March 2008 01:42 By: curlybird
cost in explain plan By: dcaroli on Mon, 10 March 2008	3	2662	Mon, 10 March 2008 20:56 By: rleishman
AWR Report or ADDM Report? Oracle 10g - 10.2.0.3.0 on RHEL 64 bit By: OraKaran on Mon, 10 March 2008	1	11117	Mon, 10 March 2008 12:47 By: Michel Cadot
Tunning required Oracle 9.2.0.7.0 By: gksenthilkumar on Sun, 09 March 2008	5	2748	Mon, 10 March 2008 06:39 By: rleishman
optimized search for max() function By: nooruls143 on Mon, 10 March 2008	2	2384	Mon, 10 March 2008 06:36 By: rleishman
Database Metrics for Capacity Planning Oracle 10G and 9i By: mkrishna95050 on Thu, 28 February 2008	1	2224	Mon, 10 March 2008 05:31 By: Frank Naude
Impact of NLS Sort Oracle10g, UNIX By: amorphous4u on Thu, 06 March 2008	1	3476	Thu, 06 March 2008 08:52 By: Michel Cadot
Reclaiming free space questions Oracle g10 By: kian.tern on Mon, 03 March 2008	6	3471	Thu, 06 March 2008 07:22 By: hd999
Tuning Suggestion By: GokulTendulkar on Tue, 04 March 2008	3	2537	Thu, 06 March 2008 06:37 By: hd999
Performance Issue oracle 10g,windows By: ramanajv1968 on Wed, 05 March 2008	2	2460	Wed, 05 March 2008 09:20 By: S.Rajaram
query hangs on order by By: ziadaher on Wed, 05 March 2008	4	2646	Wed, 05 March 2008 01:25 By: dhananjay
Single operation slows down a query Oracle9i, 9.2.0.6.0, Win 2003 By: irremediable on Mon, 03 March 2008	4	2206	Tue, 04 March 2008 23:25 By: irremediable
Can you fix this query? oracle 10g By: zim327 on Mon, 03 March 2008	5	2971	Tue, 04 March 2008 20:50 By: rleishman
Sizing tablespaces By: lotusdeva on Fri, 29 February 2008	26	9819	Tue, 04 March 2008 13:39 By: lotusdeva
Slow query By: ora_2007 on Fri, 29 February 2008	2	1653	Fri, 29 February 2008 21:16 By: rleishman
SQL statement in the SGA Oracle 10g , Linux AS4 By: rsreddy28 on Fri, 29 February 2008	4	2760	Fri, 29 February 2008 11:20 By: rsreddy28
Oracle Database Stop working By: MIFI on Thu, 21 February 2008	13	8456	Fri, 29 February 2008 08:19 By: MIFI
drop partition slow Oracle 9.2.0.6.0 with Partitioning option - Solaris 9 By: jzt9sf on Wed, 27 February 2008	7	10791	Fri, 29 February 2008 07:54 By: Michel Cadot
:x ORA-01920: user name 'PERFSTAT' conflicts with another user or role name :x oracle 10.2.0.3.0 DB running on Vista ultimate By: racman on Thu, 28 February 2008	3	17147	Fri, 29 February 2008 07:53 By: racman
Seperate datafiles for tables in Same schema Oracle 10g on Linux By: MIFI on Fri, 29 February 2008	3	2641	Fri, 29 February 2008 06:33 By: Mahesh Rajendran
Tunning SQL Query By: ORAGENASHOK on Fri, 29 February 2008	1	2033	Fri, 29 February 2008 06:04 By: Michel Cadot
slow pc startup after 10g By: alzuma on Mon, 25 February 2008	3	2552	Fri, 29 February 2008 00:10 By: racman
Performance Tuning Oracle 10g,Unix By: ravi214u on Mon, 25 February 2008	8	4727	Thu, 28 February 2008 21:08 By: ravi214u
trace-strange case By: shlomi_bt on Thu, 28 February 2008	3	2458	Thu, 28 February 2008 12:38 By: Michel Cadot
Index rebuild issue oracle 9i,linux By: tannad on Thu, 28 February 2008	4	2552	Thu, 28 February 2008 06:23 By: Michel Cadot