|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Removing Duplicates Query 9.2.0.5 Sun O.S 5.7 |
3 |
1875 |
Thu, 29 November 2007 23:07 By: Frank ![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 with SQL Oracle 10 g, Windows XP |
8 |
2477 |
Thu, 29 November 2007 21:58 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) |
|
order of drop,create and create index during data load By: beeky on Tue, 27 November 2007 |
5 |
2245 |
Thu, 29 November 2007 21:47 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) |
|
Rebuild of indexes and 'Sweeper' referred in Ask tom site Options |
2 |
2156 |
Thu, 29 November 2007 21:35 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) |
|
parameter setting error |
6 |
3089 |
Thu, 29 November 2007 08:22 By: Mohammad Taj ![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 increase the performance |
13 |
2472 |
Thu, 29 November 2007 03:28 By: mr.rajeshyadav ![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) |
|
Issue updating a partitioned table Oracle 10 g, Windows XP |
10 |
2229 |
Thu, 29 November 2007 00:56 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) |
|
Tuning look-up tables : Suggestions needed Oracle 10g By: hidnana on Fri, 16 November 2007 |
2 |
1782 |
Wed, 28 November 2007 16:32 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) |
|
oracle sequence is causing high cpu usage? oracle sequence is causing high cpu usage? |
7 |
9815 |
Wed, 28 November 2007 16:23 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) |
|
Statspack frequency |
6 |
2459 |
Wed, 28 November 2007 09:20 By: Mohammad Taj ![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) |
|
Snap Shot Error on User_Tables |
7 |
4685 |
Tue, 27 November 2007 13:43 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) |
|
SGA size 10g R1,Windows XP By: gkrishn on Tue, 27 November 2007 |
3 |
1493 |
Tue, 27 November 2007 12:55 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) |
|
tunning notes 10.1.0. |
3 |
1532 |
Mon, 26 November 2007 00:27 By: pratik123 ![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) |
|
Regarding - Large_pool_size |
3 |
1811 |
Sun, 25 November 2007 03:50 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) |
|
advantages and disadvantages of optimization |
1 |
2206 |
Sat, 24 November 2007 09:41 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) |
|
recovery of drop table oracle9i |
1 |
1607 |
Fri, 23 November 2007 18:06 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) |
|
SHARED POOL contents By: gkrishn on Fri, 23 November 2007 |
3 |
1751 |
Fri, 23 November 2007 03:15 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) |
|
Similar SQLs : Index Usage/Non-usage By: hidnana on Wed, 21 November 2007 |
11 |
2779 |
Thu, 22 November 2007 20:54 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) |
|
Another question related to Statspack Oracle 9.2.0.8 on Solaris |
5 |
2162 |
Wed, 21 November 2007 06:45 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) |
|
Maximum number of oracle processes Oracle 10g |
4 |
7573 |
Mon, 19 November 2007 09: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) |
|
Statspack question 9.2.0.8 on Solaris. |
2 |
1648 |
Mon, 19 November 2007 03:23 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) |
|
consistent gets > segment size during FTS 9.2.0.8 solaris 8 By: mlobel1 on Fri, 16 November 2007 |
2 |
1706 |
Fri, 16 November 2007 09:49 By: mlobel1 ![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 needed in tuning this query Oracle 10.2.0.2, HP Unix By: hidnana on Wed, 14 November 2007 |
4 |
1963 |
Thu, 15 November 2007 19:27 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) |
|
How to decide on SGA sizing ??? |
1 |
1607 |
Thu, 15 November 2007 09:41 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) |
|
Index |
5 |
1995 |
Thu, 15 November 2007 07:35 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) |
|
Urgent Please |
10 |
2637 |
Thu, 15 November 2007 03:36 By: balajisundar ![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 such a difference in explain plans Oracle 9.2.5.0 By: MarcL on Wed, 14 November 2007 |
0 |
7019 |
Wed, 14 November 2007 10:35 By: MarcL ![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 perform INDEX RANGE SCAN instead of FTS oracle 9.2.0.6.0 ,sunsolaris 9.5 |
2 |
1814 |
Wed, 14 November 2007 09:14 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) |
|
Query problem 10.2 |
6 |
1706 |
Wed, 14 November 2007 05:36 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) |
|
Pls. help Tune this query Oracle 10g By: hidnana on Mon, 12 November 2007 |
8 |
2737 |
Wed, 14 November 2007 01:23 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) |
|
Buffer Cache Oracle 9.2.x.x, Unix |
4 |
1729 |
Tue, 13 November 2007 09:50 By: balajisundar ![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 Tunning |
5 |
2631 |
Mon, 12 November 2007 20:23 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) |
|
BUFFER CACHE By: kingo on Mon, 12 November 2007 |
1 |
1594 |
Mon, 12 November 2007 03: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) |
|
truncate oracle 7 By: dirish on Mon, 05 November 2007 |
8 |
2335 |
Mon, 12 November 2007 00:58 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) |
|
Perfomance in Delete and Insert By: mohseni on Sat, 10 November 2007 |
3 |
1388 |
Sat, 10 November 2007 09:23 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) |
|
Process Threads Oracl 9.2x, Unix |
2 |
1595 |
Fri, 09 November 2007 07:45 By: balajisundar ![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) |
|
Index overhead Oracle, 9.2x, Unix |
2 |
2184 |
Thu, 08 November 2007 11:40 By: DreamzZ ![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 improve a group by sql stmt (merged) |
4 |
3462 |
Thu, 08 November 2007 09:26 By: S.Rajaram ![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) |
|
INDEX CREATION oracle 9.2x , UNIX |
3 |
1754 |
Wed, 07 November 2007 03:29 By: balajisundar ![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 performance Oracle 10.2.0.2, Solaris 5.8 |
1 |
1586 |
Wed, 07 November 2007 02:49 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |