|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SGA sizing 9.2.0.5 |
1 |
1282 |
Thu, 20 December 2007 10:23 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
shared pool size tunning Oracle9i,Windows2000 By: chara on Thu, 20 December 2007 |
1 |
1431 |
Thu, 20 December 2007 02:30 By: varu123 ![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) |
|
Query taking too much time than usual to execute |
9 |
3215 |
Wed, 19 December 2007 09:11 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 Query Performance |
9 |
1904 |
Wed, 19 December 2007 02:15 By: rdoggart ![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 taking long time to execute oracle 9i |
6 |
2658 |
Tue, 18 December 2007 23:32 By: venkatadeekshi ![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) |
|
Fetching Cursor Performance By: Agus211 on Fri, 14 December 2007 |
14 |
2963 |
Tue, 18 December 2007 15:06 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) |
|
ORA-03127 error? |
3 |
13020 |
Tue, 18 December 2007 05:24 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) |
|
Procedure Performance Oracle 10g By: Mannu on Mon, 17 December 2007 |
6 |
1806 |
Tue, 18 December 2007 00:07 By: Mannu ![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) |
|
Indexing for lookup tables |
6 |
2458 |
Mon, 17 December 2007 20:29 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) |
|
Optimum value for INITIAL_EXTENT oracle 9.2.0.8 |
2 |
3913 |
Mon, 17 December 2007 14:21 By: andrew again ![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 SQL tuning : Is NULL, In vs Exists By: hidnana on Fri, 14 December 2007 |
4 |
2392 |
Mon, 17 December 2007 06:03 By: hidnana ![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) |
|
To improve execution time of query By: donind on Sun, 16 December 2007 |
2 |
1288 |
Mon, 17 December 2007 01:08 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) |
|
Some questions on SQL tuning By: hidnana on Tue, 11 December 2007 |
11 |
2427 |
Sat, 15 December 2007 22:39 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) |
|
STATSPACK |
14 |
4128 |
Sat, 15 December 2007 09:49 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) |
|
Oracle Memory Leakage 9.2.0.5.0, Sun OS 5.9 |
4 |
1741 |
Fri, 14 December 2007 22:53 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) |
|
This query make much recursive call |
3 |
2000 |
Thu, 13 December 2007 21:08 By: trantuananh24hg ![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) |
|
Optimize large SQL query with multiple joins |
8 |
2941 |
Thu, 13 December 2007 01:12 By: trantuananh24hg ![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 more time to open lov forms 6i , oracle -9i |
4 |
2120 |
Wed, 12 December 2007 23:17 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) |
|
DBLink performance issues |
6 |
24194 |
Wed, 12 December 2007 20:04 By: trantuananh24hg ![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) |
|
Need to improve query performance |
1 |
1269 |
Wed, 12 December 2007 14:35 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) |
|
IO Performance Problems |
4 |
1949 |
Tue, 11 December 2007 11:20 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) |
|
How to disable archivelog generation for a patricular session ? oracle 9.2.0.2.0, sunsolaris 5.9 |
5 |
5452 |
Tue, 11 December 2007 07:07 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) |
|
Poorly performing SQL query Oracle 9.2.0.6 on Solaris |
7 |
1963 |
Mon, 10 December 2007 05:47 By: rdoggart ![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) |
|
Use of RBO in 10g By: kingo on Mon, 10 December 2007 |
7 |
1892 |
Mon, 10 December 2007 03:11 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) |
|
Need to tune SQL involving Join Oracle 10g By: hidnana on Wed, 05 December 2007 |
8 |
2335 |
Mon, 10 December 2007 01: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) |
|
A question about SQL * net message in a batch program 9.2.0.8 on Solaris |
5 |
1624 |
Sat, 08 December 2007 09:03 By: michael_bialik ![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) |
|
disadvantages of optimization |
7 |
4280 |
Fri, 07 December 2007 13:36 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) |
|
the query is too slow By: daria on Wed, 05 December 2007 |
19 |
3613 |
Fri, 07 December 2007 00:24 By: daria ![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 with aggregate function not using index By: ndahafa on Thu, 06 December 2007 |
7 |
2850 |
Thu, 06 December 2007 19:45 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) |
![icon8.gif](/forum/images/message_icons/icon8.gif) |
Outer Join is very very slow Oracle, 10g, 10.2.0.2.0 By: klkoona on Wed, 05 December 2007 |
2 |
1326 |
Wed, 05 December 2007 20:52 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) |
|
Can you explain to me? |
0 |
9325 |
Wed, 05 December 2007 20:30 By: trantuananh24hg ![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 in stat pack |
6 |
11210 |
Wed, 05 December 2007 02:18 By: pratik123 ![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) |
|
Faceing Database Performance Related Problem window server 2003 |
2 |
1328 |
Wed, 05 December 2007 00:35 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) |
|
DBMS_STATS Problem By: babuknb on Tue, 04 December 2007 |
4 |
7166 |
Tue, 04 December 2007 07:58 By: babuknb ![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) |
|
Shows difference in EXPLAIN PLAN result for same query. |
9 |
2259 |
Tue, 04 December 2007 03:56 By: spmano1983 ![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 Degrads |
13 |
2941 |
Tue, 04 December 2007 01:31 By: pablolee ![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 |
4 |
2217 |
Sun, 02 December 2007 20:12 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) |
|
Weird client performance problem 10gR2 Standard Edition RAC; 10gR2 Instant Client |
1 |
1282 |
Sun, 02 December 2007 19:59 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 joins |
3 |
1710 |
Sat, 01 December 2007 20:09 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Poor Insert Performance after table truncation was interupted |
3 |
1658 |
Sat, 01 December 2007 13:30 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |