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
Why did I not use the index? Windows XP, Oracle 10.2.0.2 Release By: trantuananh24hg on Thu, 13 March 2008	4	1851	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	3749	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	8898	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	3301	Fri, 14 March 2008 12:25 By: OraKaran
Waits During Inserts . By: faiz_hyd on Thu, 13 March 2008	2	1793	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	2782	Thu, 13 March 2008 01:11 By: rleishman
AWR report By: balaji1482 on Wed, 12 March 2008	0	6232	Wed, 12 March 2008 16:14 By: balaji1482
package not completing By: chriswitt on Wed, 12 March 2008	3	1240	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	3373	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	1448	Tue, 11 March 2008 21:58 By: rleishman
Statspack By: sairajesh on Mon, 03 March 2008	11	2218	Tue, 11 March 2008 03:28 By: JRowbottom
IMPROVE PERFORMANCE WHEN INSERT RECORDS By: curlybird on Tue, 11 March 2008	2	1473	Tue, 11 March 2008 01:42 By: curlybird
cost in explain plan By: dcaroli on Mon, 10 March 2008	3	1408	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	10428	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	1553	Mon, 10 March 2008 06:39 By: rleishman
optimized search for max() function By: nooruls143 on Mon, 10 March 2008	2	1479	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	1608	Mon, 10 March 2008 05:31 By: Frank Naude
Impact of NLS Sort Oracle10g, UNIX By: amorphous4u on Thu, 06 March 2008	1	2825	Thu, 06 March 2008 08:52 By: Michel Cadot
Reclaiming free space questions Oracle g10 By: kian.tern on Mon, 03 March 2008	6	1970	Thu, 06 March 2008 07:22 By: hd999
Tuning Suggestion By: GokulTendulkar on Tue, 04 March 2008	3	1724	Thu, 06 March 2008 06:37 By: hd999
Performance Issue oracle 10g,windows By: ramanajv1968 on Wed, 05 March 2008	2	2103	Wed, 05 March 2008 09:20 By: S.Rajaram
query hangs on order by By: ziadaher on Wed, 05 March 2008	4	2120	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	1607	Tue, 04 March 2008 23:25 By: irremediable
Can you fix this query? oracle 10g By: zim327 on Mon, 03 March 2008	5	2472	Tue, 04 March 2008 20:50 By: rleishman
Sizing tablespaces By: lotusdeva on Fri, 29 February 2008	26	8123	Tue, 04 March 2008 13:39 By: lotusdeva
Slow query By: ora_2007 on Fri, 29 February 2008	2	1256	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	1411	Fri, 29 February 2008 11:20 By: rsreddy28
Oracle Database Stop working By: MIFI on Thu, 21 February 2008	13	6019	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	9835	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	15307	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	1412	Fri, 29 February 2008 06:33 By: Mahesh Rajendran
Tunning SQL Query By: ORAGENASHOK on Fri, 29 February 2008	1	1322	Fri, 29 February 2008 06:04 By: Michel Cadot
slow pc startup after 10g By: alzuma on Mon, 25 February 2008	3	1473	Fri, 29 February 2008 00:10 By: racman
Performance Tuning Oracle 10g,Unix By: ravi214u on Mon, 25 February 2008	8	3027	Thu, 28 February 2008 21:08 By: ravi214u
trace-strange case By: shlomi_bt on Thu, 28 February 2008	3	1297	Thu, 28 February 2008 12:38 By: Michel Cadot
Index rebuild issue oracle 9i,linux By: tannad on Thu, 28 February 2008	4	1419	Thu, 28 February 2008 06:23 By: Michel Cadot
Query performance By: ora_2007 on Tue, 26 February 2008	8	2911	Thu, 28 February 2008 03:09 By: MarcS
Rebuild all the indexes of schema By: kamragulshan on Tue, 26 February 2008	7	6472	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	1305	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	1512	Tue, 26 February 2008 16:56 By: rleishman