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
getting bad Performance during use By: hartmut.stumpf@stratos.ag on Wed, 15 June 2005	5	2549	Wed, 15 June 2005 15:24 By: smartin
Which parameter? By: sunil_v_mishra on Mon, 13 June 2005	8	1320	Wed, 15 June 2005 08:45 By: smartin
which view to use to know about global partitioned index By: tom_k_mishra on Tue, 14 June 2005	1	686	Tue, 14 June 2005 14:00 By: smartin
SQL QUERY NOT USING BITMAP INDEX By: puneetsachar on Mon, 13 June 2005	8	3318	Tue, 14 June 2005 09:30 By: smartin
Index on varchar2(2500) By: sandeep55 on Mon, 13 June 2005	7	2253	Tue, 14 June 2005 09:25 By: smartin
RBO is there in oracle 10g? By: sunil_v_mishra on Mon, 13 June 2005	5	1486	Tue, 14 June 2005 09:21 By: smartin
FTS even there is an index on table. By: sunil_v_mishra on Mon, 13 June 2005	5	1289	Tue, 14 June 2005 08:39 By: Maaher
HELP ON STATSPACK By: sponguru_dba on Mon, 06 June 2005	2	994	Tue, 14 June 2005 04:33 By: sponguru_dba
who is the user executing query which is using more disk space? By: sunil_v_mishra on Thu, 09 June 2005	2	1111	Mon, 13 June 2005 23:13 By: sunil_v_mishra
Document security model By: vpronnikov on Mon, 13 June 2005	3	922	Mon, 13 June 2005 10:03 By: smartin
Oracle sequence By: belboey on Sun, 12 June 2005	2	1001	Mon, 13 June 2005 09:36 By: smartin
When to use index By: d.dineshkumar on Fri, 03 June 2005	6	1973	Mon, 13 June 2005 05:53 By: d.dineshkumar
Constraint state in DWH environment (rely disable novalidate) By: henning.schroer on Sun, 12 June 2005	0	2533	Sun, 12 June 2005 04:30 By: henning.schroer
Explain Plan - number of rows returned. By: Lee Sutton on Wed, 08 June 2005	5	2191	Fri, 10 June 2005 08:08 By: Lee Sutton
Index Question By: j_potucek on Tue, 03 May 2005	2	1065	Thu, 09 June 2005 04:15 By: nabeelkhan
What is happening with this sql? By: rramanat on Fri, 27 May 2005	15	3978	Wed, 08 June 2005 20:10 By: rramanat
select large amount of data By: r2d2dev on Wed, 08 June 2005	1	857	Wed, 08 June 2005 15:47 By: Art Metzer
forced view By: ramvenky on Tue, 07 June 2005	4	3512	Wed, 08 June 2005 00:20 By: nabeelkhan
URGENT:-Performance Tuning. By: milind_sri on Wed, 18 May 2005	8	1980	Tue, 07 June 2005 15:28 By: skempins
Stubborn Query By: tansdot on Thu, 02 June 2005	4	1269	Tue, 07 June 2005 06:35 By: nabeelkhan
How to read the execution plan By: shibu on Wed, 01 June 2005	6	2110	Mon, 06 June 2005 09:06 By: smartin
Composite bitmap indexes By: tansdot on Fri, 03 June 2005	2	5814	Mon, 06 June 2005 08:49 By: smartin
can use 2 GB as SGA(4gb ram) oracle 8i windows 2000s By: reyazan on Sat, 07 May 2005	11	6210	Sun, 05 June 2005 09:00 By: girish.rohini
Reg. out put of DBMS_XPLAN.DISPLAY By: d.dineshkumar on Fri, 03 June 2005	6	2356	Sun, 05 June 2005 07:23 By: nabeelkhan
Select on same table gives poor performace. By: abc123 on Sat, 04 June 2005	1	2173	Sun, 05 June 2005 02:24 By: nabeelkhan
Index Partition rebuild Query By: bhagwan on Fri, 03 June 2005	1	27158	Fri, 03 June 2005 08:16 By: carsten.jorgensen
The same sql runs very slowly in jboss-cmp,very quickly in native jdbc. By: peixubin on Wed, 01 June 2005	1	1112	Thu, 02 June 2005 21:01 By: peixubin
Oracle Server Information By: well_rbs on Tue, 31 May 2005	1	1030	Tue, 31 May 2005 09:07 By: smartin
What are the steps to tune a query By: d.dineshkumar on Mon, 30 May 2005	3	4762	Mon, 30 May 2005 09:08 By: d.dineshkumar
Datawarehouse query By: well_rbs on Thu, 26 May 2005	3	831	Thu, 26 May 2005 20:41 By: well_rbs
All "Rows" equal 0 in TKPROF. Is this a setting? By: scottwmackey on Wed, 25 May 2005	6	1864	Thu, 26 May 2005 14:27 By: scottwmackey
Batch Tuning By: kanth33 on Mon, 23 May 2005	3	1840	Mon, 23 May 2005 15:49 By: Mahesh Rajendran
Performance problem!! By: kinjal on Mon, 23 May 2005	2	1148	Mon, 23 May 2005 09:44 By: Mahesh Rajendran
activating Online Index Build By: mbexel on Wed, 18 May 2005	3	4453	Fri, 20 May 2005 08:58 By: smartin
Statspack for 9i on 8.1.6 By: _simma_dba on Fri, 13 May 2005	1	1264	Fri, 20 May 2005 06:07 By: Frank Naude
Ploblem connect oracle by Vb application By: chara on Tue, 17 May 2005	3	3421	Wed, 18 May 2005 10:44 By: girish.rohini
Prameters For Improving DB Perfomance By: ksst on Fri, 13 May 2005	3	989	Fri, 13 May 2005 22:33 By: smartin
statspack top 5 wait event By: confident on Thu, 12 May 2005	2	1655	Fri, 13 May 2005 07:24 By: Frank
Comparision of Two Execution Plan By: sujit_ocp on Tue, 10 May 2005	4	1030	Wed, 11 May 2005 09:07 By: smartin
ARCHIVELOG GETTING FILLED By: nitin_228 on Mon, 09 May 2005	1	862	Tue, 10 May 2005 02:16 By: mihelic