|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to re-write th eprocedure...? oracle 9.0.1 |
5 |
1872 |
Tue, 01 April 2008 23:28 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) |
|
optimzier RULE 10, sun |
6 |
2586 |
Tue, 01 April 2008 21:56 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) |
|
Bucketing Query Performance |
19 |
7703 |
Tue, 01 April 2008 17: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) |
|
Oracle execution plan help needed Oracle 8i |
2 |
1289 |
Tue, 01 April 2008 07:22 By: gangulyz ![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) |
|
'EXISTS' vs 'IN' By: vkrn on Tue, 01 April 2008 |
1 |
1623 |
Tue, 01 April 2008 00: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) |
|
SQL Query behaving weirdly in 10g 10g |
4 |
1982 |
Mon, 31 March 2008 16:37 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) |
|
db_cache_size Oracle 10.2.3, SunOS sun11 5.9 |
6 |
13709 |
Mon, 31 March 2008 11:33 By: lotusdeva ![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) |
|
Statspack oracle 9i |
4 |
1783 |
Mon, 31 March 2008 06:31 By: sudhir1582 ![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 performance tuning concept oracle 10g |
3 |
1466 |
Mon, 31 March 2008 05: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) |
|
performance problem with DATE field Comparison Oracle 9i |
4 |
2828 |
Mon, 31 March 2008 02:23 By: me_arindam ![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 Materialized View using Union All Operator Windows, Oracle 9iR2 |
4 |
5223 |
Sun, 30 March 2008 22:07 By: ajitpal.s ![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) |
|
bulkloading oracle9i |
1 |
1461 |
Fri, 28 March 2008 08:22 By: Frank Naude ![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 takes long time to execute first time |
9 |
3990 |
Thu, 27 March 2008 17:11 By: emilSverige ![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 do update statistics on oracle 10g database 10g |
3 |
7412 |
Thu, 27 March 2008 12: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) |
|
CAN ANY ONE PROVIDE ME THE STATSPACK SCRIPTS |
4 |
1869 |
Thu, 27 March 2008 05:37 By: manoj12 ![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) |
|
Check and telll whether the following configuration is correct or not |
10 |
2145 |
Thu, 27 March 2008 00:19 By: manoj12 ![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) |
|
Summary table Update statement. By: arksjd on Wed, 26 March 2008 |
3 |
1428 |
Wed, 26 March 2008 21:00 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) |
|
Partitioning effect |
4 |
1388 |
Wed, 26 March 2008 06:51 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) |
|
Usuage of hints. By: vkrn on Tue, 25 March 2008 |
2 |
1310 |
Tue, 25 March 2008 18:34 By: gintsp ![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 HASH GROUP BY & SORT GROUP BY performance Oracle 10g |
8 |
26827 |
Tue, 25 March 2008 18:32 By: gintsp ![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) |
|
altering rollback segment oracle 9i |
5 |
1871 |
Tue, 25 March 2008 15: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) |
|
usuage of DECODE By: vkrn on Tue, 25 March 2008 |
9 |
2331 |
Tue, 25 March 2008 09:01 By: vkrn ![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 of a query |
1 |
1350 |
Tue, 25 March 2008 02:23 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) |
|
When I should increase the size of datafile,tablespace,redolog files as well as sort area size Oracle 9i,Windows XP/2000 |
4 |
2456 |
Mon, 24 March 2008 08:27 By: manoj12 ![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) |
|
BAD performing query, OR Clause Oracle 10g By: stghag on Sat, 22 March 2008 |
5 |
2126 |
Sun, 23 March 2008 07:10 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) |
|
ADDM Findings from OEM 10g Rel 2 |
0 |
8555 |
Fri, 21 March 2008 10:52 By: azeem87 ![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) |
|
Analytical Functions and Backward Index scans |
17 |
12193 |
Thu, 20 March 2008 16:54 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) |
|
Efficient Data Management. Solaris , 10.2g |
2 |
1547 |
Thu, 20 March 2008 07:43 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Selection of driving table By: vkrn on Tue, 18 March 2008 |
8 |
2275 |
Thu, 20 March 2008 05:25 By: vkrn ![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) |
|
About Oracle Database Link Solaris , 10.2g |
7 |
2317 |
Thu, 20 March 2008 04:50 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 can we write this query in a better or more efficeint way? oracle 10g |
4 |
2793 |
Thu, 20 March 2008 04:47 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 |
2 |
1335 |
Thu, 20 March 2008 03:48 By: msmallya ![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) |
|
Can anybody explain this index oracle 10g, AIX |
6 |
1994 |
Wed, 19 March 2008 17:23 By: cycloscott ![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) |
|
9i-Clearing cache and memory oracle 9i, Aix |
3 |
1518 |
Wed, 19 March 2008 12:15 By: shlomi_bt ![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 OF A QUERY ; By: sispk6 on Wed, 19 March 2008 |
4 |
1945 |
Wed, 19 March 2008 09:29 By: ThomasG ![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) |
|
database configuration of SGA,shared pool size,redolog buffer and sort area size (merged) |
15 |
6885 |
Wed, 19 March 2008 06:56 By: manoj12 ![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) |
|
tablespace related |
1 |
1187 |
Wed, 19 March 2008 06: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) |
|
Simple query going for a full table scan By: Flash on Tue, 18 March 2008 |
4 |
1953 |
Wed, 19 March 2008 01:19 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) |
|
Procedure taking long time to execute |
16 |
4538 |
Tue, 18 March 2008 22:00 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) |
![icon6.gif](/forum/images/message_icons/icon6.gif) |
Database parameters for tuning |
2 |
3417 |
Tue, 18 March 2008 04:57 By: manoj12 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |