|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
UNION and UNION ALL discrepancy Oracle 9i, Solaris By: bijou on Fri, 01 August 2008 |
13 |
5456 |
Thu, 07 August 2008 21:52 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 is used still problem By: bubbly on Wed, 06 August 2008 |
5 |
1705 |
Thu, 07 August 2008 03:36 By: sunil_v_mishra ![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 estimate query response time and number of rows without executing query Oracle 10.2.0.3 on Sun Solaris 5.10 |
4 |
2406 |
Thu, 07 August 2008 02:52 By: gkodakalla ![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 assist to delete histograms oracle 10.2.0.3 solaris 10 |
2 |
3011 |
Wed, 06 August 2008 12:09 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) |
|
Help me tune the query Oracle 9.0.0.2 |
1 |
1353 |
Wed, 06 August 2008 11:19 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) |
|
How gathering of stats/ analyze stats work? 10g By: beetel on Wed, 06 August 2008 |
4 |
1705 |
Wed, 06 August 2008 08:48 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) |
|
sql consumes more cpu oracle 10g, 10.2.0.1, Linux AS 3 By: guyj on Wed, 06 August 2008 |
5 |
1834 |
Wed, 06 August 2008 05:56 By: rajatratewal ![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) |
|
to decide pctused,pctfree in Oracle8i (merged) |
3 |
1454 |
Wed, 06 August 2008 04:11 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) |
|
buffer cache handles oracle 10g |
6 |
3538 |
Wed, 06 August 2008 02:17 By: holdersav2000 ![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) |
|
selectivity in index usage Oracle 9i |
3 |
1553 |
Tue, 05 August 2008 10: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) |
|
QUERY REWRITING 9.2.0.7.WONDOWS SERVER 2003 |
2 |
1775 |
Tue, 05 August 2008 08:24 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 link query. 10.2.0.3 |
1 |
4170 |
Mon, 04 August 2008 16:26 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) |
|
Merging large amounts of data into large tables oracle 10 |
6 |
3484 |
Mon, 04 August 2008 14:04 By: zzasteven ![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 suggestion for a better query. |
6 |
3038 |
Mon, 04 August 2008 07:27 By: pravin3032 ![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 Methods & Books 9i/10g |
1 |
1477 |
Sun, 03 August 2008 11:51 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) |
|
CREATE TABLE using SEQUENCE ORacle 9i |
3 |
3592 |
Sun, 03 August 2008 01: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) |
|
statspack report Oracle 9i |
8 |
4600 |
Sun, 03 August 2008 01:40 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) |
|
HIGH no of LOCKS exclusive in tables for UPDATE Statement Oracle 9.2.0.8 By: udara on Mon, 21 July 2008 |
3 |
1990 |
Sat, 02 August 2008 20:59 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) |
|
criteria for partitioning Oracle 10gR2 |
5 |
2253 |
Fri, 01 August 2008 01:24 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) |
|
Adding INDEX_DESC hint slow down the query Oracle9i |
3 |
5056 |
Thu, 31 July 2008 13:28 By: shrinika ![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) |
|
Report hangs ORACLE 10.2.0.4.0, WINDOWS 2003 SERVER SP2 |
1 |
1594 |
Thu, 31 July 2008 08:57 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) |
|
Performance issues after Database Hang during backup Oracle 10g |
7 |
2876 |
Thu, 31 July 2008 06:28 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) |
|
ora-04030 |
8 |
11066 |
Thu, 31 July 2008 05:42 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) |
|
Reverse key index |
8 |
2469 |
Wed, 30 July 2008 22:52 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 Oracle 9i(9.2.0.1.0) |
8 |
2537 |
Tue, 29 July 2008 22: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) |
|
Stale Statisics Oracle 10g,Rel 2 ,Linux AS4 |
1 |
1386 |
Tue, 29 July 2008 05:24 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) |
|
gather stats |
3 |
1451 |
Tue, 29 July 2008 03:19 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) |
|
Tuning 'LIKE' Clause Oracle,10g,Windows XP |
2 |
2178 |
Mon, 28 July 2008 14:24 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) |
|
type tables in plsql/ variable IN list |
3 |
1962 |
Fri, 25 July 2008 17: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) |
|
need help to optimize the query oracle 10.2.0.3 solaris 10 |
1 |
1388 |
Thu, 24 July 2008 22:26 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) |
|
need assistance to tune the query solarin 5.10, oracle 10.2.0.3 |
8 |
2536 |
Thu, 24 July 2008 22:22 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) |
|
Testing of generated test data from Sequence oracle 10g |
1 |
1378 |
Thu, 24 July 2008 13:08 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) |
|
how find SGA size is sufficient or not? oracle 10.2.0.3 solaris 10 |
8 |
17130 |
Thu, 24 July 2008 01: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) |
|
Is possible to turn the following into a view Oracle 10g |
4 |
1765 |
Wed, 23 July 2008 16:03 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) |
|
high cost oracle 10g,TOAD |
12 |
2796 |
Wed, 23 July 2008 10:28 By: balaji1482 ![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) |
|
Avoiding : ORA-00470: LGWR process terminated with error |
1 |
17863 |
Wed, 23 July 2008 07:54 By: sunil_v_mishra ![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 issues in insert stmt Oracle, 10g, windows XP |
1 |
1420 |
Wed, 23 July 2008 05: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) |
|
Slow query with customer data Oracle 10.2.0.3.0 on Solaris 10 By: elmu on Thu, 17 July 2008 |
8 |
3925 |
Tue, 22 July 2008 13:19 By: Kriptas ![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) |
|
Better way to handle this query? Oracle 9i By: Olivia on Tue, 22 July 2008 |
5 |
2783 |
Tue, 22 July 2008 11:00 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) |
|
optimize queries oracle 10g |
4 |
2032 |
Tue, 22 July 2008 08:30 By: michael_bialik ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |