|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
fast_start_mttr_target By: yash_v on Wed, 05 July 2006 |
1 |
2445 |
Wed, 05 July 2006 13:35 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) |
|
how to speed up |
1 |
1637 |
Tue, 04 July 2006 03:10 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) |
|
Global Temporary Table - Creating Locks |
3 |
9683 |
Mon, 03 July 2006 06:53 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) |
|
HELP! very high in cpu usage By: alicia on Tue, 27 June 2006 |
8 |
2892 |
Mon, 03 July 2006 06:15 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) |
|
Index Creation Speed-up |
2 |
2735 |
Mon, 03 July 2006 02:46 By: ithanver ![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 is slow By: Tai on Sun, 02 July 2006 |
2 |
2164 |
Mon, 03 July 2006 02:02 By: Littlefoot ![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) |
|
Pls advice about this EXECUTION PLAN |
4 |
1925 |
Sun, 02 July 2006 21:57 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) |
|
NORMALIZATION AND DENORMALIZATION |
1 |
5152 |
Thu, 29 June 2006 05:20 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) |
|
RedoLog Contention |
3 |
3004 |
Wed, 28 June 2006 11:54 By: Kavitha Suresh ![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 insert/update - same schema on two servers By: SASA on Tue, 27 June 2006 |
4 |
2566 |
Wed, 28 June 2006 02:12 By: SASA ![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 performance: Hard code values vs. parmeterized values |
1 |
2155 |
Tue, 27 June 2006 22:23 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) |
|
Server Parameters !! By: AlinaC on Thu, 22 June 2006 |
3 |
1561 |
Tue, 27 June 2006 07:24 By: AlinaC ![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) |
|
Log filesize By: yash_v on Tue, 27 June 2006 |
1 |
1564 |
Tue, 27 June 2006 06:16 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) |
|
low buffer hit ratio |
2 |
4072 |
Mon, 26 June 2006 10:08 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) |
|
convert partition table to normal table |
1 |
3355 |
Mon, 26 June 2006 09:05 By: Frank Naude ![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) |
|
Configuration of PGA Aggregate Target |
2 |
7498 |
Mon, 26 June 2006 06:52 By: jimit_shaili ![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) |
|
Question on 10.2.0.2 patch application on 10.2.0.1 database By: rajd on Sun, 25 June 2006 |
1 |
3857 |
Sun, 25 June 2006 19:23 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) |
|
improve performance of query over dblink. By: rajd on Sun, 25 June 2006 |
5 |
5844 |
Sun, 25 June 2006 17:19 By: rajd ![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 I use Pragma Autonomous Transactions for Performance Improvement? |
1 |
4017 |
Thu, 22 June 2006 17:22 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) |
|
How to reduce nested loops in a big query? |
6 |
3583 |
Wed, 21 June 2006 09:52 By: Jaime Stuardo ![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) |
|
capture users & statements causing archive log full |
1 |
2387 |
Wed, 21 June 2006 05:09 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) |
|
How to find the loading session By: akudba on Wed, 21 June 2006 |
1 |
1724 |
Wed, 21 June 2006 04:48 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 Improve Oracle View Performance |
6 |
11239 |
Tue, 20 June 2006 09: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) |
|
Is there any way for defrage the tablespace in linux Os |
1 |
1743 |
Mon, 19 June 2006 10:49 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) |
|
Req. help on Temporary Tablespace |
1 |
3225 |
Sun, 18 June 2006 07:19 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) |
|
Improving materialized view performance |
3 |
2451 |
Sat, 17 June 2006 10:47 By: Littlefoot ![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) |
|
Automatic Shared Memory Management (ASMM) !! By: AlinaC on Fri, 16 June 2006 |
1 |
1499 |
Fri, 16 June 2006 13:08 By: Frank Naude ![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) |
|
More "SQL*Net message to/from client" than expected |
3 |
5015 |
Thu, 15 June 2006 17:26 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Latch Contention |
4 |
2787 |
Thu, 15 June 2006 13:59 By: vikramjogi ![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 on collecting schema statistics (oracle 9i) |
5 |
5491 |
Wed, 14 June 2006 13:15 By: asmishra ![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) |
|
is unique index helpful in making query fast? |
1 |
1611 |
Wed, 14 June 2006 02:35 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) |
|
database slow |
2 |
1450 |
Mon, 12 June 2006 01:23 By: chidellanr ![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) |
|
OPTIMIZER_INDEX_COST_ADJ & OPTIMIZER_INDEX_CACHING |
2 |
4532 |
Fri, 09 June 2006 09:28 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) |
|
PL/SQL code review tool |
2 |
3428 |
Fri, 09 June 2006 07:29 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) |
|
Advice |
2 |
1790 |
Fri, 09 June 2006 02:53 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) |
|
From where can I get all available SQL tuning HINTS for Oracle? |
1 |
1963 |
Thu, 08 June 2006 13:03 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) |
![icon13.gif](/forum/images/message_icons/icon13.gif) |
Require Information |
3 |
1447 |
Thu, 08 June 2006 07:36 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) |
|
Considering constraints |
3 |
1376 |
Thu, 08 June 2006 03:38 By: ehegagoka ![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) |
|
I Need information about the value of "row cache enqueue latch" By: crozas on Wed, 07 June 2006 |
0 |
3716 |
Wed, 07 June 2006 14:53 By: crozas ![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 is really taking a long time. Please help By: pzlj6x on Fri, 02 June 2006 |
4 |
2053 |
Wed, 07 June 2006 13:18 By: pzlj6x ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |