|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Index vs Full table scan on sysdate 11.2.0.3,Linux X86_64 |
7 |
5991 |
Tue, 25 November 2014 08:38 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) |
|
Decide on Partitioning Column/Purge Approach Oracle 11g Release 2 By: azeem87 on Thu, 13 November 2014 |
9 |
6396 |
Fri, 14 November 2014 08: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) |
|
Logging operation takes longer but no wait events Oracle 11.2.0.4 EE, Linux 64 bit By: d_seng on Mon, 01 September 2014 |
15 |
9408 |
Fri, 14 November 2014 05:54 By: d_seng ![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) |
Cursor: Pin S Wait on X Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 |
4 |
7201 |
Fri, 14 November 2014 03: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) |
|
PGA_AGREGATE_TARGET parameter Oracle11g 11.2.0.3 |
4 |
5303 |
Tue, 11 November 2014 12:35 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) |
|
Plan missing from cursor cache Oracle 12.1 ,OEL 6 By: gkrishn on Sun, 09 November 2014 |
2 |
5054 |
Sun, 09 November 2014 03:10 By: gkrishn ![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 taking long due to index maintenance? Oracle 11.2.0.3 / CentOS By: ThomasG on Thu, 30 October 2014 |
14 |
10636 |
Wed, 05 November 2014 02:35 By: ThomasG ![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 in Loop causing performance issue 11i |
12 |
9137 |
Mon, 03 November 2014 00:48 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) |
|
SQL tuning advisor being retarted |
6 |
6450 |
Thu, 23 October 2014 05:08 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) |
|
Table creation with nologging clause is stopped in between 10g, 10.2.0.4, hp unix |
7 |
6057 |
Thu, 16 October 2014 04:09 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) |
|
Materialized view refresh thrashing DBWR In post |
4 |
5974 |
Wed, 15 October 2014 04:38 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) |
|
Need to tune package. Oracle 11.2.0.3.0 By: swap19 on Sat, 11 October 2014 |
18 |
10161 |
Mon, 13 October 2014 01:49 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) |
|
Default value of SEND_BUF_SIZE and RECV_BUF_SIZE for IBM Aix 7 Aix 7 |
1 |
7042 |
Sun, 12 October 2014 09:31 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) |
|
Query chooses bitmap index and runs slower 11.2.0.2/11.2.0.4 Enterprise, RHL By: d_seng on Wed, 01 October 2014 |
27 |
16303 |
Fri, 10 October 2014 09:18 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) |
|
improve performance for the query Oracle 11g By: sumanh on Wed, 08 October 2014 |
2 |
5036 |
Wed, 08 October 2014 02:12 By: flyboy ![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) |
![icon10.gif](/forum/images/message_icons/icon10.gif) |
code taking long amount of time to execute ORACLE 11G By: manoj12 on Fri, 03 October 2014 |
2 |
4484 |
Fri, 03 October 2014 09:06 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Access Remote Data Slow |
22 |
9692 |
Tue, 30 September 2014 13:56 By: oasisinsky ![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) |
|
Private message |
3 |
4946 |
Tue, 30 September 2014 06:18 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) |
|
Data PERFORMANCE ISSUES LINUX 5.3 Oracle 11gr2 |
2 |
4554 |
Sun, 28 September 2014 21:57 By: lzfhope ![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) |
How to tune a slow query |
4 |
5313 |
Sat, 27 September 2014 11: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) |
|
Db servers capacity oracle |
3 |
4940 |
Wed, 24 September 2014 00:47 By: simplesanju ![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 a way to monitor historical locks in Standard Edition 11.2.0.3 SE, 11.2.0.3 EE, |
1 |
6842 |
Fri, 19 September 2014 09:48 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) |
|
Query requires tuning Oracle 11gr2, sun By: AviatoR on Fri, 12 September 2014 |
13 |
8346 |
Fri, 19 September 2014 03:01 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) |
|
sql_id of a sql not the same in different databases Oracle 11.2.0.4 on Linux. |
7 |
6773 |
Wed, 17 September 2014 06:21 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) |
|
High insertion on the database | Tuning parameters Oracle 10g, Linux 64 |
9 |
5681 |
Tue, 16 September 2014 23:01 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) |
|
Auto stats job window details Oracle 11.2.0.4 on Enterprise linux 6 |
8 |
6976 |
Thu, 11 September 2014 13:12 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) |
|
Materialized view oracle 11gr2 |
5 |
5021 |
Sun, 07 September 2014 00: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) |
|
dbms_addm.real_time_addm_report DB 12.x |
8 |
7581 |
Sat, 06 September 2014 10:11 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) |
|
Update non-token column on compressed table Oracle EE 11.2.0.2 By: d_seng on Thu, 28 August 2014 |
2 |
5474 |
Sun, 31 August 2014 05:18 By: d_seng ![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 performance guide Oracle 11.2.4.0 , SunOS |
2 |
4814 |
Fri, 22 August 2014 01:00 By: mc1825263 ![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) |
|
explain plan details vary between display & display_cursor 11g, 11.2.0.3, solaris10 |
6 |
4901 |
Wed, 20 August 2014 06:15 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) |
|
Regarding sql id 11.2.0.4 |
5 |
4777 |
Wed, 20 August 2014 02:46 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) |
|
oracle performance metrics 11g |
5 |
5774 |
Mon, 18 August 2014 10:07 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) |
|
view slowness.. 11.2.0.2, WIndows 2008 R2 |
4 |
4931 |
Thu, 14 August 2014 15:52 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) |
|
cache issue 11.2.0.2, WIndows 2008 R2 |
12 |
9207 |
Thu, 14 August 2014 09:53 By: sant_new1 ![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) |
|
Reading byte data from BLOB vs File System By: mafoe on Wed, 13 August 2014 |
5 |
6119 |
Wed, 13 August 2014 08: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) |
|
How to calculate ROI on performance gain Oracle 11gr2, sun |
3 |
4499 |
Tue, 12 August 2014 21:23 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) |
|
Parallel Threads Waiting |
8 |
8140 |
Sat, 09 August 2014 12:20 By: scottwmackey ![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) |
|
Queries "break" after automatic statistic gathering. 11.2.0.3 / CentOS Linux |
4 |
5785 |
Fri, 01 August 2014 13:34 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) |
|
gather table stats 11.2.0.3, sun sol 10 |
8 |
7265 |
Thu, 31 July 2014 19:31 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |