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

    Replies Views Last message
  implications of merging 17 tables into 1...
By: orausern on Tue, 26 June 2007
11 3621 Thu, 28 June 2007 23:45
By: flyboy
  poor performance of selecting from view.
By: eggplant on Thu, 28 June 2007
0 7422 Thu, 28 June 2007 15:07
By: eggplant
  Execution Plan
By: eggplant on Thu, 28 June 2007
13 3486 Thu, 28 June 2007 14:52
By: eggplant
  Help- Tuning a Query
By: orasaket on Wed, 27 June 2007
5 2512 Thu, 28 June 2007 05:33
By: orasaket
  Help: Tuning Query
By: orasaket on Wed, 27 June 2007
2 2006 Wed, 27 June 2007 15:30
By: michael_bialik
icon5.gif cache hit ratio
By: pratik25 on Wed, 27 June 2007
4 3349 Wed, 27 June 2007 06:56
By: Michel Cadot
  Long Running SQL - NO entry in Session_LongOps view?
By: mymot on Mon, 25 June 2007
7 3932 Tue, 26 June 2007 13:07
By: gintsp
icon4.gif Fine Tune Insert Statement
By: kumarvk on Wed, 20 June 2007
9 4246 Tue, 26 June 2007 04:45
By: michael_bialik
  spreport - tuning paramters!
By: rons on Tue, 26 June 2007
3 2635 Tue, 26 June 2007 04:41
By: michael_bialik
  SQL tuning -- need help urgent
By: AshaTyagi on Mon, 25 June 2007
3 3153 Tue, 26 June 2007 03:00
By: AshaTyagi
  Finally moving to LMT
By: tobyc on Mon, 25 June 2007
3 2043 Mon, 25 June 2007 15:09
By: tobyc
  shared pool
By: sajut on Mon, 25 June 2007
1 1919 Mon, 25 June 2007 01:39
By: Michel Cadot
icon9.gif 10.1 much slower than 10.2? help!
By: Magic][ on Wed, 20 June 2007
2 2324 Thu, 21 June 2007 01:04
By: Magic][
  Performance of Update Statement
By: chintu25 on Tue, 19 June 2007
10 5266 Wed, 20 June 2007 15:56
By: michael_bialik
  Want to use Alias
By: subho_ORA on Wed, 20 June 2007
1 2084 Wed, 20 June 2007 07:15
By: Brayan
  PLan Cost?-Sql Tuning
By: tkmittal1 on Tue, 19 June 2007
6 3484 Wed, 20 June 2007 01:52
By: Michel Cadot
  Rebuild index online
By: tmathew on Sun, 17 June 2007
7 15428 Mon, 18 June 2007 14:54
By: tmathew
  dbms_advisor
By: adee_saleh on Wed, 13 June 2007
9 7546 Mon, 18 June 2007 12:47
By: adee_saleh
  UPDATE DATE AND TIME OF TABLE
By: meeta on Mon, 18 June 2007
1 1861 Mon, 18 June 2007 06:07
By: Michel Cadot
  Buffer Busy waits, db file scatteredl read, sequential read
By: tkmittal1 on Sat, 16 June 2007
7 2754 Sat, 16 June 2007 04:39
By: Michel Cadot
  Improving performance of insert statement
By: rolex.mp on Fri, 15 June 2007
1 1733 Fri, 15 June 2007 05:15
By: Michel Cadot
  query tuning
By: dr46014 on Wed, 13 June 2007
2 2323 Wed, 13 June 2007 15:32
By: michael_bialik
  SQL Tuning
By: Brayan on Mon, 11 June 2007
9 4569 Wed, 13 June 2007 15:29
By: michael_bialik
  quick tuning
By: eb222 on Tue, 15 May 2007
8 6075 Tue, 12 June 2007 01:50
By: amol_umbarkar
  DELETE with Parallel - Parallel is not working
By: mymot on Mon, 28 May 2007
7 43163 Tue, 12 June 2007 00:42
By: amol_umbarkar
  10g and Index Fast Full scans
By: Todd Barry on Fri, 08 June 2007
3 6773 Mon, 11 June 2007 22:53
By: rleishman
  How do you determine db_cache_size
By: mivey4 on Wed, 06 June 2007
3 6695 Mon, 11 June 2007 09:31
By: mivey4
  Oracle 9i Performance and Tuning question
By: sk003 on Thu, 07 June 2007
5 4153 Fri, 08 June 2007 08:27
By: michael_bialik
  2 tables same rowcount different size
By: Duke on Fri, 08 June 2007
8 3427 Fri, 08 June 2007 06:57
By: Brayan
  Pipelining Table Functions
By: artmt on Mon, 04 June 2007
2 2626 Thu, 07 June 2007 16:03
By: artmt
  Normal Forms
By: shahnazurs on Thu, 07 June 2007
2 2179 Thu, 07 June 2007 10:37
By: DreamzZ
  Limiting the resources for specific User
By: Brayan on Mon, 04 June 2007
3 2413 Wed, 06 June 2007 13:32
By: Michel Cadot
  PEFSTAT dropped and recreated
By: LaFilipina on Wed, 06 June 2007
4 3334 Wed, 06 June 2007 10:48
By: Michel Cadot
  Problem in QUICK TUNE advisor
By: tanmoy1048 on Wed, 06 June 2007
0 8339 Wed, 06 June 2007 02:00
By: tanmoy1048
  dbms_stats.gather_schema_stats causes ORA-01555
By: ajay_patil22 on Tue, 05 June 2007
5 11887 Wed, 06 June 2007 00:54
By: Michel Cadot
  Limitation for view
By: vasudevan on Fri, 01 June 2007
7 3177 Mon, 04 June 2007 21:21
By: artmt
  about patch
By: vasudevan on Mon, 04 June 2007
5 2946 Mon, 04 June 2007 12:01
By: Michel Cadot
  Please guide how to tune the given query (merged)
By: mr_dba01 on Mon, 04 June 2007
6 4630 Mon, 04 June 2007 09:40
By: BlackSwan
  WORK_AREA_SIZE_POLICY = manual
By: balaji1010 on Sat, 12 May 2007
2 4271 Mon, 04 June 2007 06:23
By: parthokonar
  Performance issues with dbms_job
By: amit_nanote on Fri, 01 June 2007
1 2502 Fri, 01 June 2007 03:29
By: Michel Cadot
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: Wed Oct 01 05:55:52 CDT 2025