|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
need to know about shared pool sizing 8.1.7,win 2003 server By: ultgnp on Mon, 05 July 2010 |
1 |
1606 |
Mon, 05 July 2010 01:32 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) |
|
Logwriter processes Hp Unix,11.3 |
3 |
2465 |
Fri, 02 July 2010 04: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) |
|
parition of table 10.2.0.4 |
2 |
1697 |
Mon, 28 June 2010 08:09 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) |
|
select partition table with non partition key condition By: ekopur on Sat, 26 June 2010 |
3 |
2706 |
Sat, 26 June 2010 09: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) |
|
Help proving a database is slow 10.2 / Solaris |
16 |
7790 |
Sat, 26 June 2010 05:13 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) |
|
Pin Sql query in shared pool |
3 |
3872 |
Fri, 25 June 2010 08:02 By: cookiemonster ![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 tuning this query 8.1.6, win2000 server By: ultgnp on Sun, 20 June 2010 |
17 |
3039 |
Wed, 23 June 2010 08:36 By: ultgnp ![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 order by clause without changing sort area Oracle 9i,9.2.0.6.0,Windows XP |
10 |
9937 |
Wed, 23 June 2010 03:36 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) |
|
My indexes was not active Oracle 10g, Windows 32bit |
9 |
2304 |
Wed, 23 June 2010 02:54 By: Roachcoach ![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 reduce the disk reads |
14 |
3292 |
Tue, 22 June 2010 06:28 By: akilabaskaran ![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) |
|
reducing the parse-execution ration |
12 |
2457 |
Fri, 18 June 2010 03:59 By: cookiemonster ![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 fragmentation Oracla 9i By: Nau on Wed, 16 June 2010 |
2 |
1503 |
Thu, 17 June 2010 12:42 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) |
|
Tuning PL/SQLApplications Oracle 10g |
2 |
1593 |
Thu, 17 June 2010 00:49 By: rmaheshbabu ![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) |
|
shared pool oracle 10.2.0.4 2 node rac,aix 6.3 |
9 |
5739 |
Wed, 16 June 2010 00:54 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) |
|
TKPROF Output Understanding Oracle 10g,10.2.0.3.0,AIX |
14 |
6725 |
Wed, 16 June 2010 00:44 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) |
|
Avoiding bind variable from a sql in java code oracle 10.2.0.4 on Solaris 10 |
9 |
3195 |
Tue, 15 June 2010 13:21 By: orausern ![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) |
|
SGA "usage" |
8 |
6526 |
Mon, 14 June 2010 17:17 By: mikerault ![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) |
|
Alternative to REPLACE function? 10gr2 |
2 |
1993 |
Mon, 14 June 2010 11:34 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) |
|
Very first step Oracle SQL Tuning |
3 |
1672 |
Mon, 14 June 2010 05:36 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) |
|
Changing execution plans Oracle 10.2.0.4 RAC |
3 |
2433 |
Sat, 12 June 2010 13:55 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) |
|
Merge Performance (wide open question here) 10g release (4?) and 11g release 1 |
6 |
3864 |
Sat, 12 June 2010 08:48 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) |
|
tkprof question 10gr2 |
5 |
2170 |
Fri, 11 June 2010 22:48 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) |
|
Rule based tips still valid in 11g By: ind9 on Fri, 11 June 2010 |
1 |
1411 |
Fri, 11 June 2010 07:38 By: cookiemonster ![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) |
|
Oracle Internal Query 11.1.0.7.0 |
2 |
3816 |
Fri, 11 June 2010 03:10 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) |
|
Does high volume of data can change plan Oracle 10.2.0.3 |
6 |
2376 |
Fri, 04 June 2010 09:17 By: Its_me_ved ![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) |
|
Why Elapsed Time Changed while execution plan and stats remains the same? Oracle 9.2.0.6.0 on HP-UX |
10 |
2717 |
Fri, 04 June 2010 09:15 By: chetanaZ ![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) |
|
awr report for specific date |
2 |
3420 |
Fri, 04 June 2010 01:32 By: Riyasbasha ![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) |
|
oracleorcl (LOCAL=NO) cpu 100% Oracle10.1.0.2.0, Rhel4 |
9 |
11602 |
Tue, 01 June 2010 23:19 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) |
|
help to tune this query ot help to re write in onther way oracle ,11.1,xp |
4 |
2436 |
Mon, 31 May 2010 07:22 By: Alessandro Rossi ![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 resolve query tuning? |
1 |
1685 |
Sun, 30 May 2010 02:40 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 to check the query performance |
2 |
1759 |
Sat, 29 May 2010 03: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) |
|
P&T Guide Question [Restructuring SQL Statements] 10g Release 2 (10.2) - Documention Related |
2 |
2242 |
Fri, 28 May 2010 05:30 By: Roachcoach ![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 with tuning a query 8.0.6, win 2000 server |
5 |
1888 |
Wed, 26 May 2010 06:07 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) |
|
V$SESSION_LONGOPS - Looking for more than last 16 ops 10.2.0.4.0 |
3 |
5216 |
Wed, 26 May 2010 04:46 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) |
|
Different EXPLAIN PLAN Before and after execution Oracle 10g |
7 |
3078 |
Wed, 26 May 2010 03:33 By: prateekgupta1210 ![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) |
|
AWR report evaluation oracle10g |
5 |
3232 |
Sun, 23 May 2010 00:00 By: ramoradba ![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 sql Oracle 10.2.0.3 |
19 |
4804 |
Sat, 22 May 2010 03:41 By: Alessandro Rossi ![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 11g |
6 |
2153 |
Tue, 18 May 2010 08:59 By: cookiemonster ![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 with rewriting the query 8.0.6 |
10 |
2687 |
Mon, 17 May 2010 02:50 By: ateeqrahman786 ![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 to speed up data loading in form 8.0.6, forms 4.5, win 2003 server |
1 |
1456 |
Sat, 15 May 2010 07:48 By: rleishman ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |