|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
create index 10.2.0.4 |
13 |
2943 |
Wed, 07 December 2011 07:57 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 problem Oracle 9i |
3 |
2149 |
Wed, 07 December 2011 02: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) |
|
How to improve the performance of export job(expdp)? Oracle10gr2, Linux. |
1 |
3105 |
Tue, 06 December 2011 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) |
|
How to reduce cost of my query? sql developer |
3 |
4248 |
Sat, 03 December 2011 01:16 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) |
|
urgent please modify this query frenz sloww performance |
12 |
4295 |
Fri, 02 December 2011 16:07 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) |
|
parallel_index 11g1, 11g2 LINUX By: mjm22 on Wed, 23 November 2011 |
1 |
6258 |
Thu, 01 December 2011 14:05 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) |
|
I/O issue 11g r2 HP-UX |
4 |
6786 |
Thu, 01 December 2011 13:43 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) |
|
memory_max_target and 11g memory utilization - question 11.2.0.1.0 |
5 |
4715 |
Wed, 30 November 2011 13:27 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) |
|
WINDOW SORT Oracle 11g By: sachi09 on Wed, 30 November 2011 |
5 |
8282 |
Wed, 30 November 2011 04:37 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) |
|
Data type conversion impact on performance |
8 |
5140 |
Tue, 29 November 2011 03:59 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) |
|
Query performance decreased between order by ASC/DESC |
11 |
3525 |
Mon, 28 November 2011 11:59 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) |
|
SGA AND PGA PARAMETER SETTINGS WINDOWS 2000 SERVER ORACLE 9I By: mrdb on Sun, 27 November 2011 |
5 |
4711 |
Sun, 27 November 2011 02: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) |
|
Table space with different block size inside same database Oracle 10g, 10.2.0.1.0 Linux By: Rags123 on Fri, 25 November 2011 |
14 |
4186 |
Fri, 25 November 2011 16:55 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) |
|
Reports Tuning Oracle Report builder 6i or later .. |
1 |
2648 |
Thu, 24 November 2011 02:02 By: ramoradba ![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) |
|
MVIEW huge temp space 10.2.0.3 linux |
6 |
6563 |
Wed, 23 November 2011 09:43 By: dee_bee_eh ![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) |
|
Elapsed Time in Trace file output (2 Merged) Oracle 11g R2 on Windows 7 |
1 |
20756 |
Wed, 23 November 2011 05:29 By: dee_bee_eh ![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) |
|
Temp Tablespace running out of space (68 GB) Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit |
5 |
8894 |
Wed, 23 November 2011 04:41 By: dee_bee_eh ![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) |
![icon3.gif](/forum/images/message_icons/icon3.gif) |
At the end of the road of my sql tuning oracle By: tigerxu on Mon, 21 November 2011 |
1 |
1874 |
Mon, 21 November 2011 20:47 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) |
|
Definition between 2 metrics "Physical Reads" 10gR2 By: nikko on Mon, 21 November 2011 |
3 |
2346 |
Mon, 21 November 2011 06:22 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 in Hierarchical queries Oracle 10.2.0.2.0 |
4 |
2793 |
Fri, 18 November 2011 19:12 By: praveenkumarsr ![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 for query tunning the below query |
5 |
2663 |
Thu, 17 November 2011 03: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) |
|
Slow running query -Explain plan attached-pls help! ORacle,11g,windows server2003 By: aviana on Wed, 16 November 2011 |
2 |
2408 |
Wed, 16 November 2011 13:54 By: LKBrwn_DBA ![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 inserts Slow (merged 6) oracle 10g XP |
7 |
2984 |
Wed, 16 November 2011 07:05 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) |
|
Shrinking index Oracle 10.2.0.3,Windows server 2003 64 bit |
7 |
2574 |
Wed, 16 November 2011 01:30 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) |
|
index monitoring oracle 10g |
23 |
6855 |
Fri, 11 November 2011 16:31 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) |
|
Merge statement tuning for 100M records in table ( 1 2) By: sachi09 on Mon, 31 October 2011 |
49 |
10146 |
Tue, 08 November 2011 04:35 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) |
|
Need help (2 Merged) |
14 |
3834 |
Tue, 08 November 2011 00:53 By: supriyadba1 ![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 11.2.0.2 By: singh09 on Sun, 06 November 2011 |
3 |
2982 |
Mon, 07 November 2011 01:17 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) |
|
Reducing Hard parses Oracle 10g, 10.2.0.3.0, Linux By: Rags123 on Wed, 02 November 2011 |
30 |
14212 |
Fri, 04 November 2011 05:00 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) |
|
Doubt about Tuning SQL Oracle 11g R2 By: aucrun on Thu, 03 November 2011 |
8 |
3100 |
Thu, 03 November 2011 12:25 By: aucrun ![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 tunning help required 11.1.0.7 |
4 |
2328 |
Wed, 02 November 2011 13:12 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) |
|
Compare current row values with previous one until mismatch Oracle 10g |
7 |
3035 |
Wed, 02 November 2011 05: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) |
|
Parallelism in queries |
4 |
2080 |
Sun, 30 October 2011 23:55 By: manojbe09 ![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) |
|
Bulk update performance issue Oracle 11g, Windows XP By: ninan on Sat, 01 October 2011 |
26 |
10084 |
Sat, 29 October 2011 19:54 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) |
|
buffer busy wait Linux 2.6.18-92.1.13.el5 |
20 |
7508 |
Fri, 28 October 2011 16:12 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) |
|
Reading explain plan 11GR2 RAC on Windows |
4 |
2602 |
Fri, 28 October 2011 10:21 By: Vackar ![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 diff Oracle 10.2.0.1.0 CentOS 5 By: Vackar on Tue, 25 October 2011 |
12 |
3309 |
Fri, 28 October 2011 06:41 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) |
|
Tuning my first query 11GR2 RAC on Windows |
10 |
3664 |
Thu, 27 October 2011 04: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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Are Stale STATS Any Good v10.2.0.4 SunOS 5.10 x86_64 By: drovnik on Tue, 18 October 2011 |
2 |
2546 |
Thu, 27 October 2011 02:31 By: drovnik ![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) |
|
Proving OTT undo reads In post |
3 |
2570 |
Wed, 26 October 2011 08:50 By: Roachcoach ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |