|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Help with SQL Optimization (merged) By: Creems on Fri, 05 December 2008 |
5 |
3349 |
Fri, 05 December 2008 19:15 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) |
|
Production Performance Issue Oracle 10.2.0.3 + Sun Solaris 5.9 By: babuknb on Fri, 05 December 2008 |
5 |
2077 |
Fri, 05 December 2008 13:56 By: babuknb ![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 mysql, 5.0, XP |
3 |
1637 |
Fri, 05 December 2008 02:20 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) |
|
Reg Reorg activity oracle 9206 By: anand47 on Fri, 05 December 2008 |
3 |
2580 |
Fri, 05 December 2008 02:18 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) |
|
whats syntax to keep table in memory? AIX 10G |
7 |
3094 |
Thu, 04 December 2008 23:18 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) |
|
LOCKWAIT 10g AIX |
10 |
3752 |
Thu, 04 December 2008 12:26 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 find the query optimized or Not? 9i |
10 |
2865 |
Thu, 04 December 2008 06:06 By: user71408 ![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) |
|
Createing index Oracle 10g By: Olivia on Fri, 28 November 2008 |
9 |
2853 |
Thu, 04 December 2008 05:30 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) |
|
how to find list of sql statements ran in the past time. oracle 10.2.0.3 |
1 |
2026 |
Mon, 01 December 2008 13: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) |
|
ORACLE V$SQL issue .... |
1 |
1948 |
Mon, 01 December 2008 08:15 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) |
|
Clob column on remote database Oracle 9i By: Hidden on Thu, 27 November 2008 |
2 |
2594 |
Fri, 28 November 2008 04:57 By: Hidden ![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 Null' versus '=' 10g By: beetel on Thu, 27 November 2008 |
3 |
2126 |
Thu, 27 November 2008 20:27 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) |
|
Creating SQL tuning set and how it will help Oracle 10g By: Olivia on Thu, 27 November 2008 |
2 |
2278 |
Thu, 27 November 2008 04:15 By: Olivia ![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) |
|
Contention oracle 9i on AIX By: dbcop on Fri, 21 November 2008 |
9 |
4736 |
Wed, 26 November 2008 22:38 By: dbcop ![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 on Partition Table (merged) |
6 |
4086 |
Wed, 26 November 2008 20:09 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) |
|
dbms_stats.gather_table_stats oracle 10g |
2 |
5028 |
Wed, 26 November 2008 12:50 By: Mahesh Rajendran ![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) |
|
procedure running with no end |
3 |
1666 |
Wed, 26 November 2008 01:28 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) |
|
Performance tuing using FIRST_ROWS Oracle 9.2.0.1.0 |
4 |
3096 |
Tue, 25 November 2008 23:19 By: unmeshmohanan ![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 Feature Oracle 10g By: Olivia on Tue, 25 November 2008 |
2 |
1821 |
Tue, 25 November 2008 11:38 By: Olivia ![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 avoid union? Oracle 10g,Windows 2003 |
2 |
5013 |
Tue, 25 November 2008 01:49 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) |
|
Template to capture Details about successful Oracle Performance Improvement Oracle 10.2.0.4 on Sun Solaris |
1 |
2228 |
Mon, 24 November 2008 09:22 By: Mahesh Rajendran ![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 I/O disk writes Oracle 10.2g |
3 |
1679 |
Mon, 24 November 2008 09:14 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) |
|
Index Oracle 10g |
2 |
1823 |
Mon, 24 November 2008 06:23 By: ora_2007 ![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 size and sql performance By: djeevan on Sun, 23 November 2008 |
2 |
2130 |
Sun, 23 November 2008 19:34 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) |
|
INIT.ORA parameters to SCALE UP INSTANCE 10.2.0.3 ON LINUX By: andydba on Wed, 19 November 2008 |
7 |
3759 |
Sun, 23 November 2008 17:03 By: andydba ![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 make use of indexes? Oracle 10g,10.2.0.1.0,Windows 2003 |
7 |
2571 |
Sat, 22 November 2008 01:06 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) |
|
performance problems when using ...like string||'%'; oracle 11g By: jsulc on Thu, 20 November 2008 |
6 |
2375 |
Fri, 21 November 2008 11:09 By: jsulc ![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) |
|
The difference between sql_text in v$sqlarea and v$sqltext Oracle 9i, 9.2.0.2, Linux By: efachim on Tue, 18 November 2008 |
3 |
4879 |
Fri, 21 November 2008 10:59 By: efachim ![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 this a 10g bug? Oracle 10g, 10.2.0.2, Linux By: efachim on Tue, 18 November 2008 |
9 |
3993 |
Fri, 21 November 2008 10:52 By: efachim ![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) |
|
Understand how optimizer works Oracle 9i, AIX |
7 |
2649 |
Fri, 21 November 2008 10:04 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) |
|
Oracle Tuning - Explain plan Oracle 9i, AIX |
5 |
4064 |
Fri, 21 November 2008 10: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) |
|
Synonyms and dblinks Oracle 9i |
4 |
2486 |
Fri, 21 November 2008 08:21 By: Srinandini ![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-12013: updatable materialized views must be simple enough to do fast refresh Oracle 10g |
2 |
5336 |
Thu, 20 November 2008 22:31 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Query optimization Oracle 10G |
2 |
2145 |
Thu, 20 November 2008 22: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) |
|
Generic data models - academic questions By: nmcsw98 on Tue, 18 November 2008 |
3 |
3251 |
Thu, 20 November 2008 21:56 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) |
|
Tuning a small query Oracle 10g |
6 |
2154 |
Thu, 20 November 2008 05:02 By: magesh_magi1 ![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) |
|
Querry performance |
5 |
2304 |
Wed, 19 November 2008 22:58 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) |
![icon8.gif](/forum/images/message_icons/icon8.gif) |
parallel hint 10g |
1 |
1671 |
Wed, 19 November 2008 03:41 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) |
|
Materialized View Refresh Performance Oracle 10g |
2 |
3513 |
Tue, 18 November 2008 13:30 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) |
|
jobsq slave 10g ,linux |
1 |
1549 |
Tue, 18 November 2008 01:07 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |