|
|
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 |
1760 |
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 |
3320 |
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 |
1718 |
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 |
3877 |
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 |
2189 |
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 |
1624 |
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 |
1790 |
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 |
1885 |
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 |
1440 |
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 |
1901 |
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 |
1953 |
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 |
3815 |
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 |
2079 |
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 |
4871 |
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 |
1484 |
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 |
2703 |
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 |
2233 |
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 |
1463 |
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 |
1680 |
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 |
4941 |
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 |
2854 |
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 |
10358 |
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 |
2007 |
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 |
1778 |
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 |
1764 |
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 |
18073 |
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 |
1552 |
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 |
2150 |
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 |
2060 |
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 |
2020 |
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 |
1761 |
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 |
31378 |
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 |
3737 |
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 |
2583 |
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 |
12624 |
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 |
2833 |
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 |
1660 |
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 |
5103 |
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 |
2349 |
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 |
1684 |
Mon, 01 October 2007 03:34 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |