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

    Replies Views Last message
  View doesn't use Index
By: vettorel on Mon, 30 July 2007
1 1502 Mon, 30 July 2007 11:22
By: Michel Cadot
  Need help - Tuning the SQL
By: ritesh15j on Mon, 30 July 2007
2 1611 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 7337 Mon, 30 July 2007 03:50
By: anamika_025
  Help : Histograms Size
By: orasaket on Sun, 29 July 2007
1 1354 Sun, 29 July 2007 11:13
By: Michel Cadot
  Database hanged
By: kamragulshan on Wed, 25 July 2007
0 7402 Wed, 25 July 2007 04:51
By: kamragulshan
  SGA
By: dirish on Wed, 25 July 2007
1 1789 Wed, 25 July 2007 03:35
By: Michel Cadot
  ARCH wait on SENDREQ
By: ursg02 on Wed, 25 July 2007
1 15744 Wed, 25 July 2007 03:19
By: Michel Cadot
icon7.gif index not used
By: pradns on Tue, 24 July 2007
6 2482 Tue, 24 July 2007 06:34
By: pradns
  Real Application Testing --> Database Replay
By: gkodakalla on Thu, 19 July 2007
1 1183 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 1286 Wed, 18 July 2007 13:12
By: DreamzZ
  Time Differnce in Execution with / without Hint
By: faiz_hyd on Mon, 16 July 2007
6 3445 Tue, 17 July 2007 23:16
By: rleishman
  how to speedup mentioned SQL query
By: rajat_chaudhary on Tue, 17 July 2007
22 2997 Tue, 17 July 2007 15:07
By: Michel Cadot
  slow update on large table
By: subusona on Thu, 12 July 2007
8 6692 Sat, 14 July 2007 03:07
By: michael_bialik
icon5.gif optimatize query??
By: steve_kc on Tue, 10 July 2007
2 2534 Fri, 13 July 2007 00:33
By: orafan23
  statspack table fetch continued row
By: alanm on Thu, 12 July 2007
16 4027 Thu, 12 July 2007 20:42
By: BlackSwan
  Buffer Pool
By: poratips on Thu, 21 June 2007
4 4057 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 2351 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 6153 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 3286 Wed, 11 July 2007 06:03
By: Michel Cadot
  Performance tuning
By: ammishra on Wed, 04 July 2007
12 3196 Tue, 10 July 2007 09:10
By: ammishra
  detecting environment issues
By: yog_23 on Mon, 09 July 2007
2 1343 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 1777 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 2094 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 1367 Mon, 09 July 2007 01:05
By: kmkan28
  Help : Understanding the Explain Plan
By: orasaket on Fri, 06 July 2007
5 4853 Sun, 08 July 2007 12:04
By: orasaket
  99% Hit-Ratio but poor performance
By: naveenkumar001 on Thu, 05 July 2007
3 1380 Sat, 07 July 2007 05:04
By: gintsp
  New Server but performance still the same
By: alpaje on Tue, 03 July 2007
2 1341 Wed, 04 July 2007 11:58
By: michael_bialik
  Perfomance problem due to Distinct clause
By: ShivrajGutte on Wed, 04 July 2007
1 1330 Wed, 04 July 2007 07:10
By: Michel Cadot
  SQL query needs tuning
By: kpremsagar on Sun, 01 July 2007
9 12022 Wed, 04 July 2007 02:23
By: kpremsagar
icon5.gif Performance Problem
By: barakula on Tue, 03 July 2007
6 1653 Tue, 03 July 2007 12:39
By: flyboy
  How can i tune such a simple sql
By: member1975 on Tue, 03 July 2007
3 1377 Tue, 03 July 2007 10:45
By: DreamzZ
  gather_statistics
By: adee_saleh on Sun, 01 July 2007
7 6095 Tue, 03 July 2007 10:06
By: DreamzZ
  Questions about Executing Explain Plan against a query.
By: Rustican on Tue, 03 July 2007
1 1374 Tue, 03 July 2007 09:22
By: Michel Cadot
  pga_aggregate_target - Issue
By: Brayan on Tue, 03 July 2007
4 2223 Tue, 03 July 2007 07:48
By: Brayan
  Avoid Index to be used by Queries
By: feroze on Mon, 02 July 2007
3 1385 Mon, 02 July 2007 15:42
By: Michel Cadot
  Performance issue in report
By: jamalfarooq on Fri, 29 June 2007
3 1512 Fri, 29 June 2007 15:41
By: BlackSwan
  implications of merging 17 tables into 1...
By: orausern on Tue, 26 June 2007
11 2157 Thu, 28 June 2007 23:45
By: flyboy
  poor performance of selecting from view.
By: eggplant on Thu, 28 June 2007
0 6992 Thu, 28 June 2007 15:07
By: eggplant
  Execution Plan
By: eggplant on Thu, 28 June 2007
13 2554 Thu, 28 June 2007 14:52
By: eggplant
  Help- Tuning a Query
By: orasaket on Wed, 27 June 2007
5 1764 Thu, 28 June 2007 05:33
By: orasaket
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 May 16 07:38:24 CDT 2024