|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How many times Queries/DML statement run over a week. Solaris, 10.2.0.3 |
3 |
1510 |
Tue, 22 July 2008 08:29 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Need help to Optimize this query By: srajan on Mon, 21 July 2008 |
2 |
1749 |
Tue, 22 July 2008 05:49 By: rajatratewal ![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 enable Bitmap Index Oracle 10G Express Edition |
1 |
2524 |
Mon, 21 July 2008 08:07 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) |
|
oracle9i Precaution for defining VARCHAR2(4000) |
3 |
1696 |
Sun, 20 July 2008 00: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) |
|
maximum number of process exceeded oracle 9i-9.2.0.1.0-Red Hat Linux RHAS 2.1 |
4 |
2298 |
Sat, 19 July 2008 03:34 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) |
|
user I/O and read by other session waits oracle 10.2.0.3 soalris 10 |
0 |
8642 |
Fri, 18 July 2008 17:39 By: kumar.joy ![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,9.2.0.8,window |
9 |
2385 |
Fri, 18 July 2008 12:11 By: Kriptas ![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) |
|
Effect on physical standby database oracle 9i-9.2.0.1.0-Red Hat Linux RHAS 2.1 |
1 |
2174 |
Fri, 18 July 2008 00: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) |
|
replacing with single update statement Oracle 10g |
8 |
2179 |
Thu, 17 July 2008 22:40 By: kumarbo7 ![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 runs SLOWER on XEON than Pentium Dual Oracle 8.1, Windows 2003 Server |
7 |
2604 |
Thu, 17 July 2008 08:09 By: tranzicija ![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 caching oracle, 9i R1, Win XP |
2 |
1473 |
Wed, 16 July 2008 07:32 By: JRowbottom ![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) |
what are the various steps of query processing Oracle 9i |
3 |
1843 |
Tue, 15 July 2008 11: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) |
![icon6.gif](/forum/images/message_icons/icon6.gif) |
Index Partitioning Oracle 9i,version-92010,OS-Linux RHAS 2.1 |
9 |
2358 |
Tue, 15 July 2008 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) |
|
pls help to reduce some loop 10g |
16 |
3426 |
Mon, 14 July 2008 23:11 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) |
|
Oracle Query Tuning |
3 |
3506 |
Mon, 14 July 2008 21:59 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) |
|
Nasty query re-write Oracle 9i |
25 |
6161 |
Mon, 14 July 2008 10:27 By: svguerin3 ![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) |
query performance |
1 |
1288 |
Mon, 14 July 2008 07:59 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) |
|
how to force parallel to subquery of select statement ? |
7 |
3705 |
Mon, 14 July 2008 03:13 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) |
|
Create Index ? |
3 |
1550 |
Sun, 13 July 2008 10: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) |
|
GATHERING STATISTICS |
6 |
2094 |
Sat, 12 July 2008 17:46 By: Kriptas ![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) |
Bind variable in a data warehouse By: stegau on Wed, 09 July 2008 |
4 |
2901 |
Fri, 11 July 2008 07:54 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) |
|
Query running slow Oracle 9i R2, Sun Soalris |
8 |
2614 |
Thu, 10 July 2008 13:35 By: poratips ![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 TRACE : maximum number of recursive SQL levels (50) exceeded Linux 2.6.9-5.ELsmp x86_64 x86_64 x86_64 GNU/Linux |
7 |
5300 |
Thu, 10 July 2008 05:54 By: JRowbottom ![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 (Multicolumn Range Parttiion Pruning) 10.2.0.2 |
3 |
3350 |
Wed, 09 July 2008 11:38 By: JRowbottom ![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 plan change By: jinga on Wed, 09 July 2008 |
3 |
1521 |
Wed, 09 July 2008 08:30 By: tahpush ![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 is slow with CLOB data oracle9i |
9 |
8548 |
Tue, 08 July 2008 10:47 By: shrinika ![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) |
|
Optimizing the Query Oracle 10g release 2, OS Server Unix, OS Client Window XP |
1 |
1554 |
Tue, 08 July 2008 07:34 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) |
|
What do Oracle waits mean By: lunaut on Mon, 07 July 2008 |
2 |
2257 |
Mon, 07 July 2008 14:17 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) |
|
Materialized view not getting used Oracle 10g By: vkumar on Mon, 07 July 2008 |
1 |
1601 |
Mon, 07 July 2008 09:46 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) |
|
UNION causing slow performance Oracle 9i |
21 |
37783 |
Sun, 06 July 2008 08:27 By: Kriptas ![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 taking much time Oracle 10g |
15 |
3318 |
Sat, 05 July 2008 14:17 By: Kriptas ![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 space estimation ? |
4 |
1611 |
Sat, 05 July 2008 10: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) |
|
Oracle10g very slow on windows2003 server Oracle10g |
1 |
2539 |
Sat, 05 July 2008 08:13 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) |
|
How heavy an AWR snapshot is 10g By: lunaut on Wed, 02 July 2008 |
3 |
1604 |
Fri, 04 July 2008 06:03 By: alanm ![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) |
|
Problem sorting and inserting huge data (merged) |
7 |
2306 |
Thu, 03 July 2008 17:45 By: coleing ![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) |
|
Generate SQL Statements from 10046 trace file |
0 |
6282 |
Thu, 03 July 2008 11:26 By: jochenbandhauer ![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) |
|
free command 10.2.0.4 By: mafc73 on Wed, 02 July 2008 |
3 |
1619 |
Thu, 03 July 2008 08:53 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 running slow oracle,10202,AIX By: areeb on Tue, 01 July 2008 |
1 |
2659 |
Tue, 01 July 2008 13:39 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) |
|
multiple dbwr processes and multiple archver process Oracle 9.0.2.0.6 Windows Server 2003 |
3 |
3291 |
Tue, 01 July 2008 07:25 By: alanm ![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 way to partition my table |
7 |
2808 |
Mon, 30 June 2008 23:34 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |