|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Changing Query Approach |
11 |
2871 |
Thu, 20 December 2007 10:46 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) |
|
SGA sizing 9.2.0.5 |
1 |
1402 |
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 |
1554 |
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 |
3389 |
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 |
2075 |
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 |
2840 |
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 |
3239 |
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 |
13206 |
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 |
1999 |
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 |
2681 |
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 |
4075 |
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 |
2555 |
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 |
1466 |
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 |
2700 |
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 |
4402 |
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 |
1935 |
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 |
2174 |
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 |
3170 |
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 |
2251 |
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 |
24409 |
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 |
1378 |
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 |
2077 |
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 |
5633 |
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 |
2115 |
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 |
2027 |
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 |
2481 |
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 |
1764 |
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 |
4441 |
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 |
3801 |
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 |
2978 |
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 |
1463 |
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 |
9472 |
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 |
11399 |
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 |
1452 |
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 |
7321 |
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 |
2414 |
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 |
3110 |
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 |
2347 |
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 |
1395 |
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 |
1839 |
Sat, 01 December 2007 20:09 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |