|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Using ROW_NUMBER() reduces performance Oracle 10g R2 By: antenc on Mon, 08 November 2010 |
5 |
8915 |
Mon, 08 November 2010 05:03 By: antenc ![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 a partition table run to slow (2 Merged) Oracle 9, HP-UX |
4 |
3290 |
Sun, 07 November 2010 21:27 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) |
|
Partitioned table windows xp, oracle 9.2.0.0 |
3 |
3624 |
Wed, 03 November 2010 05:24 By: John Watson ![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 do I justify using different disks (2 merged) Oracle Database 10g Enterprise Edition 10.2.0.4.0 Prod, Microsoft Windows IA (32-bit) |
2 |
2598 |
Wed, 03 November 2010 02:22 By: kytemanaic ![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_ADVISOR ORA-13699 11.2.0.1, Linux and Windows 32 bit |
4 |
20067 |
Tue, 02 November 2010 14:43 By: John Watson ![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 Oracle 9i |
6 |
2569 |
Tue, 02 November 2010 03:50 By: Roachcoach ![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) |
|
union in one go oracle 10g |
5 |
2170 |
Mon, 01 November 2010 11:14 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) |
![icon7.gif](/forum/images/message_icons/icon7.gif) |
Required tool for SQL Query ORACLE 10g 10.2.0.1.0 |
4 |
2213 |
Thu, 28 October 2010 07:05 By: dkdms2124 ![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 11g r2 result_cache is Not working linux centos 5 |
10 |
4600 |
Thu, 28 October 2010 03:05 By: John Watson ![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) |
|
Group By taking more time (merged) |
10 |
2536 |
Wed, 27 October 2010 04:38 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) |
|
DBMS Stats gathering Oracle 10.2.0.4,Linux |
1 |
2462 |
Tue, 26 October 2010 18:56 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) |
|
distributing datafiles in server Win 2000,8.1.7 By: ultgnp on Tue, 26 October 2010 |
4 |
2313 |
Tue, 26 October 2010 02:49 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) |
|
Difference in query performance 10.2.0.4 |
9 |
3496 |
Mon, 25 October 2010 03:20 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) |
|
PCTFREE AND PCTUSED |
7 |
3697 |
Wed, 20 October 2010 06:22 By: sunayana_girl ![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) |
|
PX Deq: Execute Reply ORACLE 10G,10.2.0.3.0,AIX |
6 |
41127 |
Tue, 19 October 2010 11:52 By: rajatratewal ![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) |
|
MV refresh with atomic_refresh false 10.2.0.4 |
3 |
4055 |
Tue, 19 October 2010 10:47 By: sandhyaa ![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 analysis By: dba1234 on Thu, 14 October 2010 |
1 |
8680 |
Tue, 19 October 2010 06:18 By: kamkan ![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) |
|
Full tablescan eventhough join is on indexed field 10.2.0.4 |
9 |
5208 |
Tue, 19 October 2010 02:49 By: Yasir Hashmi ![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 OPTIMIZATION |
1 |
2130 |
Sun, 17 October 2010 06:57 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Returning all rows that equal a max(value) Oracle,11.1.0.6,Linux |
2 |
2262 |
Fri, 15 October 2010 10:06 By: mandie722 ![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) |
|
(probably) basic CBO question Oracle 11g |
7 |
3553 |
Fri, 15 October 2010 09:19 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) |
|
Related to data base import |
2 |
1669 |
Fri, 15 October 2010 02: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) |
|
How we do Optimisation and tuning |
1 |
1915 |
Thu, 14 October 2010 01:28 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) |
Need performance tuning in delete statement Oracle 10g, windows |
14 |
9071 |
Wed, 13 October 2010 02:38 By: burasami ![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) |
|
Order of executing indexes (2 merged) oracle 10.2.0,4,0 |
5 |
3448 |
Mon, 11 October 2010 16:56 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) |
|
Query Problem Oracle 9.2.0.8(HP-UX) |
6 |
2897 |
Tue, 05 October 2010 11:52 By: S.Rajaram ![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 running way too slow Oracle 9.2.0.8 (HP-UX) |
6 |
3997 |
Mon, 04 October 2010 21:51 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) |
|
Tuning Buffer cache and Buffer Busy Waits. oracle 9.2.0.1.0 windows |
5 |
2888 |
Sun, 03 October 2010 14:57 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) |
|
Column width convergation with Index performance Oracel 10.2.x By: sky_lt on Thu, 30 September 2010 |
24 |
5654 |
Sun, 03 October 2010 05:06 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) |
|
Performace issue in update oracle 11g |
2 |
10002 |
Fri, 01 October 2010 10:21 By: LKBrwn_DBA ![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) |
|
DBA_WAITERS , BLOCKERS $ V$LOCK Oracle Enterprise Edition 10.2.0.4, Solaris 10 |
5 |
7412 |
Wed, 29 September 2010 00:05 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) |
|
Query Tunning |
5 |
2215 |
Mon, 27 September 2010 15: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) |
|
Columns of v$ sessions_event. oracle 10.1.0.2.0 - windows |
7 |
2311 |
Mon, 27 September 2010 12:50 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) |
|
Insert into table slows down query Oracle 8i By: dev_777 on Thu, 23 September 2010 |
3 |
3160 |
Mon, 27 September 2010 08:46 By: S.Rajaram ![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) |
|
Flushing Buffer Cache. Oracle 9i.2, Windows. |
1 |
1698 |
Mon, 27 September 2010 01:10 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) |
|
"Fast refresh" MV too slow By: ss1_3 on Thu, 23 September 2010 |
2 |
2725 |
Fri, 24 September 2010 18:03 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) |
|
will effect the performace of DML on Fast refresh of Materialized view Oracle 10g |
5 |
2609 |
Fri, 24 September 2010 08:30 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) |
|
queary taking time Oracle10.2.0.1/linux |
2 |
2502 |
Thu, 23 September 2010 04:54 By: goracle9 ![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 over a DB link!! |
10 |
12220 |
Wed, 22 September 2010 07:57 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) |
|
Performance tunning oracle 8i |
3 |
2295 |
Wed, 22 September 2010 00:12 By: Its_me_ved ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |