|
|
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 |
3045 |
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 |
1593 |
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 |
3298 |
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 |
2309 |
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 |
3455 |
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 |
2264 |
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 |
3838 |
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 |
1497 |
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 |
2091 |
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 |
5757 |
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 |
2092 |
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 |
1863 |
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 |
2641 |
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 |
14707 |
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 |
4855 |
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 |
1450 |
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 |
1384 |
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 |
2752 |
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 |
1980 |
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 |
1778 |
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 |
2062 |
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 |
4409 |
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 |
1306 |
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 |
1538 |
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 |
4913 |
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 |
10996 |
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 |
1616 |
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 |
3224 |
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 |
2161 |
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 |
3117 |
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 |
2963 |
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 |
1436 |
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 |
2443 |
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 |
7555 |
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 |
8590 |
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 |
5938 |
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 |
1349 |
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 |
2071 |
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 |
1465 |
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 |
3133 |
Tue, 10 January 2006 12:47 By: SQLAREA ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |