|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Query is really taking a long time. Please help By: pzlj6x on Fri, 02 June 2006 |
4 |
2196 |
Wed, 07 June 2006 13:18 By: pzlj6x ![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 commands |
1 |
2028 |
Wed, 07 June 2006 06:31 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) |
|
Issue with index tablespace. |
3 |
1983 |
Wed, 07 June 2006 04:45 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) |
|
Query Tuning ... |
4 |
2148 |
Tue, 06 June 2006 22:49 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) |
|
Advice on shared_pool and block_size on 9i By: rkl1 on Tue, 06 June 2006 |
1 |
1730 |
Tue, 06 June 2006 21:01 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) |
|
Application Turns Slow |
1 |
1796 |
Fri, 02 June 2006 00:58 By: Frank ![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) |
|
Implement Partitioning & Purging of Partitions By: feroze on Wed, 24 May 2006 |
11 |
4030 |
Thu, 01 June 2006 04:31 By: girish.rohini ![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) |
|
Urgent Help Needed:Oracle 10g |
1 |
1868 |
Wed, 31 May 2006 21:18 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) |
|
Problem with Object Dependencies |
9 |
5393 |
Wed, 31 May 2006 01:52 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) |
|
Oracle Parameter Setting |
2 |
2091 |
Wed, 31 May 2006 00:20 By: kumarsz ![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 INDEX on Oracle 10 g.0.2 By: luchot on Tue, 30 May 2006 |
2 |
3944 |
Tue, 30 May 2006 10:05 By: luchot ![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) |
|
HASH partitioning By: Nau on Mon, 29 May 2006 |
1 |
2473 |
Tue, 30 May 2006 03:28 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) |
|
Question about partitioning By: Nau on Mon, 29 May 2006 |
1 |
1922 |
Mon, 29 May 2006 08:13 By: Frank Naude ![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 Tuining(URGENT) |
5 |
2578 |
Thu, 25 May 2006 09:10 By: sethybibeka ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
Update a new column in a Large Table |
2 |
2021 |
Wed, 24 May 2006 03:35 By: Maaher ![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) |
|
Gathering statistics with different size parameter |
2 |
2349 |
Tue, 23 May 2006 23:03 By: kumarsz ![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) |
|
Error Using STATPACK |
3 |
3147 |
Tue, 23 May 2006 05:11 By: oradba16 ![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 SQL scripts that uses partitioned tables |
1 |
1828 |
Tue, 23 May 2006 04: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) |
|
error capturing |
1 |
1797 |
Mon, 22 May 2006 11:11 By: Frank Naude ![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 code block running v.v.v. slow |
3 |
2095 |
Mon, 22 May 2006 08:09 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) |
|
hint : use of an index Ora 10g By: luchot on Fri, 19 May 2006 |
3 |
2167 |
Mon, 22 May 2006 07:34 By: luchot ![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) |
|
buffer busy waits |
1 |
2143 |
Sun, 21 May 2006 14:12 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) |
|
Gathering CBO Stats |
4 |
2475 |
Fri, 19 May 2006 08:34 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) |
![icon2.gif](/forum/images/message_icons/icon2.gif) |
CBO leaves out access path ? |
0 |
3408 |
Thu, 18 May 2006 11:26 By: iliakan ![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) |
|
Can We Reduced the Time |
3 |
1776 |
Thu, 18 May 2006 07:51 By: raji_kb02 ![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 System By: yash_v on Thu, 11 May 2006 |
3 |
1490 |
Thu, 18 May 2006 03:05 By: yash_v ![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) |
|
RAM Tuning By: yash_v on Tue, 16 May 2006 |
3 |
3124 |
Wed, 17 May 2006 10:06 By: yash_v ![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) |
|
Measuring the impact of indexes? |
3 |
1772 |
Wed, 17 May 2006 04:21 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) |
Tuning without the knowledge of what it is |
1 |
1467 |
Tue, 16 May 2006 19:55 By: krystian.zieja ![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 By: rkl1 on Tue, 16 May 2006 |
1 |
1805 |
Tue, 16 May 2006 19:47 By: krystian.zieja ![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 hit from 9i to 10g By: ericdp on Fri, 12 May 2006 |
3 |
3383 |
Fri, 12 May 2006 16:46 By: ericdp ![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) |
|
For Faster Delete statement |
2 |
1519 |
Fri, 12 May 2006 14:05 By: jrich ![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 interpreting a trace |
1 |
1453 |
Fri, 12 May 2006 06:25 By: sanka_yanka ![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 statistics of two queries |
0 |
3788 |
Fri, 12 May 2006 01:04 By: kumarsz ![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 Tuning a Query |
2 |
1422 |
Thu, 11 May 2006 12:39 By: jrich ![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 tunning tips(oracle9i) |
6 |
3422 |
Thu, 11 May 2006 02:40 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 required in Tuning Query |
0 |
3539 |
Thu, 11 May 2006 02:18 By: kumarsz ![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) |
|
low librarycache hit ratio for indexes... |
3 |
1929 |
Wed, 10 May 2006 21:51 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) |
|
Driving Table in Oracle 9i |
13 |
8792 |
Wed, 10 May 2006 11:53 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) |
|
Problem with order by clause |
4 |
13955 |
Wed, 10 May 2006 09:56 By: kumarsz ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |