|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Run TKPROF.............. |
3 |
3242 |
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 |
1428 |
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 |
1451 |
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 |
2481 |
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 |
3315 |
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 |
1714 |
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 |
5119 |
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 |
6409 |
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 |
6482 |
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 |
1988 |
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 |
4319 |
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 |
7468 |
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 |
2460 |
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 |
4348 |
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 |
3314 |
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 |
2642 |
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 |
1836 |
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 |
2186 |
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 |
2545 |
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 |
3402 |
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 |
1948 |
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 |
2184 |
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 |
13148 |
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 |
4270 |
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 |
2655 |
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 |
2217 |
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 |
1903 |
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 |
1786 |
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 |
2227 |
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 |
1901 |
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 |
1818 |
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 |
1835 |
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 |
3950 |
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 |
2698 |
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 |
2005 |
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 |
5459 |
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 |
2049 |
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 |
1660 |
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 |
2233 |
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 |
5027 |
Wed, 01 August 2007 10:55 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |