|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Sql slow query plan |
1 |
1457 |
Wed, 12 September 2007 10:35 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) |
|
Too much memory consumed in SGA |
2 |
6642 |
Wed, 12 September 2007 10:19 By: rrodriguez56 ![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) |
|
SMON TOP PROCESS By: pag63 on Wed, 12 September 2007 |
1 |
10634 |
Wed, 12 September 2007 09:33 By: MarcL ![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_Cache_Hit Ratio less than 70 |
16 |
2283 |
Wed, 12 September 2007 06:15 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) |
|
What is the different between Oracle parse and application parse? |
1 |
1955 |
Wed, 12 September 2007 01:10 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) |
|
Trying to tune a query. |
6 |
2222 |
Tue, 11 September 2007 21:41 By: galan_josel ![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 when I try to connect to a database using sqlplus |
5 |
2867 |
Tue, 11 September 2007 05:36 By: alexia_net ![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 lot of rollback problem |
3 |
1465 |
Tue, 11 September 2007 04:55 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 many connection are on line |
3 |
1329 |
Tue, 11 September 2007 04:17 By: alexia_net ![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) |
|
CPU usage has been 100% consistently |
6 |
3558 |
Tue, 11 September 2007 01:31 By: rupaliss ![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) |
Query running slow .. a day before it was fine |
8 |
2787 |
Tue, 11 September 2007 01:26 By: Arju ![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) |
|
Too many redo log file (merged) |
10 |
2317 |
Mon, 10 September 2007 23:15 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) |
|
Table lock Blocking |
5 |
2199 |
Mon, 10 September 2007 01:35 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 identify a parse of SQL statement? |
4 |
2351 |
Sun, 09 September 2007 13:43 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 can we get statistics on a table being used 24/7 in a database |
4 |
1870 |
Sun, 09 September 2007 10: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) |
|
Instance Efficiency |
4 |
2996 |
Fri, 07 September 2007 13:02 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) |
|
Procedure Tuning By: yashora on Thu, 06 September 2007 |
6 |
2062 |
Thu, 06 September 2007 22:01 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) |
|
Oracle10g 10.0.2.0.1 Performance Problems By: geonet on Mon, 27 August 2007 |
18 |
5437 |
Wed, 05 September 2007 23:48 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) |
|
Can anyone sent me the good peformance & tuning pdf file for 10g |
3 |
1822 |
Wed, 05 September 2007 23: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) |
![icon6.gif](/forum/images/message_icons/icon6.gif) |
STATSPACK ANALYSIS TOOL |
7 |
14755 |
Wed, 05 September 2007 23:19 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) |
|
Help - Tuning query |
5 |
2034 |
Wed, 05 September 2007 19:16 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) |
|
Which is memory set to shared pool? |
6 |
2680 |
Wed, 05 September 2007 10:15 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) |
|
netstat| grep 1522| wc -l |
0 |
7992 |
Wed, 05 September 2007 01:47 By: nonstopkaran ![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_cache_size - correct size By: rons on Mon, 13 August 2007 |
11 |
16036 |
Tue, 04 September 2007 07:14 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) |
|
shared memory realm already exists |
12 |
4153 |
Tue, 04 September 2007 04:02 By: trantuananh24hg ![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) |
|
Hash join vs NL join By: beetel on Mon, 03 September 2007 |
6 |
3418 |
Mon, 03 September 2007 12:00 By: beetel ![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) |
![icon3.gif](/forum/images/message_icons/icon3.gif) |
Database is slow. |
5 |
2697 |
Sun, 02 September 2007 23:08 By: pablolee ![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) |
|
Duplicating ** million record table |
1 |
2168 |
Sun, 02 September 2007 08:29 By: muzahid ![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) |
|
warning message |
1 |
1437 |
Fri, 31 August 2007 13:54 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) |
|
rebuilding index |
17 |
15366 |
Wed, 29 August 2007 22:03 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) |
|
slow in scanning documents |
1 |
1781 |
Wed, 29 August 2007 08:22 By: vasudevan ![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) |
|
CBO vs RBO |
4 |
2389 |
Tue, 28 August 2007 14:04 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) |
|
Output of Query is very slow through SQL |
3 |
1424 |
Tue, 28 August 2007 08: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) |
|
DBMS_APPLICATION_INFO Usage |
1 |
2253 |
Fri, 24 August 2007 08:07 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) |
|
about add more cpus.. |
2 |
1412 |
Fri, 24 August 2007 05:25 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) |
|
Baby Tuning !!! By: Creems on Thu, 23 August 2007 |
1 |
1431 |
Thu, 23 August 2007 15:41 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) |
|
Too much IO By: marrec on Mon, 20 August 2007 |
3 |
1486 |
Thu, 23 August 2007 06:42 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) |
|
Help-Histogram |
3 |
2880 |
Thu, 23 August 2007 03: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) |
|
How to Ping (keep) table in db_keep_cache |
2 |
5079 |
Wed, 22 August 2007 03:46 By: aslamkhalife ![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) |
|
AWR snap_id sequence |
6 |
3785 |
Mon, 20 August 2007 13:57 By: adam15612 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |