|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
when to use_merge or use_hash for large data sets |
2 |
10841 |
Thu, 15 March 2007 04:57 By: renjunatarajan ![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) |
all about db_block_size |
3 |
2094 |
Wed, 14 March 2007 11:36 By: nmacdannald ![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 instances and performance |
4 |
1868 |
Wed, 14 March 2007 08:35 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) |
|
Multiple sessions in a single instance and performance |
4 |
1932 |
Wed, 14 March 2007 08:31 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) |
|
How to tuning our oracle product server? |
5 |
10263 |
Tue, 13 March 2007 16:15 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) |
|
Poor Performance query By: chara on Thu, 08 March 2007 |
3 |
1836 |
Thu, 08 March 2007 22:25 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) |
|
Execution Plan in Trace File |
5 |
2209 |
Thu, 08 March 2007 22:07 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) |
Reverse Key Index |
2 |
1485 |
Thu, 08 March 2007 14:14 By: sanjay_kant ![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 Concatenation in SQL query effect performance |
4 |
1991 |
Wed, 07 March 2007 14:59 By: kirso491 ![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) |
|
is there any limit for number of connections on a listner port |
9 |
2587 |
Wed, 07 March 2007 13:23 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) |
|
performance of a query |
1 |
1737 |
Wed, 07 March 2007 09:41 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) |
|
Doubt on "SQL Ordered by Parse Calls" |
4 |
9122 |
Wed, 07 March 2007 00:48 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) |
|
Tunned querry By: donind on Tue, 06 March 2007 |
1 |
1673 |
Wed, 07 March 2007 00:41 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 hangs |
5 |
2282 |
Wed, 07 March 2007 00:06 By: flyboy ![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 suggestion on query which performs search on name |
1 |
1785 |
Tue, 06 March 2007 07:59 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) |
|
saving time in query execution |
2 |
1746 |
Tue, 06 March 2007 06:27 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) |
|
Nested loops, Hash join and Sort Merge joins – difference? |
1 |
3071 |
Mon, 05 March 2007 05:39 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) |
|
when use_hash related hint is used? |
1 |
2189 |
Mon, 05 March 2007 05: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) |
|
Tuning of a sql querry By: donind on Thu, 01 March 2007 |
5 |
2685 |
Fri, 02 March 2007 06:10 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) |
|
parallel DML By: rcd70 on Thu, 01 March 2007 |
1 |
3470 |
Thu, 01 March 2007 18:59 By: ebrian ![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) |
|
Row Chaining Issue |
5 |
3681 |
Thu, 01 March 2007 08:34 By: gintsp ![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) |
|
setting db_file_multiblock_read_count By: Brayan on Thu, 01 March 2007 |
4 |
3803 |
Thu, 01 March 2007 07: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) |
|
Dynamic Table List Selection for STATS |
4 |
2263 |
Thu, 01 March 2007 07:40 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) |
|
Alter Session (workareas and area_sizes) By: smartin on Tue, 27 February 2007 |
6 |
7129 |
Thu, 01 March 2007 07:37 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) |
|
Explain plan By: donind on Thu, 01 March 2007 |
1 |
2039 |
Thu, 01 March 2007 02:59 By: Mohammad Taj ![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 with materialized view |
1 |
3314 |
Thu, 01 March 2007 00:05 By: vivekg19 ![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) |
|
Ref :"Understanding Indexes" from Home Page Link |
6 |
4151 |
Wed, 28 February 2007 13:07 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) |
|
How to Purge tables ?? By: deepakc on Wed, 28 February 2007 |
3 |
1764 |
Wed, 28 February 2007 12:38 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) |
|
Reduce the number of Datafiles |
7 |
2219 |
Wed, 28 February 2007 00:44 By: frozenam_24 ![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 measure the Performance improvement By: buck444 on Tue, 27 February 2007 |
4 |
1841 |
Tue, 27 February 2007 07:34 By: Mohammad Taj ![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) |
|
Slow Performance of query |
2 |
4095 |
Mon, 26 February 2007 10:01 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) |
|
performance enhancement By: dr46014 on Sat, 24 February 2007 |
3 |
2036 |
Sun, 25 February 2007 02: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) |
|
DBMS_STATS.GATHER_SCHEMA_STATS - Suggestion By: Brayan on Sat, 24 February 2007 |
2 |
2934 |
Sat, 24 February 2007 09:18 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) |
|
Optimize mode first_rows returns full table By: coleex on Fri, 23 February 2007 |
2 |
1391 |
Fri, 23 February 2007 15:38 By: coleex ![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) |
|
Queries not running - pls help By: sajut on Tue, 30 January 2007 |
9 |
2939 |
Fri, 23 February 2007 12:29 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) |
|
db statistics after db abnormal shutdown |
2 |
1641 |
Thu, 22 February 2007 15:12 By: vinu_raj ![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) |
|
doubt on paritions |
5 |
1905 |
Thu, 22 February 2007 10:29 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) |
|
while block is being read..... |
2 |
1869 |
Thu, 22 February 2007 09:43 By: pramodgarre ![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 10 Longest Running Query By: rkl1 on Tue, 20 February 2007 |
3 |
2197 |
Thu, 22 February 2007 04:23 By: gintsp ![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) |
|
update performance By: rcd70 on Wed, 21 February 2007 |
3 |
3720 |
Thu, 22 February 2007 02:37 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |