|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Distinct versus group by |
4 |
3205 |
Fri, 12 September 2008 01:15 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) |
|
Gather statistics Oracle 9i By: Olivia on Thu, 11 September 2008 |
1 |
1267 |
Thu, 11 September 2008 06:56 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Performance impact Kernel Parameters Oracle 9.2.0.8,HP-UX 11.11 ----> Oracle 9.2.0.8, HP-UX 11.23 |
6 |
1965 |
Wed, 10 September 2008 13:56 By: coleing ![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 index in performance tuning oracle 8i |
2 |
1858 |
Wed, 10 September 2008 10:49 By: harrysmall3 ![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 unpin a table from cache |
3 |
3432 |
Wed, 10 September 2008 10:34 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) |
|
A performance test of Oracle Analtyicals vs Group By Oracle 9.2.0.3 / Unix |
6 |
7837 |
Wed, 10 September 2008 10:05 By: harrysmall3 ![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) |
|
Cursor versus select into for simple select Oracle 9,10 By: goo321 on Sun, 07 September 2008 |
4 |
7755 |
Tue, 09 September 2008 10:45 By: goo321 ![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) |
|
Before Asking the Index Question Oracle 9.2.0.3 Unix |
5 |
3190 |
Tue, 09 September 2008 10:40 By: harrysmall3 ![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) |
|
Perfomance tuning of a view Oracle 10g By: anantha on Tue, 09 September 2008 |
3 |
3471 |
Tue, 09 September 2008 09:09 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) |
|
to find out time taken |
13 |
4044 |
Tue, 09 September 2008 03:31 By: tanyaa ![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 of delete stmt Oracle, 9.2.0.8, Unix |
9 |
3977 |
Mon, 08 September 2008 19:36 By: harrysmall3 ![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 Index Oracle 9i |
9 |
2214 |
Mon, 08 September 2008 14:58 By: harrysmall3 ![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) |
|
Why showing BITMAP in Plan while no bitmap exists for the table Oracle9i By: Olivia on Fri, 05 September 2008 |
8 |
2131 |
Mon, 08 September 2008 13:13 By: harrysmall3 ![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) |
|
lobg running query 10.2.0.1 ( 1 2) |
40 |
5012 |
Fri, 05 September 2008 14:48 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) |
|
help in tuning procedure |
7 |
2170 |
Fri, 05 September 2008 03:19 By: trupti111 ![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 determine join order for tuning |
5 |
1991 |
Fri, 05 September 2008 02:16 By: trupti111 ![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) |
|
tunning Oracle 10G By: saagar on Thu, 04 September 2008 |
9 |
2473 |
Thu, 04 September 2008 23:46 By: saagar ![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 to check that statistics gathered Oracle 9i By: Olivia on Thu, 04 September 2008 |
6 |
5298 |
Thu, 04 September 2008 10:20 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) |
|
What does it signifies Oracle9i By: Olivia on Thu, 04 September 2008 |
1 |
1229 |
Thu, 04 September 2008 07:34 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) |
|
Function Based Join Without Nested Loops Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: annagel on Wed, 03 September 2008 |
6 |
2226 |
Thu, 04 September 2008 06:42 By: annagel ![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) |
![icon3.gif](/forum/images/message_icons/icon3.gif) |
Index not being used for Min/Max Oracle 11g |
4 |
2141 |
Thu, 04 September 2008 01:45 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) |
|
Which one is to choose? Oracle9i By: Olivia on Tue, 02 September 2008 |
3 |
1605 |
Thu, 04 September 2008 01:32 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) |
|
alternative for DISTINCT Oracle9i By: Olivia on Tue, 02 September 2008 |
7 |
7894 |
Wed, 03 September 2008 22:25 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) |
|
Not Exists Vs Join 10g |
5 |
6315 |
Wed, 03 September 2008 06:11 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) |
![icon6.gif](/forum/images/message_icons/icon6.gif) |
Performance tuning Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production By: NewLife on Tue, 02 September 2008 |
9 |
2086 |
Tue, 02 September 2008 09:24 By: NewLife ![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) |
|
UPDATE ISSUE Oracle 10g |
4 |
1938 |
Tue, 02 September 2008 08:11 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) |
|
Alternative way to avoid full scan? Oracle9i By: Olivia on Tue, 02 September 2008 |
8 |
2176 |
Tue, 02 September 2008 07:35 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) |
|
Query to check statistics are up to date Oracle9i By: Olivia on Tue, 02 September 2008 |
2 |
1385 |
Tue, 02 September 2008 06:56 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) |
|
How to make the response time less for this query Oracle9i By: Olivia on Mon, 01 September 2008 |
27 |
3448 |
Tue, 02 September 2008 02:08 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) |
|
Table Partitioning Oracle 10g |
4 |
2275 |
Tue, 02 September 2008 00:49 By: mariaandreou ![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 optimisation using meaningless condition By: bmikle on Fri, 29 August 2008 |
16 |
3994 |
Mon, 01 September 2008 16:24 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) |
|
unstable sort is inapprehensible (merged) |
3 |
2060 |
Mon, 01 September 2008 00:34 By: stronghearted ![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) |
|
DB parameters ORacle 10.2.0.3 |
3 |
1475 |
Fri, 29 August 2008 09:51 By: pdhayan@qwest.com ![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) |
|
help in tuning query |
1 |
1450 |
Fri, 29 August 2008 05:54 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) |
|
histogram |
4 |
1379 |
Thu, 28 August 2008 14:41 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) |
|
Definition of wait event By: lunaut on Wed, 27 August 2008 |
5 |
1849 |
Thu, 28 August 2008 13:16 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) |
|
memory in statspack 9i windows |
2 |
1557 |
Thu, 28 August 2008 12:54 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) |
|
AWR Service Stats By: lunaut on Thu, 28 August 2008 |
1 |
2480 |
Thu, 28 August 2008 12:54 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) |
|
10g Database Performance |
1 |
1358 |
Thu, 28 August 2008 10:47 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) |
|
response time |
3 |
1466 |
Thu, 28 August 2008 01:24 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |