|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
REPORT BASED ON 2 VIEWS |
1 |
2365 |
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 |
2384 |
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 |
2015 |
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 |
2019 |
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 |
4558 |
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 |
1734 |
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 |
2600 |
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 |
2196 |
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 |
2071 |
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 |
2197 |
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 |
4414 |
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 |
3462 |
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 |
2244 |
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 |
1803 |
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 |
2268 |
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 |
2035 |
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 |
3978 |
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 |
8031 |
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 |
11285 |
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 |
2181 |
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 |
2263 |
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 |
2021 |
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 |
2499 |
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 |
3327 |
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 |
1926 |
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 |
2093 |
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 |
2258 |
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 |
4211 |
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 |
3018 |
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 |
2177 |
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 |
2548 |
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 |
4049 |
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 |
6191 |
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 |
2046 |
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 |
2586 |
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 |
1977 |
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 |
2566 |
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 |
2866 |
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 |
3189 |
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 |
3028 |
Tue, 22 August 2006 11:21 By: kudur_kv ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |