|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
performance tuning By: donind on Thu, 22 February 2007 |
1 |
2399 |
Thu, 22 February 2007 02:02 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) |
|
Questions |
1 |
1756 |
Wed, 21 February 2007 23:47 By: nmacdannald ![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) |
|
Memory question |
1 |
1691 |
Wed, 21 February 2007 15:37 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) |
|
Data Buffer Cache and Dirty Blocks |
1 |
2744 |
Wed, 21 February 2007 07:02 By: cbruhn2 ![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-1555 |
1 |
2195 |
Wed, 21 February 2007 06:10 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) |
|
SQL Tuning - Distinct Vs Group by |
1 |
7828 |
Wed, 21 February 2007 05:07 By: tahpush ![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) |
|
NOt EXISTS & NOT IN ??? |
1 |
2063 |
Mon, 19 February 2007 06:09 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) |
|
WHERE CLAUSE TUNING By: bm_souj on Sun, 18 February 2007 |
7 |
2751 |
Mon, 19 February 2007 06: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) |
|
Tunig of query By: jaydba on Fri, 16 February 2007 |
1 |
1820 |
Sun, 18 February 2007 20:22 By: nmacdannald ![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) |
|
transaction |
1 |
1848 |
Sun, 18 February 2007 20:04 By: nmacdannald ![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) |
|
DBA_SEGMENTS: Criteria for a DB/Table export |
7 |
4293 |
Fri, 16 February 2007 06:26 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) |
|
Power Builder Data window linkage performance By: afreen on Thu, 15 February 2007 |
2 |
2653 |
Fri, 16 February 2007 01:26 By: afreen ![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) |
|
straight sql vs procedural ASAP |
6 |
2598 |
Thu, 15 February 2007 22:52 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) |
|
Updating a BIG table By: gulabo on Wed, 07 February 2007 |
4 |
2209 |
Thu, 15 February 2007 10:33 By: gulabo ![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 file init write By: Frank on Wed, 14 February 2007 |
2 |
10047 |
Wed, 14 February 2007 04:03 By: Frank ![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 approach this By: laiko on Tue, 13 February 2007 |
2 |
2153 |
Tue, 13 February 2007 20: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) |
|
Load on Oracle server |
3 |
2256 |
Tue, 13 February 2007 13:16 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) |
|
ORA-12520: TNS:listener could not find available handler for requested type of server |
10 |
126649 |
Mon, 12 February 2007 18: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) |
|
9i to 10g By: jfrano on Thu, 18 January 2007 |
4 |
2562 |
Mon, 12 February 2007 07:27 By: cbruhn2 ![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 tune query |
8 |
2998 |
Sun, 11 February 2007 05:03 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) |
|
SQL with high consistent gets By: vipin on Tue, 06 February 2007 |
10 |
12160 |
Fri, 09 February 2007 14:06 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) |
|
Database Triggers performance issues |
1 |
2042 |
Fri, 09 February 2007 00: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) |
|
query fast in one session slow in another By: henriec on Wed, 07 February 2007 |
1 |
2238 |
Wed, 07 February 2007 14:46 By: skooman ![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) |
data guard query |
1 |
1667 |
Wed, 07 February 2007 08:02 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) |
|
Index based on subtype |
0 |
6125 |
Wed, 07 February 2007 05:36 By: tlahyani ![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) |
|
Single Join Query vs Individual Table Queries By: tolas on Fri, 02 February 2007 |
4 |
3756 |
Wed, 07 February 2007 02:39 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) |
|
STATSPACK |
2 |
2484 |
Tue, 06 February 2007 06:19 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) |
|
SQL Statement Tuning By: irfanr on Tue, 06 February 2007 |
1 |
1922 |
Tue, 06 February 2007 05:52 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) |
|
How to push Hash Anti join without HINT or code modification ? |
1 |
2657 |
Tue, 06 February 2007 04:05 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) |
|
Help Required in Tunning |
1 |
1938 |
Tue, 06 February 2007 03:38 By: vamsi kasina ![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) |
|
Full table scan |
3 |
2313 |
Sat, 03 February 2007 11:28 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) |
|
Insert from 2 million rows |
3 |
2248 |
Fri, 02 February 2007 12:40 By: prashant_pathak ![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 INDEXing |
3 |
1843 |
Thu, 01 February 2007 03:20 By: premchellam ![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) |
|
Group By By: tookep on Mon, 29 January 2007 |
6 |
2405 |
Wed, 31 January 2007 01:31 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) |
|
Cost in the Explain Plan |
2 |
2004 |
Tue, 30 January 2007 14:18 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) |
|
Performance Implications of a Generic Lookup Table Design By: artmt on Mon, 29 January 2007 |
4 |
2251 |
Tue, 30 January 2007 11:17 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) |
|
Optimizing Queries Against UNIONed View By: artmt on Tue, 23 January 2007 |
8 |
3812 |
Mon, 29 January 2007 11:02 By: srinivas4u2 ![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 one best ? By: babuknb on Mon, 29 January 2007 |
2 |
1812 |
Mon, 29 January 2007 05:17 By: babuknb ![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 Performace with different size drives. By: cajohn on Wed, 24 January 2007 |
2 |
1868 |
Sat, 27 January 2007 11:40 By: cbruhn2 ![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) |
|
Testing performance tweaks |
7 |
2431 |
Sat, 27 January 2007 04:01 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |