|
|
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 |
13645 |
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 |
1663 |
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 |
2685 |
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 |
3339 |
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 |
3896 |
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 |
5603 |
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 |
5845 |
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 |
3452 |
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 |
2567 |
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 |
2227 |
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 |
1383 |
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 |
1678 |
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 |
2336 |
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 |
5396 |
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 |
2955 |
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 |
2409 |
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 |
4287 |
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 |
15171 |
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 |
3161 |
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 |
2487 |
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 |
2541 |
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 |
2157 |
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 |
3749 |
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 |
11427 |
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 |
1743 |
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 |
1736 |
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 |
2599 |
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 |
4506 |
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 |
2623 |
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 |
3395 |
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 |
1511 |
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 |
2476 |
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 |
2018 |
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 |
2635 |
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 |
2591 |
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 |
2317 |
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 |
4318 |
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 |
3051 |
Fri, 01 May 2009 17:33 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |