|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Please help me my query performance is bad. Oracle 11g |
24 |
11228 |
Mon, 25 November 2013 06:18 By: ramya_162 ![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 & PL/SQL |
1 |
5356 |
Mon, 25 November 2013 02:04 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) |
|
Locking In application code. By: VIP2013 on Mon, 18 November 2013 |
6 |
5960 |
Fri, 22 November 2013 17:04 By: EdStevens ![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) |
|
SELECT works, INSERT+ SELECT hangs in SQLDeveloper Tools Oracle, 11.2, SQLDeveloper |
15 |
8161 |
Thu, 21 November 2013 02:38 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) |
|
Need advice on index to apply Oracle 11.2, Window 2008 By: jxh461 on Tue, 19 November 2013 |
10 |
6728 |
Wed, 20 November 2013 16:23 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 DB Performance Tests Oracle 11g By: ind9 on Tue, 05 November 2013 |
6 |
8767 |
Wed, 13 November 2013 17:51 By: alan.kendall@nfl.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) |
|
Please help me how to improve the performance of this query further. Oracle 11g |
33 |
12164 |
Tue, 12 November 2013 11:15 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) |
|
forms 6i too slow when database have approximately 1 million records Oracle 8i |
4 |
6925 |
Mon, 11 November 2013 05:58 By: Littlefoot ![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) |
|
Adaptive Cursor Sharing VS SPM By: VIP2013 on Tue, 05 November 2013 |
3 |
5693 |
Sat, 09 November 2013 13:45 By: VIP2013 ![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 SQL is faster/better Oracle By: mokarem on Mon, 04 November 2013 |
11 |
9056 |
Wed, 06 November 2013 03: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) |
|
Performance issue in one sql 11i |
4 |
5804 |
Tue, 05 November 2013 23:35 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) |
|
Understanding ASH Oracle 10g,10.2.0.4.0, windows server 2008 |
1 |
4963 |
Tue, 05 November 2013 01:47 By: Lalit Kumar B ![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) |
|
Tiff Images and Oracle Oracle 10, 11 and 12 |
6 |
7187 |
Fri, 01 November 2013 11:22 By: gazzag ![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 performance problem or "bad" SQL query Oracle 10g By: rc3d on Thu, 24 October 2013 |
30 |
15371 |
Wed, 30 October 2013 12:25 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) |
|
Please help me on tune this query Oracle 11g |
27 |
13542 |
Wed, 30 October 2013 08:49 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) |
|
XML/XPath rewrites and plan baselines 11.2.0.4 RHEL |
6 |
6318 |
Wed, 30 October 2013 04:12 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) |
|
standard SQL query to benchmark Oracle DB response time (performance) Oracle 10g By: rc3d on Sat, 26 October 2013 |
1 |
5274 |
Sat, 26 October 2013 06:17 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 Increase Data Reterival / Insertion Speed Oacle 8i and Forms 6i |
2 |
5910 |
Thu, 24 October 2013 04: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) |
|
db file parallel read 11.2.0.3.0 |
4 |
19283 |
Mon, 21 October 2013 03:38 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) |
|
Digging out the Wait events. By: VIP2013 on Tue, 15 October 2013 |
14 |
14070 |
Mon, 21 October 2013 03:14 By: VIP2013 ![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 your help in tuning the query 11.5.10.2 |
28 |
14522 |
Fri, 18 October 2013 05:21 By: Lalit Kumar B ![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 with 12c vs 10.2g 12c |
19 |
14812 |
Thu, 17 October 2013 10:39 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) |
|
Insert data fast on table Oracle 11.2 RAC |
14 |
7805 |
Tue, 15 October 2013 08:59 By: Lalit Kumar B ![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) |
|
database links question oracle 11g By: manoj12 on Mon, 14 October 2013 |
6 |
7063 |
Mon, 14 October 2013 11:42 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) |
|
Force the optimizer to consider all join permutations 11.2.0.4 RHEL |
5 |
6287 |
Mon, 14 October 2013 09:45 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) |
|
Please help me to tune this procedure Oracle 11g |
25 |
11316 |
Mon, 14 October 2013 06:48 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) |
|
performance - index creation on text column Oracle 10g,Solaris By: prejib on Thu, 10 October 2013 |
9 |
6925 |
Fri, 11 October 2013 00:46 By: prejib ![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) |
|
about increasing performance speed of slow running package Oracle 11.2.0.2.0, Oracle Enterprise Linux -5 |
7 |
6585 |
Mon, 07 October 2013 02:19 By: 8939513598$ ![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_TARGET error Oracle 11.2.0.1.0, Oracle Enterprise Linux -5 |
2 |
5227 |
Fri, 04 October 2013 11: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 configure SGA_MAX_SIZE parameter Oracle Enterprise 11.2.0.3, RH Enterprise Linux 5 By: rcct on Tue, 24 September 2013 |
7 |
8614 |
Fri, 04 October 2013 11:01 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) |
|
Please advise on configuring memory Oracle 11.1, Windows Server 2008 R2 By: jxh461 on Wed, 18 September 2013 |
23 |
9716 |
Fri, 04 October 2013 02: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) |
|
Need help to tune this query Oracle 11g |
10 |
7460 |
Fri, 04 October 2013 01:50 By: 8939513598$ ![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) |
|
Buffer Busy Wait DBMS_ALERT_INFO Oracle DB 11.2.0.3, Standard 64-bit, Windows 2008 R2 By: Flyby on Wed, 02 October 2013 |
7 |
7710 |
Thu, 03 October 2013 04:19 By: 8939513598$ ![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 joining Oracle 10g |
4 |
5958 |
Tue, 01 October 2013 10: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) |
|
Question for List partition By: dba10 on Mon, 30 September 2013 |
2 |
5222 |
Mon, 30 September 2013 17:36 By: Lalit Kumar B ![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 IN THE PERFORMANCE ORACLE 10G |
5 |
5852 |
Sun, 29 September 2013 09:14 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) |
|
pagging oracle 11.2.0.3 sun solaris 10.5 |
3 |
6302 |
Thu, 26 September 2013 16:28 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) |
|
Split Data separated by comma ; then create a collection with data mapped from other columns |
4 |
6217 |
Wed, 25 September 2013 07:45 By: abhenav123 ![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) |
|
Select query taking time even after using PARALLEL hint Oracle 11.2.0.3,Linux x86-64 |
2 |
5904 |
Wed, 25 September 2013 04:24 By: arunshrish ![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) |
|
Please help me to tune this query |
2 |
6199 |
Tue, 24 September 2013 13:29 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |