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

    Replies Views Last message
  more precise timing with TKPROF
By: HibsMax on Tue, 05 December 2006
4 2696 Tue, 05 December 2006 15:48
By: HibsMax
  PGA_AGGREGATE_TARGET & SORT_AREA_SIZE
By: Anand Ramaswamy on Tue, 28 November 2006
2 8496 Tue, 05 December 2006 14:00
By: d0hboy
  bit confused about Execution Plan
By: it_me24 on Sun, 03 December 2006
2 2268 Tue, 05 December 2006 10:05
By: it_me24
  Access to the database is very slow.
By: jesuisantony on Fri, 01 September 2006
4 22892 Tue, 05 December 2006 09:32
By: Mohammad Taj
icon9.gif Stored Procedure Performance Slows
By: feizz on Mon, 04 December 2006
4 2414 Mon, 04 December 2006 20:51
By: feizz
  Analyze tables using OEM
By: seema.taunk on Fri, 01 December 2006
2 3603 Sun, 03 December 2006 22:53
By: seema.taunk
  Performance of Lower() function in query
By: rsilvestri on Sun, 26 November 2006
14 3565 Sat, 02 December 2006 13:12
By: michael_bialik
  Timing queries
By: tlahyani on Thu, 30 November 2006
5 2502 Fri, 01 December 2006 22:36
By: tlahyani
  Help Help me plz urgent
By: juliee_jitu on Fri, 01 December 2006
1 1783 Fri, 01 December 2006 09:56
By: michael_bialik
  Would my SQL work to record which indexes are being used
By: aidi-h on Thu, 30 November 2006
0 4821 Thu, 30 November 2006 08:34
By: aidi-h
  Index Rebuild Taking Long
By: nikhilpaneri on Thu, 30 November 2006
1 3694 Thu, 30 November 2006 08:09
By: Mahesh Rajendran
  Automating - Gathering Satistics
By: Brayan on Thu, 30 November 2006
1 2154 Thu, 30 November 2006 06:12
By: Mahesh Rajendran
  SQL vs. PLSQL
By: sebastianR on Mon, 20 November 2006
4 4172 Thu, 30 November 2006 00:47
By: rleishman
  INDEX column combination
By: AbuShreek on Sat, 18 November 2006
8 3919 Wed, 29 November 2006 15:01
By: orasaket
  Hierarchical queries with rownum pseudocolumn in 10g vs. 9i
By: orafaqer on Tue, 28 November 2006
1 11645 Tue, 28 November 2006 20:30
By: rleishman
  TKPROF & Statspack question
By: MajorGlory on Sun, 19 November 2006
5 4693 Tue, 28 November 2006 16:54
By: orasaket
  # VERY URGENT # -Monitoring memory utilization in oracle 9i
By: orafacjublu on Tue, 28 November 2006
1 2597 Tue, 28 November 2006 06:49
By: Mahesh Rajendran
  Using Bind Variables
By: Anand Ramaswamy on Mon, 27 November 2006
4 2308 Mon, 27 November 2006 09:51
By: Anand Ramaswamy
  Query Tuning (Performance)
By: prashanth_gs on Mon, 27 November 2006
1 2269 Mon, 27 November 2006 08:54
By: vshari
  Statspack
By: seema.taunk on Fri, 24 November 2006
3 2111 Sun, 26 November 2006 22:24
By: seema.taunk
  Any Recommendation for Statspack Reprot
By: Brayan on Thu, 23 November 2006
5 2923 Sat, 25 November 2006 03:23
By: Brayan
  "+0 trick undesirable", why?
By: skooman on Thu, 23 November 2006
3 2677 Fri, 24 November 2006 00:32
By: skooman
icon5.gif Bothering "Sudden Death" by unexpected dropping efficient execution plan
By: oranje66 on Thu, 23 November 2006
0 4097 Thu, 23 November 2006 18:44
By: oranje66
  latch waits
By: seema.taunk on Thu, 23 November 2006
2 2230 Thu, 23 November 2006 05:21
By: seema.taunk
  While Analyzing Schema
By: dattatraya on Thu, 23 November 2006
3 1974 Thu, 23 November 2006 01:05
By: dattatraya
  Partitioning Tables
By: M.Shakeel Azeem on Wed, 22 November 2006
1 2400 Wed, 22 November 2006 19:55
By: rleishman
  Difference Between Global Index and Local Index
By: juliee_jitu on Tue, 21 November 2006
1 10753 Tue, 21 November 2006 22:32
By: Mohammad Taj
  Which Partition to Apply? What should be the partition key?
By: blazingrock4u on Tue, 14 November 2006
12 2868 Tue, 21 November 2006 20:00
By: rleishman
  DB tuning
By: ataufique on Tue, 21 November 2006
4 2741 Tue, 21 November 2006 09:02
By: JRowbottom
  GATHER_SCHEMA_STATS - monitoring progress?
By: gwicke on Tue, 21 November 2006
1 8511 Tue, 21 November 2006 09:00
By: JRowbottom
  Difference between two query
By: juliee_jitu on Mon, 20 November 2006
2 1816 Mon, 20 November 2006 22:22
By: moparthy99
  Regarding parse_calls in v$sqlarea
By: reena_ch30 on Thu, 16 November 2006
2 6490 Mon, 20 November 2006 08:05
By: michael_bialik
  Oracle 9i materialized view refresh problems
By: radhakrishnane on Wed, 26 July 2006
11 18008 Sat, 18 November 2006 05:16
By: jacquesh
  oracle reads from buttom to top
By: bagulia_pilla on Fri, 17 November 2006
3 2885 Sat, 18 November 2006 00:32
By: bagulia_pilla
  Query performance
By: Safeeq.S on Thu, 16 November 2006
4 2296 Fri, 17 November 2006 06:26
By: rleishman
  Small Doubt Regarding CBO
By: selvakumar_82 on Fri, 17 November 2006
3 2378 Fri, 17 November 2006 06:18
By: rleishman
  Please Help me for Tune
By: bagulia_pilla on Fri, 17 November 2006
0 3960 Fri, 17 November 2006 00:03
By: bagulia_pilla
  Is this the best performed query?
By: Akshar on Tue, 14 November 2006
8 2819 Thu, 16 November 2006 23:54
By: Akshar
  Chained Fetch Ratio & Parse to Execute Ratio
By: Brayan on Thu, 16 November 2006
1 9480 Thu, 16 November 2006 14:00
By: michael_bialik
  check last statement executed
By: reena_ch30 on Wed, 15 November 2006
5 9192 Thu, 16 November 2006 06:05
By: Mohammad Taj
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: Tue Nov 26 23:54:25 CST 2024