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
Performance hit of the application after moving the DB server oracle 9i, 10g, forms 10g/9i, AS9i By: rajesh4851 on Thu, 23 December 2010	1	2195	Thu, 23 December 2010 03:47 By: Michel Cadot
archive log oracle 10g By: prashant_ora on Sun, 19 December 2010	8	5772	Wed, 22 December 2010 10:47 By: Roachcoach
Temp tablespace full ORACLE,9.2.0.5.0,AIX By: lokeshracdba on Wed, 22 December 2010	1	2799	Wed, 22 December 2010 01:10 By: Michel Cadot
delete procedure taking time oracle,9i,unix By: vickey_sagar1 on Tue, 21 December 2010	7	3225	Wed, 22 December 2010 00:01 By: rleishman
Change in explain plan due to Oracle upgrade Oracle 10.2.0.4.0, Windows Server 2003 By: chowdhhx on Tue, 14 December 2010	5	5391	Thu, 16 December 2010 19:14 By: BlackSwan
Tune the query Oracle9i By: ajaykumarkona on Wed, 15 December 2010	4	2534	Wed, 15 December 2010 17:17 By: cookiemonster
dbms_job oracle 10g By: prashant_ora on Tue, 14 December 2010	9	3540	Wed, 15 December 2010 14:23 By: Haraprasad Hota
When to use sub-query and when to use join 11g R1, Windows By: delna.sexy on Tue, 14 December 2010	9	4056	Wed, 15 December 2010 01:31 By: Michel Cadot
dbms_lob.append oracle 10g By: prashant_ora on Mon, 13 December 2010	6	7299	Tue, 14 December 2010 12:10 By: prashant_ora
help on Query tuning oracle 10g By: saaya123 on Tue, 14 December 2010	4	2904	Tue, 14 December 2010 06:25 By: rleishman
Index leading columns Oracle 10.2.0.3 By: pointers on Tue, 14 December 2010	4	4765	Tue, 14 December 2010 05:53 By: pointers
TEMP usage history Oracle 10g, Sun OS By: gkrishn on Mon, 19 July 2010	6	18741	Mon, 13 December 2010 10:41 By: Michel Cadot
SID column in V$SESSION ORCLE 10g.2 WINDOWS XP By: muktha_22 on Sun, 12 December 2010	2	3061	Sun, 12 December 2010 09:01 By: Michel Cadot
What are the best practices with indexes? By: DataMouse on Fri, 10 December 2010	3	3414	Sat, 11 December 2010 03:48 By: Littlefoot
Query using rownum in where cluase with millions of records Oracle 11g , Windows By: pradies on Wed, 08 December 2010	10	5376	Thu, 09 December 2010 11:53 By: Michel Cadot
Creating index on base tables of a view By: mmtr on Thu, 09 December 2010	1	3481	Thu, 09 December 2010 08:43 By: BlackSwan
Expensive Query Oracle 11g By: ashoka_bl on Mon, 06 December 2010	5	4369	Mon, 06 December 2010 05:53 By: flyboy
SQL query performance tuning Oracle 11g Suse Linux 11 By: burasami on Thu, 02 December 2010	5	11786	Sat, 04 December 2010 00:39 By: rleishman
Trailing issue during processing huge data Oracle 9i By: adi_bbay on Fri, 03 December 2010	1	2115	Fri, 03 December 2010 02:01 By: Michel Cadot
Confusion about Partitioning 11g,HP-UNIX B11.23 By: indrajit2002 on Thu, 02 December 2010	1	2423	Thu, 02 December 2010 08:58 By: BlackSwan
Why oracle doesn't use the index? By: iblazquez on Thu, 02 December 2010	9	3842	Thu, 02 December 2010 07:51 By: Roachcoach
Analysys about a single oracle table red hat linux 4/oracle 10g2 By: goracle9 on Tue, 30 November 2010	7	4964	Wed, 01 December 2010 08:43 By: Constancy
SQL - Query Performance Oracle Database 11g Release 11.1.0.6.0, Windows Server 2003 By: MSAM123 on Mon, 29 November 2010	25	6455	Wed, 01 December 2010 04:05 By: MSAM123
Copy data's from Transaction database(db1) to Reporting database (db2) Windows 2000, Oracle 10g By: oraranjangmailcom on Fri, 26 November 2010	4	3024	Fri, 26 November 2010 04:15 By: Michel Cadot
Performance issue for distributed transaction (2PC) Oracle RDBMS 10.2.0.4, HP-UX 11.31 By: samg4ug on Fri, 26 November 2010	0	11080	Fri, 26 November 2010 02:17 By: samg4ug
Improve performance of create statements on a highly fragmented disk By: steffeli on Wed, 24 November 2010	7	9822	Wed, 24 November 2010 09:33 By: Roachcoach
Sql Taking More CPU time (merged) Oracle 10g ,Sun Solaris By: saiphani723 on Tue, 23 November 2010	4	3277	Wed, 24 November 2010 00:50 By: michael_bialik
Performance tuning (cache sub query results) Oracle 10g By: yosikal on Sun, 21 November 2010	1	4001	Sun, 21 November 2010 07:53 By: Michel Cadot
order by Oracle9i By: ajaykumarkona on Thu, 18 November 2010	3	2943	Fri, 19 November 2010 15:23 By: rleishman
Tune the query Windows 2000, Oracle 10g By: oraranjangmailcom on Fri, 19 November 2010	1	2239	Fri, 19 November 2010 08:50 By: BlackSwan
Index with NVL By: ss1_3 on Fri, 19 November 2010	2	3280	Fri, 19 November 2010 08:00 By: Michel Cadot
Method of Tuning Database - row reduction By: palhello on Wed, 20 October 2010	6	4380	Thu, 18 November 2010 23:34 By: rleishman
Help me find the SQL using hash value? (ORA-00060) rdbms 10.2, sles10 x64, three node RAC By: hristo on Thu, 18 November 2010	2	15406	Thu, 18 November 2010 08:48 By: Michel Cadot
Query running slow Oracle 10g By: virmahi on Thu, 18 November 2010	6	3291	Thu, 18 November 2010 04:49 By: Its_me_ved
Procedure performance issue on new DB import? Oracle 11g By: chris32680 on Mon, 15 November 2010	13	4594	Mon, 15 November 2010 20:14 By: chris32680
STOPKEY & Index Use 10.2.0.4.0 - 64bi, Windows 2003 By: annagel on Sat, 06 November 2010	15	8161	Mon, 15 November 2010 13:42 By: annagel
a lot of 'EXISTS' in query Oracle 10g By: mape on Mon, 15 November 2010	12	12209	Mon, 15 November 2010 12:14 By: Michel Cadot
Slow Running Query By: sameek1211 on Wed, 10 November 2010	20	5769	Mon, 15 November 2010 03:00 By: michael_bialik
Oracle Row Chaining and Migration Oracle 10.2.0.4 AIX 6L By: dba_7722 on Sat, 13 November 2010	4	3509	Sat, 13 November 2010 10:44 By: Michel Cadot
which index is best for query performance Oracel 11.1 Red Hat By: nehaverma on Fri, 12 November 2010	5	3575	Sat, 13 November 2010 08:23 By: BlackSwan

Pages (119): [ « ‹ 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 › »]

Goto Forum:

[ Syndicate this forum (XML) ] [

]

Legend

New Messages

No New messages

Locked (w/ unread messages) Locked

Locked

Moved to another forum

Current Time: Mon Oct 06 21:08:22 CDT 2025