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
monitoring the instance specialy shared pool By: mostafa71 on Tue, 26 July 2005	1	1006	Thu, 28 July 2005 02:38 By: tarundua
dbms_stats By: balavignesh on Tue, 26 July 2005	3	3725	Tue, 26 July 2005 10:45 By: balavignesh
How increase OLTP regarding more CPU? By: enkhbold on Sun, 24 July 2005	3	1054	Tue, 26 July 2005 07:37 By: smartin
statspack-buffer waits By: rkl1 on Mon, 25 July 2005	2	3028	Tue, 26 July 2005 07:24 By: Mahesh Rajendran
Performance on DB Link By: scottwmackey on Fri, 22 July 2005	3	1184	Mon, 25 July 2005 16:18 By: srinivas4u2
Bitmap Indexes By: oratech on Thu, 21 July 2005	6	1446	Mon, 25 July 2005 14:17 By: srinivas4u2
Quad CPU By: enkhbold on Thu, 21 July 2005	2	945	Fri, 22 July 2005 05:05 By: tarundua
B-Tree or Bitmap Indexes By: milind_sri on Thu, 21 July 2005	4	1227	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	1810	Thu, 21 July 2005 03:29 By: d.dineshkumar
Temporary Tablespace By: gaurav_hdr2002 on Wed, 20 July 2005	2	1145	Wed, 20 July 2005 08:05 By: smartin
tuning insert By: mjschwenger on Thu, 14 July 2005	7	4317	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	1918	Mon, 18 July 2005 23:41 By: d.dineshkumar
increasing buffer cache....! By: balavignesh on Mon, 18 July 2005	4	1084	Mon, 18 July 2005 13:30 By: smartin
blocking problem By: mjschwenger on Fri, 15 July 2005	2	1086	Mon, 18 July 2005 11:38 By: ziggy
Performance reports on Oracle 10g By: nomthied on Mon, 18 July 2005	0	2093	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	3078	Sat, 16 July 2005 11:11 By: smartin
Query optimization By: Hina on Fri, 15 July 2005	3	1041	Sat, 16 July 2005 04:06 By: Frank Naude
/+ RULE / hint in SQL Queries By: sujit_ocp on Mon, 09 May 2005	11	75324	Fri, 15 July 2005 05:38 By: d.dineshkumar
How to monitor query By: Hina on Thu, 14 July 2005	2	1247	Thu, 14 July 2005 22:20 By: Hina
reversed indexes By: mjschwenger on Thu, 14 July 2005	2	1531	Thu, 14 July 2005 16:08 By: smartin
Pinning question By: james_briar on Sat, 25 June 2005	12	1945	Thu, 14 July 2005 15:31 By: james_briar
Extracting CPU data from statspack tables By: dee_hicks on Thu, 14 July 2005	1	980	Thu, 14 July 2005 09:21 By: Mahesh Rajendran
trace level for query By: Hina on Wed, 13 July 2005	1	855	Thu, 14 July 2005 08:15 By: smartin
Configuring the database parameters By: hafeez_splendid on Wed, 13 July 2005	3	2341	Thu, 14 July 2005 08:10 By: smartin
Influence of snapshot (STATSPACK) in object locks By: oskarthik on Thu, 14 July 2005	0	1810	Thu, 14 July 2005 07:53 By: oskarthik
functional desing advise needed By: mjschwenger on Wed, 06 July 2005	5	1391	Thu, 14 July 2005 04:52 By: ziggy
Database performance issue By: Hina on Tue, 12 July 2005	5	1556	Thu, 14 July 2005 00:14 By: milind_sri
using statspack .......! By: balavignesh on Wed, 13 July 2005	0	1863	Wed, 13 July 2005 09:51 By: balavignesh
Sql Tuning - (urgent) By: rc_ashish on Thu, 07 July 2005	2	1212	Wed, 13 July 2005 05:19 By: SoporteDBA
wait events By: subusona on Fri, 08 July 2005	2	1629	Wed, 13 July 2005 05:01 By: SoporteDBA
steps for tuning oracle...! By: balavignesh on Tue, 12 July 2005	3	1392	Tue, 12 July 2005 11:23 By: smartin
Regarding CPU utilization By: d.dineshkumar on Tue, 12 July 2005	4	1228	Tue, 12 July 2005 08:15 By: d.dineshkumar
Trace files not getting generated By: srinivas4u2 on Fri, 08 July 2005	2	4411	Mon, 11 July 2005 14:19 By: srinivas4u2
how to find out where oracle is using paging and swapping (merged) By: ravivkumar on Sat, 09 July 2005	6	2334	Mon, 11 July 2005 11:35 By: srinivas4u2
shutting down database By: kinjal on Fri, 08 July 2005	7	1290	Mon, 11 July 2005 10:12 By: smartin
composite index or single column index? By: liux99 on Wed, 06 July 2005	3	1428	Wed, 06 July 2005 13:15 By: smartin
SQL*Net messages By: mjschwenger on Wed, 06 July 2005	1	1192	Wed, 06 July 2005 12:05 By: smartin
unable to allocate 4128 bytes of shared memory ("shared pool By: lordtorero on Fri, 24 June 2005	4	12755	Mon, 04 July 2005 01:53 By: ziggy
Explain plan By: peanand on Wed, 29 June 2005	1	1082	Wed, 29 June 2005 08:23 By: Mahesh Rajendran
Logical database design By: hafeez_splendid on Tue, 21 June 2005	5	1495	Mon, 27 June 2005 13:20 By: andrew again