|
|
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 |
4079 |
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 |
5952 |
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 |
3080 |
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 |
1978 |
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 |
2074 |
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 |
7059 |
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 |
1870 |
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 |
2571 |
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 |
2419 |
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 |
1839 |
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 |
3542 |
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 |
2938 |
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 |
3309 |
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 |
1796 |
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 |
2304 |
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 |
2379 |
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 |
3287 |
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 |
3783 |
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 |
5391 |
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 |
2521 |
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 |
3672 |
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 |
2149 |
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 |
2720 |
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 |
3065 |
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 |
6397 |
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 |
1601 |
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 |
2480 |
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 |
4182 |
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 |
1795 |
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 |
2429 |
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 |
3396 |
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 |
2350 |
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 |
13250 |
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 |
3862 |
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 |
5973 |
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 |
2576 |
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 |
19031 |
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 |
10369 |
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 |
15422 |
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 |
2899 |
Sun, 07 August 2011 12:20 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |