|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Execution time differences between Devl and Test Oracle 10g/Windows2000 |
3 |
1660 |
Tue, 26 February 2008 16:56 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) |
|
Index Oracle 10g |
3 |
1458 |
Tue, 26 February 2008 00:53 By: subbu_tce ![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) |
|
Whats the difference between these two queries ? - tunning purspective oracle 9.0.2 |
1 |
1584 |
Mon, 25 February 2008 22:59 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) |
|
Oracle Slows down. |
2 |
5407 |
Mon, 25 February 2008 15:30 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) |
|
Effect of size of composite primary key on IOT performance. |
7 |
4200 |
Mon, 25 February 2008 03:46 By: Michel Cadot ![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) |
|
Tune the SQL Qury windows, oracle 10g |
2 |
1787 |
Sun, 24 February 2008 23: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) |
|
Procedure slow in Oracle 10g Oracle Enterprise 10.2.0.3.0 |
8 |
5468 |
Sat, 23 February 2008 11:16 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) |
|
statspack oracle,8.1.7, unix |
5 |
1834 |
Fri, 22 February 2008 04:30 By: Michel Cadot ![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) |
|
Temp tablespace resizing |
3 |
2259 |
Fri, 22 February 2008 03:55 By: shahnazurs ![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 tuning By: guyj on Tue, 12 February 2008 |
11 |
2743 |
Fri, 22 February 2008 02:51 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) |
|
SQL getting timed out. |
1 |
1769 |
Fri, 22 February 2008 01:22 By: Michel Cadot ![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) |
|
Pivoting or Cross Tab Report Unix, Oracle 10g |
2 |
1790 |
Thu, 21 February 2008 12:14 By: S.Rajaram ![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) |
|
Execution time differences between environments Oracle 10g/Windows2000 |
4 |
1856 |
Thu, 21 February 2008 11:56 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) |
|
Whey sometimes using Exists Function is better By: epall on Wed, 20 February 2008 |
7 |
1792 |
Thu, 21 February 2008 07:01 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) |
|
Optimization for Large-Volume Data Streams Oracle 8i,Windows 2000 |
2 |
1390 |
Thu, 21 February 2008 05:58 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) |
|
I cant understand this behavior |
4 |
1697 |
Thu, 21 February 2008 03:48 By: Michel Cadot ![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) |
|
wrong execution plan |
15 |
3193 |
Wed, 20 February 2008 23:43 By: daniesh.shaikh@gmail.com ![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) |
|
Oracle Tuning |
3 |
1829 |
Wed, 20 February 2008 16:59 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) |
|
Negative Number for Logical Reads on Statspack Report Oracle 9.2.0.7 By: Greeno on Tue, 19 February 2008 |
1 |
3386 |
Tue, 19 February 2008 19:42 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) |
|
After Collecting Statistics database is very very slow Oracle Enterpride Edition, 9.2.0.1.0 , Windows |
1 |
1313 |
Tue, 19 February 2008 06:02 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) |
|
Improving data loading into tables |
11 |
2442 |
Tue, 19 February 2008 03:25 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) |
|
Query to be tuned which uses a table hint /*+ USE_CONCAT */ in Oracle 10g. |
9 |
4119 |
Mon, 18 February 2008 22:42 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) |
|
Query tunning required |
7 |
3725 |
Sun, 17 February 2008 17:34 By: gksenthilkumar ![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 partitioned table import |
11 |
2998 |
Fri, 15 February 2008 16:48 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) |
|
sql tuning unix, 8.1.7 |
6 |
1857 |
Fri, 15 February 2008 13:20 By: daniesh.shaikh@gmail.com ![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) |
|
Procedure is running from more than 3 hrs but do not return the results By: it_me24 on Fri, 15 February 2008 |
3 |
1802 |
Fri, 15 February 2008 07:29 By: Michel Cadot ![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) |
|
A query with one additional condition slows down |
11 |
2142 |
Fri, 15 February 2008 07:29 By: irremediable ![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) |
|
TOAD / Oracle qeps |
21 |
9022 |
Fri, 15 February 2008 02:37 By: jayassun ![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) |
|
need help in tuning this query 8.1.7,Unix |
5 |
2395 |
Thu, 14 February 2008 23:08 By: daniesh.shaikh@gmail.com ![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) |
|
calling a function from remote db 8.1.6.3 |
1 |
1748 |
Thu, 14 February 2008 05:58 By: Michel Cadot ![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) |
|
disk read speed ORACLE9i |
1 |
1327 |
Mon, 11 February 2008 10:47 By: Michel Cadot ![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) |
|
Delaying insert... |
2 |
1498 |
Sun, 10 February 2008 11:41 By: Kevin Meade ![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) |
|
Improvong performance of SQL script By: aviana on Fri, 08 February 2008 |
1 |
1581 |
Fri, 08 February 2008 09:30 By: Michel Cadot ![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) |
|
Tool/method for detecting changed executions plans |
6 |
1833 |
Fri, 08 February 2008 04:18 By: fcastill69 ![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 Entry Oracle,9i,SunOs |
1 |
1258 |
Thu, 07 February 2008 11:28 By: Michel Cadot ![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) |
|
Dictionary_cache = 0 ? By: DrNeko on Mon, 04 February 2008 |
8 |
2086 |
Wed, 06 February 2008 17:01 By: DrNeko ![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) |
|
RBO to CBO migration Oracle 9i |
1 |
1617 |
Wed, 06 February 2008 04:46 By: Michel Cadot ![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) |
|
Deletion records - Performance |
5 |
1942 |
Wed, 06 February 2008 03:12 By: ora_2007 ![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) |
|
DB deadlock issue By: rballal on Fri, 01 February 2008 |
21 |
3894 |
Wed, 06 February 2008 02:13 By: Michel Cadot ![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) |
|
Incremental logic on a complex query |
6 |
2748 |
Tue, 05 February 2008 08:53 By: S.Rajaram ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |