|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Blocking Session - blocked SQL -> SELECT SYSDATE FROM SYS.DUAL Oracle 10.0.0.4g, Windows 2003 |
8 |
7013 |
Fri, 14 August 2009 09:14 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) |
|
Impact of table partitioning on DML/Index creation Time (merged) |
7 |
4704 |
Thu, 13 August 2009 09:10 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) |
|
ORA-600 and ORA-7445 error in Oracle 10g R2 Oracle 10g R2 ,OS - 2003 Server, RAM 4GB, Front End-JAVA |
4 |
7888 |
Thu, 13 August 2009 03:18 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) |
|
Performance issue in Plsql oracle10g |
2 |
2465 |
Sat, 08 August 2009 21:08 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) |
![icon7.gif](/forum/images/message_icons/icon7.gif) |
Parallelism disabled in data warehouse Oracle 9.2 on unix By: goo321 on Fri, 07 August 2009 |
3 |
2604 |
Sat, 08 August 2009 21:01 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) |
|
Hard parse in RAC 10.2.0.4 |
0 |
8110 |
Fri, 07 August 2009 03:28 By: serenaender ![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) |
|
Need help to tune the query |
14 |
8536 |
Thu, 06 August 2009 15:08 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) |
|
Block Corruption Oracle 9204, XP |
1 |
2499 |
Thu, 06 August 2009 11:23 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) |
|
Temp Size 10.2.0.3 |
5 |
2194 |
Thu, 06 August 2009 05:00 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) |
|
A high value of Rollback per Transaction (97,74%) 10.2.0.4.0 RAC |
11 |
6416 |
Wed, 05 August 2009 16:39 By: serenaender ![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) |
|
FTS - Full Table Scan - (merged 3) |
9 |
5328 |
Wed, 05 August 2009 08:29 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) |
|
Selection/Updation from a table based on condition Oracle 10g |
4 |
2708 |
Tue, 04 August 2009 05:28 By: virmahi ![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) |
|
regarding statspack.... |
12 |
23499 |
Mon, 03 August 2009 01:57 By: SameerChoudhari ![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 Performance Issue with dbms_stats.gather_table_stats Oracle 9i |
1 |
3040 |
Sun, 02 August 2009 05:29 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) |
|
How To Eliminate Sort Unique Oracle 10.1.0.2.0 HP-UX |
3 |
5211 |
Sun, 02 August 2009 04:43 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 optimize this plan (merged) |
8 |
2533 |
Sat, 01 August 2009 10:44 By: amardeep.sidhu ![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) |
|
Recompute plan each time for the sql oracle 10.2.0.3 |
15 |
6418 |
Fri, 31 July 2009 00:47 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) |
|
Bind variables and SGA size Oracle, Any, Any By: lharpf on Thu, 30 July 2009 |
4 |
3118 |
Fri, 31 July 2009 00:34 By: lharpf ![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) |
![icon1.gif](/forum/images/message_icons/icon1.gif) |
Erratic explain plan 10.1.0.4.0, 64 bit By: cherry on Wed, 29 July 2009 |
9 |
3344 |
Thu, 30 July 2009 03:14 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) |
|
Negative Tablespace Free Space value Oracle, 10.2.0, Windows Server 2003 |
12 |
8249 |
Thu, 30 July 2009 02:24 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) |
|
performance issue oracle 10g RAC Oracle 10g RAC with ASM Windows Server 2003 |
8 |
5287 |
Wed, 29 July 2009 14:18 By: t.velayutham@gmail.com ![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) |
|
Rollback segment too small error oracle10g |
9 |
3179 |
Wed, 29 July 2009 00:13 By: deepbans ![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) |
|
No parallel DML with IOTs oracle 10.2.0.3 |
2 |
3896 |
Tue, 28 July 2009 09:37 By: Alessandro Rossi ![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) |
|
sqlarea sql oracle 10.2.0.3 |
2 |
1985 |
Tue, 28 July 2009 07:23 By: prachij593 ![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) |
|
Different plan for same sql oracle 10.2.0.3 |
10 |
4061 |
Mon, 27 July 2009 09:23 By: Alessandro Rossi ![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) |
|
Response time is high in 10g Oracle10.2.0.3 |
7 |
3291 |
Mon, 27 July 2009 05:59 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) |
|
Funtion Tuning Oracle 9204, XP |
3 |
1841 |
Sat, 25 July 2009 06:23 By: michael_bialik ![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 with OR predicates Oracle 9.2.0.3 |
4 |
2138 |
Fri, 24 July 2009 02:09 By: prachij593 ![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 Full table scan for Like '%XYZ%' Oracle 9.2.0.3 |
2 |
2146 |
Thu, 23 July 2009 16: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) |
|
Viewing Pinned Objects in KEEP cache 9.2.0.7 By: Brayan on Mon, 20 July 2009 |
14 |
8089 |
Thu, 23 July 2009 04:17 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 tuning Oracle, 10gR2, Linux 5.2 |
4 |
2608 |
Thu, 23 July 2009 03:47 By: ivpraveen ![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) |
|
Parse And Executing Statements Oracle 10.1.0.2.0,HP-UX B.11.23 |
1 |
1843 |
Thu, 23 July 2009 01:12 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) |
|
Storage parameters.. Oralce 10g. |
9 |
5121 |
Wed, 22 July 2009 04:34 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) |
|
Problem with query having order by , distinct clause |
5 |
4088 |
Sun, 19 July 2009 00:39 By: saptarshibasu ![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) |
|
Select with no conditions taking long time, too many blocks, pctused Oracle 9.2.0.8 Solaris By: goo321 on Thu, 16 July 2009 |
9 |
3362 |
Sat, 18 July 2009 06:55 By: goo321 ![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) |
|
Force the optimizer to use the primary key index Oracle 10g, Win XP |
21 |
10395 |
Thu, 16 July 2009 07:05 By: prachij593 ![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 or To use Hints (merged) |
4 |
2780 |
Wed, 15 July 2009 23:20 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) |
|
Enable 10053 Trace information Oracle 10g, Win XP |
7 |
4904 |
Sun, 12 July 2009 10:33 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) |
|
Redo Size doesn't increase more than 260MB HP-UX 11.23, Oracle 9.2i |
1 |
2129 |
Fri, 10 July 2009 01:45 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) |
|
Performance question Oracle9.2.0.3 By: Olivia on Tue, 07 July 2009 |
3 |
2018 |
Thu, 09 July 2009 15:40 By: coleing ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |