|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Create Index vs Rebuild Index Oracle 9iR2 on RHEL |
2 |
2835 |
Thu, 27 January 2011 07:52 By: OraKaran ![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) |
|
Optimizer question/ Date handling Oracle 9.2.0.8.0 |
9 |
3684 |
Wed, 26 January 2011 02:57 By: Roachcoach ![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) |
|
Locker and waiter problem oraccle 10g RAC environment |
1 |
1745 |
Tue, 25 January 2011 07:39 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) |
|
db sequential read (merged) oracle 10g R2 By: sahadba on Tue, 25 January 2011 |
1 |
4427 |
Tue, 25 January 2011 05: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) |
|
Query regarding tkprof output and cardinality in it Oracle 10g R2 on REHL |
4 |
4650 |
Mon, 24 January 2011 08:07 By: OraKaran ![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 Links Oracle, 10g, Windows Server 2003 By: faizul on Thu, 20 January 2011 |
12 |
9528 |
Thu, 20 January 2011 14:48 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) |
|
AWR report in 11g standard not supported? 11.2.0.1 |
6 |
4286 |
Wed, 19 January 2011 00:31 By: sean1970 ![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) |
|
Avoid chain rows oracle, 9.2.0.4.0, SunSolaris By: sathik on Mon, 17 January 2011 |
5 |
2577 |
Mon, 17 January 2011 10: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) |
|
MEMORY_TARGET and MEMORY_MAX_TARGET 11.2.0.1 |
3 |
4026 |
Sat, 15 January 2011 11:15 By: sean1970 ![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) |
|
Confusion over Keep Cache (2 Merged) Oracle 11g, HP-UX B11.23 |
2 |
1909 |
Sat, 15 January 2011 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) |
|
Retreiving from the Data is slow Oracle 11g, Linux |
6 |
2124 |
Sat, 15 January 2011 03:13 By: tariqdba ![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 Perfomance Oracle 10g, Windows XP |
18 |
9123 |
Fri, 14 January 2011 07:33 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) |
|
AWR report Oracle 10.2.0.3 + 2 node RAC + HP-UX Itanium 11.31 |
3 |
3082 |
Fri, 14 January 2011 06:29 By: seema.taunk ![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) |
|
Elapsed time not accounted in tkprof file Oracle 9.2 on HP-UX |
11 |
3332 |
Thu, 13 January 2011 11:17 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) |
|
How to partition tables and indexes in this scenario? Oracle 11g R2 By: steffi on Wed, 12 January 2011 |
3 |
2392 |
Thu, 13 January 2011 08:16 By: steffi ![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, Many "ora_p" processes (merged) or By: sahadba on Thu, 13 January 2011 |
2 |
14483 |
Thu, 13 January 2011 07:48 By: sahadba ![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 Linux By: gkrishn on Sat, 08 January 2011 |
12 |
4935 |
Thu, 13 January 2011 04:33 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) |
|
Initialization parameters value Oracle 10g, 10.2.0.4.0, Solaris 10 By: reym21 on Wed, 12 January 2011 |
8 |
3387 |
Thu, 13 January 2011 01:33 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) |
|
Session tracing for shared servers By: sekar52 on Wed, 12 January 2011 |
1 |
1643 |
Wed, 12 January 2011 00:59 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 Taking too much time Oracle 9.2 on HP-UX |
4 |
2328 |
Tue, 11 January 2011 09:41 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) |
|
Index rebuild online |
3 |
3211 |
Mon, 10 January 2011 15:53 By: varunvir ![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 taking time Oracle 11g HP-UX B11.23 |
7 |
3823 |
Mon, 10 January 2011 09: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) |
|
performance issue Oracle 10.2.0.4 windows 64 bit |
1 |
2722 |
Sun, 09 January 2011 06:38 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 with problem query Oracle 9.2.0.8 (HP-UX B11.23) |
7 |
2742 |
Sat, 08 January 2011 10:01 By: indrajit2002 ![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) |
|
Disk Performance Issues By: unex on Fri, 07 January 2011 |
3 |
1742 |
Fri, 07 January 2011 08:15 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) |
|
ADDM Retention Oracle 10g |
2 |
9653 |
Thu, 06 January 2011 06:28 By: vnkumaresh ![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 runs long time (merged) Oracle Enterprise Edition 10.2.0.4, Solaris 10 |
4 |
2829 |
Wed, 05 January 2011 11:47 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) |
|
Procedure taking tomuch time in execution Oracle 10g |
9 |
2829 |
Tue, 04 January 2011 04:25 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) |
|
Oracle Coalesce vs Index Rebuild 10g(10.2.0.4) |
10 |
10550 |
Mon, 03 January 2011 23:37 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) |
|
Parse once - Execute many Oracle 9,10, cross platform |
4 |
3672 |
Mon, 03 January 2011 22:04 By: trantuananh24hg ![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) |
|
Less Cost,Cardinality,Bytes Query is taking More time to execute |
1 |
3378 |
Mon, 03 January 2011 08:20 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) |
|
ADDM report 10g Linux By: gkrishn on Wed, 22 December 2010 |
4 |
5057 |
Tue, 28 December 2010 07:27 By: mani.aggarwal ![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 overcome rownum clause from select Oracle 11g ,windows 2003 By: pradies on Mon, 27 December 2010 |
3 |
3005 |
Mon, 27 December 2010 01:33 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Clustering Factor in Index Oracle 11g |
3 |
6207 |
Sat, 25 December 2010 01:15 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) |
|
stored outline 9.2.0.1 |
6 |
2229 |
Fri, 24 December 2010 02:04 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) |
|
Optimizing select from view |
7 |
2678 |
Thu, 23 December 2010 11:28 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) |
|
Performance hit of the application after moving the DB server oracle 9i, 10g, forms 10g/9i, AS9i |
1 |
1456 |
Thu, 23 December 2010 03: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) |
|
archive log oracle 10g |
8 |
5088 |
Wed, 22 December 2010 10:47 By: Roachcoach ![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 full ORACLE,9.2.0.5.0,AIX |
1 |
2112 |
Wed, 22 December 2010 01:10 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) |
|
delete procedure taking time oracle,9i,unix |
7 |
2429 |
Wed, 22 December 2010 00:01 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |