|
|
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 |
6901 |
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 |
5382 |
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 |
3418 |
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 |
15219 |
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 |
3021 |
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 |
3830 |
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 |
6134 |
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 |
1996 |
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 |
2330 |
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 |
2499 |
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 |
4773 |
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 |
2342 |
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 |
2296 |
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 |
6659 |
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 |
1571 |
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 |
1629 |
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 |
2023 |
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 |
2098 |
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 |
6694 |
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 |
4006 |
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 |
3329 |
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 |
7329 |
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 |
2069 |
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 |
4135 |
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 |
2230 |
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 |
2705 |
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 |
8441 |
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 |
2299 |
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 |
6285 |
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 |
4931 |
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 |
2406 |
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 |
2956 |
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 |
2503 |
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 |
2464 |
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 |
1805 |
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 |
3318 |
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 |
1782 |
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 |
11281 |
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 |
2657 |
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 |
3766 |
Sun, 07 December 2008 22:45 By: dmerin ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |