|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Optimizing the query 10.2.0.3.0 |
7 |
2253 |
Tue, 24 March 2009 07:31 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) |
|
optimisation of queries oracle 10g |
3 |
2119 |
Tue, 24 March 2009 06:25 By: cookiemonster ![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) |
|
rownum slowing query 11g By: psk1 on Wed, 18 March 2009 |
14 |
11790 |
Mon, 23 March 2009 05:50 By: Alessandro Rossi ![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 problem (merged 4) |
4 |
1868 |
Sun, 22 March 2009 09:48 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) |
|
No difference in plan and cost for IN and EXISTS Oracle 10.2.0.1.0 |
6 |
3019 |
Sat, 21 March 2009 01:19 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) |
|
Slowness Problem when logging in by tool Oracle sql developer Oracle 10g 10.2.0.3.0 on linux 64 bit By: MIFI on Fri, 13 February 2009 |
1 |
3065 |
Thu, 19 March 2009 19:53 By: oraxperts ![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) |
|
show parameter session (merged) By: dirish on Wed, 11 March 2009 |
7 |
5421 |
Thu, 19 March 2009 19:50 By: oraxperts ![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) |
|
which index is faster oracle 10g |
7 |
2593 |
Thu, 19 March 2009 05:29 By: jayanta.senapati ![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) |
|
Is there any way to rebuilds indexes online in Oracle SE !! Oracle 11g By: AlinaC on Wed, 18 March 2009 |
1 |
1453 |
Wed, 18 March 2009 18:43 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) |
|
Query perfomance Oracle 10 g |
5 |
1970 |
Wed, 18 March 2009 11:15 By: Mahesh Rajendran ![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 release the un-used INDEX space, which were created by DELETE Oracle9i Release 9.2.0.4.0 |
8 |
2798 |
Sat, 14 March 2009 19:36 By: Mahesh Rajendran ![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) |
|
TNS-12518: TNS:listener could not hand off client connection inbound connection timed out (ORA-3136) |
2 |
4952 |
Sat, 14 March 2009 09:20 By: alexzeng ![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) |
|
Issue of Space as Data is growing Rapidly. racle 9.2.0.4.0 Database |
3 |
1821 |
Thu, 12 March 2009 04:41 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) |
|
BITMAP CONVERSION FROM/TO ROWIDS 10g Enterprise Edition Release 10.2.0.1.0 |
2 |
4562 |
Wed, 11 March 2009 21:05 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) |
|
Effective SQL Oracle 10G By: stvel on Tue, 10 March 2009 |
1 |
1642 |
Tue, 10 March 2009 07:40 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) |
|
Oracle Performance Tuning of a view Oracle version 9.2.0.1.0 |
4 |
3446 |
Sat, 07 March 2009 09:31 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) |
|
Changes to the query Oracle 10.2.0.1.0 |
3 |
2042 |
Sat, 07 March 2009 09:03 By: alexzeng ![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) |
|
PLSQL Query Tuning Suggestion/Feedback needed Oracle 10G |
4 |
3295 |
Sat, 07 March 2009 08:59 By: alexzeng ![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) |
|
IOT secondary indexes SLOW performance 9i, hp-ux By: sky_lt on Tue, 17 February 2009 |
23 |
7081 |
Fri, 06 March 2009 05:19 By: sky_lt ![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) |
|
Hash Joins and Memory Requirements |
11 |
4069 |
Fri, 06 March 2009 01:40 By: alexzeng ![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) |
|
updation of 200millions rows Oracle, 10.2.0.3, AIX 5.3 ML9 |
17 |
3569 |
Wed, 04 March 2009 08:45 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) |
|
Difference between cost and %CPU? Oracle 10g |
12 |
3293 |
Tue, 03 March 2009 15:33 By: Mahesh Rajendran ![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) |
|
Indexes (merged 3) |
8 |
2036 |
Tue, 03 March 2009 11:51 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) |
|
Package Tuning using Bulk Excpetion oracle10g |
2 |
1879 |
Tue, 03 March 2009 06:45 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) |
|
Package Tuning (merged 4) By: sr_orcl on Wed, 25 February 2009 |
9 |
3467 |
Mon, 02 March 2009 08:50 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 9i sga advisory view By: jrmtl on Sun, 01 March 2009 |
5 |
4204 |
Mon, 02 March 2009 08:02 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) |
|
Understanding Explain Plan 10g |
6 |
6018 |
Mon, 02 March 2009 03:07 By: oyaryn ![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) |
|
Tuning analytical function query oracle 10g |
12 |
4527 |
Fri, 27 February 2009 06:28 By: ajitpal.s ![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) |
![icon7.gif](/forum/images/message_icons/icon7.gif) |
better way to write or tune a query with joins |
3 |
2187 |
Thu, 26 February 2009 14: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) |
|
unable to reduce the cost of the query Oracle 10G /Linux |
4 |
1935 |
Thu, 26 February 2009 07:26 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) |
![icon1.gif](/forum/images/message_icons/icon1.gif) |
Subpartitions number Oracle 10.2G By: wakula on Tue, 13 January 2009 |
15 |
9172 |
Thu, 26 February 2009 04:13 By: wakula ![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) |
|
cardinality in bitmap index Oracle 9.2.0.6.0 |
3 |
3850 |
Thu, 26 February 2009 03:18 By: saurabhshukla ![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) |
Joining Oracle Text results with multiple tables / Performance Problems Oracle 9i, Win Server 2003 By: ltnuke on Thu, 27 March 2008 |
9 |
12015 |
Wed, 25 February 2009 22:55 By: Barbara Boehmer ![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) |
|
blevel in bitmap index Oracle 9.2.0.5.0, AIX 5.3.0.0 |
1 |
2367 |
Wed, 25 February 2009 03:44 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) |
|
Modifying a plan Oracle 10g By: Olivia on Tue, 24 February 2009 |
3 |
1881 |
Tue, 24 February 2009 04:14 By: Olivia ![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 tuning (merged) By: cherry on Sat, 21 February 2009 |
5 |
3399 |
Mon, 23 February 2009 22:42 By: cherry ![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) |
|
Inconsistent performance in database Oracle 10g |
6 |
4655 |
Mon, 23 February 2009 22:25 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) |
|
tuning Oracle10g By: sr_orcl on Sun, 22 February 2009 |
1 |
1412 |
Sun, 22 February 2009 22:33 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 usage |
2 |
1794 |
Fri, 20 February 2009 21:19 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) |
|
Execution Plan (merged) By: Brayan on Tue, 17 February 2009 |
22 |
5428 |
Fri, 20 February 2009 21:13 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |