|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Run TKPROF.............. |
3 |
3255 |
Mon, 20 August 2007 12:53 By: Michel Cadot ![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) |
|
Time taken to refresh with DBMS_REFRESH |
1 |
1436 |
Mon, 20 August 2007 11:34 By: Michel Cadot ![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 implement SQL changes when tuning By: mson77 on Sun, 19 August 2007 |
2 |
1455 |
Mon, 20 August 2007 01:01 By: mson77 ![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) |
|
Currently Executing statement not available in Trace file- Oracle 10g |
4 |
2487 |
Sun, 19 August 2007 22:00 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) |
|
Currently executing statement for Oracle Job- Oracle 10g |
4 |
3319 |
Sun, 19 August 2007 12:31 By: Michel Cadot ![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) |
|
CONTEXT index |
1 |
1720 |
Sat, 18 August 2007 08:58 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) |
|
SQL Tuning By: mson77 on Tue, 14 August 2007 |
24 |
5129 |
Sat, 18 August 2007 00:46 By: mson77 ![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) |
|
TUNNING |
8 |
6417 |
Fri, 17 August 2007 07:51 By: qasim845 ![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) |
|
Some missing concepts and definitions By: mson77 on Thu, 16 August 2007 |
3 |
6492 |
Fri, 17 August 2007 00:29 By: mson77 ![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) |
Indexes on LMT |
3 |
1997 |
Thu, 16 August 2007 21:59 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) |
|
How to recreate statistics to whole schema? By: mson77 on Thu, 16 August 2007 |
11 |
4326 |
Thu, 16 August 2007 13:31 By: mson77 ![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 Monitoring tool |
0 |
7472 |
Thu, 16 August 2007 12:13 By: winnerMedas ![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.exe 100% during many hours By: mson77 on Thu, 16 August 2007 |
1 |
2468 |
Thu, 16 August 2007 11:09 By: mson77 ![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 high redo space wait ratios on 10g |
2 |
4352 |
Wed, 15 August 2007 08:36 By: orafaqer ![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) |
|
v$sga_target_advice view |
1 |
3321 |
Tue, 14 August 2007 12:37 By: Michel Cadot ![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) |
|
Update Statement - Performance Tuning By: mymot on Tue, 14 August 2007 |
4 |
2651 |
Tue, 14 August 2007 08:13 By: S.Rajaram ![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 find out the I/O and CPU bottleneks |
1 |
1841 |
Mon, 13 August 2007 14:24 By: DreamzZ ![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) |
|
Takes more time - DELETE. |
2 |
2196 |
Mon, 13 August 2007 12:30 By: DreamzZ ![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) |
|
Different Explain in Different Instances. |
7 |
2561 |
Mon, 13 August 2007 09:35 By: maggy_ashee ![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 performance tuning (how can I practice?) By: mson77 on Sat, 11 August 2007 |
9 |
3408 |
Sun, 12 August 2007 22:42 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) |
|
cached objects in buffer |
1 |
1952 |
Sat, 11 August 2007 09:22 By: Michel Cadot ![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 - Histogram |
4 |
2191 |
Thu, 09 August 2007 14:36 By: orasaket ![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) |
|
dead ORADISM process |
0 |
13153 |
Thu, 09 August 2007 05:30 By: preet_kumar ![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 for Order by clause |
19 |
4282 |
Wed, 08 August 2007 22:57 By: poratips ![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) |
|
Error during Merge Statment |
6 |
2659 |
Wed, 08 August 2007 11:44 By: DreamzZ ![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) |
|
Creation of index By: donind on Mon, 06 August 2007 |
3 |
2224 |
Tue, 07 August 2007 22:19 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) |
|
reverse key index By: donind on Tue, 07 August 2007 |
2 |
1910 |
Tue, 07 August 2007 22:14 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 Slow - Jobs |
1 |
1794 |
Tue, 07 August 2007 20:56 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) |
|
Performance tunning |
3 |
2246 |
Tue, 07 August 2007 08:15 By: qasim845 ![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) |
Performance problem when using Analytic Functions. Need Help !!! By: v@to on Tue, 07 August 2007 |
2 |
1903 |
Tue, 07 August 2007 07:50 By: v@to ![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) |
|
stripping in oracle 10g dba? |
4 |
1823 |
Mon, 06 August 2007 08:08 By: enchantress ![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) |
|
Monthly Avg. CPU Time usage.. meaningful? |
1 |
1840 |
Sun, 05 August 2007 19:20 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) |
|
Sort Area Size - ORA-600 & ORA-02097 (merged) |
3 |
3953 |
Fri, 03 August 2007 10:23 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) |
|
Problem when installing statspack |
13 |
2708 |
Fri, 03 August 2007 06:23 By: chaitanya_krishna ![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) |
![icon14.gif](/forum/images/message_icons/icon14.gif) |
Temp Datafiles Size |
5 |
2018 |
Fri, 03 August 2007 04:23 By: martijn ![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 |
16 |
5466 |
Thu, 02 August 2007 21:47 By: vimal.negi ![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 WE USE HINT IN VIEW QUERY STATEMENT |
2 |
2052 |
Thu, 02 August 2007 13:00 By: Michel Cadot ![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 Generate Statistics of a table and how to see in oracle 10g |
2 |
1667 |
Thu, 02 August 2007 10:22 By: DreamzZ ![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 problem when use parallel and hash join on large tables By: fbucco on Tue, 31 July 2007 |
5 |
2239 |
Wed, 01 August 2007 13:08 By: fbucco ![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 find out the bad sql statemets ? |
7 |
5030 |
Wed, 01 August 2007 10:55 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |