|
|
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 |
2713 |
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 |
7181 |
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 |
2535 |
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 |
2276 |
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 |
5320 |
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 |
1792 |
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 |
3399 |
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 |
2146 |
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 |
1845 |
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 |
5739 |
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 |
2328 |
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 |
7309 |
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 |
2716 |
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 |
5014 |
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 |
4666 |
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 |
2853 |
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 |
10149 |
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 |
3610 |
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 |
17910 |
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 |
2923 |
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 |
2744 |
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 |
2221 |
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 |
5322 |
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 |
2553 |
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 |
7684 |
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 |
10321 |
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 |
4589 |
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 |
6403 |
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 |
7130 |
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 |
2454 |
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 |
4498 |
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 |
4037 |
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 |
9531 |
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 |
3352 |
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 |
2122 |
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 |
2402 |
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 |
2237 |
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 |
2219 |
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 |
1613 |
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 |
3042 |
Mon, 05 October 2009 07:51 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |