|
|
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 |
1284 |
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 |
1432 |
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 |
3219 |
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 |
1905 |
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 |
2659 |
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 |
2969 |
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 |
13021 |
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 |
1809 |
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 |
2462 |
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 |
3915 |
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 |
2393 |
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 |
2429 |
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 |
4135 |
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 |
1743 |
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 |
2001 |
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 |
2943 |
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 |
2121 |
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 |
24206 |
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 |
1271 |
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 |
1953 |
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 |
5456 |
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 |
1965 |
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 |
1896 |
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 |
2338 |
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 |
1626 |
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 |
4281 |
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 |
3616 |
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 |
2854 |
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 |
1330 |
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 |
11216 |
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 |
1330 |
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 |
7171 |
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 |
2260 |
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 |
1285 |
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 |
1713 |
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 |
1661 |
Sat, 01 December 2007 13:30 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |