|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
general query tuning |
7 |
4487 |
Wed, 22 March 2006 15:11 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) |
|
A myth of TKPROF output in Oracle 10.1.0.4 |
3 |
2853 |
Mon, 20 March 2006 22:25 By: Art Metzer ![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) |
|
Truncation of Queries in Statspack Report |
1 |
1720 |
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 |
3058 |
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 |
2767 |
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 |
3778 |
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 |
1499 |
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 |
2555 |
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 |
10229 |
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 |
1950 |
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 |
5967 |
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 |
3844 |
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 |
1827 |
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 |
2039 |
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 |
1831 |
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 |
3794 |
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 |
6808 |
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 |
4203 |
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 |
19655 |
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 |
5005 |
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 |
2117 |
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 |
5317 |
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 |
3968 |
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 |
1868 |
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 |
2367 |
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 |
4424 |
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 |
5752 |
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 |
3529 |
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 |
7640 |
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 |
3502 |
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 |
3914 |
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 |
1773 |
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 |
4018 |
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 |
2222 |
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 |
3993 |
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 |
14480 |
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 |
2143 |
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 |
3524 |
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 |
5018 |
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 |
1946 |
Thu, 02 March 2006 09:58 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |