|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance tuning commands |
1 |
1898 |
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 |
1856 |
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 |
1968 |
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 |
1588 |
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 |
1641 |
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 |
3795 |
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 |
1732 |
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 |
5158 |
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 |
1915 |
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 |
3781 |
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 |
2326 |
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 |
1765 |
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 |
2404 |
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 |
1871 |
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 |
2192 |
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 |
2991 |
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 |
1680 |
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 |
1667 |
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 |
1943 |
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 |
2026 |
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 |
2019 |
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 |
2338 |
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 |
3272 |
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 |
1626 |
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 |
1335 |
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 |
2964 |
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 |
1624 |
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 |
1333 |
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 |
1674 |
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 |
3244 |
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 |
1385 |
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 |
1305 |
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 |
3673 |
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 |
1294 |
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 |
3277 |
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 |
3424 |
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 |
1810 |
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 |
8655 |
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 |
13807 |
Wed, 10 May 2006 09:56 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) |
|
tunning wizard oracle 9i can not collect schema oracle 7.3.4 |
0 |
4061 |
Wed, 10 May 2006 05:01 By: rivadarwito ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |