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
Procedure taking long time to execute By: anandhi80 on Wed, 12 March 2008	16	4818	Tue, 18 March 2008 22:00 By: rleishman
Database parameters for tuning By: manoj12 on Tue, 18 March 2008	2	4075	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	2079	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	4861	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	9106	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	4354	Fri, 14 March 2008 12:25 By: OraKaran
Waits During Inserts . By: faiz_hyd on Thu, 13 March 2008	2	2102	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	3652	Thu, 13 March 2008 01:11 By: rleishman
AWR report By: balaji1482 on Wed, 12 March 2008	0	6431	Wed, 12 March 2008 16:14 By: balaji1482
package not completing By: chriswitt on Wed, 12 March 2008	3	2025	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	4279	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	1963	Tue, 11 March 2008 21:58 By: rleishman
Statspack By: sairajesh on Mon, 03 March 2008	11	2475	Tue, 11 March 2008 03:28 By: JRowbottom
IMPROVE PERFORMANCE WHEN INSERT RECORDS By: curlybird on Tue, 11 March 2008	2	2043	Tue, 11 March 2008 01:42 By: curlybird
cost in explain plan By: dcaroli on Mon, 10 March 2008	3	2408	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	10959	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	2570	Mon, 10 March 2008 06:39 By: rleishman
optimized search for max() function By: nooruls143 on Mon, 10 March 2008	2	2248	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	2082	Mon, 10 March 2008 05:31 By: Frank Naude
Impact of NLS Sort Oracle10g, UNIX By: amorphous4u on Thu, 06 March 2008	1	3255	Thu, 06 March 2008 08:52 By: Michel Cadot
Reclaiming free space questions Oracle g10 By: kian.tern on Mon, 03 March 2008	6	3265	Thu, 06 March 2008 07:22 By: hd999
Tuning Suggestion By: GokulTendulkar on Tue, 04 March 2008	3	2412	Thu, 06 March 2008 06:37 By: hd999
Performance Issue oracle 10g,windows By: ramanajv1968 on Wed, 05 March 2008	2	2330	Wed, 05 March 2008 09:20 By: S.Rajaram
query hangs on order by By: ziadaher on Wed, 05 March 2008	4	2453	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	1926	Tue, 04 March 2008 23:25 By: irremediable
Can you fix this query? oracle 10g By: zim327 on Mon, 03 March 2008	5	2755	Tue, 04 March 2008 20:50 By: rleishman
Sizing tablespaces By: lotusdeva on Fri, 29 February 2008	26	8842	Tue, 04 March 2008 13:39 By: lotusdeva
Slow query By: ora_2007 on Fri, 29 February 2008	2	1494	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	2485	Fri, 29 February 2008 11:20 By: rsreddy28
Oracle Database Stop working By: MIFI on Thu, 21 February 2008	13	8067	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	10381	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	16512	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	2379	Fri, 29 February 2008 06:33 By: Mahesh Rajendran
Tunning SQL Query By: ORAGENASHOK on Fri, 29 February 2008	1	1915	Fri, 29 February 2008 06:04 By: Michel Cadot
slow pc startup after 10g By: alzuma on Mon, 25 February 2008	3	2399	Fri, 29 February 2008 00:10 By: racman
Performance Tuning Oracle 10g,Unix By: ravi214u on Mon, 25 February 2008	8	4503	Thu, 28 February 2008 21:08 By: ravi214u
trace-strange case By: shlomi_bt on Thu, 28 February 2008	3	2288	Thu, 28 February 2008 12:38 By: Michel Cadot
Index rebuild issue oracle 9i,linux By: tannad on Thu, 28 February 2008	4	2303	Thu, 28 February 2008 06:23 By: Michel Cadot
Query performance By: ora_2007 on Tue, 26 February 2008	8	3318	Thu, 28 February 2008 03:09 By: MarcS
Rebuild all the indexes of schema By: kamragulshan on Tue, 26 February 2008	7	7947	Wed, 27 February 2008 21:09 By: rleishman