|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
suggestions required to change the query to improve its performance Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production,windows XP |
2 |
2068 |
Thu, 20 December 2007 20:04 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) |
|
Changing Query Approach |
11 |
3422 |
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 |
1553 |
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 |
1639 |
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 |
3809 |
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 |
2260 |
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 |
3014 |
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 |
3684 |
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 |
13755 |
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 |
3024 |
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 |
2924 |
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 |
4269 |
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 |
2710 |
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 |
1573 |
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 |
2927 |
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 |
4631 |
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 |
2357 |
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 |
2268 |
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 |
3426 |
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 |
2376 |
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 |
24711 |
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 |
1592 |
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 |
2397 |
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 |
5930 |
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 |
2342 |
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 |
2374 |
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 |
2630 |
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 |
1913 |
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 |
4740 |
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 |
4228 |
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 |
3187 |
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 |
1806 |
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 |
9627 |
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 |
12087 |
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 |
1619 |
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 |
7489 |
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 |
2708 |
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 |
3366 |
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 |
2459 |
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 |
1489 |
Sun, 02 December 2007 19:59 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |