|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
what are the steps to follow to coalesce By: pnvani on Tue, 28 February 2006 |
14 |
3031 |
Wed, 01 March 2006 07:58 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) |
|
Visual Explain By: theo06 on Thu, 23 February 2006 |
2 |
1578 |
Fri, 24 February 2006 05:10 By: suryaevl ![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) |
|
formula for value of INITIAL By: quytc on Wed, 22 February 2006 |
0 |
3283 |
Wed, 22 February 2006 20:40 By: quytc ![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) |
![icon7.gif](/forum/images/message_icons/icon7.gif) |
Attempt to de-mystify DBMS_STATS ( Any Takers ? ) |
3 |
2294 |
Tue, 21 February 2006 07:53 By: smartin ![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) |
|
Unique constraint versus unique index |
3 |
3439 |
Tue, 21 February 2006 04:57 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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Analyze Table |
3 |
2252 |
Tue, 21 February 2006 04: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) |
|
fragmented tables and indexes By: uv_anil on Mon, 20 February 2006 |
1 |
3823 |
Mon, 20 February 2006 10:13 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) |
|
Generate the execution plan for a stored procedure !! By: AlinaC on Sun, 19 February 2006 |
1 |
1479 |
Sun, 19 February 2006 20:14 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) |
|
help with outer join |
3 |
2076 |
Sun, 19 February 2006 17:39 By: mjschwenger ![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 set DB_BLOCK_SIZE??????help meeeeeee...... By: quytc on Thu, 16 February 2006 |
9 |
5742 |
Fri, 17 February 2006 22:52 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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Slow query performance... |
4 |
2078 |
Fri, 17 February 2006 22:37 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) |
|
Commit time format in retention table |
2 |
1845 |
Fri, 17 February 2006 04:54 By: arado196 ![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) |
|
functional index and bind variable problem By: uv_anil on Fri, 17 February 2006 |
1 |
2622 |
Fri, 17 February 2006 01:43 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) |
|
Why Merge Cartesian Join |
5 |
14692 |
Fri, 17 February 2006 01:26 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) |
|
No data in v$sql_plan for SELECT |
0 |
4838 |
Thu, 16 February 2006 10:42 By: piotrgrz ![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) |
|
share server& dedicated server By: lazycat on Wed, 15 February 2006 |
1 |
1436 |
Wed, 15 February 2006 08:17 By: Art Metzer ![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 Query not using Composite Index |
1 |
1371 |
Wed, 15 February 2006 03:54 By: meguesswho ![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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Problem on temporary tablespace |
1 |
2736 |
Tue, 14 February 2006 11:48 By: smartin ![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 hint |
1 |
1959 |
Tue, 14 February 2006 01:13 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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Query Takes Lots Of time to execute. |
3 |
1763 |
Mon, 13 February 2006 20: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) |
|
Delete Rows By: vposina on Sun, 12 February 2006 |
3 |
2048 |
Mon, 13 February 2006 14:44 By: vposina ![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) |
|
In Vs Like |
12 |
4394 |
Mon, 13 February 2006 07:47 By: meguesswho ![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) |
|
plan stability:outlines By: rkl1 on Wed, 08 February 2006 |
1 |
1292 |
Wed, 08 February 2006 16:57 By: chetwyn ![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) |
|
Comparing data from two databases – Exception reports |
1 |
1524 |
Wed, 08 February 2006 11:57 By: rkl1 ![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 Query with aggregate function taking long time to execute |
0 |
4895 |
Wed, 08 February 2006 08:56 By: najnarin ![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) |
|
Hint - First_Row |
9 |
10978 |
Tue, 07 February 2006 08: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) |
|
bad view - slow reports |
2 |
1603 |
Tue, 07 February 2006 08:11 By: smartin ![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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
help plzz, oracle slow response |
0 |
3211 |
Fri, 03 February 2006 14:14 By: virtualmystic ![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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Same query , Same database - Different performances ?? |
4 |
2144 |
Fri, 03 February 2006 02:38 By: aditya_itc ![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) |
|
statistics - to Update or Not |
3 |
3101 |
Sat, 28 January 2006 19:32 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) |
|
Delete Advice By: rkl1 on Wed, 25 January 2006 |
12 |
2946 |
Fri, 27 January 2006 22: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) |
|
finding oracle guidelines for performance and tuning By: ldebro on Tue, 24 January 2006 |
2 |
1420 |
Thu, 26 January 2006 11:51 By: ldebro ![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 Very Slow By: mdamjad on Tue, 24 January 2006 |
6 |
2428 |
Wed, 25 January 2006 12:17 By: smartin ![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 Update Statements By: csatish on Mon, 16 January 2006 |
9 |
7541 |
Wed, 25 January 2006 04:51 By: csatish ![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: multiple table inner join query with partitioning |
3 |
8565 |
Mon, 23 January 2006 11:36 By: SQLAREA ![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 - Help |
5 |
5921 |
Sun, 22 January 2006 06:52 By: SQLAREA ![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) |
|
V$LibraryCache |
1 |
1333 |
Wed, 18 January 2006 03:57 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) |
|
Sorting a trace file using TKPROF By: guyj on Thu, 12 January 2006 |
8 |
2057 |
Mon, 16 January 2006 22:43 By: guyj ![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) |
Getting a list of commonly used views for finding tuning statistics By: ldebro on Thu, 12 January 2006 |
1 |
1449 |
Fri, 13 January 2006 07:32 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) |
|
long scans and short scans By: alanm on Thu, 22 December 2005 |
10 |
3106 |
Tue, 10 January 2006 12:47 By: SQLAREA ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |