|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
tuning time consuming queries oracle 8i |
1 |
2022 |
Wed, 30 April 2008 22:56 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) |
|
Costly update |
2 |
1679 |
Tue, 29 April 2008 12:24 By: poratips ![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) |
|
check oracle job status |
2 |
8124 |
Sun, 27 April 2008 03:31 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) |
|
How to check for Null values By: vkrn on Thu, 24 April 2008 |
2 |
1593 |
Thu, 24 April 2008 08:27 By: vkrn ![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 tuning 9.0.4.0 |
20 |
5891 |
Thu, 24 April 2008 03:30 By: user71408 ![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 Tuning |
11 |
3118 |
Mon, 21 April 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) |
|
Performance isssue 9.0.4.0 |
13 |
4557 |
Mon, 21 April 2008 12:52 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) |
|
Statspack Report 9.2.0.6.0 IBM AIX |
3 |
1686 |
Mon, 21 April 2008 12:48 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) |
|
more reloads |
4 |
1897 |
Sat, 19 April 2008 01:11 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) |
|
Rosco's Performance Tuning Guide |
12 |
6512 |
Fri, 18 April 2008 20: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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
how can i execute this query faster Oracle 10g R1 |
4 |
2004 |
Thu, 17 April 2008 23:39 By: gopu_g ![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) |
|
Enabling Trace file generation. Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production By: moshea on Thu, 17 April 2008 |
2 |
2094 |
Thu, 17 April 2008 11:06 By: moshea ![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 to execute in front end(Oracle 10g R2) Oracle 10g R2. |
12 |
2839 |
Thu, 17 April 2008 06:13 By: anee459 ![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) |
|
tuning the view (merged) |
5 |
1915 |
Thu, 17 April 2008 04:52 By: gopu_g ![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) |
|
Loading objects in parallel? Oracle 10.2.0.3 on Sun OS 5.10 |
4 |
1867 |
Thu, 17 April 2008 03:53 By: Kingfisher ![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 discrepancies Oracle 9i/10g Window2000 |
7 |
2642 |
Tue, 15 April 2008 22:23 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) |
|
INDEX ANALYZE 10g AIX |
5 |
2108 |
Tue, 15 April 2008 09:47 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) |
|
bulk collect help in production XP ,Oracle 10g |
8 |
3159 |
Mon, 14 April 2008 22:10 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) |
|
Poor performance of query with VPD policy 10gR1, 10.1.0.3 4 node RAC on AIX 5.2 64bit |
8 |
7646 |
Mon, 14 April 2008 07:34 By: kwalz58 ![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 tuning with indexes |
11 |
3390 |
Sun, 13 April 2008 03:01 By: swas_fly ![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) |
|
'DISTINCT' vs 'GROUP by' By: vkrn on Fri, 11 April 2008 |
8 |
16700 |
Fri, 11 April 2008 10: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) |
|
full tablescan though indexes exist |
4 |
4330 |
Fri, 11 April 2008 09:58 By: skooman ![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 update on million of records orcale 9i |
11 |
2734 |
Fri, 11 April 2008 02:04 By: S.Rajaram ![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 buffer cache 10g |
1 |
1922 |
Thu, 10 April 2008 09:30 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) |
|
Cursor_Sharing settings not working (merged) |
5 |
4013 |
Thu, 10 April 2008 08:13 By: OraKaran ![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 reduce the execution timing of SQL Query SQL*Plus: Release 3.3.4.0.0, Oracle7:7.3.4.0.0 |
15 |
3201 |
Thu, 10 April 2008 03:18 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) |
|
Order by with Nulls -- Performance Oracle 9i By: MarcL on Wed, 09 April 2008 |
3 |
1807 |
Wed, 09 April 2008 22:06 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) |
|
Cursors not closed at the database level 10gR2, Windows |
14 |
2903 |
Wed, 09 April 2008 15: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) |
|
Index Creation |
2 |
1847 |
Wed, 09 April 2008 08:57 By: smartin ![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) |
|
Two similar queries, two different plans Oracle 8i |
9 |
4723 |
Wed, 09 April 2008 08:50 By: smartin ![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) |
|
Reg Hash Join in Performance tunning toad 9.1 ,oracle 10g |
4 |
3636 |
Tue, 08 April 2008 07:42 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 10G/Unix |
2 |
1667 |
Tue, 08 April 2008 02:33 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) |
|
Query Tuning Oracle 9.2 |
12 |
3082 |
Mon, 07 April 2008 02: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) |
|
How to increase the database size of oracle 9i Oracle 9i |
3 |
3680 |
Fri, 04 April 2008 10: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) |
|
update takes much time to execute |
5 |
2083 |
Thu, 03 April 2008 15:51 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) |
|
Which Performance hint we should use when? |
3 |
1749 |
Thu, 03 April 2008 07:30 By: manoj12 ![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 decrease time to execute SUM function? oracle10gR2 Solaris5.9 |
6 |
2020 |
Thu, 03 April 2008 07:05 By: sispk6 ![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 using explain plan oracle , linux |
4 |
2242 |
Wed, 02 April 2008 21: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) |
|
insert took a lnog time. sun 10g |
3 |
1726 |
Wed, 02 April 2008 21: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) |
|
Find a correct value for PGA_AGGREGATE_TARGET Oracle 9i, AIX |
1 |
3081 |
Wed, 02 April 2008 08:02 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |