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
Function Based Indexes By: navin_deep on Wed, 03 February 2010	2	2698	Wed, 03 February 2010 12:09 By: Michel Cadot
Oracle Segment Tuning Oracle10g By: salora on Tue, 02 February 2010	2	9025	Tue, 02 February 2010 02:59 By: rahulvb
Heap size exceeds warning notification in alert.log oracle 10.2.0.1.0,Redhat Linux 4.5 [Enterprise edition] By: goracle9 on Sat, 30 January 2010	9	50654	Sun, 31 January 2010 01:41 By: Michel Cadot
slower execution of pl/sql code By: mandark on Thu, 28 January 2010	1	2655	Fri, 29 January 2010 10:56 By: Kevin Meade
Bitmap Join Index for DW Oracle 10g By: summoner on Mon, 25 January 2010	5	4868	Fri, 29 January 2010 10:51 By: Kevin Meade
When is execution plan for a package determined (merged) By: firefly on Thu, 28 January 2010	17	4545	Fri, 29 January 2010 02:38 By: firefly
Rarely used columns Oracle 10.2.0.1.0,RHEL5,pro*c By: johnbach on Thu, 28 January 2010	4	2742	Thu, 28 January 2010 05:52 By: rleishman
how to calculate cpu usage of database from statspack report 10.1.0.5.0 , linux By: anwar786 on Wed, 27 January 2010	2	5047	Wed, 27 January 2010 23:54 By: anwar786
v$pgastat value 11.0.0.6 By: jinga on Wed, 27 January 2010	4	5099	Wed, 27 January 2010 11:05 By: Michel Cadot
Undo used by Batch Job Oracle 9.2.0.6.0 on HP-UX By: chetanaZ on Tue, 26 January 2010	3	2611	Tue, 26 January 2010 05:27 By: Michel Cadot
Query performance problem Oracle 9.2.0.8.0 By: mbmalasenthil on Mon, 25 January 2010	2	2641	Mon, 25 January 2010 05:39 By: rleishman
Use of double parallel hint By: sameertuladhar on Mon, 25 January 2010	1	3693	Mon, 25 January 2010 02:58 By: Michel Cadot
Finding INSERT statments between 2 AWR snapshots 10.2.0.4 By: kamran.irshad on Sat, 23 January 2010	1	3158	Sat, 23 January 2010 00:32 By: kamran.irshad
Query With View Vs Select of the View behave differently Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 By: faiz_hyd on Thu, 21 January 2010	3	3968	Fri, 22 January 2010 07:45 By: cookiemonster
Query Fetching data within Two hrs 9.2.0.8 By: jaganerp@gmail.com on Fri, 22 January 2010	3	7536	Fri, 22 January 2010 05:53 By: cookiemonster
Table Access by ROWID vs UNIQUE INDEX SCAN 10.2.0.4 By: kamran.irshad on Thu, 21 January 2010	4	9332	Thu, 21 January 2010 21:35 By: rleishman
Determining UPDATE statements from DBA_HIST_SQL_PLAN 10.2.0.4 By: kamran.irshad on Tue, 19 January 2010	4	4115	Thu, 21 January 2010 01:23 By: John Watson
"os thread startup" in top 5 Events linux , oracle 10.2.0.4 By: gir_sat on Wed, 20 January 2010	1	19589	Wed, 20 January 2010 04:59 By: ramoradba
Database slow problem 10g Database By: allianz2010 on Mon, 18 January 2010	5	3612	Wed, 20 January 2010 03:44 By: JRowbottom
how to avoid multiple Like operators in a single query By: bubblyaruna on Tue, 22 December 2009	8	4258	Sat, 16 January 2010 17:45 By: Kevin Meade
Query optimisation, table partitionning and lack of index database 10g By: didiera on Thu, 14 January 2010	5	4058	Sat, 16 January 2010 17:41 By: rleishman
Oracle audit view performance issue Oracle Apps R12 By: sreejit on Thu, 24 December 2009	5	6618	Sat, 16 January 2010 15:53 By: Kevin Meade
Wait event problem oracle 10.1.0.5.0, Sunsolaris 5.10 By: sathik on Thu, 14 January 2010	2	2684	Sat, 16 January 2010 15:37 By: Kevin Meade
SQL Tuning and optimization- Help Needed 10g By: benjamin.tl on Wed, 13 January 2010	5	2904	Thu, 14 January 2010 09:02 By: benjamin.tl
11g tuning oracle 11g By: orafacjublu on Tue, 12 January 2010	3	2507	Tue, 12 January 2010 04:22 By: Michel Cadot
Query monitoring/intercepting 10g By: newerakb on Mon, 11 January 2010	4	2516	Mon, 11 January 2010 15:20 By: newerakb
how to reduce the response time of the sql query oracl 10 linux By: dhanamukesh on Fri, 08 January 2010	10	3818	Mon, 11 January 2010 07:31 By: JRowbottom
what is the best ? (merged 3) oracle 11g By: al_hareth on Sat, 09 January 2010	4	2453	Sat, 09 January 2010 16:23 By: martijn
cardinality of join affected by transitivity 10201 By: stsy38 on Thu, 31 December 2009	14	5696	Sat, 09 January 2010 11:53 By: narsap
SQL Tuning- Need help Oracle 10g Enterprise Edition Release 10.2.0.3.0 - Prod By: marlon_loyolite on Thu, 07 January 2010	1	2468	Fri, 08 January 2010 02:31 By: Michel Cadot
to tune an SQL query oracle 9i By: mohannksr on Fri, 08 January 2010	3	2697	Fri, 08 January 2010 01:36 By: rahulvb
Re-structuring the SQL query By: decci_7 on Mon, 04 January 2010	3	2621	Wed, 06 January 2010 19:47 By: rleishman
How to tune this sql? Oracle 10.0.2.3 By: prachij593 on Tue, 05 January 2010	7	3074	Tue, 05 January 2010 09:31 By: BlackSwan
Instance profiling 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: rahulvb on Tue, 05 January 2010	5	2878	Tue, 05 January 2010 03:25 By: rahulvb
write as a single statement Databse 10.1,xp By: krajasekhar.v on Tue, 22 December 2009	2	1987	Sun, 03 January 2010 09:46 By: coleing
Current snap shot level? 9.2, Windows XP By: muthu_dba on Sat, 02 January 2010	3	2335	Sat, 02 January 2010 11:39 By: BlackSwan
Explain Plan from statsreport Oracle DB, 10.2.0.4.0 , UNIX By: smita_giri on Thu, 24 December 2009	5	4422	Wed, 30 December 2009 06:33 By: JRowbottom
Sql query tuning oracle,10.1.0.5.0,sunsolaris 5.10 By: sathik on Wed, 23 December 2009	9	3842	Wed, 30 December 2009 06:15 By: JRowbottom
Top wait event - control file sequential read By: oracleperm on Sun, 22 November 2009	3	11466	Fri, 25 December 2009 21:30 By: BlackSwan
How to retrieve SQLs and execution plans from awr history oracle database 10R2 By: anurag_telenor on Wed, 23 December 2009	3	15629	Wed, 23 December 2009 18:00 By: BlackSwan

Pages (119): [ « ‹ 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Fri Nov 22 07:45:37 CST 2024