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

    Replies Views Last message
  How to find out the bad sql statemets ?
By: kesevan on Sat, 28 April 2007
7 5094 Wed, 01 August 2007 10:55
By: Michel Cadot
  View doesn't use Index
By: vettorel on Mon, 30 July 2007
1 1685 Mon, 30 July 2007 11:22
By: Michel Cadot
  Need help - Tuning the SQL
By: ritesh15j on Mon, 30 July 2007
2 1795 Mon, 30 July 2007 10:54
By: Michel Cadot
  how to increase a performance of a table in oracle 10g (merged) ( 1 2)
By: anamika_025 on Wed, 25 July 2007
53 7699 Mon, 30 July 2007 03:50
By: anamika_025
  Help : Histograms Size
By: orasaket on Sun, 29 July 2007
1 1538 Sun, 29 July 2007 11:13
By: Michel Cadot
  Database hanged
By: kamragulshan on Wed, 25 July 2007
0 7585 Wed, 25 July 2007 04:51
By: kamragulshan
  SGA
By: dirish on Wed, 25 July 2007
1 1973 Wed, 25 July 2007 03:35
By: Michel Cadot
  ARCH wait on SENDREQ
By: ursg02 on Wed, 25 July 2007
1 15945 Wed, 25 July 2007 03:19
By: Michel Cadot
icon7.gif index not used
By: pradns on Tue, 24 July 2007
6 2671 Tue, 24 July 2007 06:34
By: pradns
  Real Application Testing --> Database Replay
By: gkodakalla on Thu, 19 July 2007
1 1356 Thu, 19 July 2007 08:04
By: Michel Cadot
  Deletion on an partition table is very slow
By: balaji1010 on Wed, 18 July 2007
2 1464 Wed, 18 July 2007 13:12
By: DreamzZ
  Time Differnce in Execution with / without Hint
By: faiz_hyd on Mon, 16 July 2007
6 3701 Tue, 17 July 2007 23:16
By: rleishman
  how to speedup mentioned SQL query
By: rajat_chaudhary on Tue, 17 July 2007
22 3327 Tue, 17 July 2007 15:07
By: Michel Cadot
  slow update on large table
By: subusona on Thu, 12 July 2007
8 7029 Sat, 14 July 2007 03:07
By: michael_bialik
icon5.gif optimatize query??
By: steve_kc on Tue, 10 July 2007
2 2721 Fri, 13 July 2007 00:33
By: orafan23
  statspack table fetch continued row
By: alanm on Thu, 12 July 2007
16 4270 Thu, 12 July 2007 20:42
By: BlackSwan
  Buffer Pool
By: poratips on Thu, 21 June 2007
4 4277 Thu, 12 July 2007 10:29
By: poratips
  ORA-1652: unable to extend temp segment by 16 in TEMP TS
By: poratips on Fri, 08 June 2007
3 2538 Thu, 12 July 2007 10:28
By: poratips
icon5.gif execution plan for a stored procedure
By: steve_kc on Thu, 12 July 2007
2 6339 Thu, 12 July 2007 04:46
By: ebrian
icon5.gif How Oracle using SAMPLE Clause on statistics?
By: aprodovikov on Wed, 11 July 2007
3 3504 Wed, 11 July 2007 06:03
By: Michel Cadot
  Performance tuning
By: ammishra on Wed, 04 July 2007
12 3454 Tue, 10 July 2007 09:10
By: ammishra
  detecting environment issues
By: yog_23 on Mon, 09 July 2007
2 1537 Tue, 10 July 2007 00:33
By: BlackSwan
  Index created is not using(I dont want to use hints)
By: donind on Mon, 09 July 2007
4 2003 Mon, 09 July 2007 14:53
By: michael_bialik
  Partitioned table takes longer to load than ordinary table
By: kpremsagar on Wed, 04 July 2007
3 2291 Mon, 09 July 2007 03:02
By: rleishman
  How to use optimizer hint in a recursivly called procedure
By: kmkan28 on Fri, 06 July 2007
2 1565 Mon, 09 July 2007 01:05
By: kmkan28
  Help : Understanding the Explain Plan
By: orasaket on Fri, 06 July 2007
5 5054 Sun, 08 July 2007 12:04
By: orasaket
  99% Hit-Ratio but poor performance
By: naveenkumar001 on Thu, 05 July 2007
3 1561 Sat, 07 July 2007 05:04
By: gintsp
  New Server but performance still the same
By: alpaje on Tue, 03 July 2007
2 1515 Wed, 04 July 2007 11:58
By: michael_bialik
  Perfomance problem due to Distinct clause
By: ShivrajGutte on Wed, 04 July 2007
1 1504 Wed, 04 July 2007 07:10
By: Michel Cadot
  SQL query needs tuning
By: kpremsagar on Sun, 01 July 2007
9 12310 Wed, 04 July 2007 02:23
By: kpremsagar
icon5.gif Performance Problem
By: barakula on Tue, 03 July 2007
6 1877 Tue, 03 July 2007 12:39
By: flyboy
  How can i tune such a simple sql
By: member1975 on Tue, 03 July 2007
3 1568 Tue, 03 July 2007 10:45
By: DreamzZ
  gather_statistics
By: adee_saleh on Sun, 01 July 2007
7 6323 Tue, 03 July 2007 10:06
By: DreamzZ
  Questions about Executing Explain Plan against a query.
By: Rustican on Tue, 03 July 2007
1 1544 Tue, 03 July 2007 09:22
By: Michel Cadot
  pga_aggregate_target - Issue
By: Brayan on Tue, 03 July 2007
4 2423 Tue, 03 July 2007 07:48
By: Brayan
  Avoid Index to be used by Queries
By: feroze on Mon, 02 July 2007
3 1586 Mon, 02 July 2007 15:42
By: Michel Cadot
  Performance issue in report
By: jamalfarooq on Fri, 29 June 2007
3 1712 Fri, 29 June 2007 15:41
By: BlackSwan
  implications of merging 17 tables into 1...
By: orausern on Tue, 26 June 2007
11 2471 Thu, 28 June 2007 23:45
By: flyboy
  poor performance of selecting from view.
By: eggplant on Thu, 28 June 2007
0 7182 Thu, 28 June 2007 15:07
By: eggplant
  Execution Plan
By: eggplant on Thu, 28 June 2007
13 2860 Thu, 28 June 2007 14:52
By: eggplant
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: Thu Sep 19 13:17:26 CDT 2024