|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Adding ORDER BY increases parse time dramatically By: milovdl on Wed, 24 January 2007 |
8 |
2686 |
Thu, 25 January 2007 14:24 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Industry standard best practice for Primary keys..should they be meaningful or meaningless? |
2 |
2160 |
Thu, 25 January 2007 09:55 By: orausern ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
users not logged on last 30 days |
1 |
1977 |
Thu, 25 January 2007 00:21 By: Littlefoot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Append hint, Truncate, Global Temp Table |
2 |
4207 |
Wed, 24 January 2007 05:56 By: Mahesh Rajendran ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Partitioning with ONline Redefinition |
2 |
3419 |
Tue, 23 January 2007 16:45 By: faiz_hyd ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Does view change table_plan for select stmts. on base table |
2 |
2338 |
Tue, 23 January 2007 09:46 By: Mahesh Rajendran ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Tuning in 10g By: babuknb on Tue, 23 January 2007 |
1 |
1691 |
Tue, 23 January 2007 03:57 By: Littlefoot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Materialized view refresh methods |
3 |
2617 |
Mon, 22 January 2007 18:05 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Veiw synonym performs differently in diferent users |
5 |
3286 |
Mon, 22 January 2007 12:45 By: omkar@tcs ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SQL performance tuning |
13 |
3850 |
Sun, 21 January 2007 21:27 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
How to see the constraints in the table ? |
3 |
4894 |
Sun, 21 January 2007 13:02 By: cbruhn2 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Selecting from a big table. |
7 |
2582 |
Sat, 20 January 2007 01:46 By: a_developer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Optimalization problem with static subquery |
1 |
2048 |
Fri, 19 January 2007 10:57 By: skooman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Regarding sort operation |
2 |
2011 |
Fri, 19 January 2007 08:51 By: cbruhn2 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
The Temporary Tablespace?? |
2 |
2172 |
Fri, 19 January 2007 01:32 By: trantuananh24hg ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance tuning |
1 |
2006 |
Thu, 18 January 2007 08:31 By: tahpush ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
index & tables should be separated? |
2 |
2037 |
Thu, 18 January 2007 04:47 By: karismapanda ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Help with general preformance increase... |
2 |
1764 |
Tue, 16 January 2007 19:35 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance Issue!!! |
4 |
2642 |
Tue, 16 January 2007 13:37 By: prashant_pathak ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Partitioning |
1 |
1905 |
Mon, 15 January 2007 19:54 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Tuning an oracle view to increase the speed of the view |
2 |
2657 |
Sat, 13 January 2007 09:22 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Different OPtimizer behaviour on Ora9iR2 ( patch 7 )-Shared server |
1 |
1999 |
Fri, 12 January 2007 10:12 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Insert all vs Forall |
3 |
7110 |
Fri, 12 January 2007 06:29 By: a_developer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query performing good in 9i but very very slow in 10g |
7 |
2615 |
Fri, 12 January 2007 03:45 By: tahpush ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Log Switches |
2 |
2193 |
Thu, 11 January 2007 06:05 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query running slow in Forms |
3 |
2292 |
Tue, 09 January 2007 20:44 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
with out enforcing index i want use how to do this |
8 |
2387 |
Tue, 09 January 2007 07:22 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Help Tune My query |
5 |
2766 |
Tue, 09 January 2007 06:47 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query performance |
1 |
2002 |
Tue, 09 January 2007 06:17 By: Mahesh Rajendran ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Cognos tuning By: alanm on Mon, 08 January 2007 |
4 |
6340 |
Tue, 09 January 2007 03:40 By: alanm ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
At specific table size i'm seeing a 10x increase in query time By: tolas on Fri, 05 January 2007 |
6 |
2681 |
Mon, 08 January 2007 19:46 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Hints index combine By: uicmxz on Mon, 08 January 2007 |
1 |
2781 |
Mon, 08 January 2007 17:37 By: Mahesh Rajendran ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Parallel queries. |
4 |
2335 |
Mon, 08 January 2007 15:19 By: artmt ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
MERGE but no PK on the table |
0 |
5671 |
Mon, 08 January 2007 11:10 By: lotusdeva ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Merge over dblink - too slow.. |
2 |
6882 |
Mon, 08 January 2007 11:08 By: lotusdeva ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance Forms 6i - Where clause in block By: ora_dev on Mon, 08 January 2007 |
8 |
2909 |
Mon, 08 January 2007 08:05 By: ora_dev ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Question about parsing and Bind variables |
2 |
2215 |
Sat, 06 January 2007 05:50 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Database Down By: Alps on Wed, 06 December 2006 |
5 |
2459 |
Fri, 05 January 2007 08:56 By: Alps ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to avoid redo log entries for a table |
5 |
4398 |
Fri, 05 January 2007 04:41 By: Mahesh Rajendran ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
tuning |
2 |
1758 |
Tue, 02 January 2007 12:54 By: SRIVASUWIN ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |