|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Very slow commit Oracle XE By: emeded on Fri, 22 May 2009 |
12 |
13653 |
Thu, 28 May 2009 12:43 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) |
|
Need help on Query Tuning |
1 |
1667 |
Thu, 28 May 2009 01: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) |
|
Delete statement taking long time in Test database Oracle 9i |
5 |
2703 |
Wed, 27 May 2009 21:53 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) |
|
Database Performance (merged2) 10.2 |
1 |
3345 |
Tue, 26 May 2009 01:30 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) |
|
Oracle 9i Cost very high Oracle 9i |
1 |
3902 |
Mon, 25 May 2009 13:34 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) |
|
More archivelogs are generating. Oracle 10.2.0.4, Windows 2003 server |
9 |
5610 |
Sat, 23 May 2009 09:49 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 tuning |
7 |
5852 |
Fri, 22 May 2009 16:47 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) |
|
Index issue 10.2.0.3, Windows 2003 |
11 |
3456 |
Fri, 22 May 2009 09:55 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) |
|
Difference between awr metrics |
4 |
2571 |
Fri, 22 May 2009 09:40 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) |
|
Full scan even index being added |
6 |
2247 |
Fri, 22 May 2009 02: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) |
|
setting up performance monitoring on my schema oracle 10.1.0.2.0,red hat linux By: nash12 on Fri, 22 May 2009 |
1 |
1389 |
Fri, 22 May 2009 01:25 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) |
|
Question about AWR 10.2.0.3 on Solaris 10 |
2 |
1683 |
Thu, 21 May 2009 23: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) |
|
Performance in joins Oracle,9i,AIX 5.2 |
4 |
2345 |
Thu, 21 May 2009 02:48 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Mysterious Insufficient TEMP Tablespace... By: aimy on Fri, 13 March 2009 |
24 |
5402 |
Wed, 20 May 2009 13:00 By: bangalibor ![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 Slow Oracle-9i and 10g |
10 |
2969 |
Wed, 20 May 2009 12:41 By: bangalibor ![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 - QUERY TUNING Oracle 10g, linux |
3 |
2412 |
Tue, 19 May 2009 03:40 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) |
|
performance Tunning |
13 |
4290 |
Tue, 19 May 2009 03:26 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) |
|
Increasing number of Processes |
8 |
15174 |
Mon, 18 May 2009 10:24 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) |
|
Queries on the fly using DBMS_ADVANCED_REWRITE |
4 |
3163 |
Mon, 18 May 2009 08:56 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) |
|
Index is not working properly in my query ? |
6 |
2489 |
Sun, 17 May 2009 11:00 By: bangalibor ![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) |
|
Inner workings: how often is data written to disk |
4 |
2544 |
Thu, 14 May 2009 12:08 By: Joppybt ![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 oracle 10g, Linux |
3 |
2159 |
Thu, 14 May 2009 08:24 By: manijash ![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 Optimization (merged) By: sdey on Mon, 11 May 2009 |
23 |
3760 |
Wed, 13 May 2009 10: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) |
|
No performance boost after upgrading database server RAM from 3GB to 16G win 3000 Server Enterprise Edition, Oracle 9i (9.2.0.7.0) Enterprise Edition |
22 |
11458 |
Wed, 13 May 2009 04:20 By: dbanukesh ![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 AWR report 10.2.0.4, Solaris 10 |
1 |
1746 |
Sun, 10 May 2009 23:07 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) |
|
Gets and GetHits difference ? |
3 |
1738 |
Sun, 10 May 2009 00: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) |
|
Query "Statements run in past 24 hrs with execution time" Oracle 10.2.0.4 |
3 |
2606 |
Fri, 08 May 2009 12:25 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) |
|
get list of all sql's executed in a session with out sql trace Oracle, 10g, Unix |
6 |
4514 |
Fri, 08 May 2009 09:29 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) |
|
10-15 seconds on a 200 record DataSet 9.1 |
3 |
2638 |
Fri, 08 May 2009 08:03 By: rboggess ![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 taking time |
14 |
3398 |
Fri, 08 May 2009 02:10 By: varu123 ![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) |
|
Transaction memory/space amount configuration Oracle 10g |
1 |
1516 |
Thu, 07 May 2009 09:19 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) |
|
What is High water mark? oracle |
6 |
2477 |
Thu, 07 May 2009 06:36 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) |
|
Use of Btree in Oracle: Concept Oracle |
1 |
1505 |
Thu, 07 May 2009 02:57 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Slow Order by, Index needed? 10g |
2 |
2024 |
Wed, 06 May 2009 03:27 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
UPDATE query with JOIN |
5 |
2636 |
Wed, 06 May 2009 03:22 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) |
|
Locks in Oracle Oracle 9i |
1 |
1513 |
Tue, 05 May 2009 08:24 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) |
|
configuring undo_retention. |
1 |
2593 |
Mon, 04 May 2009 02:26 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) |
|
dynamic view to get 'SQL ordered by...' section from AWR |
1 |
2323 |
Mon, 04 May 2009 01: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) |
|
Hint is not working oracle10g |
8 |
4323 |
Sun, 03 May 2009 20:49 By: iamadba ![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) |
![icon3.gif](/forum/images/message_icons/icon3.gif) |
value BETWEEN x AND y Oracle 10.2G By: wakula on Thu, 12 March 2009 |
8 |
3060 |
Fri, 01 May 2009 17:33 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |