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

    Replies Views Last message
  Best practice for querying weighted sparse data
By: kfritsche on Fri, 21 April 2006
5 1595 Thu, 27 April 2006 14:38
By: kfritsche
  SQL Tuning
By: gajini on Wed, 26 April 2006
1 882 Wed, 26 April 2006 22:25
By: rleishman
  sizing sort area
By: balavignesh on Wed, 26 April 2006
1 891 Wed, 26 April 2006 17:08
By: Daljit Singh
  dbms_job package
By: raviteja on Wed, 26 April 2006
1 832 Wed, 26 April 2006 14:24
By: Art Metzer
  Check My Query Plz
By: sohailnawaz on Wed, 26 April 2006
2 993 Wed, 26 April 2006 13:26
By: Art Metzer
  Bulk delete
By: murtuja_oracle on Tue, 25 April 2006
2 8134 Tue, 25 April 2006 03:26
By: JSI2001
icon14.gif use HASH instead of index range scan,why the CBO choose the wrong plan?!!
By: wenaini on Thu, 20 April 2006
10 3529 Mon, 24 April 2006 21:55
By: wenaini
  Cost of an update
By: hrshah74 on Mon, 24 April 2006
1 746 Mon, 24 April 2006 21:52
By: rleishman
  Data Gaurd 10g
By: yash_v on Sun, 23 April 2006
1 866 Sun, 23 April 2006 13:03
By: madhusunkara
  Index Order and Question
By: just_a_kid on Thu, 20 April 2006
5 1045 Thu, 20 April 2006 23:51
By: Frank
  URGENT-Query not performing
By: milind_sri on Thu, 13 April 2006
4 1373 Thu, 20 April 2006 12:46
By: Art Metzer
  How can I improve the performance of LOWER (col) LIKE ‘%name%’
By: moeen49 on Wed, 19 April 2006
4 1307 Thu, 20 April 2006 09:28
By: Art Metzer
  Multiple index on Multiple tables
By: kishinevetz on Fri, 14 April 2006
8 1391 Thu, 20 April 2006 00:25
By: rleishman
  Re Update index
By: mghong on Sun, 16 April 2006
4 1228 Tue, 18 April 2006 22:16
By: rleishman
  High Disk Reads and FTS
By: faiz_hyd on Thu, 06 April 2006
4 1566 Tue, 18 April 2006 11:10
By: faiz_hyd
icon7.gif Large SGA
By: yash_v on Fri, 14 April 2006
6 1549 Sun, 16 April 2006 17:31
By: alanm
  sort unique problem
By: hypnotoad on Wed, 12 April 2006
2 888 Fri, 14 April 2006 02:07
By: hypnotoad
  Tool
By: goodsadanand on Fri, 14 April 2006
1 840 Fri, 14 April 2006 01:16
By: Mahesh Rajendran
  Use of Histogram and Statistics for All Index columns or All columns?
By: SMISHRA on Tue, 11 April 2006
5 4221 Thu, 13 April 2006 16:39
By: Mahesh Rajendran
  partitioned table indexes, rebuild
By: tridentadm on Tue, 11 April 2006
1 981 Tue, 11 April 2006 21:43
By: rleishman
  db_block_buffers = 0
By: alanm on Tue, 11 April 2006
2 5286 Tue, 11 April 2006 17:13
By: alanm
  Temporary segment when fetching.
By: croK on Mon, 10 April 2006
2 834 Tue, 11 April 2006 09:57
By: croK
  Oracle 8 rebuild index
By: marco118 on Tue, 11 April 2006
4 1228 Tue, 11 April 2006 07:28
By: marco118
  Monitoring memory used by oracle process
By: Nau on Mon, 10 April 2006
1 1121 Tue, 11 April 2006 05:13
By: madhusunkara
  Performance for Full table scan ( Huge data )
By: rawat_me on Mon, 10 April 2006
5 1546 Tue, 11 April 2006 02:22
By: rleishman
  Partitioning Table
By: faiz_hyd on Sun, 09 April 2006
2 1141 Mon, 10 April 2006 08:48
By: faiz_hyd
icon5.gif Problem ORA-04031 was solved and spfile changed.
By: amit_nanote on Mon, 10 April 2006
2 1929 Mon, 10 April 2006 07:45
By: kmsalih
  error in SPreport output
By: vraman3 on Wed, 05 April 2006
1 2558 Sun, 09 April 2006 23:55
By: vraman3
  List vs Range Partitioning
By: a_developer on Wed, 05 April 2006
7 6377 Sun, 09 April 2006 23:07
By: rleishman
  about PCT in mv_capabilities_table.
By: srikanth.raju on Fri, 07 April 2006
1 1516 Sat, 08 April 2006 19:29
By: rleishman
  Database speed up
By: amkotz on Sat, 08 April 2006
3 837 Sat, 08 April 2006 06:32
By: Mahesh Rajendran
  migrating SYS from DICT to LOCAL
By: tridentadm on Fri, 07 April 2006
3 830 Sat, 08 April 2006 04:18
By: Mahesh Rajendran
  Performance Tuning Tool
By: suryamz on Thu, 06 April 2006
1 1035 Fri, 07 April 2006 03:55
By: madhusunkara
  Is it Oracle 10g slower comparatively Oracle 9i
By: sponguru on Fri, 07 April 2006
1 959 Fri, 07 April 2006 03:50
By: madhusunkara
  slow connection to oracle 8 server with oracle 9 client
By: mustafat on Thu, 30 March 2006
1 1216 Wed, 05 April 2006 07:21
By: mustafat
  "db file scattered read" too high and Query going for full table scan-Why ?
By: tayalarun on Tue, 04 April 2006
4 1688 Tue, 04 April 2006 18:11
By: RaeMarvin
  gather_fixed_objects_stats
By: orant1 on Mon, 03 April 2006
1 3571 Mon, 03 April 2006 06:36
By: Mahesh Rajendran
  Clearing Blocks from Memory
By: scottwmackey on Fri, 31 March 2006
4 1672 Mon, 03 April 2006 04:43
By: madhusunkara
  Query Speed Slow.
By: rvnair123 on Fri, 31 March 2006
3 1385 Mon, 03 April 2006 03:22
By: nmacdannald
  Merge Cartesian Join in Plan and More Reads
By: faiz_hyd on Fri, 31 March 2006
1 1002 Fri, 31 March 2006 22:49
By: rleishman
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: Fri May 27 17:36:49 CDT 2022