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

    Replies Views Last message
  UTLBSTAT UTLESTAT
By: Alps on Fri, 22 December 2006
1 2074 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 8493 Mon, 01 January 2007 14:36
By: kumarsz
  Tablespace for table with 1,000,000 rows
By: emilSverige on Sat, 30 December 2006
6 3346 Mon, 01 January 2007 10:37
By: emilSverige
  Tune the Update Process
By: yerics on Thu, 28 December 2006
4 2225 Sat, 30 December 2006 20:21
By: rleishman
  too many views
By: mjschwenger on Wed, 27 December 2006
4 2037 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 5955 Wed, 27 December 2006 20:18
By: kumarsz
  TPC testing
By: it_me24 on Wed, 27 December 2006
4 1846 Wed, 27 December 2006 11:36
By: it_me24
  tkprof fetch count
By: sourajit_seth on Wed, 27 December 2006
3 2504 Wed, 27 December 2006 05:44
By: rleishman
  does it cause any negative impact on performance
By: sreehari on Wed, 27 December 2006
2 1960 Wed, 27 December 2006 04:12
By: Mahesh Rajendran
  about sql tuning
By: SRIVASUWIN on Fri, 22 December 2006
2 2188 Sat, 23 December 2006 10:02
By: michael_bialik
  Table Stats running
By: toshidas2000 on Wed, 20 December 2006
2 2193 Fri, 22 December 2006 11:47
By: michael_bialik
  Oracle Database Slow
By: hemanthkumar.t on Fri, 22 December 2006
1 2023 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 2433 Thu, 21 December 2006 20:18
By: rleishman
  Which One is better... VARCHAR or Number
By: amit_nanote on Wed, 20 December 2006
3 1593 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 5069 Wed, 20 December 2006 06:14
By: Mahesh Rajendran
  Process tuning
By: SSALEMY2K on Sun, 17 December 2006
35 5391 Tue, 19 December 2006 20:43
By: ebrian
  Introduce a good book for oracle performance tuning!
By: wxfjordan on Tue, 19 December 2006
2 1713 Tue, 19 December 2006 20:14
By: rleishman
  Help - Performance Issue - statspack report attached
By: orasaket on Mon, 18 December 2006
4 2946 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 2182 Mon, 18 December 2006 22:27
By: Mohammad Taj
  Performance tuning
By: misha603 on Mon, 18 December 2006
1 1706 Mon, 18 December 2006 13:08
By: michael_bialik
  LATCH FREE - HIGH DURING MID NIGHT
By: cresento on Mon, 18 December 2006
1 1805 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 6783 Mon, 18 December 2006 03:29
By: blazingrock4u
  Cost is high
By: subhajit on Tue, 12 December 2006
4 2275 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 1815 Sun, 17 December 2006 06:14
By: michael_bialik
  Shared Pool Advisory for Shared Pool Size
By: orasaket on Thu, 14 December 2006
3 6292 Sat, 16 December 2006 08:44
By: ebrian
  Trace Oracle Job Session using tkprof
By: orasaket on Thu, 14 December 2006
3 6382 Sat, 16 December 2006 08:35
By: Mahesh Rajendran
  Windows vs Linux
By: dfmflinn on Fri, 15 December 2006
1 1665 Fri, 15 December 2006 21:37
By: rleishman
  Looking for a guru
By: rvgriff on Thu, 14 December 2006
5 5449 Thu, 14 December 2006 15:43
By: BlackSwan
  DBF files
By: srinivas.k2005 on Tue, 05 December 2006
4 2038 Thu, 14 December 2006 05:45
By: kudur_kv
  session cached cursors
By: seema.taunk on Thu, 14 December 2006
2 6013 Thu, 14 December 2006 03:43
By: seema.taunk
  Find - Database growth monthwise
By: orasaket on Sat, 09 December 2006
5 5500 Wed, 13 December 2006 15:41
By: orasaket
  Performance Issue
By: Alps on Tue, 12 December 2006
8 2515 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 9971 Tue, 12 December 2006 03:01
By: Frank Naude
icon5.gif nothing in trace-file
By: AndreyPozhidaev on Fri, 08 December 2006
2 1870 Fri, 08 December 2006 23:27
By: Mohammad Taj
  query tunning
By: baskarb_2006 on Thu, 07 December 2006
2 3217 Thu, 07 December 2006 16:19
By: Admin@Lightsql.Com
  DB tuning
By: ataufique on Tue, 21 November 2006
2 2099 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 5623 Thu, 07 December 2006 00:22
By: girishta
  Alter Table parallel complexity
By: rkl1 on Tue, 05 December 2006
2 6910 Wed, 06 December 2006 09:04
By: rkl1
  more precise timing with TKPROF
By: HibsMax on Tue, 05 December 2006
4 2387 Tue, 05 December 2006 15:48
By: HibsMax
  PGA_AGGREGATE_TARGET & SORT_AREA_SIZE
By: Anand Ramaswamy on Tue, 28 November 2006
2 7853 Tue, 05 December 2006 14:00
By: d0hboy
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 Jun 15 07:53:03 CDT 2024