|
|
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 |
1865 |
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 |
3432 |
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 |
1853 |
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 |
4005 |
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 |
2338 |
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 |
1727 |
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 |
1904 |
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 |
2008 |
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 |
1557 |
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 |
2017 |
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 |
2075 |
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 |
3963 |
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 |
2184 |
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 |
5001 |
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 |
1603 |
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 |
2817 |
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 |
2353 |
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 |
1574 |
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 |
1799 |
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 |
5075 |
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 |
2988 |
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 |
10488 |
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 |
2116 |
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 |
1886 |
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 |
1881 |
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 |
18248 |
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 |
1662 |
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 |
2269 |
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 |
2195 |
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 |
2163 |
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 |
1878 |
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 |
31558 |
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 |
3883 |
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 |
2758 |
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 |
12779 |
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 |
2932 |
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 |
1785 |
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 |
5239 |
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 |
2495 |
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 |
1795 |
Mon, 01 October 2007 03:34 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |