|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Howto avoid virtual circuit wait as application developer? 11gR2 (11.2.0.3) |
4 |
24765 |
Thu, 19 September 2013 08:28 By: bet32978 ![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) |
|
snapshot skipped in between the scheduled time (AWR) 11g, 11.2.0.1, window server 2008 |
7 |
14028 |
Sat, 14 September 2013 10:48 By: trantuananh24hg ![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 11i |
22 |
10614 |
Fri, 13 September 2013 00:00 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) |
|
Call from specified Machine not assigned to Database resource consumer. Release 11.2.0.3.0 - 64bit By: VIP2013 on Fri, 06 September 2013 |
9 |
9262 |
Sun, 08 September 2013 00: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) |
|
Database crash Due To CPU Starvation 11.2.0.3 Version Oracle. By: VIP2013 on Sun, 01 September 2013 |
9 |
7568 |
Wed, 04 September 2013 14:04 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) |
|
Parallel hints with cursor queries Oracle 11.2.0.2.0, Windows XP |
13 |
18741 |
Sun, 01 September 2013 13:56 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) |
|
Performance issue with a query using DB links am on Oracle 11.2.0.3 on Solaris 10 on one database and oracle 10.2.0.4 on Solaris 10 on another database |
18 |
10526 |
Fri, 30 August 2013 13:06 By: orausern ![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 on this Oracle 11g |
4 |
6244 |
Fri, 30 August 2013 02:54 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) |
|
Impact of RAM to oracle 11gR2 on HP-UX IA64 |
11 |
8095 |
Thu, 29 August 2013 10:06 By: yipchunyu ![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) |
|
NOWAIT lock requests could hang (like Parallel Queries may hang "enq: TS - contention") database enterprize edition 11.2.0.3 solaris 10 |
2 |
6205 |
Thu, 29 August 2013 04:38 By: mshrkshl ![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 guide to improve the performance of query Oracle 11g |
8 |
6901 |
Tue, 27 August 2013 03:56 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) |
|
Moving Tables to Encrypted Tablespace. 11.2.0.3.0 version of oracle. |
2 |
6114 |
Tue, 27 August 2013 03:20 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) |
|
dynamic sql choosing wrong index oracle 11g / aix |
3 |
7333 |
Thu, 22 August 2013 08:31 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) |
|
query tuning oracle 010g |
6 |
11966 |
Thu, 22 August 2013 08:15 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) |
|
Stats on a partitioned table 11g |
3 |
7941 |
Wed, 21 August 2013 21:47 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) |
|
Efficient Way - Outer join Vs Not Exists Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production |
4 |
8160 |
Wed, 21 August 2013 01:33 By: saipradyumn ![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) |
|
identifying query problem Oracle 10.2.0.4.0, RedHatLinux-5 |
4 |
6294 |
Tue, 20 August 2013 22:11 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) |
|
dbms_stats.set_table_prefs and "LIST STALE" 11.2.0.3.0 |
8 |
13265 |
Thu, 15 August 2013 10:12 By: johnp12 ![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 index Oracle 10.2.0.4.0, RedHatLinux-5 |
4 |
7186 |
Thu, 15 August 2013 10:06 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) |
|
Please help me to improve the performance of this query. Oracle 11G ( 1 2) |
41 |
18211 |
Mon, 12 August 2013 05:58 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) |
|
Optimize Query using Explain Plan 10g |
5 |
7494 |
Fri, 09 August 2013 11:47 By: developer12 ![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 Index Scan issue 11.2.0.3.0 |
9 |
7753 |
Wed, 07 August 2013 01:50 By: rishwinger ![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) |
|
Analyze stats running long Oracle 11g R2, Windows 32 bit By: nvembu on Wed, 31 July 2013 |
9 |
7591 |
Mon, 05 August 2013 05:15 By: pointers ![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 ... SELECT FROM t@dblink |
6 |
7128 |
Sat, 03 August 2013 05: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) |
|
Performance tunning |
2 |
5376 |
Thu, 01 August 2013 23:49 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) |
|
Lost Index from the second execution time Oracle 11gR2, Windows 64 bit |
7 |
8556 |
Tue, 30 July 2013 21:24 By: trantuananh24hg ![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 determine memory usage for a function Toad for Oracle 11g on Windows 7 By: jxh461 on Wed, 24 July 2013 |
5 |
5806 |
Tue, 30 July 2013 08:57 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) |
|
Please tune this query. Oracle 11G |
24 |
10373 |
Tue, 30 July 2013 04:17 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) |
|
Need Help In Performance Tuning 10g |
3 |
6521 |
Sat, 27 July 2013 12:15 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) |
|
Cannot collect Top Frequency Histogram on column Oracle 11.2.0.2.0 on Windows Server 2003 |
3 |
5626 |
Thu, 25 July 2013 10:35 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) |
|
TDE Related Question |
4 |
5720 |
Wed, 24 July 2013 11:33 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) |
|
SQL Execution Plan Export/Import within 10.2.0.4 version databases 10.2.0.4 in AIX By: TRaj on Tue, 16 July 2013 |
2 |
6591 |
Sun, 21 July 2013 14:27 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) |
|
Exec plan explanation 11.2.0.3 |
10 |
8490 |
Sun, 21 July 2013 07:55 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) |
|
Different execution plan in Different DB Oracle 10g |
6 |
6547 |
Sun, 21 July 2013 05:22 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) |
|
About NO_INDEX Hint Oracle 11.2.0.3.0 |
2 |
6712 |
Fri, 19 July 2013 03: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) |
|
Script to load Trace files errors to a Table IBM AIX By: user81 on Sat, 13 July 2013 |
3 |
4874 |
Sat, 13 July 2013 14: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) |
|
How to enable AWR in oracle 10g 10g, 10.2.0.1, windows XP |
3 |
10402 |
Fri, 12 July 2013 06:10 By: suman1986 ![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 Table scan - Query without where clause 11g, 11.2.0.5, AIX |
6 |
6279 |
Fri, 12 July 2013 00:10 By: ishika_20 ![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) |
|
Simple query is taking long time Oracle 11G |
16 |
9406 |
Tue, 09 July 2013 08:38 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) |
|
Efficient Way to Alter Column For TDE. |
5 |
5735 |
Mon, 08 July 2013 05:51 By: VIP2013 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |