|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
performance issue on oracle 8 By: rc_ora on Tue, 16 October 2007 |
1 |
1767 |
Tue, 16 October 2007 02:12 By: Michel Cadot ![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) |
|
difference between db_buffer_keep and db_keep_cache_size? difference between db_buffer_keep and db_keep_cache_size? |
1 |
3327 |
Mon, 15 October 2007 23:17 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) |
|
Keep buffer &recycle cache size Keep buffer &recycle cache size |
5 |
1725 |
Mon, 15 October 2007 23:10 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) |
|
while taking performance measeure ? |
7 |
3883 |
Mon, 15 October 2007 12:12 By: Michel Cadot ![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) |
|
degradation after restart By: Sergius on Fri, 12 October 2007 |
8 |
2197 |
Mon, 15 October 2007 08:39 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) |
|
search on text column |
3 |
1631 |
Mon, 15 October 2007 06:58 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) |
|
DB link problem DB link problem |
4 |
1796 |
Fri, 12 October 2007 13:44 By: Michel Cadot ![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 in all aspects |
4 |
1892 |
Fri, 12 October 2007 00:05 By: Michel Cadot ![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) |
|
SGA and PGA By: e3339 on Thu, 11 October 2007 |
1 |
1447 |
Fri, 12 October 2007 00:05 By: Michel Cadot ![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) |
|
sample size in user_table |
3 |
1909 |
Thu, 11 October 2007 17:44 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) |
|
View not using index on underlying tables |
3 |
1959 |
Thu, 11 October 2007 13: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) |
|
Large table help inserting into large tables. |
9 |
3821 |
Thu, 11 October 2007 09:01 By: Kevin Meade ![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) |
|
Updaing a 804 million partioned table (for 365 days) from a 67 million table By: Aju on Thu, 11 October 2007 |
1 |
2086 |
Thu, 11 October 2007 04:12 By: Michel Cadot ![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) |
|
ora 01555 By: risy_s on Thu, 11 October 2007 |
3 |
4879 |
Thu, 11 October 2007 02:17 By: Michel Cadot ![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 Read Time By: e3339 on Wed, 10 October 2007 |
1 |
1491 |
Wed, 10 October 2007 14:16 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) |
|
Index creation.... |
4 |
2709 |
Wed, 10 October 2007 09:31 By: mson77 ![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) |
|
Different explain plan Different explain plan |
2 |
2239 |
Wed, 10 October 2007 01:30 By: Michel Cadot ![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) |
|
Rule for optimizing the query (merged) |
4 |
1471 |
Tue, 09 October 2007 23:00 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) |
|
Performance Not Improved with Hint |
4 |
1687 |
Tue, 09 October 2007 22:20 By: mchittib ![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) |
|
Non Standard Block size |
5 |
4947 |
Tue, 09 October 2007 13:00 By: Michel Cadot ![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) |
|
Takes long time on sorting. |
8 |
2860 |
Mon, 08 October 2007 07:07 By: Michel Cadot ![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 statement taking long time By: el33t on Sun, 07 October 2007 |
8 |
10365 |
Mon, 08 October 2007 06:42 By: el33t ![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) |
|
What are the keep tables and indexes in Oracle HRMS, Oracle Financials and Oracle Payroll |
1 |
2015 |
Mon, 08 October 2007 06:34 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) |
|
SQL Query for tuning SQL Query for tuning |
1 |
1785 |
Mon, 08 October 2007 06:32 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 make table scan faster By: legna on Mon, 08 October 2007 |
6 |
1770 |
Mon, 08 October 2007 05:46 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) |
|
Help reading TOAD Explain Plan By: bogey on Wed, 25 October 2006 |
18 |
18077 |
Fri, 05 October 2007 05:32 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) |
|
sql query optimization By: antana on Fri, 05 October 2007 |
1 |
1559 |
Fri, 05 October 2007 04:35 By: Michel Cadot ![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 |
2 |
2156 |
Thu, 04 October 2007 04:54 By: Michel Cadot ![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) |
|
Optimizing Oracle SQL statements - can anyone help? |
2 |
2066 |
Thu, 04 October 2007 04:18 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) |
|
database is going down very frequently |
6 |
2028 |
Thu, 04 October 2007 02:21 By: Michel Cadot ![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 performance tuning By: gsr29 on Wed, 03 October 2007 |
3 |
1767 |
Wed, 03 October 2007 14:34 By: gsr29 ![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) |
|
Outer Join killing Performance |
16 |
31381 |
Wed, 03 October 2007 10:37 By: mson77 ![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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Tuning query (insert using select) |
9 |
3744 |
Tue, 02 October 2007 14:08 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) |
|
open cursors By: dirish on Mon, 01 October 2007 |
15 |
2590 |
Tue, 02 October 2007 03:10 By: Michel Cadot ![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) |
|
Lots of 'Row Lock Waits" on the indexes, but no on the based table By: wqhhust on Mon, 01 October 2007 |
3 |
12634 |
Mon, 01 October 2007 17:28 By: wqhhust ![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) |
|
Rollback per transaction % too high and a lot db file sequential reads |
4 |
2840 |
Mon, 01 October 2007 17:02 By: OracleDisected ![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 |
5 |
1667 |
Mon, 01 October 2007 16:54 By: OracleDisected ![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_locking |
9 |
5111 |
Mon, 01 October 2007 09:46 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) |
|
How to Best Performance Param of Oracle in Windows |
11 |
2356 |
Mon, 01 October 2007 04:19 By: Oyunbold ![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) |
|
What is the number of cost? |
5 |
1690 |
Mon, 01 October 2007 03:34 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |