|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Change in explain plan due to Oracle upgrade Oracle 10.2.0.4.0, Windows Server 2003 |
5 |
4268 |
Thu, 16 December 2010 19:14 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) |
|
Tune the query Oracle9i |
4 |
2133 |
Wed, 15 December 2010 17:17 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) |
|
dbms_job oracle 10g |
9 |
2946 |
Wed, 15 December 2010 14:23 By: Haraprasad Hota ![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) |
|
When to use sub-query and when to use join 11g R1, Windows |
9 |
3275 |
Wed, 15 December 2010 01:31 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) |
|
dbms_lob.append oracle 10g |
6 |
6620 |
Tue, 14 December 2010 12:10 By: prashant_ora ![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) |
|
help on Query tuning oracle 10g |
4 |
2332 |
Tue, 14 December 2010 06:25 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 leading columns Oracle 10.2.0.3 |
4 |
4183 |
Tue, 14 December 2010 05:53 By: pointers ![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 usage history Oracle 10g, Sun OS |
6 |
17968 |
Mon, 13 December 2010 10:41 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) |
|
SID column in V$SESSION ORCLE 10g.2 WINDOWS XP |
2 |
1943 |
Sun, 12 December 2010 09:01 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 are the best practices with indexes? |
3 |
2839 |
Sat, 11 December 2010 03:48 By: Littlefoot ![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 using rownum in where cluase with millions of records Oracle 11g , Windows By: pradies on Wed, 08 December 2010 |
10 |
3187 |
Thu, 09 December 2010 11:53 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) |
|
Creating index on base tables of a view By: mmtr on Thu, 09 December 2010 |
1 |
2796 |
Thu, 09 December 2010 08:43 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) |
|
Expensive Query Oracle 11g |
5 |
3724 |
Mon, 06 December 2010 05:53 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) |
|
SQL query performance tuning Oracle 11g Suse Linux 11 |
5 |
11062 |
Sat, 04 December 2010 00: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) |
|
Trailing issue during processing huge data Oracle 9i |
1 |
1624 |
Fri, 03 December 2010 02:01 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) |
|
Confusion about Partitioning 11g,HP-UNIX B11.23 |
1 |
1713 |
Thu, 02 December 2010 08:58 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) |
|
Why oracle doesn't use the index? |
9 |
3039 |
Thu, 02 December 2010 07:51 By: Roachcoach ![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) |
|
Analysys about a single oracle table red hat linux 4/oracle 10g2 |
7 |
3279 |
Wed, 01 December 2010 08:43 By: Constancy ![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 - Query Performance Oracle Database 11g Release 11.1.0.6.0, Windows Server 2003 By: MSAM123 on Mon, 29 November 2010 |
25 |
4835 |
Wed, 01 December 2010 04:05 By: MSAM123 ![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) |
|
Copy data's from Transaction database(db1) to Reporting database (db2) Windows 2000, Oracle 10g |
4 |
2434 |
Fri, 26 November 2010 04: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) |
|
Performance issue for distributed transaction (2PC) Oracle RDBMS 10.2.0.4, HP-UX 11.31 By: samg4ug on Fri, 26 November 2010 |
0 |
10378 |
Fri, 26 November 2010 02:17 By: samg4ug ![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) |
|
Improve performance of create statements on a highly fragmented disk |
7 |
8978 |
Wed, 24 November 2010 09:33 By: Roachcoach ![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 Taking More CPU time (merged) Oracle 10g ,Sun Solaris |
4 |
2718 |
Wed, 24 November 2010 00:50 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) |
|
Performance tuning (cache sub query results) Oracle 10g By: yosikal on Sun, 21 November 2010 |
1 |
3440 |
Sun, 21 November 2010 07:53 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) |
|
order by Oracle9i |
3 |
2450 |
Fri, 19 November 2010 15:23 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) |
|
Tune the query Windows 2000, Oracle 10g |
1 |
1953 |
Fri, 19 November 2010 08:50 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) |
|
Index with NVL By: ss1_3 on Fri, 19 November 2010 |
2 |
2866 |
Fri, 19 November 2010 08:00 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) |
|
Method of Tuning Database - row reduction |
6 |
3076 |
Thu, 18 November 2010 23: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) |
|
Help me find the SQL using hash value? (ORA-00060) rdbms 10.2, sles10 x64, three node RAC By: hristo on Thu, 18 November 2010 |
2 |
15003 |
Thu, 18 November 2010 08:48 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) |
|
Query running slow Oracle 10g By: virmahi on Thu, 18 November 2010 |
6 |
2665 |
Thu, 18 November 2010 04:49 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) |
|
Procedure performance issue on new DB import? Oracle 11g |
13 |
3611 |
Mon, 15 November 2010 20:14 By: chris32680 ![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) |
|
STOPKEY & Index Use 10.2.0.4.0 - 64bi, Windows 2003 By: annagel on Sat, 06 November 2010 |
15 |
6845 |
Mon, 15 November 2010 13:42 By: annagel ![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) |
|
a lot of 'EXISTS' in query Oracle 10g By: mape on Mon, 15 November 2010 |
12 |
11328 |
Mon, 15 November 2010 12:14 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) |
|
Slow Running Query |
20 |
4448 |
Mon, 15 November 2010 03:00 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) |
|
Oracle Row Chaining and Migration Oracle 10.2.0.4 AIX 6L |
4 |
2637 |
Sat, 13 November 2010 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) |
|
which index is best for query performance Oracel 11.1 Red Hat |
5 |
2247 |
Sat, 13 November 2010 08:23 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) |
|
Order by Clause is too slow Oracle 11g r2 centos linux |
4 |
15020 |
Fri, 12 November 2010 16: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) |
|
query problem |
5 |
2784 |
Wed, 10 November 2010 03:43 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) |
|
MV when detailed table consists of Millions of records By: ind9 on Tue, 09 November 2010 |
5 |
8083 |
Tue, 09 November 2010 04:47 By: ind9 ![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 working very slow oracle 10.2.0.4.0 |
9 |
3821 |
Tue, 09 November 2010 02:55 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |