|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
The column name in user_ind_colums shows a SYS_ name when function based index created 10g By: DRDBA on Mon, 30 June 2008 |
2 |
3371 |
Mon, 30 June 2008 13:58 By: DRDBA ![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) |
|
reduce the wait event for db file sequential read event Oracle 10g |
6 |
9147 |
Mon, 30 June 2008 12: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) |
|
SQL tuning Oracle 9.2 |
13 |
3409 |
Mon, 30 June 2008 12:08 By: Kriptas ![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 a query 9i |
2 |
1391 |
Mon, 30 June 2008 11:41 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) |
|
increase of sessions Oracle 8.1.7 |
0 |
6354 |
Mon, 30 June 2008 09:44 By: darcioreine ![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 is taking more time to execute Oracle 10G, Actuate reports |
3 |
1999 |
Sun, 29 June 2008 23:23 By: sreenadhaj ![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) |
|
to make fast retrival oracle 10g, xp |
3 |
1913 |
Sat, 28 June 2008 15:21 By: Kriptas ![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) |
|
Segment Tuning --- TablePartition 10g, solaris |
2 |
10234 |
Sat, 28 June 2008 15:19 By: Kriptas ![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) |
|
Optimize this query.. 10g By: beetel on Fri, 06 June 2008 |
8 |
2384 |
Sat, 28 June 2008 15:12 By: Kriptas ![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) |
|
Long running SQL needs tuning Oracle 10g |
4 |
2086 |
Sat, 28 June 2008 15:03 By: Kriptas ![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 database , please help oracle 9i, 9.2.0.1, windows |
7 |
3076 |
Fri, 27 June 2008 12:53 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) |
|
Unable to Understand Explain Plan Oracle 10g, red hat |
18 |
3783 |
Fri, 27 June 2008 08: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) |
|
Tuning the query - Not using the index 9.2.0.7.0 By: Brayan on Tue, 24 June 2008 |
12 |
4843 |
Thu, 26 June 2008 05:08 By: Brayan ![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) |
|
High Frequency of Redo Log Files Oracle 8.1.7.0 By: pune01 on Wed, 25 June 2008 |
3 |
1895 |
Wed, 25 June 2008 08:43 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) |
|
Window Sort |
9 |
6350 |
Wed, 25 June 2008 06:34 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) |
|
How tuning this query ? (merged) |
7 |
2054 |
Wed, 25 June 2008 02:54 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) |
|
max number of users and sessions oracle,solaris |
4 |
1598 |
Tue, 24 June 2008 07:59 By: sheldon1982 ![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 for Queuing (merged) |
7 |
2388 |
Tue, 24 June 2008 01:33 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) |
|
Please help to Tuning Please help to Tuning |
4 |
1835 |
Tue, 24 June 2008 01:32 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) |
|
Capturing top 10 longest running SQLs Oracle Enterprise RDBMS server 8.1.7.4 |
5 |
2300 |
Mon, 23 June 2008 13:55 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) |
|
Soft Close Cursor 9i and 10g |
3 |
1842 |
Mon, 23 June 2008 13:50 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) |
|
Explain Plan |
8 |
1856 |
Sun, 22 June 2008 12:21 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) |
|
slow server windows 2000 |
12 |
2436 |
Wed, 18 June 2008 23:09 By: alister ![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) |
|
Self join removal Oracle, 9.2.0.4, Windows XP |
16 |
11452 |
Wed, 18 June 2008 22:37 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) |
|
Hit Rate. Oracle10g, Windows 2003 |
1 |
1398 |
Wed, 18 June 2008 10:27 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) |
|
SQL Tune Oracle 9i |
1 |
2069 |
Wed, 18 June 2008 06:10 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 issues Oracle 9i ,SunT2000 |
3 |
2326 |
Tue, 17 June 2008 03:29 By: alanm ![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 in tuning this procedure |
7 |
2169 |
Tue, 17 June 2008 02:27 By: flyboy ![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) |
|
Extents and blocks Oracle 10.2.0.3.0, Solaris |
10 |
2269 |
Tue, 17 June 2008 01:08 By: aslamkhalife ![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 sql_id value in awr report oracle 10.2.0.3 solaris 10 64bit |
5 |
6511 |
Tue, 17 June 2008 00:53 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) |
|
Partitioning a table in Source 10g By: beetel on Tue, 10 June 2008 |
2 |
1420 |
Mon, 16 June 2008 23:29 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) |
|
Performance1 Oracle 9i |
10 |
2343 |
Mon, 16 June 2008 15:25 By: JackyShu ![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 improvement measures Oracle 9i |
1 |
1423 |
Mon, 16 June 2008 10:37 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) |
|
SQL Needs to be tuned Oracle 10g |
7 |
3972 |
Sun, 15 June 2008 23:06 By: rajatratewal ![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 is causing lot of performance hurt in DB oracle 10.2.0.2 solaris 10 |
3 |
1774 |
Fri, 13 June 2008 12:28 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) |
![icon8.gif](/forum/images/message_icons/icon8.gif) |
sessions were hung for long time oracle 10.2.0.3 solaris 10 64bit |
6 |
2111 |
Fri, 13 June 2008 00:17 By: skumar.dba ![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) |
|
diskreads/executions |
2 |
2154 |
Thu, 12 June 2008 03:18 By: bm50793 ![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) |
|
explain plan |
1 |
1274 |
Tue, 10 June 2008 06:20 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) |
|
About tkprof |
3 |
1472 |
Tue, 10 June 2008 03: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) |
|
BITMAP INDEX |
7 |
2080 |
Mon, 09 June 2008 15:51 By: JackyShu ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |