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

    Replies Views Last message
  Adding ORDER BY increases parse time dramatically
By: milovdl on Wed, 24 January 2007
8 2526 Thu, 25 January 2007 14:24
By: rleishman
  Industry standard best practice for Primary keys..should they be meaningful or meaningless?
By: orausern on Tue, 23 January 2007
2 2022 Thu, 25 January 2007 09:55
By: orausern
  users not logged on last 30 days
By: M.Shakeel Azeem on Wed, 24 January 2007
1 1854 Thu, 25 January 2007 00:21
By: Littlefoot
  Append hint, Truncate, Global Temp Table
By: a_developer on Tue, 23 January 2007
2 4060 Wed, 24 January 2007 05:56
By: Mahesh Rajendran
  Partitioning with ONline Redefinition
By: faiz_hyd on Tue, 23 January 2007
2 3278 Tue, 23 January 2007 16:45
By: faiz_hyd
  Does view change table_plan for select stmts. on base table
By: liegler.joerg on Tue, 23 January 2007
2 2206 Tue, 23 January 2007 09:46
By: Mahesh Rajendran
  Tuning in 10g
By: babuknb on Tue, 23 January 2007
1 1566 Tue, 23 January 2007 03:57
By: Littlefoot
  Materialized view refresh methods
By: Ksaravan on Wed, 17 January 2007
3 2477 Mon, 22 January 2007 18:05
By: rleishman
  Veiw synonym performs differently in diferent users
By: omkar@tcs on Fri, 19 January 2007
5 3136 Mon, 22 January 2007 12:45
By: omkar@tcs
  SQL performance tuning
By: rawat_me on Thu, 18 January 2007
13 3691 Sun, 21 January 2007 21:27
By: rleishman
icon5.gif How to see the constraints in the table ?
By: victoryhendry on Sun, 14 January 2007
3 4761 Sun, 21 January 2007 13:02
By: cbruhn2
  Selecting from a big table.
By: a_developer on Thu, 18 January 2007
7 2423 Sat, 20 January 2007 01:46
By: a_developer
  Optimalization problem with static subquery
By: piotr.kozak on Fri, 19 January 2007
1 1940 Fri, 19 January 2007 10:57
By: skooman
  Regarding sort operation
By: reena_ch30 on Thu, 18 January 2007
2 1883 Fri, 19 January 2007 08:51
By: cbruhn2
  The Temporary Tablespace??
By: trantuananh24hg on Fri, 19 January 2007
2 2042 Fri, 19 January 2007 01:32
By: trantuananh24hg
  Performance tuning
By: suresh3k on Thu, 18 January 2007
1 1843 Thu, 18 January 2007 08:31
By: tahpush
  index & tables should be separated?
By: karismapanda on Thu, 18 January 2007
2 1911 Thu, 18 January 2007 04:47
By: karismapanda
icon4.gif Help with general preformance increase...
By: andybyrne55 on Tue, 16 January 2007
2 1636 Tue, 16 January 2007 19:35
By: rleishman
  Performance Issue!!!
By: prashant_pathak on Tue, 16 January 2007
4 2509 Tue, 16 January 2007 13:37
By: prashant_pathak
  Partitioning
By: kedar_ambardekar on Mon, 15 January 2007
1 1797 Mon, 15 January 2007 19:54
By: rleishman
  Tuning an oracle view to increase the speed of the view
By: suranjita_hajra_7 on Fri, 12 January 2007
2 2536 Sat, 13 January 2007 09:22
By: BlackSwan
  Different OPtimizer behaviour on Ora9iR2 ( patch 7 )-Shared server
By: snow-runner on Thu, 11 January 2007
1 1862 Fri, 12 January 2007 10:12
By: michael_bialik
  Insert all vs Forall
By: a_developer on Thu, 11 January 2007
3 6965 Fri, 12 January 2007 06:29
By: a_developer
  Query performing good in 9i but very very slow in 10g
By: srinivas4u2 on Fri, 15 December 2006
7 2442 Fri, 12 January 2007 03:45
By: tahpush
  Log Switches
By: M.Shakeel Azeem on Thu, 11 January 2007
2 2053 Thu, 11 January 2007 06:05
By: michael_bialik
  Query running slow in Forms
By: neo_oracle on Mon, 08 January 2007
3 2145 Tue, 09 January 2007 20:44
By: rleishman
  with out enforcing index i want use how to do this
By: saiyshnav on Wed, 03 January 2007
8 2211 Tue, 09 January 2007 07:22
By: michael_bialik
  Help Tune My query
By: JRowbottom on Fri, 05 January 2007
5 2624 Tue, 09 January 2007 06:47
By: JRowbottom
  Query performance
By: vaddiparthi on Tue, 09 January 2007
1 1860 Tue, 09 January 2007 06:17
By: Mahesh Rajendran
  Cognos tuning
By: alanm on Mon, 08 January 2007
4 6154 Tue, 09 January 2007 03:40
By: alanm
  At specific table size i'm seeing a 10x increase in query time
By: tolas on Fri, 05 January 2007
6 2531 Mon, 08 January 2007 19:46
By: rleishman
  Hints index combine
By: uicmxz on Mon, 08 January 2007
1 2653 Mon, 08 January 2007 17:37
By: Mahesh Rajendran
  Parallel queries.
By: shahnazurs on Wed, 03 January 2007
4 2199 Mon, 08 January 2007 15:19
By: artmt
  MERGE but no PK on the table
By: lotusdeva on Mon, 08 January 2007
0 5517 Mon, 08 January 2007 11:10
By: lotusdeva
  Merge over dblink - too slow..
By: lotusdeva on Fri, 05 January 2007
2 6751 Mon, 08 January 2007 11:08
By: lotusdeva
  Performance Forms 6i - Where clause in block
By: ora_dev on Mon, 08 January 2007
8 2763 Mon, 08 January 2007 08:05
By: ora_dev
  Question about parsing and Bind variables
By: kevin_oracle_2003 on Fri, 05 January 2007
2 2104 Sat, 06 January 2007 05:50
By: michael_bialik
  Database Down
By: Alps on Wed, 06 December 2006
5 2303 Fri, 05 January 2007 08:56
By: Alps
  How to avoid redo log entries for a table
By: amit.pandey on Wed, 03 January 2007
5 4256 Fri, 05 January 2007 04:41
By: Mahesh Rajendran
  tuning
By: SRIVASUWIN on Tue, 02 January 2007
2 1630 Tue, 02 January 2007 12:54
By: SRIVASUWIN
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 08:11:32 CDT 2024