|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Index Hit Retio Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production |
8 |
2875 |
Fri, 26 March 2010 15:10 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) |
|
Swap Partition or Recreate Synonym 10g By: beetel on Tue, 23 March 2010 |
3 |
3511 |
Tue, 23 March 2010 05:06 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) |
|
most accessed 11g, solaris 9 |
4 |
2555 |
Tue, 23 March 2010 04:27 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) |
|
11g sql tuning(urgent) 11g,solaris9 |
2 |
2868 |
Sat, 20 March 2010 09:54 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) |
|
Optimize the Query Oracle 9i |
2 |
3281 |
Fri, 19 March 2010 08:30 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) |
|
Slow connection in Linux 64 bit oracle 9i Oracle 9.2.0.6, Linux 64 bit |
19 |
16020 |
Thu, 18 March 2010 11:25 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) |
|
11g index can't be rebuild 11g, solaris 9 |
3 |
8904 |
Thu, 18 March 2010 05:25 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) |
|
Lot of Trace files under udump,bdump with error: Ioctl ASYNC_CONFIG error, errno = 1 Oracle 10.2.0.4 on HP-UX |
8 |
18646 |
Thu, 11 March 2010 11:51 By: Ricky_1362002 ![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) |
|
Update statement resulting time out Oracle 10g |
37 |
8264 |
Wed, 10 March 2010 04:24 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) |
|
Explicit cursor data Oracle10g |
3 |
1985 |
Tue, 09 March 2010 23: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) |
|
sga 11g,solaris 9 |
1 |
1677 |
Tue, 09 March 2010 05: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) |
|
Tune "where col in (val1,val2,val3) oracle 10g |
2 |
2048 |
Tue, 09 March 2010 04: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) |
|
Resource busy during stats gather Oracle 10g |
2 |
2797 |
Sun, 07 March 2010 08:48 By: gkrishn ![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) |
|
Autotrace (merged by CM) Oracle 9.2, Windows |
2 |
1955 |
Wed, 03 March 2010 06:43 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 this query be improved for performance? |
9 |
2921 |
Tue, 02 March 2010 08:32 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) |
|
Should an index be rebuilt or recreated during data load. |
1 |
1689 |
Tue, 02 March 2010 04: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) |
|
TEMP TABLESPACE 11G, WINDOWS |
1 |
2710 |
Tue, 02 March 2010 00:25 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) |
|
ora-1652 11g,solaris 9 |
9 |
7134 |
Tue, 02 March 2010 00:02 By: orafacjublu ![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) |
|
question about stats oracle 10.2.0.4 on solaris 8 |
5 |
3010 |
Mon, 01 March 2010 10:11 By: orausern ![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 regression from 8i to 10G Oracle 10G By: Irena on Thu, 25 February 2010 |
2 |
2157 |
Mon, 01 March 2010 01:53 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) |
|
Restructering Oracle, 10g, Windows server 2003 |
5 |
3936 |
Fri, 26 February 2010 04:31 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) |
![icon14.gif](/forum/images/message_icons/icon14.gif) |
ORACLE OPTIMIZER Oracle 9.2, Windows |
1 |
2005 |
Tue, 23 February 2010 22: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) |
|
Migration to Oracle 10 Performance issues Oracle 10g Database |
2 |
1759 |
Tue, 23 February 2010 21:12 By: rahulvb ![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) |
![icon11.gif](/forum/images/message_icons/icon11.gif) |
Query Tuning Oracle 9.2, Windows |
10 |
4253 |
Mon, 22 February 2010 10:15 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) |
|
Improve Performance (Merged RL) Oracle, 10g, Windows server 2003 |
9 |
3417 |
Sun, 21 February 2010 09: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) |
|
Copy history from db1 to db 2 oracle 10, unix By: elnbado on Fri, 19 February 2010 |
1 |
1980 |
Fri, 19 February 2010 05:42 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) |
|
11g Result Cache oracle11g, unix |
7 |
4564 |
Fri, 19 February 2010 02:10 By: tahpush ![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) |
Raplace Group by clause Oracle 9.2, Windows |
4 |
3037 |
Thu, 18 February 2010 04:03 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) |
|
Pls tell me, what I need to check before tuning the SQL code? Windows |
1 |
1628 |
Wed, 17 February 2010 08:36 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 some review my materialized view? Oracle 9i |
1 |
2360 |
Wed, 17 February 2010 07:19 By: S.Rajaram ![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) |
Replace Not Exists Oracle 9.2, UNIX |
4 |
3758 |
Wed, 17 February 2010 06:42 By: S.Rajaram ![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 Distributed Queries oracle 11g with windows server2003 64bit |
4 |
3176 |
Tue, 16 February 2010 23:25 By: Adeelusman ![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 enqueue waits in statspack - lock contention on Primary key index showing 98% of db wait time 9.2.0.6 By: mwansa on Thu, 11 February 2010 |
22 |
9910 |
Mon, 15 February 2010 11:58 By: S.Rajaram ![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 Pruning on fact table 10.2.0.4 |
10 |
4988 |
Fri, 12 February 2010 07:48 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) |
|
Index is not used after running dbms_stats.gather_table_stats Oracle Database 10g in Sun Solaris 64bit |
7 |
5950 |
Tue, 09 February 2010 07:51 By: raselvista ![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) |
|
Long run time of query with Order by clause Oracle 10g |
3 |
3040 |
Fri, 05 February 2010 15:06 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) |
![icon8.gif](/forum/images/message_icons/icon8.gif) |
HASH cluster building very Slow Oracle 10g R2 By: sky_lt on Tue, 02 February 2010 |
7 |
4370 |
Fri, 05 February 2010 03:05 By: John Watson ![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 in Oracle 10g using Bulk Collect Oracle 10.2.0.3.0 |
3 |
3964 |
Fri, 05 February 2010 02: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) |
|
Function Based Indexes |
2 |
2399 |
Wed, 03 February 2010 12:09 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) |
|
Oracle Segment Tuning Oracle10g By: salora on Tue, 02 February 2010 |
2 |
8568 |
Tue, 02 February 2010 02:59 By: rahulvb ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |