|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Heap size exceeds warning notification in alert.log oracle 10.2.0.1.0,Redhat Linux 4.5 [Enterprise edition] |
9 |
49024 |
Sun, 31 January 2010 01:41 By: Michel Cadot ![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) |
|
slower execution of pl/sql code By: mandark on Thu, 28 January 2010 |
1 |
2384 |
Fri, 29 January 2010 10:56 By: Kevin Meade ![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 Join Index for DW Oracle 10g |
5 |
4467 |
Fri, 29 January 2010 10:51 By: Kevin Meade ![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) |
|
When is execution plan for a package determined (merged) By: firefly on Thu, 28 January 2010 |
17 |
3877 |
Fri, 29 January 2010 02:38 By: firefly ![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) |
|
Rarely used columns Oracle 10.2.0.1.0,RHEL5,pro*c |
4 |
2458 |
Thu, 28 January 2010 05: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) |
|
how to calculate cpu usage of database from statspack report 10.1.0.5.0 , linux |
2 |
4755 |
Wed, 27 January 2010 23:54 By: anwar786 ![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$pgastat value 11.0.0.6 By: jinga on Wed, 27 January 2010 |
4 |
4704 |
Wed, 27 January 2010 11:05 By: Michel Cadot ![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) |
|
Undo used by Batch Job Oracle 9.2.0.6.0 on HP-UX |
3 |
2314 |
Tue, 26 January 2010 05:27 By: Michel Cadot ![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 problem Oracle 9.2.0.8.0 |
2 |
2376 |
Mon, 25 January 2010 05: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) |
|
Use of double parallel hint |
1 |
3149 |
Mon, 25 January 2010 02:58 By: Michel Cadot ![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) |
|
Finding INSERT statments between 2 AWR snapshots 10.2.0.4 |
1 |
2600 |
Sat, 23 January 2010 00:32 By: kamran.irshad ![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 With View Vs Select of the View behave differently Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 |
3 |
3665 |
Fri, 22 January 2010 07:45 By: cookiemonster ![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 Fetching data within Two hrs 9.2.0.8 |
3 |
7188 |
Fri, 22 January 2010 05:53 By: cookiemonster ![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) |
|
Table Access by ROWID vs UNIQUE INDEX SCAN 10.2.0.4 |
4 |
8393 |
Thu, 21 January 2010 21:35 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) |
|
Determining UPDATE statements from DBA_HIST_SQL_PLAN 10.2.0.4 |
4 |
3827 |
Thu, 21 January 2010 01:23 By: John Watson ![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) |
|
"os thread startup" in top 5 Events linux , oracle 10.2.0.4 By: gir_sat on Wed, 20 January 2010 |
1 |
19217 |
Wed, 20 January 2010 04:59 By: ramoradba ![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 problem 10g Database |
5 |
3292 |
Wed, 20 January 2010 03:44 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) |
|
how to avoid multiple Like operators in a single query |
8 |
3909 |
Sat, 16 January 2010 17:45 By: Kevin Meade ![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 optimisation, table partitionning and lack of index database 10g By: didiera on Thu, 14 January 2010 |
5 |
2907 |
Sat, 16 January 2010 17:41 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) |
|
Oracle audit view performance issue Oracle Apps R12 By: sreejit on Thu, 24 December 2009 |
5 |
6354 |
Sat, 16 January 2010 15:53 By: Kevin Meade ![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) |
|
Wait event problem oracle 10.1.0.5.0, Sunsolaris 5.10 By: sathik on Thu, 14 January 2010 |
2 |
2430 |
Sat, 16 January 2010 15:37 By: Kevin Meade ![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 and optimization- Help Needed 10g |
5 |
2632 |
Thu, 14 January 2010 09:02 By: benjamin.tl ![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) |
|
11g tuning oracle 11g |
3 |
1852 |
Tue, 12 January 2010 04:22 By: Michel Cadot ![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 monitoring/intercepting 10g |
4 |
2197 |
Mon, 11 January 2010 15:20 By: newerakb ![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 the response time of the sql query oracl 10 linux |
10 |
3460 |
Mon, 11 January 2010 07:31 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) |
|
what is the best ? (merged 3) oracle 11g |
4 |
2174 |
Sat, 09 January 2010 16:23 By: martijn ![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) |
|
cardinality of join affected by transitivity 10201 By: stsy38 on Thu, 31 December 2009 |
14 |
5232 |
Sat, 09 January 2010 11:53 By: narsap ![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- Need help Oracle 10g Enterprise Edition Release 10.2.0.3.0 - Prod |
1 |
2273 |
Fri, 08 January 2010 02:31 By: Michel Cadot ![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) |
|
to tune an SQL query oracle 9i |
3 |
2416 |
Fri, 08 January 2010 01:36 By: rahulvb ![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-structuring the SQL query By: decci_7 on Mon, 04 January 2010 |
3 |
2410 |
Wed, 06 January 2010 19:47 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) |
|
How to tune this sql? Oracle 10.0.2.3 |
7 |
2786 |
Tue, 05 January 2010 09:31 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) |
|
Instance profiling 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: rahulvb on Tue, 05 January 2010 |
5 |
2226 |
Tue, 05 January 2010 03:25 By: rahulvb ![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) |
|
write as a single statement Databse 10.1,xp |
2 |
1770 |
Sun, 03 January 2010 09:46 By: coleing ![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) |
|
Current snap shot level? 9.2, Windows XP |
3 |
2107 |
Sat, 02 January 2010 11:39 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) |
|
Explain Plan from statsreport Oracle DB, 10.2.0.4.0 , UNIX |
5 |
4154 |
Wed, 30 December 2009 06:33 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) |
|
Sql query tuning oracle,10.1.0.5.0,sunsolaris 5.10 By: sathik on Wed, 23 December 2009 |
9 |
3540 |
Wed, 30 December 2009 06:15 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) |
|
Top wait event - control file sequential read |
3 |
10618 |
Fri, 25 December 2009 21:30 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) |
|
How to retrieve SQLs and execution plans from awr history oracle database 10R2 |
3 |
15182 |
Wed, 23 December 2009 18:00 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) |
|
Deadlock interpretation Oracle 10g |
2 |
2819 |
Wed, 23 December 2009 15:59 By: vipull.sayal ![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 instance performance oralce 9i , Linux |
1 |
1818 |
Tue, 22 December 2009 05:15 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |