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
All sorting etc done on temp space By: djcot on Tue, 09 August 2005	2	826	Wed, 10 August 2005 16:46 By: djcot
I don't get Rows & Row Source Operation By: perfnewbee on Wed, 10 August 2005	3	3140	Wed, 10 August 2005 15:49 By: Mahesh Rajendran
Solaris 7 Oracle 8.1.6 logfile switch takes 10 minutes By: nmacdannald on Mon, 08 August 2005	1	765	Wed, 10 August 2005 14:31 By: Art Metzer
Index & Performance Tuning By: csharpdev on Tue, 09 August 2005	2	1007	Wed, 10 August 2005 14:27 By: Art Metzer
best strategy to gather statistics in a very dynamic By: peterzaweber on Wed, 10 August 2005	3	1344	Wed, 10 August 2005 08:45 By: Mahesh Rajendran
How manage over 8GB memory By: enkhbold on Mon, 25 July 2005	3	1018	Tue, 09 August 2005 15:53 By: nmacdannald
who reads the redo logs By: mjschwenger on Wed, 03 August 2005	5	989	Tue, 09 August 2005 15:50 By: nmacdannald
SQL Analyze By: quetzalcoatl on Tue, 09 August 2005	0	1966	Tue, 09 August 2005 13:36 By: quetzalcoatl
indexes sql tunning By: quetzalcoatl on Mon, 08 August 2005	1	1899	Mon, 08 August 2005 20:46 By: Mahesh Rajendran
how to split the query using rowid By: confident on Thu, 28 July 2005	1	1081	Mon, 08 August 2005 13:12 By: nmacdannald
user_segments and tablesize:some thing wrong By: rkl1 on Mon, 08 August 2005	3	3437	Mon, 08 August 2005 12:03 By: rkl1
8.1.6 control file too large, how to shrink? By: nmacdannald on Mon, 08 August 2005	0	2027	Mon, 08 August 2005 02:44 By: nmacdannald
What is the use of index By: vidya2005 on Tue, 02 August 2005	6	1140	Fri, 05 August 2005 23:04 By: vidya2005
UNION QUERY OPTIMIZE By: quetzalcoatl on Fri, 05 August 2005	2	735	Fri, 05 August 2005 13:39 By: quetzalcoatl
Regarding load testing By: d.dineshkumar on Thu, 14 July 2005	6	1194	Fri, 05 August 2005 07:23 By: d.dineshkumar
ORA-04045: errors during recompilation/revalidation of HPQ_IF.java/lang/String By: SRReddy on Fri, 05 August 2005	0	2155	Fri, 05 August 2005 01:29 By: SRReddy
tuning SUM reproting statement By: mjschwenger on Mon, 01 August 2005	2	911	Thu, 04 August 2005 22:44 By: joeancell
Help me in tune my database PLZ By: masoud_iesoft on Tue, 02 August 2005	5	1865	Thu, 04 August 2005 22:42 By: joeancell
Application Tuning By: milind_sri on Thu, 04 August 2005	1	822	Thu, 04 August 2005 22:23 By: joeancell
Best way to figure out bad sql in the database By: sumang24 on Mon, 01 August 2005	3	1461	Thu, 04 August 2005 05:15 By: rgopani
How to avoid full tablescan using group function? By: rgopani on Wed, 13 July 2005	8	3597	Wed, 03 August 2005 01:28 By: sharan_it
undo management By: mkuipers on Mon, 25 July 2005	8	1879	Mon, 01 August 2005 22:22 By: mjschwenger
delete statement cause application hang By: liux99 on Mon, 01 August 2005	3	6041	Mon, 01 August 2005 15:28 By: Mahesh Rajendran
data load-index rebuild or index drop By: rkl1 on Thu, 28 July 2005	6	6709	Mon, 01 August 2005 09:47 By: smartin
Index range scan vs full table access By: nitesh_rana on Mon, 01 August 2005	1	3535	Mon, 01 August 2005 07:08 By: Mahesh Rajendran
High privileged% usage in Oracle on win2k server By: amroo on Mon, 01 August 2005	0	1664	Mon, 01 August 2005 06:57 By: amroo
Regarding the sizing of disk for a database By: hafeez_splendid on Thu, 28 July 2005	2	769	Thu, 28 July 2005 07:51 By: smartin
How to better write this query to improved performance By: sumang24 on Tue, 19 July 2005	1	864	Thu, 28 July 2005 03:41 By: oraclejo
monitoring the instance specialy shared pool By: mostafa71 on Tue, 26 July 2005	1	818	Thu, 28 July 2005 02:38 By: tarundua
dbms_stats By: balavignesh on Tue, 26 July 2005	3	3607	Tue, 26 July 2005 10:45 By: balavignesh
How increase OLTP regarding more CPU? By: enkhbold on Sun, 24 July 2005	3	946	Tue, 26 July 2005 07:37 By: smartin
statspack-buffer waits By: rkl1 on Mon, 25 July 2005	2	2922	Tue, 26 July 2005 07:24 By: Mahesh Rajendran
Performance on DB Link By: scottwmackey on Fri, 22 July 2005	3	1060	Mon, 25 July 2005 16:18 By: srinivas4u2
Bitmap Indexes By: oratech on Thu, 21 July 2005	6	1251	Mon, 25 July 2005 14:17 By: srinivas4u2
Quad CPU By: enkhbold on Thu, 21 July 2005	2	825	Fri, 22 July 2005 05:05 By: tarundua
B-Tree or Bitmap Indexes By: milind_sri on Thu, 21 July 2005	4	1072	Thu, 21 July 2005 08:25 By: Mahesh Rajendran
About the sql_text in V$sqlarea By: d.dineshkumar on Tue, 19 July 2005	3	1647	Thu, 21 July 2005 03:29 By: d.dineshkumar
Temporary Tablespace By: gaurav_hdr2002 on Wed, 20 July 2005	2	1028	Wed, 20 July 2005 08:05 By: smartin
tuning insert By: mjschwenger on Thu, 14 July 2005	7	4130	Tue, 19 July 2005 07:35 By: smartin
how to get the explain plan of a insert statement By: d.dineshkumar on Mon, 18 July 2005	12	1742	Mon, 18 July 2005 23:41 By: d.dineshkumar