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
user_segments and tablesize:some thing wrong By: rkl1 on Mon, 08 August 2005	3	4822	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	3125	Mon, 08 August 2005 02:44 By: nmacdannald
What is the use of index By: vidya2005 on Tue, 02 August 2005	6	3041	Fri, 05 August 2005 23:04 By: vidya2005
UNION QUERY OPTIMIZE By: quetzalcoatl on Fri, 05 August 2005	2	2034	Fri, 05 August 2005 13:39 By: quetzalcoatl
Regarding load testing By: d.dineshkumar on Thu, 14 July 2005	6	3636	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	3260	Fri, 05 August 2005 01:29 By: SRReddy
tuning SUM reproting statement By: mjschwenger on Mon, 01 August 2005	2	2417	Thu, 04 August 2005 22:44 By: joeancell
Help me in tune my database PLZ By: masoud_iesoft on Tue, 02 August 2005	5	4086	Thu, 04 August 2005 22:42 By: joeancell
Application Tuning By: milind_sri on Thu, 04 August 2005	1	1932	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	3369	Thu, 04 August 2005 05:15 By: rgopani
How to avoid full tablescan using group function? By: rgopani on Wed, 13 July 2005	8	6233	Wed, 03 August 2005 01:28 By: sharan_it
undo management By: mkuipers on Mon, 25 July 2005	8	4567	Mon, 01 August 2005 22:22 By: mjschwenger
delete statement cause application hang By: liux99 on Mon, 01 August 2005	3	7426	Mon, 01 August 2005 15:28 By: Mahesh Rajendran
data load-index rebuild or index drop By: rkl1 on Thu, 28 July 2005	6	8275	Mon, 01 August 2005 09:47 By: smartin
Index range scan vs full table access By: nitesh_rana on Mon, 01 August 2005	1	4902	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	2703	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	2457	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	1981	Thu, 28 July 2005 03:41 By: oraclejo
monitoring the instance specialy shared pool By: mostafa71 on Tue, 26 July 2005	1	2201	Thu, 28 July 2005 02:38 By: tarundua
dbms_stats By: balavignesh on Tue, 26 July 2005	3	5293	Tue, 26 July 2005 10:45 By: balavignesh
How increase OLTP regarding more CPU? By: enkhbold on Sun, 24 July 2005	3	2312	Tue, 26 July 2005 07:37 By: smartin
statspack-buffer waits By: rkl1 on Mon, 25 July 2005	2	4484	Tue, 26 July 2005 07:24 By: Mahesh Rajendran
Performance on DB Link By: scottwmackey on Fri, 22 July 2005	3	2213	Mon, 25 July 2005 16:18 By: srinivas4u2
Bitmap Indexes By: oratech on Thu, 21 July 2005	6	2699	Mon, 25 July 2005 14:17 By: srinivas4u2
Quad CPU By: enkhbold on Thu, 21 July 2005	2	2347	Fri, 22 July 2005 05:05 By: tarundua
B-Tree or Bitmap Indexes By: milind_sri on Thu, 21 July 2005	4	2998	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	2974	Thu, 21 July 2005 03:29 By: d.dineshkumar
Temporary Tablespace By: gaurav_hdr2002 on Wed, 20 July 2005	2	2258	Wed, 20 July 2005 08:05 By: smartin
tuning insert By: mjschwenger on Thu, 14 July 2005	7	6888	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	3433	Mon, 18 July 2005 23:41 By: d.dineshkumar
increasing buffer cache....! By: balavignesh on Mon, 18 July 2005	4	2756	Mon, 18 July 2005 13:30 By: smartin
blocking problem By: mjschwenger on Fri, 15 July 2005	2	2488	Mon, 18 July 2005 11:38 By: ziggy
Performance reports on Oracle 10g By: nomthied on Mon, 18 July 2005	0	3252	Mon, 18 July 2005 10:10 By: nomthied
The Server Performance deteriorates after some time after the instance is restarted By: rhm1 on Thu, 14 July 2005	1	4195	Sat, 16 July 2005 11:11 By: smartin
Query optimization By: Hina on Fri, 15 July 2005	3	2198	Sat, 16 July 2005 04:06 By: Frank Naude
/+ RULE / hint in SQL Queries By: sujit_ocp on Mon, 09 May 2005	11	86813	Fri, 15 July 2005 05:38 By: d.dineshkumar
How to monitor query By: Hina on Thu, 14 July 2005	2	2472	Thu, 14 July 2005 22:20 By: Hina
reversed indexes By: mjschwenger on Thu, 14 July 2005	2	3240	Thu, 14 July 2005 16:08 By: smartin
Pinning question By: james_briar on Sat, 25 June 2005	12	4580	Thu, 14 July 2005 15:31 By: james_briar
Extracting CPU data from statspack tables By: dee_hicks on Thu, 14 July 2005	1	2125	Thu, 14 July 2005 09:21 By: Mahesh Rajendran