|
|
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 |
2540 |
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 |
2040 |
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 |
1868 |
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 |
4082 |
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 |
3291 |
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 |
2217 |
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 |
1584 |
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 |
2495 |
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 |
3157 |
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 |
3701 |
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 |
4779 |
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 |
2440 |
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 |
1954 |
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 |
1896 |
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 |
2060 |
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 |
1861 |
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 |
1926 |
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 |
1652 |
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 |
2522 |
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 |
1808 |
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 |
2553 |
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 |
1875 |
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 |
6986 |
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 |
2458 |
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 |
2070 |
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 |
2168 |
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 |
2226 |
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 |
2639 |
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 |
1880 |
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 |
6176 |
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 |
2546 |
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 |
2667 |
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 |
2218 |
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 |
5553 |
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 |
6765 |
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 |
2779 |
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 |
2120 |
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 |
2319 |
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 |
4273 |
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 |
1646 |
Tue, 02 January 2007 12:54 By: SRIVASUWIN ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |