|
|
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 |
1843 |
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 |
3405 |
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 |
1807 |
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 |
3961 |
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 |
2288 |
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 |
1701 |
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 |
1869 |
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 |
1972 |
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 |
1529 |
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 |
1981 |
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 |
2038 |
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 |
3915 |
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 |
2161 |
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 |
4961 |
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 |
1570 |
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 |
2793 |
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 |
2322 |
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 |
1547 |
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 |
1769 |
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 |
5025 |
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 |
2942 |
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 |
10447 |
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 |
2095 |
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 |
1859 |
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 |
1849 |
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 |
18173 |
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 |
1637 |
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 |
2237 |
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 |
2159 |
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 |
2118 |
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 |
1847 |
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 |
31493 |
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 |
3828 |
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 |
2685 |
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 |
12741 |
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 |
2914 |
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 |
1756 |
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 |
5214 |
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 |
2437 |
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 |
1762 |
Mon, 01 October 2007 03:34 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |