|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
redo files are on raid 5 ? why ? |
5 |
2559 |
Wed, 20 September 2006 13:38 By: jburnham ![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) |
|
REPORT BASED ON 2 VIEWS |
1 |
2879 |
Sat, 16 September 2006 14:59 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) |
|
Join Query problem. One using index while another full table scan |
3 |
3003 |
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 |
2861 |
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 |
2241 |
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 |
5203 |
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 |
2286 |
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 |
3242 |
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 |
2293 |
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 |
2313 |
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 |
2882 |
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 |
4703 |
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 |
4716 |
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 |
3377 |
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 |
2161 |
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 |
2524 |
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 |
2348 |
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 |
4215 |
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 |
8611 |
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 |
11760 |
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 |
2655 |
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 |
2945 |
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 |
2873 |
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 |
2709 |
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 |
3703 |
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 |
2323 |
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 |
2304 |
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 |
2620 |
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 |
4574 |
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 |
3841 |
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 |
2808 |
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 |
2766 |
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 |
4181 |
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 |
6493 |
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 |
3033 |
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 |
2813 |
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 |
2652 |
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 |
2887 |
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 |
3181 |
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 |
3355 |
Wed, 23 August 2006 04:31 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |