|
|
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 |
1878 |
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 |
1836 |
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 |
1949 |
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 |
1565 |
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 |
1626 |
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 |
3777 |
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 |
1717 |
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 |
5142 |
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 |
1896 |
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 |
3757 |
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 |
2310 |
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 |
1748 |
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 |
2387 |
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 |
1848 |
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 |
2171 |
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 |
2973 |
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 |
1665 |
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 |
1650 |
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 |
1918 |
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 |
2006 |
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 |
2002 |
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 |
2318 |
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 |
3252 |
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 |
1609 |
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 |
1307 |
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 |
2946 |
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 |
1605 |
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 |
1311 |
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 |
1656 |
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 |
3224 |
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 |
1366 |
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 |
1281 |
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 |
3650 |
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 |
1276 |
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 |
3255 |
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 |
3408 |
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 |
1785 |
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 |
8630 |
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 |
13785 |
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 |
4045 |
Wed, 10 May 2006 05:01 By: rivadarwito ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |