|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
regarding Large Pool usage ?? |
2 |
1853 |
Wed, 10 May 2006 01:41 By: tridentadm ![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_$view VS v$views |
9 |
4675 |
Tue, 09 May 2006 09:50 By: kumarsz ![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) |
|
pinning objects ?? but when ?? |
1 |
1330 |
Mon, 08 May 2006 08:22 By: orausern ![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) |
|
ip address |
1 |
1648 |
Sat, 06 May 2006 09:12 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) |
|
Queries perform slow |
1 |
1366 |
Fri, 05 May 2006 03:15 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) |
|
Query Slow - any ideas how to speed it up??? here's what I have... |
2 |
1449 |
Fri, 05 May 2006 01:25 By: chetwyn ![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 |
3 |
2008 |
Thu, 04 May 2006 22:39 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) |
|
Number of transactions |
1 |
1685 |
Thu, 04 May 2006 17:19 By: andrew again ![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 while extracting the data |
4 |
1783 |
Thu, 04 May 2006 01:41 By: raji_kb02 ![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) |
|
Joins in Queries |
1 |
3373 |
Wed, 03 May 2006 22:34 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) |
|
Tuning This Query |
7 |
5389 |
Tue, 02 May 2006 10:33 By: faiz_hyd ![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) |
|
job not visible in dba_jobs |
4 |
4687 |
Tue, 02 May 2006 08:15 By: raji_kb02 ![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) |
|
Bitmap or Normal Index |
10 |
5133 |
Sat, 29 April 2006 13:10 By: ssg5174 ![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 processes causing 100 % CPU usage |
4 |
5279 |
Fri, 28 April 2006 13:38 By: dixxee ![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 tool on performance tuning By: pzlj6x on Fri, 28 April 2006 |
1 |
2475 |
Fri, 28 April 2006 09:32 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) |
|
Best practice for querying weighted sparse data |
5 |
2197 |
Thu, 27 April 2006 14:38 By: kfritsche ![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: gajini on Wed, 26 April 2006 |
1 |
1402 |
Wed, 26 April 2006 22:25 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) |
|
sizing sort area |
1 |
1387 |
Wed, 26 April 2006 17:08 By: Daljit Singh ![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_job package |
1 |
1362 |
Wed, 26 April 2006 14:24 By: Art Metzer ![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) |
|
Check My Query Plz |
2 |
1570 |
Wed, 26 April 2006 13:26 By: Art Metzer ![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) |
|
Bulk delete |
2 |
8666 |
Tue, 25 April 2006 03:26 By: JSI2001 ![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) |
use HASH instead of index range scan,why the CBO choose the wrong plan?!! |
10 |
4171 |
Mon, 24 April 2006 21:55 By: wenaini ![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 of an update |
1 |
1251 |
Mon, 24 April 2006 21: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) |
|
Data Gaurd 10g By: yash_v on Sun, 23 April 2006 |
1 |
1327 |
Sun, 23 April 2006 13:03 By: madhusunkara ![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 Order and Question |
5 |
1662 |
Thu, 20 April 2006 23:51 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) |
|
URGENT-Query not performing |
4 |
2181 |
Thu, 20 April 2006 12:46 By: Art Metzer ![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 improve the performance of LOWER (col) LIKE ‘%name%’ |
4 |
2148 |
Thu, 20 April 2006 09:28 By: Art Metzer ![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) |
|
Multiple index on Multiple tables |
8 |
2284 |
Thu, 20 April 2006 00:25 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) |
|
Re Update index By: mghong on Sun, 16 April 2006 |
4 |
2035 |
Tue, 18 April 2006 22: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) |
|
High Disk Reads and FTS |
4 |
2225 |
Tue, 18 April 2006 11:10 By: faiz_hyd ![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) |
Large SGA By: yash_v on Fri, 14 April 2006 |
6 |
2310 |
Sun, 16 April 2006 17:31 By: alanm ![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 unique problem |
2 |
1393 |
Fri, 14 April 2006 02:07 By: hypnotoad ![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) |
|
Tool |
1 |
1289 |
Fri, 14 April 2006 01:16 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) |
|
Use of Histogram and Statistics for All Index columns or All columns? |
5 |
4763 |
Thu, 13 April 2006 16:39 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) |
|
partitioned table indexes, rebuild |
1 |
1547 |
Tue, 11 April 2006 21:43 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) |
|
db_block_buffers = 0 By: alanm on Tue, 11 April 2006 |
2 |
5862 |
Tue, 11 April 2006 17:13 By: alanm ![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) |
|
Temporary segment when fetching. By: croK on Mon, 10 April 2006 |
2 |
1355 |
Tue, 11 April 2006 09:57 By: croK ![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 8 rebuild index |
4 |
1763 |
Tue, 11 April 2006 07:28 By: marco118 ![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) |
|
Monitoring memory used by oracle process By: Nau on Mon, 10 April 2006 |
1 |
1648 |
Tue, 11 April 2006 05:13 By: madhusunkara ![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 for Full table scan ( Huge data ) |
5 |
2252 |
Tue, 11 April 2006 02:22 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |