|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Automatic Workload Repository(AWR) and ADDM By: pzlj6x on Tue, 06 December 2005 |
3 |
2033 |
Tue, 06 December 2005 15:42 By: smartin ![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 the plan output By: bella13 on Tue, 06 December 2005 |
4 |
2898 |
Tue, 06 December 2005 13:30 By: smartin ![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) |
|
tkprof different types of sort |
2 |
1698 |
Tue, 06 December 2005 00:40 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) |
|
Explain Plan |
6 |
3475 |
Tue, 06 December 2005 00:38 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) |
|
Script Needed -- SQL Statements - Performance Tuning |
3 |
1543 |
Mon, 05 December 2005 18:20 By: reachriah ![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--- Automatic workload repository (AWR &ADDM) |
1 |
1415 |
Mon, 05 December 2005 12:02 By: smartin ![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 without accessing real data By: rrawasi on Thu, 24 November 2005 |
16 |
7315 |
Sat, 03 December 2005 03:31 By: rrawasi ![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 tuning By: yram on Mon, 28 November 2005 |
3 |
1534 |
Fri, 02 December 2005 03:32 By: yogeshse ![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 - ToTune This Query.... |
3 |
1549 |
Fri, 02 December 2005 01:01 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) |
|
Perfomance problem with partition table |
11 |
3168 |
Thu, 01 December 2005 15:17 By: smartin ![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) |
|
priority query By: rkl1 on Sat, 26 November 2005 |
3 |
1687 |
Wed, 30 November 2005 09:16 By: smartin ![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) |
|
hints on views By: alka205 on Tue, 22 November 2005 |
4 |
1636 |
Wed, 30 November 2005 08:53 By: smartin ![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) |
|
Incorrect system statistics |
1 |
1249 |
Wed, 30 November 2005 08:48 By: smartin ![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 error |
2 |
1526 |
Wed, 30 November 2005 08:37 By: smartin ![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) |
|
Multi-Insert in Parallel |
1 |
1387 |
Wed, 30 November 2005 08:18 By: smartin ![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) |
|
execute immediate with bind variables By: vgs2005 on Thu, 24 November 2005 |
3 |
1914 |
Tue, 29 November 2005 23:22 By: Frank ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
Removing Bulk Rows By: 9idba on Mon, 28 November 2005 |
1 |
1322 |
Mon, 28 November 2005 23:54 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
statpack result not found By: lazycat on Sun, 27 November 2005 |
1 |
1414 |
Sun, 27 November 2005 23:05 By: tarundua ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
you people can help me |
8 |
4360 |
Sat, 26 November 2005 06:03 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) |
|
Urgently required your opinion |
5 |
1655 |
Fri, 25 November 2005 14:01 By: sunil_v_mishra ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
Informatica By: renukha on Wed, 23 November 2005 |
1 |
2738 |
Wed, 23 November 2005 06:19 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) |
|
Bind vs non-Bind query performance |
5 |
2244 |
Mon, 21 November 2005 06:59 By: dmitry.nikiforov ![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) |
Difference in Toad & Oracle Report Builder |
3 |
2328 |
Fri, 18 November 2005 08:57 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) |
|
recursive relationships By: toakes1 on Thu, 10 November 2005 |
7 |
3569 |
Tue, 15 November 2005 09:31 By: smartin ![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) |
|
Need help on tuning |
1 |
1443 |
Wed, 09 November 2005 02:23 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) |
|
Reg. Performance on Table alter |
2 |
1382 |
Mon, 07 November 2005 22:43 By: d.dineshkumar ![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 join indexes |
7 |
3662 |
Mon, 07 November 2005 05:52 By: osoerland ![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) |
|
enq: TM - contention |
1 |
12337 |
Sun, 06 November 2005 17:05 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) |
|
difference between these 2 execution methods By: kals_kk on Fri, 04 November 2005 |
1 |
1553 |
Sun, 06 November 2005 16:55 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
rebuilding indexes |
12 |
3162 |
Sat, 05 November 2005 10:08 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) |
|
modify columns By: rkl1 on Fri, 04 November 2005 |
6 |
1614 |
Fri, 04 November 2005 14:13 By: smartin ![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) |
|
Impact of two databases schema in an oracle instance By: nirupam on Thu, 03 November 2005 |
6 |
2549 |
Fri, 04 November 2005 05:38 By: bmahireddy ![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) |
|
locking in oracle |
1 |
1806 |
Thu, 03 November 2005 20:27 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) |
|
partition-wise join in different cases |
2 |
6943 |
Wed, 02 November 2005 15:54 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) |
|
why AWR don't collect statistics information? |
2 |
1843 |
Wed, 02 November 2005 01:47 By: Teddyboy ![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) |
issue in temporary tablespace |
4 |
1792 |
Fri, 28 October 2005 23:02 By: deeptimadan ![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) |
|
can i create a materialized with column aliases. |
1 |
1501 |
Fri, 28 October 2005 17:56 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) |
|
Should Timeout period be increased |
0 |
2749 |
Fri, 28 October 2005 09:45 By: dassudip ![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) |
|
Need An Alternate - Synonyms |
2 |
1405 |
Thu, 27 October 2005 09:54 By: rohikesh ![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) |
|
Book for tuning (I'm not a DBA, though) By: vgs2005 on Sun, 23 October 2005 |
3 |
1788 |
Wed, 26 October 2005 10:45 By: SQLTraceViewer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |