|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
View doesn't use Index |
1 |
1551 |
Mon, 30 July 2007 11: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) |
|
Need help - Tuning the SQL |
2 |
1661 |
Mon, 30 July 2007 10:54 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 increase a performance of a table in oracle 10g (merged) ( 1 2) |
53 |
7398 |
Mon, 30 July 2007 03:50 By: anamika_025 ![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 : Histograms Size |
1 |
1404 |
Sun, 29 July 2007 11:13 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) |
|
Database hanged |
0 |
7448 |
Wed, 25 July 2007 04:51 By: kamragulshan ![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) |
|
SGA By: dirish on Wed, 25 July 2007 |
1 |
1829 |
Wed, 25 July 2007 03: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) |
|
ARCH wait on SENDREQ By: ursg02 on Wed, 25 July 2007 |
1 |
15789 |
Wed, 25 July 2007 03:19 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) |
![icon7.gif](/forum/images/message_icons/icon7.gif) |
index not used By: pradns on Tue, 24 July 2007 |
6 |
2518 |
Tue, 24 July 2007 06:34 By: pradns ![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) |
|
Real Application Testing --> Database Replay |
1 |
1226 |
Thu, 19 July 2007 08:04 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) |
|
Deletion on an partition table is very slow |
2 |
1329 |
Wed, 18 July 2007 13:12 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) |
|
Time Differnce in Execution with / without Hint |
6 |
3495 |
Tue, 17 July 2007 23:16 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 speedup mentioned SQL query |
22 |
3044 |
Tue, 17 July 2007 15:07 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) |
|
slow update on large table |
8 |
6770 |
Sat, 14 July 2007 03:07 By: michael_bialik ![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) |
optimatize query?? |
2 |
2577 |
Fri, 13 July 2007 00:33 By: orafan23 ![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) |
|
statspack table fetch continued row By: alanm on Thu, 12 July 2007 |
16 |
4091 |
Thu, 12 July 2007 20: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) |
|
Buffer Pool |
4 |
4112 |
Thu, 12 July 2007 10:29 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) |
|
ORA-1652: unable to extend temp segment by 16 in TEMP TS |
3 |
2410 |
Thu, 12 July 2007 10:28 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
execution plan for a stored procedure |
2 |
6202 |
Thu, 12 July 2007 04:46 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
How Oracle using SAMPLE Clause on statistics? |
3 |
3340 |
Wed, 11 July 2007 06:03 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) |
|
Performance tuning |
12 |
3241 |
Tue, 10 July 2007 09:10 By: ammishra ![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) |
|
detecting environment issues By: yog_23 on Mon, 09 July 2007 |
2 |
1387 |
Tue, 10 July 2007 00:33 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) |
|
Index created is not using(I dont want to use hints) By: donind on Mon, 09 July 2007 |
4 |
1824 |
Mon, 09 July 2007 14:53 By: michael_bialik ![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) |
|
Partitioned table takes longer to load than ordinary table |
3 |
2137 |
Mon, 09 July 2007 03:02 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 use optimizer hint in a recursivly called procedure |
2 |
1419 |
Mon, 09 July 2007 01:05 By: kmkan28 ![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 : Understanding the Explain Plan |
5 |
4899 |
Sun, 08 July 2007 12:04 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) |
|
99% Hit-Ratio but poor performance |
3 |
1421 |
Sat, 07 July 2007 05:04 By: gintsp ![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) |
|
New Server but performance still the same By: alpaje on Tue, 03 July 2007 |
2 |
1382 |
Wed, 04 July 2007 11:58 By: michael_bialik ![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 due to Distinct clause |
1 |
1374 |
Wed, 04 July 2007 07: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) |
|
SQL query needs tuning |
9 |
12084 |
Wed, 04 July 2007 02:23 By: kpremsagar ![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) |
Performance Problem |
6 |
1696 |
Tue, 03 July 2007 12:39 By: flyboy ![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 i tune such a simple sql |
3 |
1423 |
Tue, 03 July 2007 10:45 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) |
|
gather_statistics |
7 |
6145 |
Tue, 03 July 2007 10:06 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) |
|
Questions about Executing Explain Plan against a query. |
1 |
1415 |
Tue, 03 July 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) |
|
pga_aggregate_target - Issue By: Brayan on Tue, 03 July 2007 |
4 |
2268 |
Tue, 03 July 2007 07:48 By: Brayan ![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) |
|
Avoid Index to be used by Queries By: feroze on Mon, 02 July 2007 |
3 |
1429 |
Mon, 02 July 2007 15:42 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) |
|
Performance issue in report |
3 |
1555 |
Fri, 29 June 2007 15:41 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) |
|
implications of merging 17 tables into 1... |
11 |
2204 |
Thu, 28 June 2007 23:45 By: flyboy ![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) |
|
poor performance of selecting from view. |
0 |
7034 |
Thu, 28 June 2007 15:07 By: eggplant ![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) |
|
Execution Plan |
13 |
2601 |
Thu, 28 June 2007 14:52 By: eggplant ![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 a Query |
5 |
1812 |
Thu, 28 June 2007 05:33 By: orasaket ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |