|
|
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 |
2466 |
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 |
1660 |
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 |
9718 |
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 |
2915 |
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 |
2757 |
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 |
2187 |
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 |
1956 |
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 |
5172 |
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 |
3024 |
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 |
2591 |
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 |
2178 |
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 |
1585 |
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 |
1587 |
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 |
4097 |
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 |
3379 |
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 |
7525 |
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 |
3881 |
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 |
5868 |
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 |
4040 |
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 |
3602 |
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 |
2408 |
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 |
1747 |
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 |
11257 |
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 |
1766 |
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 |
3240 |
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 |
2478 |
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 |
1523 |
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 |
5036 |
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 |
2807 |
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 |
5517 |
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 |
1630 |
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 |
1470 |
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 |
4560 |
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 |
3450 |
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 |
1816 |
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 |
1984 |
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 |
1470 |
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 |
1399 |
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 |
3739 |
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 |
2075 |
Wed, 07 June 2006 13:18 By: pzlj6x ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |