|
|
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 |
2439 |
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 |
1629 |
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 |
9675 |
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 |
2886 |
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 |
2729 |
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 |
2156 |
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 |
1918 |
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 |
5142 |
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 |
2991 |
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 |
2559 |
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 |
2150 |
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 |
1554 |
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 |
1559 |
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 |
4066 |
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 |
3349 |
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 |
7493 |
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 |
3848 |
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 |
5835 |
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 |
4011 |
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 |
3576 |
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 |
2381 |
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 |
1716 |
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 |
11231 |
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 |
1739 |
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 |
3217 |
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 |
2446 |
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 |
1492 |
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 |
5009 |
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 |
2781 |
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 |
5484 |
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 |
1604 |
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 |
1443 |
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 |
4527 |
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 |
3423 |
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 |
1782 |
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 |
1957 |
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 |
1440 |
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 |
1371 |
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 |
3711 |
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 |
2045 |
Wed, 07 June 2006 13:18 By: pzlj6x ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |