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

    Replies Views Last message
  Optimizer=Choose Error
By: Scott Cowan on Fri, 26 August 2005
0 2947 Fri, 26 August 2005 06:58
By: Scott Cowan
  How test performance of table? and how to calucalate row size min and max of the Table
By: sponguru_dba on Tue, 23 August 2005
2 2163 Thu, 25 August 2005 14:34
By: vjeedigunta
  tune the query
By: ponnilavan on Tue, 23 August 2005
2 2683 Thu, 25 August 2005 14:27
By: vjeedigunta
  Query Performance
By: jilpangs on Wed, 24 August 2005
1 2178 Thu, 25 August 2005 14:25
By: vjeedigunta
  how to figure out checkpoint running slow
By: rkl1 on Mon, 22 August 2005
1 2478 Wed, 24 August 2005 07:43
By: deepa_balu
  Partitioning of tables need sugession
By: ashishodia on Wed, 24 August 2005
1 1813 Wed, 24 August 2005 04:25
By: girish.rohini
  Users and default optimizer_mode
By: Scott Cowan on Tue, 23 August 2005
2 2583 Tue, 23 August 2005 07:57
By: Scott Cowan
  log file sync waits
By: mjschwenger on Wed, 17 August 2005
5 9796 Mon, 22 August 2005 08:37
By: smartin
  precise question: use a histogram here?
By: sebastianR on Mon, 22 August 2005
1 2032 Mon, 22 August 2005 07:46
By: smartin
  How to rewrite a query
By: mjschwenger on Sun, 21 August 2005
4 3944 Sun, 21 August 2005 17:10
By: Barbara Boehmer
  Hints on a poor performing view
By: scottwmackey on Thu, 18 August 2005
7 3379 Fri, 19 August 2005 11:41
By: scottwmackey
  index performing bad
By: sebastianR on Fri, 19 August 2005
6 2607 Fri, 19 August 2005 09:25
By: smartin
  Strange Database Shutdowns
By: rkl1 on Tue, 16 August 2005
1 2166 Fri, 19 August 2005 02:24
By: kugenuma
  Drill to Evaluate
By: rkl1 on Thu, 18 August 2005
1 2227 Fri, 19 August 2005 02:20
By: kugenuma
  tuning with statpack
By: mjschwenger on Thu, 18 August 2005
1 2279 Fri, 19 August 2005 01:59
By: kugenuma
  Selecivity on like in a query
By: stsy on Thu, 18 August 2005
0 2721 Thu, 18 August 2005 07:18
By: stsy
  How to make this query fast?
By: oracle_user_2005 on Wed, 10 August 2005
10 3516 Wed, 17 August 2005 15:36
By: oracle_user_2005
  slow server
By: mjschwenger on Wed, 17 August 2005
1 3804 Wed, 17 August 2005 11:34
By: mjschwenger
  Move Production database to test environment for load tests
By: HansHaeberle on Wed, 17 August 2005
2 2892 Wed, 17 August 2005 08:21
By: HansHaeberle
  Foreign Keys vs. custom scripts
By: andogs on Tue, 16 August 2005
2 2251 Wed, 17 August 2005 05:19
By: Maaher
  Urgent reply needed
By: RB on Mon, 15 August 2005
4 2440 Mon, 15 August 2005 14:53
By: RB
  Solaris V880 W/32 G ram Oracle 10.1.2 - parameters?
By: nmacdannald on Mon, 15 August 2005
1 2481 Mon, 15 August 2005 14:26
By: smartin
icon9.gif Oracle 8.1.6 Solaris 7 - redo log group switch
By: nmacdannald on Tue, 09 August 2005
5 3782 Mon, 15 August 2005 13:39
By: nmacdannald
  Row chaining and Local Tablespace
By: rkl1 on Wed, 10 August 2005
6 3262 Mon, 15 August 2005 10:21
By: smartin
  Performance problem
By: Manav on Thu, 11 August 2005
6 2561 Sun, 14 August 2005 12:20
By: Barbara Boehmer
  open connection memory overhead
By: mjschwenger on Wed, 10 August 2005
2 2261 Sat, 13 August 2005 10:01
By: skempins
  B*-tree or bitmap index?
By: quetzalcoatl on Thu, 11 August 2005
1 1963 Thu, 11 August 2005 19:07
By: Mahesh Rajendran
  How to make this query run faster using PL/SQL update and insert
By: Rathor on Thu, 11 August 2005
1 2570 Thu, 11 August 2005 13:58
By: Mahesh Rajendran
icon2.gif how to get full version of sql statement
By: rgopani on Thu, 11 August 2005
1 2164 Thu, 11 August 2005 06:52
By: Mahesh Rajendran
  Full Table Scan
By: puneetsachar on Wed, 10 August 2005
3 2242 Thu, 11 August 2005 03:35
By: puneetsachar
  All sorting etc done on temp space
By: djcot on Tue, 09 August 2005
2 2443 Wed, 10 August 2005 16:46
By: djcot
icon9.gif I don't get Rows & Row Source Operation
By: perfnewbee on Wed, 10 August 2005
3 4788 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 2073 Wed, 10 August 2005 14:31
By: Art Metzer
  Index & Performance Tuning
By: csharpdev on Tue, 09 August 2005
2 2300 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 3028 Wed, 10 August 2005 08:45
By: Mahesh Rajendran
  How manage over 8GB memory
By: enkhbold on Mon, 25 July 2005
3 2638 Tue, 09 August 2005 15:53
By: nmacdannald
  who reads the redo logs
By: mjschwenger on Wed, 03 August 2005
5 3012 Tue, 09 August 2005 15:50
By: nmacdannald
icon10.gif SQL Analyze
By: quetzalcoatl on Tue, 09 August 2005
0 3151 Tue, 09 August 2005 13:36
By: quetzalcoatl
icon7.gif indexes sql tunning
By: quetzalcoatl on Mon, 08 August 2005
1 2927 Mon, 08 August 2005 20:46
By: Mahesh Rajendran
  how to split the query using rowid
By: confident on Thu, 28 July 2005
1 2484 Mon, 08 August 2005 13:12
By: nmacdannald
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 Jul 09 23:29:49 CDT 2025