|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Too many columns in one index Oracle 10g By: virmahi on Sun, 04 October 2009 |
5 |
2954 |
Mon, 05 October 2009 07:26 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) |
|
flush shared pool oracle 8.1.7.0.0, windows 2003 server |
12 |
9475 |
Mon, 05 October 2009 07:17 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) |
|
Does "alter system flush shared_pool" statement impact to performance? Oracle 10g, crossover OS! |
4 |
17323 |
Fri, 02 October 2009 07: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) |
|
Slow Insert APPEND into Temporary Table By: spv73 on Fri, 02 October 2009 |
2 |
5907 |
Fri, 02 October 2009 07:44 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) |
|
Query tuning By: gajini on Tue, 22 September 2009 |
6 |
4284 |
Mon, 28 September 2009 12:21 By: madhuottapalam ![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 in Oracle 10 G |
3 |
2655 |
Mon, 28 September 2009 11:17 By: madhuottapalam ![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 query performance Oracle 9i, Windows XP By: brunom on Thu, 17 September 2009 |
8 |
4403 |
Mon, 28 September 2009 03:31 By: brunom ![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 wtith single instance database oracle 10gr2 10.2.0.3 windows2000 |
3 |
2196 |
Mon, 28 September 2009 01:26 By: sherkhan@infodynamic.net ![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 A Small help on Tuning this query. 10.2.0.2 |
5 |
6124 |
Sun, 27 September 2009 08:22 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) |
|
Bulk insert is faster then insert into select * ...... Oracle 10g, Unix |
15 |
21051 |
Thu, 24 September 2009 03:11 By: Dipali Vithalani ![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) |
|
Stale statistics and Dynamic Sampling Oracle 10gR2 (10.2.0.4) |
5 |
5434 |
Wed, 23 September 2009 03: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) |
|
FLUSH SHARED_POOL Oracle,10.2.4.0,linux |
5 |
3591 |
Tue, 22 September 2009 03:33 By: bishtoo ![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) |
|
db block gets, consistent gets By: rkl1 on Tue, 14 June 2005 |
14 |
36442 |
Mon, 21 September 2009 04:25 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 Tuning Sun Solaris |
3 |
2638 |
Mon, 21 September 2009 03:41 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) |
|
Question about parallel processing. 10.2.0.3 Sun Sparc. |
2 |
2284 |
Sat, 19 September 2009 10: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) |
|
alternate for Table Partitioning |
3 |
2282 |
Fri, 18 September 2009 03: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) |
|
Query Performance issue Oracle, 10.2.0.1, Solaris By: bhas_m on Thu, 17 September 2009 |
2 |
2364 |
Thu, 17 September 2009 19:41 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) |
|
update statement issue oracle9i By: manoj12 on Thu, 17 September 2009 |
1 |
1859 |
Thu, 17 September 2009 08:29 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) |
|
Use of Bind variable |
2 |
2021 |
Wed, 16 September 2009 23:05 By: sameertuladhar ![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) |
EXECUTE IMMEDIATE 'set autotrace on'; ORA-00922: missing or invalid option Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod || TNS for 32-bit Windows: Version 10.2.0.3.0 - Production |
4 |
9031 |
Wed, 16 September 2009 04:57 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) |
|
Error Creating STATSPACK on Oracle10g By: bahy91 on Fri, 13 July 2007 |
19 |
23671 |
Tue, 15 September 2009 20:02 By: diri ![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) |
|
Useing USE_HASH in a GROUP BY Clause (merged 7) sqlplus,10g,windows |
9 |
3940 |
Tue, 15 September 2009 00:00 By: pstanand ![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 getting filled up with multi table join |
14 |
5732 |
Sun, 13 September 2009 14: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) |
|
Use of DBMS_LOGSTDBY By: bahy91 on Fri, 31 August 2007 |
3 |
8304 |
Thu, 10 September 2009 10: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) |
|
I/O cost was very high Windows Server 2003, Oracle 10.2.0.4 |
3 |
2505 |
Wed, 09 September 2009 22:27 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) |
|
DBMS_STATS running slow. Oracle ,10.2.0.4,sun sparc |
1 |
5665 |
Tue, 08 September 2009 10: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) |
![icon1.gif](/forum/images/message_icons/icon1.gif) |
To limit Cpu consumption Oracle 10.2.0.4, Solaris 9 |
4 |
3195 |
Sun, 06 September 2009 21:32 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) |
|
Wait event problem Oracle 10g By: Nikolin on Tue, 01 September 2009 |
5 |
7038 |
Sat, 05 September 2009 10:13 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 run faster without indexes. Why? Oracle 11g |
18 |
5076 |
Fri, 04 September 2009 20:01 By: JorgeAbreu ![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 Time Spent Waiting (%)" are at 100 for event class "Concurrency" Oracle 10g r2, HP-UX 11.31 Itanium |
0 |
12354 |
Wed, 02 September 2009 11:16 By: miguechancleto ![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 undo oracle10.2.0.4 hp-ux ia |
2 |
3201 |
Sun, 30 August 2009 14:01 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) |
|
time consuming query oracle 10g |
11 |
9496 |
Sat, 29 August 2009 05:46 By: andydba ![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) |
|
A question about LRU in shared pool |
3 |
2081 |
Fri, 28 August 2009 00:05 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) |
|
dataguard tunning: checkpoint completed 11.1.0.7 By: aline on Tue, 25 August 2009 |
8 |
11546 |
Thu, 27 August 2009 07:22 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) |
|
oracle query running slow |
2 |
5198 |
Thu, 27 August 2009 00:38 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 change SYS password? Oralce 10g |
5 |
2439 |
Wed, 26 August 2009 05: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) |
|
Bitmap & Normal Index for same column - Oracle Oracle 9i |
3 |
2837 |
Wed, 26 August 2009 05:04 By: Nirnay Jaiswal ![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 performance with index rebuild 10gR2 solaris |
2 |
2054 |
Thu, 20 August 2009 00:01 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) |
![icon1.gif](/forum/images/message_icons/icon1.gif) |
Open cursor count is too high Oracle 10.2.0.4, Solaris 9 |
5 |
6952 |
Wed, 19 August 2009 00:24 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) |
|
Virtual Memory Paging Oracle 10.2.0.4g Windows Server 2003 EE |
1 |
6972 |
Sun, 16 August 2009 17:38 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |