|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Truncation of Queries in Statspack Report |
1 |
1353 |
Mon, 20 March 2006 06:34 By: Maaher ![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) |
|
Function index |
3 |
2498 |
Mon, 20 March 2006 05:08 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) |
|
bitmap index on unstable column |
4 |
2276 |
Sat, 18 March 2006 21:51 By: a_developer ![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) |
|
Transaction never fails ..where |
0 |
3339 |
Sat, 18 March 2006 07:21 By: jagjeet.malhi ![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) |
|
Difference in Execution timing By: feroze on Fri, 17 March 2006 |
1 |
1219 |
Sat, 18 March 2006 00:52 By: Frank ![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) |
|
Log File Sync |
3 |
1702 |
Fri, 17 March 2006 04:56 By: alanm ![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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Interpreting tkprof |
4 |
9122 |
Thu, 16 March 2006 15:42 By: sophieharris ![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) |
|
operation timed out |
3 |
1363 |
Thu, 16 March 2006 15:30 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) |
|
Materialized view vs Table |
2 |
5345 |
Thu, 16 March 2006 09:32 By: croK ![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) |
Oracle 8.1.7.0 - How to find BIND Variable values ? |
0 |
3521 |
Thu, 16 March 2006 09:29 By: deadpoet ![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) |
|
Difference in location of the hint |
2 |
1482 |
Wed, 15 March 2006 06:45 By: a_developer ![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) |
|
Numeric or Alphanumeric datatype By: gajini on Mon, 13 March 2006 |
1 |
1596 |
Tue, 14 March 2006 02:32 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) |
|
Partitioned to Composite Partitioned |
2 |
1486 |
Mon, 13 March 2006 12:45 By: a_developer ![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 hint/execution |
2 |
3465 |
Sun, 12 March 2006 16:16 By: a_developer ![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 8 rebuild index |
4 |
6092 |
Fri, 10 March 2006 19:22 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) |
|
Problem with insert statements sharing in shared pool |
0 |
3763 |
Fri, 10 March 2006 08:38 By: sach_sumit ![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 INTO with a hint |
4 |
18605 |
Fri, 10 March 2006 00:19 By: a_developer ![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 to rebuild indexes ... |
0 |
4530 |
Thu, 09 March 2006 23:40 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) |
|
number of rows per db block By: srhl on Thu, 09 March 2006 |
2 |
1625 |
Thu, 09 March 2006 21:10 By: srhl ![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 Monitoring |
5 |
4880 |
Thu, 09 March 2006 10:07 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) |
|
Query to select users connected |
1 |
3622 |
Thu, 09 March 2006 06:13 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) |
|
best way to create an index |
1 |
1479 |
Thu, 09 March 2006 00:47 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 for not equal and index usage |
4 |
2046 |
Wed, 08 March 2006 15:10 By: mjschwenger ![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) |
|
Sort and hash area size problem |
1 |
4109 |
Wed, 08 March 2006 09:41 By: aciolac ![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) |
|
Wait event 'db file sequential read' on TABLE segment |
1 |
5020 |
Wed, 08 March 2006 08:48 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Please tune this Query |
8 |
1911 |
Wed, 08 March 2006 06:56 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) |
|
Statpack report |
6 |
6372 |
Wed, 08 March 2006 06:21 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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
please help me ->cpu id 0 By: rzmni on Tue, 07 March 2006 |
0 |
3226 |
Tue, 07 March 2006 21:42 By: rzmni ![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 of Oracle 8i |
6 |
3233 |
Tue, 07 March 2006 12: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) |
|
Query Optimisation |
2 |
1396 |
Tue, 07 March 2006 07:12 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) |
|
ORDER BY CLAUSE |
3 |
3323 |
Tue, 07 March 2006 05:27 By: Frank ![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) |
|
Tuning Buffer Hit Ratio on Oracle 8i |
2 |
1767 |
Mon, 06 March 2006 13:44 By: Vamshee ![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) |
|
log waits |
0 |
3461 |
Mon, 06 March 2006 13:10 By: toshidas2000 ![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-024012: PLAN_TABLE not found By: Brayan on Thu, 02 February 2006 |
4 |
13526 |
Mon, 06 March 2006 05:22 By: samidc ![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 not being used in Query By: samidc on Mon, 06 March 2006 |
2 |
1336 |
Mon, 06 March 2006 02:08 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) |
|
Bulk Collect in Oracle 8i |
2 |
2882 |
Fri, 03 March 2006 05: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) |
|
library cache latch By: aline on Thu, 02 March 2006 |
1 |
4593 |
Thu, 02 March 2006 13:42 By: mchadder ![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) |
|
SELECT doubt |
1 |
1313 |
Thu, 02 March 2006 09:58 By: Barbara Boehmer ![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) |
|
Execution Plan doubt |
2 |
3747 |
Thu, 02 March 2006 06:00 By: frank.svs ![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) |
Statistic |
1 |
1613 |
Wed, 01 March 2006 09:55 By: Mahesh Rajendran ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |