|
|
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 |
1396 |
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 |
11941 |
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 |
1896 |
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 |
1885 |
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 |
1451 |
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 |
1289 |
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 |
9333 |
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 |
15296 |
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 |
2033 |
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 |
17562 |
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 |
1419 |
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 |
1718 |
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 |
1492 |
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 |
1448 |
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 |
1309 |
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 |
2376 |
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 |
1925 |
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 |
3809 |
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 |
1584 |
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 |
11863 |
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 |
1281 |
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 |
2984 |
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 |
3212 |
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 |
1528 |
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 |
5144 |
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 |
10117 |
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 |
1952 |
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 |
3138 |
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 |
8550 |
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 |
2715 |
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 |
1430 |
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 |
3474 |
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 |
1483 |
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 |
2188 |
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 |
1813 |
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 |
1353 |
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 |
1760 |
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 |
3954 |
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 |
2221 |
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 |
1914 |
Wed, 30 April 2008 22:56 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |