|
|
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 |
3347 |
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 |
9094 |
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 |
3343 |
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 |
1363 |
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 |
6331 |
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 |
1955 |
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 |
1857 |
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 |
10163 |
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 |
2323 |
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 |
2019 |
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 |
3012 |
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 |
3625 |
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 |
4775 |
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 |
1854 |
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 |
6289 |
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 |
2009 |
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 |
1555 |
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 |
2350 |
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 |
1788 |
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 |
2243 |
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 |
1794 |
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 |
1792 |
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 |
2307 |
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 |
11371 |
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 |
1382 |
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 |
2037 |
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 |
2293 |
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 |
2122 |
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 |
2198 |
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 |
6460 |
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 |
1396 |
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 |
2312 |
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 |
1406 |
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 |
3948 |
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 |
1749 |
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 |
2078 |
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 |
2132 |
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 |
1249 |
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 |
1454 |
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 |
2049 |
Mon, 09 June 2008 15:51 By: JackyShu ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |