|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Report taking long time |
3 |
2235 |
Thu, 06 July 2006 03:12 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) |
|
fast_start_mttr_target By: yash_v on Wed, 05 July 2006 |
1 |
2586 |
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 |
1750 |
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 |
9914 |
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 |
3076 |
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 |
2871 |
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 |
2309 |
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 |
2075 |
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 |
5272 |
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 |
3150 |
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 |
2695 |
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 |
2304 |
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 |
1735 |
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 |
1695 |
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 |
4207 |
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 |
3509 |
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 |
7683 |
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 |
3978 |
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 |
5996 |
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 |
4193 |
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 |
3743 |
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 |
2522 |
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 |
1841 |
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 |
11428 |
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 |
1868 |
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 |
3333 |
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 |
2577 |
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 |
1638 |
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 |
5149 |
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 |
2917 |
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 |
5642 |
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 |
1711 |
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 |
1562 |
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 |
4661 |
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 |
3558 |
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 |
1928 |
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 |
2098 |
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 |
1577 |
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 |
1509 |
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 |
3839 |
Wed, 07 June 2006 14:53 By: crozas ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |