|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to remove left join and ON JOIN from query and use better things in place of that 11i ( 1 2) |
51 |
17106 |
Thu, 31 July 2014 05:50 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) |
|
After Table analyze, the number of blocks goes Down Oracle 11gR2 |
7 |
5623 |
Wed, 30 July 2014 04:14 By: hitesh.bhatt ![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) |
|
Partitioning on a VARCHAR2 column 11g By: mafoe on Mon, 28 July 2014 |
6 |
7070 |
Tue, 29 July 2014 04:29 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) |
|
Performance issue 10.2.0.5.0 |
16 |
10520 |
Sat, 26 July 2014 08:55 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) |
|
A question about SPM 11.2.0.4 on Linux |
2 |
4630 |
Thu, 24 July 2014 12:48 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) |
|
performance lag of the quey 11g |
17 |
8241 |
Thu, 24 July 2014 11:36 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 Tuning 11g |
11 |
6978 |
Tue, 22 July 2014 08: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) |
|
How to revert the work done by accept_sql_profile procedure & Issues to watch out with SPM (merged) Oracle 11.2.0.4 on Linux |
20 |
13224 |
Wed, 16 July 2014 11:16 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) |
|
Oracle 11g on VMWARE Oracle 11g, Windows Server 2008 |
3 |
4691 |
Wed, 16 July 2014 07:18 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 Performance Oracle 11g |
3 |
5004 |
Sat, 12 July 2014 02:09 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 about performance using index on the column which is using in WHERE and SET clause. Oracle 11g |
3 |
5733 |
Sat, 12 July 2014 02:03 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 and ASH report analyze Oracle 10g,11g,Linux |
13 |
7566 |
Mon, 07 July 2014 10:46 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) |
|
Shameless plug |
5 |
7181 |
Sun, 06 July 2014 07:48 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) |
|
I/O calibration |
9 |
6423 |
Fri, 04 July 2014 06:34 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) |
|
Table Shrink Space and Performance 11g Standard Edition,Linux x86_64 |
11 |
7185 |
Tue, 01 July 2014 08:10 By: martens_b2014 ![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) |
|
UNDO Setup Issue |
9 |
9945 |
Sun, 29 June 2014 04:32 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) |
|
Debug Procedure Oracle 11g,Win7 32 bit By: Xandot on Thu, 26 June 2014 |
7 |
5675 |
Thu, 26 June 2014 09:10 By: Xandot ![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) |
|
Materialized View- Delay refresh |
7 |
6540 |
Tue, 24 June 2014 07:44 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) |
|
Calculating schema statistics during a huge 10 hour batch job Oracle 11gR2(11.2.0.4) on Linux |
7 |
6184 |
Fri, 20 June 2014 01:13 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) |
|
DBA_HIST_SEG_STAT view 11.2.0.3 |
7 |
15386 |
Fri, 20 June 2014 00: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) |
|
SQL performance tunning :- DBMS_STATS procedure errored out Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production |
22 |
11214 |
Tue, 17 June 2014 02:52 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) |
|
General question on dbms_stats 11g |
2 |
4998 |
Sat, 14 June 2014 10:43 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) |
|
how to troubleshoot slow running queries? 11g |
11 |
7099 |
Sat, 14 June 2014 02:04 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) |
|
Indexing and Tuning Oracle 10g |
5 |
6463 |
Tue, 10 June 2014 20: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) |
|
Table with 40 million records problem |
4 |
5289 |
Tue, 10 June 2014 20:21 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) |
|
Staging table without indexes, slow queries Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 |
4 |
12847 |
Thu, 05 June 2014 15:05 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) |
|
SQL performance tunning Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production |
21 |
9880 |
Thu, 05 June 2014 08:56 By: msinha8 ![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 id shows multiple plan table 11g, 11.2.0.3, sun-solaris10 |
5 |
5457 |
Tue, 27 May 2014 02:47 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) |
|
monitoring 11.2.0.3 |
3 |
4599 |
Fri, 23 May 2014 23:56 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) |
|
Direct Path Wait event Tune Direct path write temp, Direct path read, Direct path read temp |
6 |
8823 |
Fri, 23 May 2014 20:27 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) |
|
what are the disadvan of using incremental stats in oracle 11g? |
5 |
6851 |
Thu, 22 May 2014 05:26 By: ashwanth77 ![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_hist_snapshot vs dba_hist_active_sess_history oracle 11g rel 2 (11.2.0.3.0) By: ind9 on Tue, 20 May 2014 |
1 |
5849 |
Tue, 20 May 2014 07:30 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) |
|
% cpu used by a session |
2 |
5262 |
Sat, 17 May 2014 11:00 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) |
|
Procedure runs slow whereas 11.2.0.1 |
7 |
5739 |
Thu, 15 May 2014 09:43 By: guru_karnam ![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) |
|
LOV taking long time |
29 |
14548 |
Thu, 15 May 2014 00:40 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 performance issue oracle 11gr2 |
3 |
17168 |
Tue, 13 May 2014 21:40 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 execution plan is looking bad Oracle 11g |
23 |
9480 |
Tue, 13 May 2014 10:50 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 Query too slow 11g, Windows By: aldy on Thu, 08 May 2014 |
20 |
10209 |
Sat, 10 May 2014 10:21 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) |
|
High CPU Consuming Query Oracle,11.2.0.3, AIX By: nmoham on Wed, 07 May 2014 |
12 |
7004 |
Fri, 09 May 2014 02:19 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) |
|
slow sql By: fenor on Tue, 06 May 2014 |
6 |
5642 |
Wed, 07 May 2014 10:38 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |