|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Moving table into same tablespace oracle9i |
2 |
1400 |
Tue, 20 May 2008 15:20 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) |
|
cursor: pin S wait on X in Oracle 10.2.0.4 Oracle 10.2.0.4 on RHEL 4 |
2 |
11945 |
Mon, 19 May 2008 16:27 By: moatazmizo ![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 i tune database and sql Oracle 9i (9.2.0.1) on Windows 2003 Server 32 bit |
2 |
1900 |
Mon, 19 May 2008 09: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) |
|
Please help tuning SQL Oracle 9i By: Ivan on Fri, 16 May 2008 |
2 |
1887 |
Mon, 19 May 2008 07:50 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 Get Previous Version Of Stats Gathered Oracle,9.2.0.6.0,XP |
3 |
1456 |
Mon, 19 May 2008 06: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) |
|
Find the query running time oracle9i |
2 |
1297 |
Fri, 16 May 2008 17:03 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) |
|
Oracle NOT IN query is slow Oracle 10g on Win2k3 By: nmaier on Thu, 15 May 2008 |
3 |
9338 |
Fri, 16 May 2008 12:04 By: nmaier ![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) |
|
connect by prior is killing me again Oracle 10g By: zim327 on Thu, 15 May 2008 |
9 |
15301 |
Fri, 16 May 2008 09:10 By: zim327 ![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) |
Performance Issue on a specific Table only Oracle 10G V3` By: DBAsal on Thu, 15 May 2008 |
8 |
2037 |
Fri, 16 May 2008 07:31 By: DBAsal ![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 enq: TX - row lock contention Oracle 10.2 HPUX |
2 |
17569 |
Thu, 15 May 2008 15:17 By: datamile ![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) |
|
Number of table partitions Oracle 9.2 |
3 |
1423 |
Thu, 15 May 2008 10: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) |
|
challenge to Sr.DBA Oracle 8i |
2 |
1723 |
Thu, 15 May 2008 00: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) |
|
Counting whole table? oracle9i |
3 |
1494 |
Wed, 14 May 2008 15: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) |
|
Need info regarding DATABASE PARTITIONING Oracel 10g |
2 |
1452 |
Wed, 14 May 2008 04:01 By: smithsareen ![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 help to tune the query solaris 10 oracle 10.2.0.3 |
1 |
1312 |
Wed, 14 May 2008 03:46 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) |
|
What the statistics in Explain plan suggests? (merged) |
9 |
2381 |
Wed, 14 May 2008 03:38 By: VEDDETA ![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) |
|
optimization of a query |
3 |
1930 |
Wed, 14 May 2008 01: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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Error while creating partitioned table Oracle 10g |
1 |
3813 |
Tue, 13 May 2008 12:27 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 Tuning oracle 10g |
3 |
1589 |
Tue, 13 May 2008 09:57 By: enkhbold ![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) |
|
DeadLock in the database Oracle 9i on Solaris 9 ( 1 2) |
72 |
11868 |
Tue, 13 May 2008 09:46 By: vaishalikatarki ![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 data base in multi application server and multi sites oracle data base 10g and oracle application server |
1 |
1287 |
Tue, 13 May 2008 09:33 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) |
|
DB performing very slowly, 10g/Solaris |
9 |
2990 |
Tue, 13 May 2008 09:28 By: enkhbold ![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) |
|
Regd: Tuning required Oracle 9I |
12 |
3217 |
Tue, 13 May 2008 04:42 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
Tuning |
1 |
1532 |
Tue, 13 May 2008 02:27 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) |
|
Reorganizing Vs Rebuilding Indexes Oracle 9i By: riki on Mon, 12 May 2008 |
4 |
5150 |
Mon, 12 May 2008 16:22 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) |
|
Tuning Error with Order by clause 10.2.0.3, Solaris64 |
3 |
10119 |
Sun, 11 May 2008 22:24 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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Problem on understanding cardinality of index 10.2.0.3 By: stsy on Fri, 09 May 2008 |
6 |
1956 |
Fri, 09 May 2008 06:55 By: stsy ![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 choose NL in this case? |
8 |
3142 |
Fri, 09 May 2008 04:46 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) |
|
impact of this parameter bloom_filter_enabled =false oracle 10.2.0.2 solaris 10 64 bit |
6 |
8555 |
Thu, 08 May 2008 05:30 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) |
|
Importance of index unique scan (cost=0) Oracle 10g R2, HPUX |
2 |
2719 |
Wed, 07 May 2008 07:07 By: santoshorcl ![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 Compression Question Oracle 10GR2 |
3 |
1434 |
Tue, 06 May 2008 10:56 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 tune a view using 3 big tables |
13 |
3477 |
Tue, 06 May 2008 09:33 By: goodmans ![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) |
![icon14.gif](/forum/images/message_icons/icon14.gif) |
Perfomance Tuning 10g |
1 |
1485 |
Tue, 06 May 2008 08:54 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 Tuning for a package Oracle 10g |
2 |
2193 |
Tue, 06 May 2008 01:05 By: monasingh ![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 Executing Every Second Oracle 9i,9.2.0.6.0,windows XP |
6 |
1817 |
Mon, 05 May 2008 23:03 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) |
|
Data Statistics oracle 10g |
2 |
1357 |
Mon, 05 May 2008 06:41 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) |
|
Where can I download this Book? Oracle 10gR2 RedHat AS 4 |
3 |
1763 |
Mon, 05 May 2008 01: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) |
|
How to make inserts faster Oracle10g |
9 |
3957 |
Sun, 04 May 2008 06:45 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) |
|
SQL statement tuning Oracle 8i |
4 |
2228 |
Fri, 02 May 2008 02:50 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) |
|
tuning time consuming queries oracle 8i |
1 |
1916 |
Wed, 30 April 2008 22:56 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |