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
Optimizing Select from VIEW Oracle 10G By: gauravgautam135 on Thu, 12 December 2013	3	2703	Sat, 14 December 2013 15:30 By: Kevin Meade
SQL Tuning Advisor 11g By: srikanthreddy001 on Fri, 13 December 2013	3	3226	Fri, 13 December 2013 04:12 By: martijn
how avoid merge join cartesian. Oracle 11g By: na.dharma@gmail.com on Thu, 05 December 2013	4	14185	Thu, 12 December 2013 02:10 By: michael_bialik
how to avoid negative values to number datatype in oracle Oracle 11g By: na.dharma@gmail.com on Wed, 11 December 2013	13	4734	Wed, 11 December 2013 04:48 By: Lalit Kumar B
look like same query, but huge query plan different. Oracle 11g By: na.dharma@gmail.com on Tue, 10 December 2013	7	3246	Wed, 11 December 2013 03:08 By: John Watson
SQL with BIND Variable Slow - Bind Peeking 11.2 By: prax_14 on Mon, 09 December 2013	3	2835	Wed, 11 December 2013 01:10 By: John Watson
How to correct completely wrong cardinality shown in query plan 10.2.0.4 on Linux By: orausern on Thu, 05 December 2013	29	8881	Fri, 06 December 2013 11:11 By: orausern
FTS on table Oracle 11g, Unix By: a_oracle on Thu, 05 December 2013	4	3698	Fri, 06 December 2013 08:35 By: Kevin Meade
Changing the defaut number of Plans checked by optimzer Aix By: deadpoet69 on Tue, 03 December 2013	3	2709	Wed, 04 December 2013 04:07 By: Roachcoach
Need help in tuning query By: nishant87 on Fri, 29 November 2013	5	5451	Sun, 01 December 2013 17:29 By: Kevin Meade
Automatic SQL Tuning oracle 10.2.0.4 - Windows server 2003 By: muktha_22 on Thu, 28 November 2013	3	3006	Fri, 29 November 2013 01:20 By: Lalit Kumar B
Need help in tuning query 11i By: nishant87 on Tue, 26 November 2013	4	3066	Tue, 26 November 2013 11:34 By: BlackSwan
Performance degrade Oracle 11gr2 , linux AS5 By: oradba123 on Sat, 23 November 2013	3	2573	Tue, 26 November 2013 08:08 By: Kevin Meade
fast query By: narang79 on Mon, 25 November 2013	6	3122	Tue, 26 November 2013 08:00 By: Kevin Meade
Please help me my query performance is bad. Oracle 11g By: ramya_162 on Wed, 20 November 2013	24	6825	Mon, 25 November 2013 06:18 By: ramya_162
SQL & PL/SQL By: varshbugad on Mon, 25 November 2013	1	2714	Mon, 25 November 2013 02:04 By: pablolee
Locking In application code. By: VIP2013 on Mon, 18 November 2013	6	3125	Fri, 22 November 2013 17:04 By: EdStevens
SELECT works, INSERT+ SELECT hangs in SQLDeveloper Tools Oracle, 11.2, SQLDeveloper By: royalyogi on Tue, 19 November 2013	15	4637	Thu, 21 November 2013 02:38 By: cookiemonster
Need advice on index to apply Oracle 11.2, Window 2008 By: jxh461 on Tue, 19 November 2013	10	3379	Wed, 20 November 2013 16:23 By: Kevin Meade
Oracle DB Performance Tests Oracle 11g By: ind9 on Tue, 05 November 2013	6	5289	Wed, 13 November 2013 17:51 By: alan.kendall@nfl.com
Please help me how to improve the performance of this query further. Oracle 11g By: ramya_162 on Thu, 07 November 2013	33	7459	Tue, 12 November 2013 11:15 By: cookiemonster
forms 6i too slow when database have approximately 1 million records Oracle 8i By: qanita786 on Sat, 09 November 2013	4	3786	Mon, 11 November 2013 05:58 By: Littlefoot
Adaptive Cursor Sharing VS SPM By: VIP2013 on Tue, 05 November 2013	3	2940	Sat, 09 November 2013 13:45 By: VIP2013
Which SQL is faster/better Oracle By: mokarem on Mon, 04 November 2013	11	5193	Wed, 06 November 2013 03:32 By: cookiemonster
Performance issue in one sql 11i By: nishantranjan87 on Fri, 18 October 2013	4	3028	Tue, 05 November 2013 23:35 By: Kevin Meade
Understanding ASH Oracle 10g,10.2.0.4.0, windows server 2008 By: zahidbutt on Tue, 05 November 2013	1	2537	Tue, 05 November 2013 01:47 By: Lalit Kumar B
Tiff Images and Oracle Oracle 10, 11 and 12 By: Diego Pafumi on Thu, 31 October 2013	6	4223	Fri, 01 November 2013 11:22 By: gazzag
DB performance problem or "bad" SQL query Oracle 10g By: rc3d on Thu, 24 October 2013	30	10811	Wed, 30 October 2013 12:25 By: Michel Cadot
Please help me on tune this query Oracle 11g By: ajaykumarkona on Tue, 11 December 2012	27	8200	Wed, 30 October 2013 08:49 By: pablolee
XML/XPath rewrites and plan baselines 11.2.0.4 RHEL By: Roachcoach on Tue, 29 October 2013	6	3375	Wed, 30 October 2013 04:12 By: Roachcoach
standard SQL query to benchmark Oracle DB response time (performance) Oracle 10g By: rc3d on Sat, 26 October 2013	1	2692	Sat, 26 October 2013 06:17 By: Michel Cadot
How To Increase Data Reterival / Insertion Speed Oacle 8i and Forms 6i By: qanita786 on Thu, 24 October 2013	2	3115	Thu, 24 October 2013 04:47 By: Michel Cadot
db file parallel read 11.2.0.3.0 By: rishwinger on Fri, 11 October 2013	4	12516	Mon, 21 October 2013 03:38 By: michael_bialik
Digging out the Wait events. By: VIP2013 on Tue, 15 October 2013	14	9531	Mon, 21 October 2013 03:14 By: VIP2013
Need your help in tuning the query 11.5.10.2 By: nishantranjan87 on Wed, 16 October 2013	28	9425	Fri, 18 October 2013 05:21 By: Lalit Kumar B
Help with 12c vs 10.2g 12c By: hesaigo999ca on Tue, 15 October 2013	19	10636	Thu, 17 October 2013 10:39 By: cookiemonster
Insert data fast on table Oracle 11.2 RAC By: nehaverma on Tue, 15 October 2013	14	4286	Tue, 15 October 2013 08:59 By: Lalit Kumar B
database links question oracle 11g By: manoj12 on Mon, 14 October 2013	6	3783	Mon, 14 October 2013 11:42 By: BlackSwan
Force the optimizer to consider all join permutations 11.2.0.4 RHEL By: Roachcoach on Mon, 14 October 2013	5	3445	Mon, 14 October 2013 09:45 By: Roachcoach
Please help me to tune this procedure Oracle 11g By: ajaykumarkona on Fri, 11 October 2013	25	5900	Mon, 14 October 2013 06:48 By: pablolee

Pages (118): [ « ‹ 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Thu Mar 04 01:16:32 CST 2021