Home » RDBMS Server » Performance Tuning
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
icon5.gif getting bad Performance during use
By: hartmut.stumpf@stratos.ag on Wed, 15 June 2005
5 2551 Wed, 15 June 2005 15:24
By: smartin
icon5.gif Which parameter?
By: sunil_v_mishra on Mon, 13 June 2005
8 1322 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 688 Tue, 14 June 2005 14:00
By: smartin
  SQL QUERY NOT USING BITMAP INDEX
By: puneetsachar on Mon, 13 June 2005
8 3321 Tue, 14 June 2005 09:30
By: smartin
  Index on varchar2(2500)
By: sandeep55 on Mon, 13 June 2005
7 2257 Tue, 14 June 2005 09:25
By: smartin
  RBO is there in oracle 10g?
By: sunil_v_mishra on Mon, 13 June 2005
5 1489 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 1292 Tue, 14 June 2005 08:39
By: Maaher
  HELP ON STATSPACK
By: sponguru_dba on Mon, 06 June 2005
2 996 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 1116 Mon, 13 June 2005 23:13
By: sunil_v_mishra
  Document security model
By: vpronnikov on Mon, 13 June 2005
3 925 Mon, 13 June 2005 10:03
By: smartin
  Oracle sequence
By: belboey on Sun, 12 June 2005
2 1004 Mon, 13 June 2005 09:36
By: smartin
  When to use index
By: d.dineshkumar on Fri, 03 June 2005
6 1975 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 2535 Sun, 12 June 2005 04:30
By: henning.schroer
  Explain Plan - number of rows returned.
By: Lee Sutton on Wed, 08 June 2005
5 2195 Fri, 10 June 2005 08:08
By: Lee Sutton
  Index Question
By: j_potucek on Tue, 03 May 2005
2 1068 Thu, 09 June 2005 04:15
By: nabeelkhan
  What is happening with this sql?
By: rramanat on Fri, 27 May 2005
15 3982 Wed, 08 June 2005 20:10
By: rramanat
  select large amount of data
By: r2d2dev on Wed, 08 June 2005
1 860 Wed, 08 June 2005 15:47
By: Art Metzer
  forced view
By: ramvenky on Tue, 07 June 2005
4 3515 Wed, 08 June 2005 00:20
By: nabeelkhan
icon9.gif URGENT:-Performance Tuning.
By: milind_sri on Wed, 18 May 2005
8 1982 Tue, 07 June 2005 15:28
By: skempins
  Stubborn Query
By: tansdot on Thu, 02 June 2005
4 1272 Tue, 07 June 2005 06:35
By: nabeelkhan
icon4.gif How to read the execution plan
By: shibu on Wed, 01 June 2005
6 2114 Mon, 06 June 2005 09:06
By: smartin
  Composite bitmap indexes
By: tansdot on Fri, 03 June 2005
2 5817 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 6213 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 2359 Sun, 05 June 2005 07:23
By: nabeelkhan
  Select on same table gives poor performace.
By: abc123 on Sat, 04 June 2005
1 2175 Sun, 05 June 2005 02:24
By: nabeelkhan
  Index Partition rebuild Query
By: bhagwan on Fri, 03 June 2005
1 27163 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 1114 Thu, 02 June 2005 21:01
By: peixubin
  Oracle Server Information
By: well_rbs on Tue, 31 May 2005
1 1033 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 4766 Mon, 30 May 2005 09:08
By: d.dineshkumar
  Datawarehouse query
By: well_rbs on Thu, 26 May 2005
3 834 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 1867 Thu, 26 May 2005 14:27
By: scottwmackey
  Batch Tuning
By: kanth33 on Mon, 23 May 2005
3 1846 Mon, 23 May 2005 15:49
By: Mahesh Rajendran
  Performance problem!!
By: kinjal on Mon, 23 May 2005
2 1153 Mon, 23 May 2005 09:44
By: Mahesh Rajendran
  activating Online Index Build
By: mbexel on Wed, 18 May 2005
3 4456 Fri, 20 May 2005 08:58
By: smartin
  Statspack for 9i on 8.1.6
By: _simma_dba on Fri, 13 May 2005
1 1267 Fri, 20 May 2005 06:07
By: Frank Naude
icon5.gif Ploblem connect oracle by Vb application
By: chara on Tue, 17 May 2005
3 3424 Wed, 18 May 2005 10:44
By: girish.rohini
  Prameters For Improving DB Perfomance
By: ksst on Fri, 13 May 2005
3 993 Fri, 13 May 2005 22:33
By: smartin
  statspack top 5 wait event
By: confident on Thu, 12 May 2005
2 1658 Fri, 13 May 2005 07:24
By: Frank
  Comparision of Two Execution Plan
By: sujit_ocp on Tue, 10 May 2005
4 1036 Wed, 11 May 2005 09:07
By: smartin
  ARCHIVELOG GETTING FILLED
By: nitin_228 on Mon, 09 May 2005
1 865 Tue, 10 May 2005 02:16
By: mihelic
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Wed Jan 27 09:50:17 CST 2021