|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Application slow Oracle 11.1.0.7.0, Unix-HP |
4 |
3131 |
Sun, 07 August 2011 12:20 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) |
|
PERFORMANCE TUNING |
1 |
2934 |
Sat, 06 August 2011 10:02 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 to reduce the consistent gets of this sql Oracle 10.2.0.4.0 64bit , AIX 5.3 ( 1 2) |
72 |
12079 |
Wed, 03 August 2011 20:34 By: snowball ![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) |
|
enq: TS - contention 10.2.0.4 |
14 |
34475 |
Mon, 01 August 2011 07:27 By: LNossov ![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 HIT DUE TO NVL FUNCTION Oracle 9i By: Fasy on Fri, 29 July 2011 |
1 |
3185 |
Fri, 29 July 2011 07:34 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 Index Issue |
6 |
3622 |
Mon, 25 July 2011 22:00 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 optimization oracle 10gR2 , Suse Enterprise Linux By: mr_wee on Thu, 21 July 2011 |
16 |
4695 |
Mon, 25 July 2011 01:18 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) |
|
big table partitioning oracle 10gR2 By: mr_wee on Tue, 28 June 2011 |
15 |
5950 |
Sun, 24 July 2011 03:49 By: mr_wee ![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) |
|
delete statement taking forever 10.2.0.3 |
14 |
5230 |
Fri, 22 July 2011 13:18 By: varunvir ![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 comsuming time oracle 11g, Window 2003 Server |
5 |
3561 |
Thu, 21 July 2011 02:42 By: MicroJoey ![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 Tuning SQL Queries Oracle 11i Queries |
2 |
4295 |
Tue, 19 July 2011 11:24 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) |
|
DBMS_UTILITY GET_TIME |
9 |
4050 |
Tue, 19 July 2011 04:31 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) |
|
How can i force a sql use index range scan 11.2.0.1.0 Windos XP |
10 |
4577 |
Mon, 18 July 2011 03:33 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) |
|
Data dictionary Cache - dc_objects Oracle 10g |
27 |
7123 |
Sat, 16 July 2011 00:49 By: LNossov ![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) |
|
Precise I3 vs. OEM Grid 9i/10g/11g |
0 |
6021 |
Fri, 15 July 2011 09:15 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) |
|
SYSAUX Tablespace Oracle 10g/Windows XP By: gxeon on Thu, 14 July 2011 |
3 |
5295 |
Fri, 15 July 2011 03:06 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 Optimization Help - Date-Range Matching results in MERGE JOIN CARTESIAN Oracle 10gR2 (10.2.0.4) By: rasa on Mon, 11 July 2011 |
10 |
4069 |
Thu, 14 July 2011 09:39 By: rasa ![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) |
|
alter table.. shrink space command hanging.. Sun OS, 10.2.0.3.0 By: lg123 on Wed, 13 July 2011 |
2 |
4666 |
Thu, 14 July 2011 02:33 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) |
|
Wait Stats Oracle 10g/Windows By: gxeon on Mon, 11 July 2011 |
4 |
3157 |
Wed, 13 July 2011 22:24 By: hkchital ![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) |
|
NVL is degraing performance, any alternative |
9 |
6670 |
Wed, 13 July 2011 02:37 By: LNossov ![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 SQL Tuning Oracle 10.2.0.1 on Suse 10 |
13 |
4312 |
Wed, 13 July 2011 02:32 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) |
|
Reg Segment advisor Oracle 10g By: sathik on Mon, 11 July 2011 |
20 |
6616 |
Tue, 12 July 2011 09:58 By: hkchital ![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) |
|
Sol req : Alternative way of rewriting the query Oracle 10gr2 |
8 |
3266 |
Fri, 08 July 2011 05:59 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 optimization oracle 10g |
13 |
6981 |
Fri, 08 July 2011 05:51 By: LNossov ![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) |
|
Delete stmt taking so much time oracle |
28 |
5256 |
Thu, 07 July 2011 09:40 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) |
|
Become DB import too slow after server reboot Oracle 10G, Solaris 10 |
11 |
9573 |
Thu, 07 July 2011 04:38 By: LNossov ![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 more time Oracle 10g R2 |
15 |
5249 |
Wed, 06 July 2011 08:54 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) |
|
problem with outlines #2 |
19 |
5913 |
Tue, 05 July 2011 10:17 By: LNossov ![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) |
|
Solution req :Performance issue with partitioned table Oracle 10gR2 |
3 |
2678 |
Tue, 05 July 2011 06:34 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) |
|
Typical Question of Query Performance |
3 |
2328 |
Tue, 05 July 2011 05:24 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) |
|
Query doing FTS on a big table Oracle 10g 10.2.0.4.0 on AIX 5.3 |
10 |
3224 |
Tue, 05 July 2011 04:46 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) |
|
problem with outlines |
26 |
5436 |
Mon, 04 July 2011 10:32 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) |
|
how to clear cache for testing tuned code oracle 11g r2 |
4 |
2982 |
Mon, 04 July 2011 04:25 By: gogol_1987 ![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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Performance Tuning in Oracle 10g during Migration - Heavy Insert Optimization Oracle 10g |
27 |
13153 |
Sun, 03 July 2011 23:27 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 to measure the sql run time? Oracle 10.2.0.4.0 64bit , AIX 5.3 |
12 |
5880 |
Sun, 03 July 2011 16:11 By: LNossov ![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 |
22 |
5618 |
Sat, 02 July 2011 01:25 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) |
|
Performance Standard Edition without partitioning Oracle 11g - RHEL 5 |
2 |
2303 |
Sat, 02 July 2011 01:05 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) |
|
Oracle hash join Oracle 9i |
21 |
26945 |
Sat, 02 July 2011 00:26 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) |
|
AWR Report network foreground wait events 11.1.0.7.0, Linux |
8 |
14583 |
Thu, 30 June 2011 17:15 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) |
|
Performance Issue Oracle 10g, Windows XP |
1 |
2039 |
Wed, 29 June 2011 12:50 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |