|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle sequence |
2 |
2291 |
Mon, 13 June 2005 09:36 By: smartin ![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) |
|
When to use index |
6 |
3644 |
Mon, 13 June 2005 05:53 By: d.dineshkumar ![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) |
|
Constraint state in DWH environment (rely disable novalidate) |
0 |
3842 |
Sun, 12 June 2005 04:30 By: henning.schroer ![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 - number of rows returned. |
5 |
3558 |
Fri, 10 June 2005 08:08 By: Lee Sutton ![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 Question |
2 |
2423 |
Thu, 09 June 2005 04:15 By: nabeelkhan ![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 is happening with this sql? |
15 |
5829 |
Wed, 08 June 2005 20:10 By: rramanat ![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) |
|
select large amount of data |
1 |
2301 |
Wed, 08 June 2005 15:47 By: Art Metzer ![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) |
|
forced view |
4 |
5187 |
Wed, 08 June 2005 00:20 By: nabeelkhan ![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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
URGENT:-Performance Tuning. |
8 |
3525 |
Tue, 07 June 2005 15:28 By: skempins ![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) |
|
Stubborn Query |
4 |
2914 |
Tue, 07 June 2005 06:35 By: nabeelkhan ![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) |
How to read the execution plan By: shibu on Wed, 01 June 2005 |
6 |
3800 |
Mon, 06 June 2005 09:06 By: smartin ![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) |
|
Composite bitmap indexes |
2 |
8191 |
Mon, 06 June 2005 08:49 By: smartin ![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 use 2 GB as SGA(4gb ram) oracle 8i windows 2000s |
11 |
8113 |
Sun, 05 June 2005 09:00 By: girish.rohini ![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) |
|
Reg. out put of DBMS_XPLAN.DISPLAY |
6 |
3916 |
Sun, 05 June 2005 07:23 By: nabeelkhan ![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) |
|
Select on same table gives poor performace. By: abc123 on Sat, 04 June 2005 |
1 |
3596 |
Sun, 05 June 2005 02:24 By: nabeelkhan ![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 Partition rebuild Query |
1 |
28768 |
Fri, 03 June 2005 08:16 By: carsten.jorgensen ![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 same sql runs very slowly in jboss-cmp,very quickly in native jdbc. |
1 |
2498 |
Thu, 02 June 2005 21:01 By: peixubin ![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 Server Information |
1 |
2433 |
Tue, 31 May 2005 09:07 By: smartin ![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 are the steps to tune a query |
3 |
6368 |
Mon, 30 May 2005 09:08 By: d.dineshkumar ![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) |
|
Datawarehouse query |
3 |
2306 |
Thu, 26 May 2005 20:41 By: well_rbs ![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) |
|
All "Rows" equal 0 in TKPROF. Is this a setting? |
6 |
3495 |
Thu, 26 May 2005 14:27 By: scottwmackey ![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) |
|
Batch Tuning |
3 |
3277 |
Mon, 23 May 2005 15:49 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 problem!! By: kinjal on Mon, 23 May 2005 |
2 |
2515 |
Mon, 23 May 2005 09:44 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) |
|
activating Online Index Build By: mbexel on Wed, 18 May 2005 |
3 |
5985 |
Fri, 20 May 2005 08:58 By: smartin ![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 for 9i on 8.1.6 |
1 |
2565 |
Fri, 20 May 2005 06:07 By: Frank Naude ![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) |
Ploblem connect oracle by Vb application By: chara on Tue, 17 May 2005 |
3 |
4802 |
Wed, 18 May 2005 10:44 By: girish.rohini ![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) |
|
Prameters For Improving DB Perfomance By: ksst on Fri, 13 May 2005 |
3 |
2427 |
Fri, 13 May 2005 22:33 By: smartin ![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 top 5 wait event |
2 |
3197 |
Fri, 13 May 2005 07:24 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) |
|
Comparision of Two Execution Plan |
4 |
2636 |
Wed, 11 May 2005 09:07 By: smartin ![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) |
|
ARCHIVELOG GETTING FILLED |
1 |
2263 |
Tue, 10 May 2005 02:16 By: mihelic ![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) |
|
Cursor Performance Issue |
1 |
5326 |
Tue, 10 May 2005 02:07 By: Barbara Boehmer ![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 Schema slowing performance By: ravin on Wed, 04 May 2005 |
9 |
5477 |
Mon, 09 May 2005 12:23 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) |
|
Query takes long time -need help to improve Performance By: pzlj6x on Fri, 06 May 2005 |
4 |
2738 |
Sat, 07 May 2005 08:18 By: pzlj6x ![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) |
![icon9.gif](/forum/images/message_icons/icon9.gif) |
Why does checkpoint only happen at log switch? :( By: Jadie on Thu, 05 May 2005 |
2 |
2852 |
Fri, 06 May 2005 13:48 By: Jadie ![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) |
|
max size of sga in oracle 81 windows 2000 server |
1 |
2408 |
Thu, 05 May 2005 11:47 By: girish.rohini ![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 |
2 |
10084 |
Tue, 03 May 2005 08:40 By: balavignesh ![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 Doubt |
5 |
2615 |
Mon, 02 May 2005 10:11 By: sujit_ocp ![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 should be approximate Size of SGA ? |
1 |
2622 |
Sun, 01 May 2005 21:08 By: chunyuh ![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) |
|
Deleting from Huge table By: abc123 on Thu, 28 April 2005 |
4 |
2947 |
Fri, 29 April 2005 11:48 By: pscjhe ![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$SYSSTAT |
1 |
3188 |
Fri, 29 April 2005 08:44 By: Frank Naude ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |