|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
optimisation oracle 10g |
8 |
2560 |
Thu, 05 November 2009 17:53 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) |
|
Optimizing the procedure 10.2.0.4, Solaris 10 By: khan500 on Tue, 20 October 2009 |
12 |
7068 |
Thu, 05 November 2009 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) |
|
How to Query Large table .? 10G By: MR[T] on Mon, 26 October 2009 |
5 |
2418 |
Thu, 05 November 2009 17:30 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) |
|
lock issue oracle 10g , windows By: RAY_HT on Sun, 01 November 2009 |
3 |
2169 |
Thu, 05 November 2009 17:26 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 reduce CPU Utilization 10.2.0.2.0 ,windows |
11 |
5223 |
Thu, 05 November 2009 17: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) |
|
Tune the code without autotrace+ dictionary - fed up with DBA advice (merged 3) Oracle 9i |
2 |
1699 |
Thu, 05 November 2009 16:48 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 Catche 10.2.0.1.0 Redhat Linux 4 |
2 |
3273 |
Thu, 05 November 2009 16:38 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) |
|
HMV scripts 9.2.0.7 |
4 |
2048 |
Thu, 05 November 2009 05: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) |
![icon7.gif](/forum/images/message_icons/icon7.gif) |
Migration from Oracle8i to Oracle 10G Unix server |
3 |
1744 |
Thu, 05 November 2009 02:10 By: Its_me_ved ![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 statements were not shared due to the usage of literals. This resulted in additional hard parses oracle 10.2.0.1.0,Redhat Linux 4 |
2 |
5630 |
Wed, 04 November 2009 03:29 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) |
|
performance issue wtith single instance database linux 2 Advance server |
5 |
2232 |
Wed, 04 November 2009 00:04 By: sherkhan@infodynamic.net ![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) |
|
ORA-02097 AND ORA-00439 10.2.0.1.0 Redhat Linux 4 |
1 |
7212 |
Tue, 03 November 2009 02:15 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) |
|
undo usage in a query oracle 10.2.0.4, Sun 5.10 |
1 |
2616 |
Tue, 03 November 2009 01:21 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) |
|
Advanced Queuing correlation id Oracle 10g Release 10.2.0.1.0 |
2 |
4906 |
Tue, 03 November 2009 00:48 By: johnbach ![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) |
|
BITMAP INDEX performance issue 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production |
13 |
4484 |
Mon, 02 November 2009 03:24 By: johnbach ![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 oracle change the sql plan from hash join to nested loop when the system resource load is high? oracle RDBMS 10g RAC HP UNIX |
2 |
2750 |
Sat, 31 October 2009 07:29 By: davidh2y ![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) |
|
Single Query suddenly goes slow until restart or change Oracle 10g EE 10.1.0.4.0, Windows 2003 Server |
3 |
10050 |
Fri, 30 October 2009 16:42 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) |
|
INDEX_STATS.HEIGHT > 3 HP UNIX / 9.2.0.7 By: Brayan on Fri, 30 October 2009 |
3 |
3489 |
Fri, 30 October 2009 03:45 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) |
|
INTERNAL_FUNCTION in execution plan By: McLaud on Thu, 22 October 2009 |
9 |
17616 |
Mon, 26 October 2009 10:50 By: McLaud ![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 select is not executed Oracle 10g, Solaris 10 By: gym963 on Thu, 22 October 2009 |
10 |
2760 |
Mon, 26 October 2009 06: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) |
|
explain plan difference between 9i and 10g oracle 9i,oracle 10g By: manoj12 on Mon, 26 October 2009 |
2 |
2649 |
Mon, 26 October 2009 05:07 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) |
|
Performance on single query Oracle 9i |
4 |
2116 |
Sat, 24 October 2009 16:13 By: Its_me_ved ![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 containing 7 table joins |
28 |
5110 |
Fri, 23 October 2009 04:01 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) |
|
regarding session time out |
4 |
2443 |
Fri, 23 October 2009 03:07 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) |
|
How to view Oracle counters in windows performance monitor Oracle 9i |
0 |
7591 |
Wed, 21 October 2009 01:16 By: balaji_cg ![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 10g/windows |
4 |
10180 |
Tue, 20 October 2009 07:33 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) |
|
Execution plan for every SQL, executed by user Oracle10g By: McLaud on Wed, 14 October 2009 |
9 |
4504 |
Mon, 19 October 2009 04:21 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) |
|
Analyze table hangs for hours Oracle 10.2.0.4 ,linux |
3 |
6297 |
Wed, 14 October 2009 03:30 By: balakrishnay ![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 clear lock???? Oracle 10g By: im_vnew on Sun, 11 October 2009 |
6 |
6998 |
Tue, 13 October 2009 21:25 By: rahulvb ![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 Manager Oracle 9i |
5 |
2334 |
Tue, 13 October 2009 11:14 By: balaji_cg ![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 on Performance tuning Oracle 10.1.0.2, Windows 2003 |
6 |
4354 |
Fri, 09 October 2009 16:39 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) |
|
Slow queries, configuration problem ? Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit By: daff24 on Wed, 07 October 2009 |
8 |
3922 |
Fri, 09 October 2009 16:37 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) |
|
regarding AWK in oracle oracle10g, 10.2.0.2.0, AIX52 |
0 |
9428 |
Fri, 09 October 2009 06:59 By: chandu_imax ![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) |
|
Hints within a query that reads from view 10g By: beetel on Wed, 07 October 2009 |
9 |
3231 |
Thu, 08 October 2009 12:04 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) |
|
Predicate Informationn in PLAN Oracle 10.2.0.3 By: Olivia on Wed, 07 October 2009 |
4 |
2013 |
Wed, 07 October 2009 11:21 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) |
|
Slow performance for Some queries Oracle 10g , solaris |
3 |
2294 |
Wed, 07 October 2009 11:19 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) |
|
db_block_buffer oracle 8i |
3 |
2135 |
Wed, 07 October 2009 05:12 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) |
|
Pctfree 9i |
5 |
2098 |
Tue, 06 October 2009 02:28 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) |
|
Histogram Issue oracle 9.2.0.6 |
3 |
1516 |
Mon, 05 October 2009 13:23 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) |
|
hard parse for SQL (merged) |
4 |
2926 |
Mon, 05 October 2009 07:51 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |