|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Merge join Cartesian and Buffer Sort Oracle 10.2.0.1, Solaris 10 |
3 |
6762 |
Thu, 01 January 2009 06:30 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) |
|
Sql query performance 10g By: huda10 on Mon, 29 December 2008 |
10 |
5166 |
Mon, 29 December 2008 20: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) |
|
Fetch is taking too long 10.2.0.3 |
5 |
3254 |
Mon, 29 December 2008 08:26 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) |
|
Thread 1 cannot allocate new log By: suspect on Mon, 29 December 2008 |
3 |
15031 |
Mon, 29 December 2008 03:59 By: suspect ![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) |
|
One query with two where Conditions on same column Oracle 10g By: virmahi on Tue, 23 December 2008 |
8 |
2838 |
Mon, 29 December 2008 03:09 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) |
|
performance of delete/insert deteriorate over time 10.2 By: Orna on Wed, 24 December 2008 |
17 |
3578 |
Sat, 27 December 2008 17:48 By: Orna ![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) |
|
Left outer join taking more time |
10 |
5931 |
Sat, 27 December 2008 11:18 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 Rewrite to Utilize Materialized Views on a Remote Database |
3 |
1853 |
Fri, 26 December 2008 18:30 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) |
|
Relate question to MViews Oracle 10g, cross platform |
4 |
2149 |
Fri, 26 December 2008 03:09 By: trantuananh24hg ![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've got a slowly query Oracle 10.2.0.1, Solaris 10 |
2 |
2343 |
Thu, 25 December 2008 23:18 By: trantuananh24hg ![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 indexes "drop/create" or "disable/rebuild" |
2 |
4586 |
Wed, 24 December 2008 04:38 By: Ferrarist ![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 for specific query? oracle 9i |
4 |
2193 |
Wed, 24 December 2008 03:16 By: mm_kanish05 ![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 Database, 10.1.0.2.0, Win 2003 Server |
6 |
2129 |
Wed, 24 December 2008 00:45 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) |
|
Substr,LTrim,Rtrim making query run slow Oracle 10g By: virmahi on Tue, 23 December 2008 |
3 |
6461 |
Tue, 23 December 2008 08:17 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) |
|
Full table scan when one type of records Oracle 9.2.0.5.0, Windows By: senaka on Tue, 23 December 2008 |
1 |
1441 |
Tue, 23 December 2008 06:48 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) |
|
Querying the database faster 8.1.7.4 |
2 |
1481 |
Tue, 23 December 2008 01:25 By: sandipshahare ![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 Oracle 10g By: virmahi on Mon, 22 December 2008 |
3 |
1873 |
Mon, 22 December 2008 04:17 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) |
|
What is difference between 2 statements? Oracle 10g, cross platform |
3 |
1965 |
Sat, 20 December 2008 21:56 By: trantuananh24hg ![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) |
|
poor performance of Exchange partition on composite range-hash tables Oracle 10.2.0.3 |
7 |
6511 |
Fri, 19 December 2008 15:21 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) |
|
open cursors 10.2.0.1.0 |
12 |
3802 |
Fri, 19 December 2008 04:27 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) |
|
Identifying trace files and how to retrieve from the server (merged) |
4 |
3162 |
Thu, 18 December 2008 20:18 By: trantuananh24hg ![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) |
|
metric defintion for SYSMETRIC Oracle server enterprise 10.2.0.3 |
0 |
7227 |
Thu, 18 December 2008 05:47 By: dermot_egan ![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 8.0.6 |
3 |
1905 |
Tue, 16 December 2008 21:38 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) |
|
Post SHRINK Actions : REBUILD INDEX & CBO Stats ? 10gR2 By: TomG on Tue, 16 December 2008 |
1 |
4004 |
Tue, 16 December 2008 21:36 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) |
|
Histograms: 32 character limit generates inaccurate stats By: zaff on Tue, 16 December 2008 |
3 |
2090 |
Tue, 16 December 2008 13:11 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) |
|
Simple query taking too long - looking for Index Suggestion 9.2.0.7 By: agurm on Fri, 12 December 2008 |
6 |
2529 |
Mon, 15 December 2008 23:58 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) |
|
Redo Log Tuning Oracle 10.2.0.3 By: rumman on Sun, 14 December 2008 |
2 |
8260 |
Mon, 15 December 2008 02:00 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) |
|
How SELECT affects remote database from which data is selected |
7 |
2135 |
Sat, 13 December 2008 01: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) |
|
data pull from a table oracle 10g unix By: dr46014 on Fri, 12 December 2008 |
0 |
6157 |
Fri, 12 December 2008 12:08 By: dr46014 ![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) |
|
Converting Trace (.TRC) file to readable(HTML) file in forms 10g 10.1.2.0.2 |
1 |
4731 |
Fri, 12 December 2008 01:04 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
How to improve the performance of "creating partition". oracle 10g R1 on Red Hat linux |
4 |
2248 |
Thu, 11 December 2008 19:12 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) |
|
Keep buffer pool after restart of the server By: snomula on Mon, 08 December 2008 |
5 |
2800 |
Wed, 10 December 2008 03:59 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) |
|
Table extents 10g ver 10.2.0.3.0 By: rcd70 on Sun, 07 December 2008 |
6 |
2329 |
Tue, 09 December 2008 15: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) |
|
Problems with with-statement Oracle 10.2.0 |
3 |
2317 |
Tue, 09 December 2008 11:23 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Oracle Benchmark Results for Different Servers brand name Oracle 10g By: chara on Tue, 09 December 2008 |
1 |
1665 |
Tue, 09 December 2008 06:57 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) |
|
Advice on SQL tuning Oracle 10g |
8 |
3099 |
Mon, 08 December 2008 23:32 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) |
|
temp tablespace stats oracle 8.1.7.3 |
1 |
1643 |
Mon, 08 December 2008 22:59 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) |
|
INDEX_DESC Hint Oracle 10.2.0.3 By: Olivia on Mon, 08 December 2008 |
3 |
11099 |
Mon, 08 December 2008 08: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) |
|
USE_HASH Oracle 9i By: jageesh on Mon, 08 December 2008 |
2 |
2507 |
Mon, 08 December 2008 06:01 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) |
|
how to tune this query? By: Selva on Wed, 08 December 2004 |
3 |
3619 |
Sun, 07 December 2008 22:45 By: dmerin ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |