|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
pl/sql oracle 10g |
24 |
4094 |
Mon, 12 September 2011 23: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) |
|
Advice on Gather_stats Oracle 8i, 9i and 10G By: sathik on Tue, 06 September 2011 |
23 |
5964 |
Sun, 11 September 2011 03: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) |
|
Don't Know how to start performance tuning. Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit |
4 |
3094 |
Sat, 10 September 2011 10:55 By: halim ![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 find out all the queries that are executed in particular range of time in oracle instance. Oracle 10g [10.2.0.3.0] windows 7 |
3 |
1989 |
Fri, 09 September 2011 07:37 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 issue Oracle 10g, wondows XP |
3 |
2080 |
Fri, 09 September 2011 03:56 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) |
|
how we can match variable sga using v$sga and v$sgastat views Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi By: msol25 on Fri, 02 September 2011 |
10 |
7072 |
Thu, 08 September 2011 08:05 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) |
|
Stopping optimizer choosing concatenation Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production |
2 |
1877 |
Wed, 07 September 2011 07:42 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) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
Statspack unit information Oracle database, Standard 10.0.2.4, Windows 2003 By: Flyby on Tue, 06 September 2011 |
2 |
2583 |
Tue, 06 September 2011 14:19 By: Flyby ![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) |
|
dml is very slowly when table have many rows 11.2.0.1.0 Windos XP |
6 |
2430 |
Mon, 05 September 2011 02:45 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 oracle 10g |
2 |
1846 |
Fri, 02 September 2011 13:15 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) |
|
Query Performance Issue (4 Merged) Oracle 10 G |
9 |
3552 |
Fri, 02 September 2011 09:33 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) |
|
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi how we can match variable sga in v$sga with v$sgastat view By: msol25 on Fri, 02 September 2011 |
5 |
2948 |
Fri, 02 September 2011 05: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) |
|
Memory Fault Error in Tkprof Oracle 10g, Unix |
1 |
3319 |
Wed, 31 August 2011 23:56 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) |
|
Importing Partitioning rows from Many Export Files. oracle version 10g Windows XP |
2 |
1803 |
Tue, 30 August 2011 02:40 By: muktha_22 ![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 between move and shink table 11g windows |
2 |
2314 |
Tue, 30 August 2011 01:27 By: jai_subi ![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) |
|
harsh area size and sort area size |
3 |
2388 |
Mon, 29 August 2011 11:38 By: John Watson ![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) |
|
Interface table design question Oracle, 10g |
5 |
3298 |
Mon, 29 August 2011 11:21 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) |
|
Need to improve speed for UPDATE statement oracle 11.2.0.1.0 linux 2.6 |
0 |
3793 |
Mon, 29 August 2011 06:17 By: kesavansundaram ![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) |
|
RANGE SCAN VS FAST FULL SCAN |
3 |
5402 |
Mon, 29 August 2011 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) |
|
SQL TUNING Oracle 10G |
7 |
2531 |
Sun, 28 August 2011 22:23 By: hkchital ![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) |
|
Managing Large Table Oracle 10g By: EbenT on Fri, 26 August 2011 |
7 |
3683 |
Sun, 28 August 2011 20:56 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) |
|
SGA_TARGET and shared pool |
2 |
2156 |
Thu, 25 August 2011 15:24 By: John Watson ![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 doubt 11.2.0.2.0 |
9 |
2730 |
Thu, 25 August 2011 07:45 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) |
|
Insert / Update Performance due to Triggers (merged 2) Oracle 9i By: mjm22 on Wed, 10 August 2011 |
5 |
3072 |
Wed, 24 August 2011 20:41 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) |
|
how expensive is unique versus primary key in large table 9.2.0.1.0 |
5 |
6405 |
Wed, 24 August 2011 19:57 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) |
|
application performance |
1 |
1611 |
Wed, 24 August 2011 17:51 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) |
|
Speed up this SQL Oracle 10g By: r23rob on Fri, 19 August 2011 |
2 |
2490 |
Mon, 22 August 2011 08: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) |
|
performance tuning PROBLEM |
8 |
4194 |
Thu, 18 August 2011 11:17 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) |
|
Need help with tuning |
1 |
1804 |
Wed, 17 August 2011 14: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) |
|
2 design alternatives, passing natural key as meaningful foreign key 9.2.0.1.0 |
5 |
2443 |
Wed, 17 August 2011 03: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) |
|
Query sub-factoring issue Oracle 10g,Windows XP |
4 |
3406 |
Wed, 17 August 2011 02:34 By: a_oracle ![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 Instance Related Query Oracle 10g |
2 |
2360 |
Wed, 17 August 2011 00:47 By: John Watson ![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) |
|
start with and connect by Oracle 11g R2 , RHEL4 By: liliek on Mon, 25 July 2011 |
28 |
13265 |
Mon, 15 August 2011 01:39 By: liliek ![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 to decrease the cost as much as possible Version: Oracle 10.2.0.3.0 OS: Solaris |
11 |
3873 |
Thu, 11 August 2011 13:36 By: SSharma ![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 for select statement |
19 |
5982 |
Thu, 11 August 2011 03:33 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) |
|
New Trace File Oracle 11g R1 |
3 |
2584 |
Thu, 11 August 2011 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) |
|
nvl problem i think 11.2.0.2.0 |
30 |
19044 |
Wed, 10 August 2011 22:45 By: shashank_kurasrediffmail ![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_MAX_SIZE to more than 2G? 10.2.0.1.0, OS=Windows 2003 server 64 bit with 16G RAM |
6 |
10380 |
Wed, 10 August 2011 22: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) |
|
Simple SQL with High Concurrency Wait Time (cursor: pin S wait on X) Oracle 10gR2 on AIX 6.1 |
18 |
15442 |
Tue, 09 August 2011 06:46 By: LNossov ![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) |
|
Application slow Oracle 11.1.0.7.0, Unix-HP |
4 |
2912 |
Sun, 07 August 2011 12:20 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |