|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle Performance Test Tools Oracle 10.2, 11.2 |
6 |
4686 |
Mon, 08 July 2013 05: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) |
|
SQL & PL/SQL Performance Tuning Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production |
1 |
4756 |
Tue, 02 July 2013 07: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) |
|
Histograms issue During DB Upgrade. Oracle - 11.2.0.3 G |
3 |
5777 |
Mon, 01 July 2013 11:35 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 with the query Oracle 11G |
8 |
4935 |
Mon, 01 July 2013 03: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) |
|
Sql query is slow Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production |
9 |
6282 |
Thu, 27 June 2013 07:49 By: Andrey_R ![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 Timings between 2 Nodes Oracle 11g Release2 By: feroze on Wed, 26 June 2013 |
2 |
4721 |
Wed, 26 June 2013 16:56 By: feroze ![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) |
|
Top wait events Oracle ,11.2.0.3.0 , Solaris 10 sparc 64 bit |
2 |
4624 |
Mon, 24 June 2013 05:30 By: Flyby ![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 a SQL query Oracle Database 10g Release 2 |
17 |
19506 |
Fri, 21 June 2013 10: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) |
|
DB designing from performance point of view. Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 |
8 |
5690 |
Mon, 17 June 2013 02:32 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) |
|
Tuning a query with an EXISTS clause Oracle 10.2.0.4 on Solaris 10 |
4 |
5953 |
Fri, 14 June 2013 17:42 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 tuning made easy Oracle 10g, Windows 7 64 bit |
9 |
5758 |
Fri, 14 June 2013 17:33 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) |
|
How to Refresh a Materialized view Data. Oracle 10g, Windows 7 64 bit |
2 |
3830 |
Wed, 12 June 2013 06:48 By: stalin4d ![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 Allocation in 11 G oracle 11.2.0.3.0 - Windows server 2008 R2 |
5 |
4912 |
Mon, 10 June 2013 07:36 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) |
|
SQL not using index from application. Oracle 11gR1 By: kanas on Thu, 06 June 2013 |
9 |
6671 |
Mon, 10 June 2013 00:27 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) |
|
System statistics: demonstration 11.2.0.3 |
6 |
6124 |
Thu, 06 June 2013 07:12 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 avoid repeat where clause in oracle sql Oracle 11g, Windows By: murman on Tue, 04 June 2013 |
2 |
4504 |
Tue, 04 June 2013 15:20 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) |
|
Unable to update newly added column in existing table Oracle 9.2.0.6, OS - AIX 6.1 |
15 |
7267 |
Mon, 03 June 2013 12:52 By: s.m.ramachandran ![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) |
|
LogMiner Doubt 11.2.0.3.0 |
6 |
7568 |
Mon, 03 June 2013 03:46 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) |
|
High System I/O Wait Class on AWR Oracle 10.2.0.4 EE 64-bit, Solaris 10 |
10 |
23697 |
Thu, 30 May 2013 09:16 By: sysdba007 ![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) |
|
Keep Pool Oracle 11g |
5 |
7329 |
Thu, 30 May 2013 05:30 By: anjugarg66 ![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 required in analyzing Network waits from AWR Oracle 10.2.0.3 on AIX |
3 |
9902 |
Thu, 30 May 2013 02:40 By: sysdba007 ![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) |
|
Best disk config for SME scale datawarehouse Oracle std 10Gx64, windows 2008 x64 |
2 |
4225 |
Mon, 20 May 2013 04:27 By: clementstore ![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 tunning for querying table oracle 10g |
4 |
4202 |
Sun, 19 May 2013 08:39 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) |
|
enable row movement - ok, but why internally this thing is needed 11.2.0.3.0 |
4 |
8213 |
Fri, 17 May 2013 14:43 By: Flyby ![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) |
|
commit_write in 10g Oracle 10g, AIX By: TRaj on Thu, 16 May 2013 |
3 |
4851 |
Fri, 17 May 2013 00:51 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 cache advice 10g Oracle 10g, AIX By: TRaj on Thu, 16 May 2013 |
2 |
4235 |
Thu, 16 May 2013 17:55 By: TRaj ![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 generates different execution plans for test and prod environments Oracle Database 11g By: httr on Wed, 08 May 2013 |
11 |
12365 |
Wed, 15 May 2013 14:07 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) |
|
Is there any way to have the DB articulate why PDML is blocked 11.2.0.3 |
10 |
5929 |
Wed, 15 May 2013 06:17 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) |
|
why this query is utilizing my undo so rapidly? |
9 |
10388 |
Sat, 11 May 2013 14:39 By: piotrtal ![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 is very slow 10.2.0.4 |
13 |
12847 |
Thu, 09 May 2013 16:53 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Query performance tuning for ETL Oracle 11g |
2 |
4674 |
Wed, 08 May 2013 14:59 By: Pms_SARA07 ![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) |
|
Does partitioning need constraints to be copied Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production |
10 |
10574 |
Tue, 07 May 2013 00:02 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 for Table analysis 11.2.0.1 |
5 |
4061 |
Fri, 03 May 2013 08: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) |
|
Ideas for fixing plan cardinality error |
11 |
6356 |
Wed, 01 May 2013 10:51 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 Tuning Oracle 11g |
7 |
5479 |
Tue, 30 April 2013 08:58 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) |
|
Sql query running slowly oracle 10g |
2 |
4451 |
Mon, 29 April 2013 22:45 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) |
|
How to Improve query performance |
5 |
5502 |
Sun, 28 April 2013 07:02 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) |
|
Bind variable issue Oracle 9i |
7 |
4749 |
Fri, 26 April 2013 06: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) |
|
v$sql_plan.object_owner incorrect? |
2 |
4673 |
Thu, 25 April 2013 11:56 By: DKATyler ![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) |
|
checking the delete performance in the package 10.2.0.4 |
13 |
7124 |
Thu, 25 April 2013 03:31 By: grpatwari ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |