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 avoid redo log entries for a table
By: amit.pandey on Wed, 03 January 2007
5 4918 Fri, 05 January 2007 04:41
By: Mahesh Rajendran
  tuning
By: SRIVASUWIN on Tue, 02 January 2007
2 2121 Tue, 02 January 2007 12:54
By: SRIVASUWIN
  UTLBSTAT UTLESTAT
By: Alps on Fri, 22 December 2006
1 2573 Tue, 02 January 2007 06:31
By: Frank Naude
  Performance issue - Physical Reads / Buffer Gets - Statspack Report
By: kumarsz on Tue, 19 December 2006
12 8845 Mon, 01 January 2007 14:36
By: kumarsz
  Tablespace for table with 1,000,000 rows
By: emilSverige on Sat, 30 December 2006
6 3739 Mon, 01 January 2007 10:37
By: emilSverige
  Tune the Update Process
By: yerics on Thu, 28 December 2006
4 2480 Sat, 30 December 2006 20:21
By: rleishman
  too many views
By: mjschwenger on Wed, 27 December 2006
4 2864 Thu, 28 December 2006 00:35
By: Littlefoot
  how to use dbms_system.set_sql_trace_in_session with 10046 level 12
By: kumarsz on Wed, 27 December 2006
2 6214 Wed, 27 December 2006 20:18
By: kumarsz
  TPC testing
By: it_me24 on Wed, 27 December 2006
4 2087 Wed, 27 December 2006 11:36
By: it_me24
  tkprof fetch count
By: sourajit_seth on Wed, 27 December 2006
3 3463 Wed, 27 December 2006 05:44
By: rleishman
  does it cause any negative impact on performance
By: sreehari on Wed, 27 December 2006
2 2312 Wed, 27 December 2006 04:12
By: Mahesh Rajendran
  about sql tuning
By: SRIVASUWIN on Fri, 22 December 2006
2 2523 Sat, 23 December 2006 10:02
By: michael_bialik
  Table Stats running
By: toshidas2000 on Wed, 20 December 2006
2 2483 Fri, 22 December 2006 11:47
By: michael_bialik
  Oracle Database Slow
By: hemanthkumar.t on Fri, 22 December 2006
1 2471 Fri, 22 December 2006 03:04
By: michael_bialik
  Avoiding FTS, Any better Way to write this
By: faiz_hyd on Wed, 20 December 2006
3 2683 Thu, 21 December 2006 20:18
By: rleishman
  Which One is better... VARCHAR or Number
By: amit_nanote on Wed, 20 December 2006
3 2282 Wed, 20 December 2006 07:09
By: JRowbottom
  High activity of "delete from smon_scn_time" in statspack report
By: Peter Babka on Wed, 20 December 2006
1 5714 Wed, 20 December 2006 06:14
By: Mahesh Rajendran
  Process tuning
By: SSALEMY2K on Sun, 17 December 2006
35 6183 Tue, 19 December 2006 20:43
By: ebrian
  Introduce a good book for oracle performance tuning!
By: wxfjordan on Tue, 19 December 2006
2 2533 Tue, 19 December 2006 20:14
By: rleishman
  Help - Performance Issue - statspack report attached
By: orasaket on Mon, 18 December 2006
4 3221 Tue, 19 December 2006 02:52
By: JRowbottom
  how to handle this wait event: "control file sequential read"?
By: wxfjordan on Mon, 18 December 2006
1 2729 Mon, 18 December 2006 22:27
By: Mohammad Taj
  Performance tuning
By: misha603 on Mon, 18 December 2006
1 2336 Mon, 18 December 2006 13:08
By: michael_bialik
  LATCH FREE - HIGH DURING MID NIGHT
By: cresento on Mon, 18 December 2006
1 2084 Mon, 18 December 2006 12:12
By: dba_blr
  Post fast/complete refresh COMPILE_STATE=NEEDS_COMPILE
By: blazingrock4u on Mon, 18 December 2006
0 7108 Mon, 18 December 2006 03:29
By: blazingrock4u
  Cost is high
By: subhajit on Tue, 12 December 2006
4 3171 Mon, 18 December 2006 00:03
By: subhajit
  how to increase the speed of a MView Refresh
By: krishnahere on Sat, 16 December 2006
1 2278 Sun, 17 December 2006 06:14
By: michael_bialik
  Shared Pool Advisory for Shared Pool Size
By: orasaket on Thu, 14 December 2006
3 6560 Sat, 16 December 2006 08:44
By: ebrian
  Trace Oracle Job Session using tkprof
By: orasaket on Thu, 14 December 2006
3 7247 Sat, 16 December 2006 08:35
By: Mahesh Rajendran
  Windows vs Linux
By: dfmflinn on Fri, 15 December 2006
1 2319 Fri, 15 December 2006 21:37
By: rleishman
  Looking for a guru
By: rvgriff on Thu, 14 December 2006
5 6599 Thu, 14 December 2006 15:43
By: BlackSwan
  DBF files
By: srinivas.k2005 on Tue, 05 December 2006
4 3342 Thu, 14 December 2006 05:45
By: kudur_kv
  session cached cursors
By: seema.taunk on Thu, 14 December 2006
2 6845 Thu, 14 December 2006 03:43
By: seema.taunk
  Find - Database growth monthwise
By: orasaket on Sat, 09 December 2006
5 6080 Wed, 13 December 2006 15:41
By: orasaket
  Performance Issue
By: Alps on Tue, 12 December 2006
8 3004 Tue, 12 December 2006 12:48
By: Mahesh Rajendran
  Timed out trying to start process J002 massage
By: shilpa.rajput on Tue, 12 December 2006
1 10697 Tue, 12 December 2006 03:01
By: Frank Naude
icon5.gif nothing in trace-file
By: AndreyPozhidaev on Fri, 08 December 2006
2 2532 Fri, 08 December 2006 23:27
By: Mohammad Taj
  query tunning
By: baskarb_2006 on Thu, 07 December 2006
2 3740 Thu, 07 December 2006 16:19
By: Admin@Lightsql.Com
  DB tuning
By: ataufique on Tue, 21 November 2006
2 2910 Thu, 07 December 2006 04:59
By: ataufique
  Doubt on Oracle Post-Wait Extension in Semaphore allocation
By: girishta on Thu, 07 December 2006
0 5916 Thu, 07 December 2006 00:22
By: girishta
  Alter Table parallel complexity
By: rkl1 on Tue, 05 December 2006
2 7753 Wed, 06 December 2006 09:04
By: rkl1
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: Sat Nov 23 08:23:33 CST 2024