|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
keep pool 10g |
10 |
2862 |
Wed, 29 April 2009 08:53 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) |
|
Job queue process takes more then 90 % cpu oracle 10.2.0.4.0,Unbrekable linux |
5 |
4662 |
Wed, 29 April 2009 05:33 By: babuknb ![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) |
|
DBWR writes entire dirty block ? |
4 |
2786 |
Mon, 27 April 2009 12:12 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) |
|
Hints USE_HASH (merged) |
14 |
7059 |
Mon, 27 April 2009 08:28 By: Anne Simms ![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 PERFORMANCE ANALYZER Oracle 11g Rel1 , RHEL AS4 |
1 |
2353 |
Sun, 26 April 2009 08:09 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) |
|
Query Rewrite Failed After RLS policy applied(QSM-01284) |
10 |
5704 |
Sat, 25 April 2009 21:31 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) |
|
PL SQL performance tuning Oracle 10g |
3 |
2555 |
Tue, 21 April 2009 22:01 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) |
|
The difference of execution plans |
0 |
6251 |
Sun, 19 April 2009 01:11 By: dingwei ![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 too slow 10g 10.1.0.2.0 - xp By: rzkhan on Thu, 16 April 2009 |
8 |
3120 |
Fri, 17 April 2009 08: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) |
|
Query is getting stuck after adding one filter condition is where clause 9I, Windows |
8 |
2958 |
Fri, 17 April 2009 00:15 By: gurinder_mann2004 ![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) |
|
problem while generating AWR report |
8 |
8144 |
Thu, 16 April 2009 12:01 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) |
|
improve the performance (merged 2) |
10 |
2511 |
Thu, 16 April 2009 06:40 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) |
|
want to change snap level in 10g r2 |
1 |
3894 |
Tue, 14 April 2009 12:42 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) |
|
improving query performance oracle 10g |
1 |
1986 |
Tue, 14 April 2009 12: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) |
|
Explain Plan Oracle Database 10g Release 10.1.0.2.0 - 64bi ,HP-UX B.11.23 |
1 |
1868 |
Tue, 14 April 2009 01:13 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) |
|
TKprof shows fetching taking long time Database: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi |
7 |
8060 |
Sun, 12 April 2009 23:16 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) |
|
create dynamic partitions in oracle 9 oracle9i/ windows |
9 |
6811 |
Sat, 11 April 2009 07:25 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) |
|
Bind variable versus CURSOR_SHARING='SIMILAR' oracle10g |
3 |
5913 |
Fri, 10 April 2009 23:19 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) |
|
List partition and Index partitioning (merged) |
14 |
3273 |
Fri, 10 April 2009 00:34 By: jimit_shaili ![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) |
|
Can any one help me to tune this query. |
9 |
2454 |
Thu, 09 April 2009 05:07 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) |
|
PCTFREE and PCTUSED 10g Warehouse database on RHEL4 |
5 |
4615 |
Thu, 09 April 2009 02:39 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) |
![icon4.gif](/forum/images/message_icons/icon4.gif) |
Report Taking So Much Of Time and goes into ORA-01555 Oracle Apps 11.5.10.2 |
4 |
3843 |
Wed, 08 April 2009 23:13 By: sumitgarg ![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 optimize sql for query big table? (merged 3) |
3 |
3397 |
Wed, 08 April 2009 21:25 By: kevin_ye ![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 Help Oracle 10g |
1 |
2290 |
Wed, 08 April 2009 15:08 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) |
|
ORA-00604: error occurred at recursive SQL level x Oracle 10.1.2.0 Windows 2003 |
1 |
1743 |
Wed, 08 April 2009 08:47 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) |
|
v$session output oracle 10203 /AIX 5.3 |
9 |
3699 |
Tue, 07 April 2009 05:55 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) |
|
Temp Tablespace usage Oracle 9.2.0.7 AIX By: dbcop on Sat, 04 April 2009 |
1 |
2991 |
Sat, 04 April 2009 19:18 By: oraxperts ![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) |
|
difference between analyze table and dbms_stats.gatherstatistic |
2 |
3397 |
Thu, 02 April 2009 09: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) |
|
'show parameter allow' doesnt work oracle 9.2 |
5 |
1941 |
Wed, 01 April 2009 13:55 By: rituraj ![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 give kill session priviledge to normal user |
3 |
2311 |
Wed, 01 April 2009 11:14 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) |
|
contention on temprary tablespace oracle 9.2 |
3 |
1593 |
Wed, 01 April 2009 11:12 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) |
|
Performance degrades suddenly. 10.2.0.4/Solaris 10 |
10 |
3524 |
Wed, 01 April 2009 05:12 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) |
|
bad index choose when using rownum < 9 or less 10.2.0.4 AIX 5 |
1 |
1702 |
Wed, 01 April 2009 03:15 By: dingwei ![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 POOL Oacle 11g on Solaris10 By: AlinaC on Tue, 31 March 2009 |
3 |
1876 |
Tue, 31 March 2009 21:06 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) |
|
What if not give any ext in datafile........ |
2 |
1674 |
Mon, 30 March 2009 10:09 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) |
|
AWR report analysis Oracle Serer, 10g R2 , RH |
0 |
8630 |
Mon, 30 March 2009 02:34 By: John Charles ![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 |
4 |
2175 |
Fri, 27 March 2009 04:57 By: avrillavinge ![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 trace file meaning Oracel10g |
3 |
2440 |
Thu, 26 March 2009 09:53 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 error |
7 |
7387 |
Tue, 24 March 2009 10:49 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) |
|
Performance tuning Oracle |
2 |
1810 |
Tue, 24 March 2009 08:40 By: JRowbottom ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |