|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Performance Tuning from scratch! |
1 |
1621 |
Sun, 22 October 2006 02:25 By: Mohammad Taj ![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 lock |
1 |
11026 |
Sat, 21 October 2006 00:31 By: Mohammad Taj ![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) |
|
Last Ananlyzed Column in OEM |
3 |
2056 |
Wed, 18 October 2006 11:20 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) |
|
Slow perfomance through satellite |
7 |
2141 |
Wed, 18 October 2006 08:30 By: pathfinder ![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) |
|
Low performance - Database |
3 |
2900 |
Wed, 18 October 2006 06:28 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) |
|
Basic question in PT |
1 |
1563 |
Wed, 18 October 2006 04:51 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) |
|
Spool from DB table to flat file slow By: yogen on Mon, 16 October 2006 |
8 |
6204 |
Tue, 17 October 2006 07: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) |
|
datapump parallel |
1 |
1872 |
Tue, 17 October 2006 07:10 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) |
|
Fine Tuning This query |
1 |
2056 |
Tue, 17 October 2006 06:38 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) |
|
Regarding Schema Stats for CBO |
1 |
1783 |
Tue, 17 October 2006 04:02 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) |
|
Very low network times when retriving data from a query. By: petpet on Mon, 16 October 2006 |
2 |
1923 |
Tue, 17 October 2006 03:26 By: petpet ![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 tuning |
5 |
3831 |
Mon, 16 October 2006 21:56 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) |
Differences in query execution between two similar environments By: pria79 on Thu, 12 October 2006 |
3 |
1959 |
Fri, 13 October 2006 11:48 By: pria79 ![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 Takes More time To Run |
3 |
2242 |
Thu, 12 October 2006 14:39 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) |
|
Hint Index |
2 |
1947 |
Thu, 12 October 2006 10:27 By: lsabster ![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) |
|
dbms_session.set_sql_trace_in_session('12,25') |
3 |
4259 |
Sat, 07 October 2006 10:50 By: Mohammad Taj ![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) |
|
Converting Non-Partitioned table to Partition table By: himang on Sat, 07 October 2006 |
1 |
2250 |
Sat, 07 October 2006 10:49 By: Mohammad Taj ![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) |
|
Regarding I/O Performance |
2 |
1696 |
Sat, 07 October 2006 06:42 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) |
|
i/o and disk planning By: spiffi on Thu, 28 September 2006 |
7 |
2431 |
Fri, 06 October 2006 10:51 By: spiffi ![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 to Defragment Tables, Index and TableSpace By: dvaddi on Wed, 04 October 2006 |
2 |
2465 |
Wed, 04 October 2006 12:12 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) |
|
10g - gather_stats_job By: judym on Tue, 03 October 2006 |
1 |
4658 |
Wed, 04 October 2006 03:07 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) |
|
Outline help By: rkl1 on Tue, 03 October 2006 |
0 |
3700 |
Tue, 03 October 2006 12:51 By: rkl1 ![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) |
|
want to see the time duration of a statement |
6 |
2753 |
Mon, 02 October 2006 09:03 By: skn ![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) |
|
Partitioning In Phases and Impact |
5 |
2255 |
Sun, 01 October 2006 07:11 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) |
|
performance tools |
2 |
1686 |
Sat, 30 September 2006 00:55 By: Database admin ![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) |
|
bottlenecks |
1 |
1686 |
Fri, 29 September 2006 10:39 By: skn ![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) |
|
Which is faster count(*),count(1),count(rowid) |
1 |
2174 |
Thu, 28 September 2006 09:05 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) |
|
performance graph report |
2 |
1809 |
Thu, 28 September 2006 04:14 By: ramkrishna_gosavi ![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) |
|
DBLinks and performance Issues |
1 |
1923 |
Wed, 27 September 2006 20: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) |
|
Help on First_Rows By: rajaobj on Wed, 27 September 2006 |
8 |
2621 |
Wed, 27 September 2006 20:15 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Statspack without perstat user |
1 |
1530 |
Wed, 27 September 2006 09:27 By: Mahesh Rajendran ![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) |
|
how do i create bitmap index? |
1 |
1561 |
Wed, 27 September 2006 04:38 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) |
|
ABOUT STATSPACK |
1 |
1457 |
Tue, 26 September 2006 05:41 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) |
|
query problem |
10 |
2633 |
Mon, 25 September 2006 19: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) |
|
Inefficient sql |
1 |
2140 |
Sun, 24 September 2006 11:11 By: orausern ![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) |
|
Maximum # of sessions. What can we do. By: bogey on Wed, 20 September 2006 |
2 |
3967 |
Thu, 21 September 2006 06:55 By: bogey ![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 query tuning |
1 |
1694 |
Thu, 21 September 2006 02:15 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) |
|
data purging from database By: manicm on Mon, 18 September 2006 |
3 |
6166 |
Wed, 20 September 2006 14:21 By: manish mendiratta ![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) |
|
redo files are on raid 5 ? why ? |
5 |
1887 |
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 |
2229 |
Sat, 16 September 2006 14:59 By: kimant ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |