|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Join Query problem. One using index while another full table scan |
3 |
2368 |
Fri, 15 September 2006 23:20 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) |
|
problems with updating big table by commit at end By: coral_3 on Thu, 14 September 2006 |
3 |
1998 |
Fri, 15 September 2006 10:11 By: coral_3 ![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 Datafiles in a Tablespace |
2 |
2008 |
Fri, 15 September 2006 10:04 By: faiz_hyd ![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) |
|
Estimate_Percent for Analyze Schema |
4 |
4539 |
Thu, 14 September 2006 00:25 By: rkulasek ![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) |
|
Analyze increases cost |
1 |
1722 |
Wed, 13 September 2006 21:31 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) |
|
help with coming up a test case! |
5 |
2584 |
Wed, 13 September 2006 07:29 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) |
|
Merge Partition into 1 single partition |
1 |
2185 |
Tue, 12 September 2006 21:23 By: email.sandeepnaik ![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_trace question By: rkl1 on Mon, 11 September 2006 |
1 |
2058 |
Tue, 12 September 2006 03:45 By: AndreyPozhidaev ![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) |
|
enable Full-Text Search |
2 |
2181 |
Mon, 11 September 2006 09:08 By: javed122 ![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) |
|
Scale of DBA_HIST_SQLSTAT values By: kwalz58 on Thu, 07 September 2006 |
2 |
4400 |
Mon, 11 September 2006 09:06 By: kwalz58 ![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) |
|
other buffer pool .... cache sizes ?? |
6 |
3428 |
Fri, 08 September 2006 09:32 By: JSI2001 ![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) |
|
Big data Inserts By: rkl1 on Fri, 18 August 2006 |
4 |
2228 |
Fri, 08 September 2006 09:17 By: goudelly ![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) |
|
inserting data in append mode .. what adv ?? |
2 |
1791 |
Fri, 08 September 2006 09:07 By: goudelly ![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) |
Index Usage and SQL Tuning Question |
2 |
2255 |
Fri, 08 September 2006 07: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) |
|
column to look for in v$system_event |
3 |
2014 |
Fri, 08 September 2006 01:07 By: tarundua ![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) |
|
shared pool, invalidations and creation indexes ?? |
0 |
3969 |
Thu, 07 September 2006 22:42 By: tridentadm ![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-01652 - Temporary Tablespace problems!! By: Tizza on Tue, 05 September 2006 |
2 |
8017 |
Wed, 06 September 2006 02:34 By: wwllzpz ![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) |
|
Hash join hint not being used By: speaker on Tue, 05 September 2006 |
4 |
11267 |
Wed, 06 September 2006 01: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) |
|
advantage of append mode ?? |
2 |
2165 |
Tue, 05 September 2006 11:12 By: ebrian ![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) |
|
analyze table By: bahy91 on Tue, 05 September 2006 |
3 |
2247 |
Tue, 05 September 2006 07:44 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) |
|
Check if the Index is performing good or not By: bahy91 on Mon, 04 September 2006 |
4 |
2004 |
Tue, 05 September 2006 07:36 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 tuning SQL By: speaker on Fri, 01 September 2006 |
3 |
2480 |
Fri, 01 September 2006 20:57 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) |
|
Cursor time out error(open cursor on bottleneck) By: pareshr on Fri, 01 September 2006 |
1 |
3311 |
Fri, 01 September 2006 20: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) |
|
db file scattered and sequential read wait events ? |
1 |
1916 |
Fri, 01 September 2006 02:39 By: kimant ![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 calculate shared pool size ?? |
1 |
2084 |
Thu, 31 August 2006 04:43 By: Frank Naude ![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) |
|
when was COST optimizer introduced ? |
3 |
2247 |
Thu, 31 August 2006 03: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) |
|
what to do about this one !!! By: seemit on Wed, 30 August 2006 |
12 |
4187 |
Wed, 30 August 2006 08:31 By: seemit ![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 9i redo logging performance poor in relation to DB2 on Solaris. Please help. By: adamb on Fri, 18 August 2006 |
2 |
3009 |
Wed, 30 August 2006 06:32 By: adamb ![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) |
![icon2.gif](/forum/images/message_icons/icon2.gif) |
Temp Data files Size |
2 |
2165 |
Wed, 30 August 2006 00:16 By: mian imran ![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) |
|
Large Volume Updates And Performance |
4 |
2540 |
Tue, 29 August 2006 23:02 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) |
|
Connection Latency |
0 |
4044 |
Mon, 28 August 2006 15:05 By: amit.pansare ![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 Updates |
4 |
6184 |
Mon, 28 August 2006 08:05 By: dpodborny ![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) |
|
Analyze Command |
4 |
2041 |
Mon, 28 August 2006 02:42 By: javed122 ![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) |
|
the outline error why |
3 |
2579 |
Fri, 25 August 2006 03:09 By: lazycat ![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) |
Oracle 9.0.2.7 enterprise problem |
2 |
1969 |
Wed, 23 August 2006 11:00 By: pabs ![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) |
|
Shared Pool sizing |
7 |
2559 |
Wed, 23 August 2006 10:59 By: kudur_kv ![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) |
|
Udmp Traces |
10 |
2850 |
Wed, 23 August 2006 09:47 By: wahdany60 ![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 Use and Renaming Partitions |
3 |
3184 |
Wed, 23 August 2006 04:31 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) |
|
Temp segment issue |
4 |
3021 |
Tue, 22 August 2006 11:21 By: kudur_kv ![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) |
|
STATSPACK question on 10g and 8i |
2 |
2201 |
Tue, 22 August 2006 03:36 By: alexdabr ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |