|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SYSTEM TS is increasing 10g RAC HP UX |
2 |
3485 |
Wed, 08 July 2009 07:17 By: madhavamanohar ![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) |
|
9i -> 10g causes JAVA performance problems 10.2.0.3 RDBMS, AIX 3 5 By: jmoran on Mon, 06 July 2009 |
2 |
2032 |
Tue, 07 July 2009 04:38 By: jmoran ![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 question Oracle 9.2.0.3 |
5 |
3019 |
Tue, 07 July 2009 01:07 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_rewrite_enabled 10G |
4 |
5447 |
Fri, 03 July 2009 17:44 By: farenheiit ![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) |
|
Statistics on Empty Partition oracle 10.2.0.3 in HP-UX11 |
1 |
1901 |
Thu, 02 July 2009 12:34 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) |
|
Index on normal and random column data Oracle 9.2.0.3 |
2 |
1607 |
Thu, 02 July 2009 08:09 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) |
|
9i cbo mode first_rows Oracle 9i on hp-ux By: TRaj on Tue, 30 June 2009 |
4 |
2427 |
Thu, 02 July 2009 03:15 By: TRaj ![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) |
|
choose which index to be create (merged) |
2 |
1555 |
Wed, 01 July 2009 08:45 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) |
|
oracle 11g - 11.0.7.0 solaris 10 By: dirish on Wed, 01 July 2009 |
4 |
3084 |
Wed, 01 July 2009 07:30 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) |
|
stale or empty statiscs 10.2.0.2.0 |
5 |
2972 |
Fri, 26 June 2009 16:42 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) |
|
BACKUP OF HISTOGRAMS Oracle 10g |
1 |
2051 |
Fri, 26 June 2009 09:00 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 do you know whether the Index is getting used or not Oracle 10g,Win XP |
7 |
2960 |
Thu, 25 June 2009 10:29 By: prachij593 ![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 Oracle 10.2.0.3.0 |
7 |
2505 |
Thu, 25 June 2009 10:22 By: prachij593 ![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) |
|
Parallel and First_rows Hints |
1 |
5719 |
Tue, 23 June 2009 05:29 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) |
|
import table having 30000000 rows oracle9i,red hat linux rhel3, having only one processor,ram 1gb |
3 |
1704 |
Tue, 23 June 2009 01:41 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) |
|
performance problem with query |
3 |
2024 |
Mon, 22 June 2009 17:18 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) |
|
Database Hung due to CPU utilization Oracle 10.2.0.2.0,Solaris10 |
4 |
2001 |
Sun, 21 June 2009 08:04 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) |
|
May you explain to me about AWR? Oracle 10.2.0.1, Solaris Sparc 64bit |
8 |
8194 |
Fri, 19 June 2009 02:37 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) |
|
Improving Performance of Large Result Set 11g |
9 |
3534 |
Thu, 18 June 2009 17:33 By: jkomorek ![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 stops responding when run on production server Oracle 10g |
3 |
2199 |
Thu, 18 June 2009 09:18 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) |
|
is there any need of rebuild pk index oracle 9i (9.2),linux rhel3 |
2 |
1518 |
Thu, 18 June 2009 01: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) |
|
ORA-1652: unable to extend temp Oracle 10g R2 ,AIX |
4 |
2873 |
Tue, 16 June 2009 23:32 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) |
|
reload of statements in library cache oracle 9i, linux rhel3 |
8 |
2595 |
Tue, 16 June 2009 06:58 By: amitzil ![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 latch: cache buffers chains Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 |
2 |
10382 |
Fri, 12 June 2009 23:15 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Group By Behaviors Oracle Database 10g 10.2.0.4.0 - 64bit, UNIX |
12 |
3808 |
Fri, 12 June 2009 04:53 By: ykathirv ![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) |
|
HINT INDEX Usage 9.2.0.7 By: Brayan on Fri, 12 June 2009 |
1 |
1533 |
Fri, 12 June 2009 04: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) |
|
How to tune memory size in oracle 8i (merged) |
12 |
3725 |
Fri, 12 June 2009 04:38 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) |
|
Dynamic_sampling and partitioning 10.2.0.4 |
1 |
2137 |
Thu, 11 June 2009 11:16 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) |
|
slow query with MERGE JOIN CARTESIAN and LATCH cache buffer chains 10g |
2 |
2888 |
Thu, 11 June 2009 09:57 By: farenheiit ![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 in Count(DISTINCT Oracle 9i |
7 |
2629 |
Wed, 10 June 2009 17:23 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) |
|
Latch:Library Cache Solaris 10, 10.2.0.1 DB |
5 |
9712 |
Tue, 09 June 2009 23:54 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
very simple but very slow query Oracle Database 10g, Suse Linux 10 |
22 |
3761 |
Mon, 08 June 2009 05:25 By: beingman ![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) |
![icon13.gif](/forum/images/message_icons/icon13.gif) |
Performance degrades with big block size tablespace oracle 10G R2, Sun solaris 10 |
13 |
4253 |
Sat, 06 June 2009 20:57 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 of database runnig on RAC 10g with two Solaris nodes Oracle 10g RAC |
12 |
5641 |
Fri, 05 June 2009 12:59 By: alexberi ![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_stats and STATTYPE_LOCKED in DBA_TAB_STATISTICS |
1 |
11695 |
Fri, 05 June 2009 03: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) |
|
How to judge the slow query? Windows 2003 SP2 Oracle 10.2.0.4 32-bit |
17 |
4677 |
Mon, 01 June 2009 04:49 By: crazypeter2005 ![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) |
IOT - what is that? By: wakula on Fri, 29 May 2009 |
5 |
4552 |
Sat, 30 May 2009 16: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) |
|
JDBC connection performance By: estola on Fri, 29 May 2009 |
1 |
2224 |
Sat, 30 May 2009 07:29 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) |
|
DIFF B/W V$SQL AND V$SQLAREA Oracle Database 10g Release 10.2.0.3.0 |
1 |
4231 |
Fri, 29 May 2009 13: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) |
|
import sql profile with opt_param hnt |
0 |
7109 |
Fri, 29 May 2009 04:12 By: loveoracle ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |